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: 8.1