Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-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	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	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
REQUIREMENT	Document or checklist item that is satisfied by entry of this information.	VARCHAR2(63)	SORTEST	SORTEST_ADMR_CODE
REQUIREMENT_DESC	Requirement description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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_ACTIVITY_DATE	Identifies the date the record was inserted or last updated.	DATE	SORTEST	SORTEST_ACTIVITY_DATE
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_ASSOCIATED_ACAD_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 period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_ASSOCIATED_APPL_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	Source system that created or updated this test record.	VARCHAR2(63)	SORTEST	SORTEST_DATA_ORIGIN
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_ENTRY_USER_ID	User who inserted or last updated the data.	VARCHAR2(63)	SORTEST	SORTEST_USER_ID
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_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	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_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 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.5