Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	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
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	NO	NO
INSTRUMENT	Instrument associated with the test, where applicable.	VARCHAR2(63)	SORTEST	SORTEST_TEIN_CODE	NO	NO
INSTRUMENT_DESC	Test instrument code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	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	Document or checklist item that is satisfied by entry of this information.	VARCHAR2(63)	SORTEST	SORTEST_ADMR_CODE	NO	NO
REQUIREMENT_DESC	Requirement description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE	NO	NO
TEST_ACCOMODATION	Identifies any special accommodations, if any, for this student taking this test.	VARCHAR2(63)	SORTEST	SORTEST_TEAC_CODE	NO	NO
TEST_ACCOMODATION_DESC	Test accommodations description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_ACTIVITY_DATE	Identifies the date the record was inserted or last updated.	DATE	SORTEST	SORTEST_ACTIVITY_DATE	NO	NO
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	NO	NO
TEST_ADMIN_TYPE_DESC	Description for the administration type used when this test was taken.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
TEST_ASSOCIATED_ACAD_PRD_DESC	Test associated academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
TEST_DATA_ORIGIN	Source system that created or updated this test record.	VARCHAR2(63)	SORTEST	SORTEST_DATA_ORIGIN	NO	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(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_ENTRY_USER_ID	User who inserted or last updated the data.	VARCHAR2(63)	SORTEST	SORTEST_USER_ID	NO	NO
TEST_FORM	Identifies the form of this test.	VARCHAR2(63)	SORTEST	SORTEST_TEFR_CODE	NO	NO
TEST_FORM_DESC	Test form description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
TEST_PURPOSE	Identifies the main purpose for this test.	VARCHAR2(63)	SORTEST	SORTEST_TEPR_CODE	NO	NO
TEST_PURPOSE_DESC	Test's purpose description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_SAT_ESSAY_ID	SAT Essay ID to view the prospects essay on the SAT website.	VARCHAR2(63)	SORTEST	SORTEST_SAT_ESSAY_ID	NO	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(63)	SORTEST	SORTEST_TSRC_CODE	NO	NO
TEST_SOURCE_DESC	Test source description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TEST_TYPE	Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT.	VARCHAR2(63)	NA	NA	NO	NO
TEST_TYPE_DESC	Test type description.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2