RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: TEST

Description Contains data about test scores for a person.
Key & Frequency One row per person per test type per test date.
Recommended Search Columns PERSON_UID, TEST
TEST

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

EQUIVALENCY_IND Indicator used to show if the test score is an equivalency for the actual test taken. VARCHAR2(1)

SORTEST

SORTEST_EQUIV_IND

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INSTRUMENT Instrument associated with the test, where applicable. VARCHAR2(63)

SORTEST

SORTEST_TEIN_CODE

INSTRUMENT_DESC Test instrument code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORIGINAL_SCORE Original score. VARCHAR2(5)

SORTEST

SORTEST_SAT_ORIG_SCORE

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SORTEST

SORTEST_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RECENTERED_OR_REVISED_IND Indicates whether the score has been recentered and/or revised. VARCHAR2(1)

SORTEST

SORTEST_RCRV_IND

TEST Test score code associated with various tests, i.e., SAT, ACT, placement scores. VARCHAR2(63)

SORTEST

SORTEST_TESC_CODE

TEST_ACCOMODATION Identifies any special accommodations, if any, for this student taking this test. VARCHAR2(63)

SORTEST

SORTEST_TEAC_CODE

TEST_ACCOMODATION_DESC Test accommodations description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_ADMIN_TYPE Identifies the type of administrative used for a particular test, i.e., locally or nationally administered. VARCHAR2(63)

SORTEST

SORTEST_TADM_CODE

TEST_ADMIN_TYPE_DESC Description for the administration type used when this test was taken. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_DATE Date this test was taken. DATE

SORTEST

SORTEST_TEST_DATE

TEST_DESC Test score description associated with a test, for example, SAT, ACT, placement scores, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_FORM Identifies the form of this test. VARCHAR2(63)

SORTEST

SORTEST_TEFR_CODE

TEST_FORM_DESC Test form description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_PURPOSE Identifies the main purpose for this test. VARCHAR2(63)

SORTEST

SORTEST_TEPR_CODE

TEST_PURPOSE_DESC Test's purpose description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_SCORE Test score value for this test code, date and person. VARCHAR2(5)

SORTEST

SORTEST_TEST_SCORE

TEST_SOURCE Test score source, or how the test score was entered. For example, magnetic tape, self-reported, etc. VARCHAR2(63)

SORTEST

SORTEST_TSRC_CODE

TEST_SOURCE_DESC Test source description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TEST_TYPE Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT. VARCHAR2(63)

NA

NA

TEST_TYPE_DESC Test type description. VARCHAR2(255)

NA

NA



Ver: 3.1