RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_TEST

Description Source composite view contains all person test scores recorded with in the institution ERP system.

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

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

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

SORTEST

SORTEST_TEIN_CODE

INSTRUMENT_DESC Test instrument code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

ORIGINAL_SCORE Original score. VARCHAR2(5)

SORTEST

SORTEST_SAT_ORIG_SCORE

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

SORTEST

SORTEST_PIDM

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(4)

SORTEST

SORTEST_TESC_CODE

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

SORTEST

SORTEST_TEAC_CODE

TEST_ACCOMODATION_DESC Test accommodations description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SORTEST

SORTEST_TADM_CODE

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

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(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SORTEST

SORTEST_TEFR_CODE

TEST_FORM_DESC Test form description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SORTEST

SORTEST_TEPR_CODE

TEST_PURPOSE_DESC Test's purpose description. VARCHAR2(30)

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(4)

SORTEST

SORTEST_TSRC_CODE

TEST_SOURCE_DESC Description for the test source. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

TEST_TYPE_DESC Test type description. VARCHAR2(0)

NA

NA

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

NA

NA



Ver: 3.1