Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
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 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



Ver: 9.2