Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Common Reporting View Reports

Banner Operational Data Store
Reporting View Target: TEST

Description Contains data about test scores for a person.
Key & Frequency One row per person per test type per test date.
Recommended Search Columns PERSON_UID, TEST
TEST

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(63)

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: 9.1