Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
EQUIVALENCY_IND	Equivalency Indicator	Indicator used to show if the test score is an equivalency for the actual test taken.	VARCHAR2(1)		SORTEST	SORTEST_EQUIV_IND
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTRUMENT	Instrument	Instrument associated with the test, where applicable.	VARCHAR2(63)		SORTEST	SORTEST_TEIN_CODE
INSTRUMENT_DESC	Instrument Description	Test instrument code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ORIGINAL_SCORE	Original Score	Original score.	VARCHAR2(5)		SORTEST	SORTEST_SAT_ORIG_SCORE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		SORTEST	SORTEST_PIDM
PROCESS_GROUP	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	Recentered Or Revised Indicator	Indicates whether the score has been recentered and/or revised.	VARCHAR2(1)		SORTEST	SORTEST_RCRV_IND
REQUIREMENT	Requirement	Document or checklist item that is satisfied by entry of this information.	VARCHAR2(63)		SORTEST	SORTEST_ADMR_CODE
REQUIREMENT_DESC	Requirement Description	Requirement description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST	Test	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST_ACCOMODATION	Test Accomodation	Identifies any special accommodations, if any, for this student taking this test.	VARCHAR2(63)		SORTEST	SORTEST_TEAC_CODE
TEST_ACCOMODATION_DESC	Test Accomodation Description	Test accommodations description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_ACTIVITY_DATE	Test Activity Date	Identifies the date the record was inserted or last updated.	DATE		SORTEST	SORTEST_ACTIVITY_DATE
TEST_ADMIN_TYPE	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	Test Admin Type Description	Description for the administration type used when this test was taken.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_ASSOCIATED_ACAD_PERIOD	Test Associated Academic Period	Academic period entered when the test score is recorded. This may have been the admission application academic period or the academic period in which the test was taken. This may be blank.	VARCHAR2(63)		SORTEST	SORTEST_TERM_CODE_ENTRY
TEST_ASSOCIATED_ACAD_PRD_DESC	Test Associated Academic Prd Description	Test associated academic period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_ASSOCIATED_APPL_NUMBER	Test Associated Applicant Number	Test associated admissions application number entered when the test score is recorded. If the associated academic period was entered this is the admission application number associated with that academic period that required this test score.	NUMBER		SORTEST	SORTEST_APPL_NO
TEST_DATA_ORIGIN	Test Data Origin	Source system that created or updated this test record.	VARCHAR2(63)		SORTEST	SORTEST_DATA_ORIGIN
TEST_DATE	Test Date	Date this test was taken.	DATE		SORTEST	SORTEST_TEST_DATE
TEST_DESC	Test Description	Test score description associated with a test, for example, SAT, ACT, placement scores, etc.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_ENTRY_USER_ID	Test Entry User ID	User who inserted or last updated the data.	VARCHAR2(63)		SORTEST	SORTEST_USER_ID
TEST_FORM	Test Form	Identifies the form of this test.	VARCHAR2(63)		SORTEST	SORTEST_TEFR_CODE
TEST_FORM_DESC	Test Form Description	Test form description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_PERCENTILE_COUNT	Test Percentile Count	Number of test percentile records recorded and stored for this test, test score and test date.	NUMBER		FUNCTION	MSKFUNC.F_GET_TEST_PERCENTILE_COUNT
TEST_PURPOSE	Test Purpose	Identifies the main purpose for this test.	VARCHAR2(63)		SORTEST	SORTEST_TEPR_CODE
TEST_PURPOSE_DESC	Test Purpose Description	Test's purpose description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_SAT_ESSAY_ID	Test Sat Essay ID	SAT Essay ID to view the prospects essay on the SAT website.	VARCHAR2(63)		SORTEST	SORTEST_SAT_ESSAY_ID
TEST_SCORE	Test Score	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SOURCE	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	Test source description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_TYPE	Test Type	Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT.	VARCHAR2(63)		NA	NA
TEST_TYPE_DESC	Test Type Description	Test type description.	VARCHAR2(255)		NA	NA

Ver: 9.0