| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-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
|
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
|
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
|