Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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
REQUIREMENT	Requirement		VARCHAR2(4)
REQUIREMENT_DESC	Requirement Description		VARCHAR2(30)
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_ACTIVITY_DATE	Test Activity Date		DATE
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_ASSOCIATED_ACAD_PERIOD	Test Associated Academic Period		VARCHAR2(6)
TEST_ASSOCIATED_ACAD_PRD_DESC	Test Associated Academic Prd Description		VARCHAR2(30)
TEST_ASSOCIATED_APPL_NUMBER	Test Associated Applicant Number		NUMBER
TEST_DATA_ORIGIN	Test Data Origin		VARCHAR2(30)
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_ENTRY_USER_ID	Test Entry User ID		VARCHAR2(30)
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_PERCENTILE	Test Percentile		VARCHAR2(10)
TEST_PERCENTILE_TYPE	Test Percentile Type		VARCHAR2(10)
TEST_PERCENTILE_TYPE_DESC	Test Percentile Type Description		VARCHAR2(30)
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_SAT_ESSAY_ID	Test Sat Essay ID		VARCHAR2(10)
TEST_SCORE		Test score value for this test code, date and person.	VARCHAR2(63)		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: