Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTRUMENT	Instrument associated with the test, where applicable.	VARCHAR2(63)	SORTEST	SORTEST_TEIN_CODE
INSTRUMENT_DESC	Test instrument code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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.	VARCHAR2(5)	SORTEST	SORTEST_SAT_ORIG_SCORE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORTEST	SORTEST_PIDM
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	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(63)	SORTEST	SORTEST_TESC_CODE
TEST_ACCOMODATION	Identifies any special accommodations, if any, for this student taking this test.	VARCHAR2(63)	SORTEST	SORTEST_TEAC_CODE
TEST_ACCOMODATION_DESC	Test accommodations description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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	Description for the administration type used when this test was taken.	VARCHAR2(255)	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(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_FORM	Identifies the form of this test.	VARCHAR2(63)	SORTEST	SORTEST_TEFR_CODE
TEST_FORM_DESC	Test form description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_PURPOSE	Identifies the main purpose for this test.	VARCHAR2(63)	SORTEST	SORTEST_TEPR_CODE
TEST_PURPOSE_DESC	Test's purpose description.	VARCHAR2(255)	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(63)	SORTEST	SORTEST_TSRC_CODE
TEST_SOURCE_DESC	Test source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_TYPE	Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT.	VARCHAR2(63)	NA	NA
TEST_TYPE_DESC	Test type description.	VARCHAR2(255)	NA	NA

Ver: 8.1