Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EQUIVALENCY_IND	Indicator used to show if the test score is an equivalency for the actual test taken.	VARCHAR2(1)	SORTEST	SORTEST_EQUIV_IND	NO	NO
INSTRUMENT	Instrument associated with the test, where applicable.	VARCHAR2(6)	SORTEST	SORTEST_TEIN_CODE	NO	NO
INSTRUMENT_DESC	Test instrument code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
ORIGINAL_SCORE	Original score.	VARCHAR2(5)	SORTEST	SORTEST_SAT_ORIG_SCORE	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORTEST	SORTEST_PIDM	NO	NO
RECENTERED_OR_REVISED_IND	Indicates whether the score has been recentered and/or revised.	VARCHAR2(1)	SORTEST	SORTEST_RCRV_IND	NO	NO
REQUIREMENT		VARCHAR2(4)				NO
REQUIREMENT_DESC		VARCHAR2(30)				NO
TEST	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(4)	SORTEST	SORTEST_TESC_CODE	NO	NO
TEST_ACCOMODATION	Identifies any special accommodations, if any, for this student taking this test.	VARCHAR2(4)	SORTEST	SORTEST_TEAC_CODE	NO	NO
TEST_ACCOMODATION_DESC	Test accommodations description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_ACTIVITY_DATE		DATE				NO
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	NO	NO
TEST_ADMIN_TYPE_DESC	Description for the type of administration used when this test was taken.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_ASSOCIATED_ACAD_PERIOD		VARCHAR2(6)				NO
TEST_ASSOCIATED_ACAD_PRD_DESC		VARCHAR2(30)				NO
TEST_ASSOCIATED_APPL_NUMBER		NUMBER				NO
TEST_DATA_ORIGIN		VARCHAR2(30)				NO
TEST_DATE	Date this test was taken.	DATE	SORTEST	SORTEST_TEST_DATE	NO	NO
TEST_DESC	Test score description associated with a test, for example, SAT, ACT, placement scores, etc.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_ENTRY_USER_ID		VARCHAR2(30)				NO
TEST_FORM	Identifies the form of this test.	VARCHAR2(2)	SORTEST	SORTEST_TEFR_CODE	NO	NO
TEST_FORM_DESC	Test form description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_PERCENTILE		VARCHAR2(10)				NO
TEST_PERCENTILE_TYPE		VARCHAR2(10)				NO
TEST_PERCENTILE_TYPE_DESC		VARCHAR2(30)				NO
TEST_PURPOSE	Identifies the main purpose for this test.	VARCHAR2(2)	SORTEST	SORTEST_TEPR_CODE	NO	NO
TEST_PURPOSE_DESC	Test's purpose description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_SAT_ESSAY_ID		VARCHAR2(10)				NO
TEST_SCORE	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE	NO	NO
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	NO	NO
TEST_SOURCE_DESC	Description for the test source.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_TYPE	Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT.	VARCHAR2(0)	NA	NA	NO	NO
TEST_TYPE_DESC	Test type description.	VARCHAR2(0)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: