Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
EQUIVALENCY_IND Indicator used to show if the test score is an equivalency for the actual test taken.    

SORTEST

SORTEST_EQUIV_IND

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
INSTRUMENT Instrument associated with the test, where applicable.    

SORTEST

SORTEST_TEIN_CODE

 
INSTRUMENT_DESC Test instrument code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Name of the person (last name, first name, middle initial) or organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
ORIGINAL_SCORE Original score.    

SORTEST

SORTEST_SAT_ORIG_SCORE

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

SORTEST

SORTEST_PIDM

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
RECENTERED_OR_REVISED_IND Indicates whether the score has been recentered and/or revised.    

SORTEST

SORTEST_RCRV_IND

 
TEST Test score code associated with various tests, i.e., SAT, ACT, placement scores.    

SORTEST

SORTEST_TESC_CODE

 
TEST_ACCOMODATION Identifies any special accommodations, if any, for this student taking this test.    

SORTEST

SORTEST_TEAC_CODE

 
TEST_ACCOMODATION_DESC Test accommodations description.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_ADMIN_TYPE Identifies the type of administrative used for a particular test, i.e., locally or nationally administered.    

SORTEST

SORTEST_TADM_CODE

 
TEST_ADMIN_TYPE_DESC Description for the administration type used when this test was taken.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_DATE Date this test was taken.    

SORTEST

SORTEST_TEST_DATE

 
TEST_DESC Test score description associated with a test, for example, SAT, ACT, placement scores, etc.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_FORM Identifies the form of this test.    

SORTEST

SORTEST_TEFR_CODE

 
TEST_FORM_DESC Test form description.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_PURPOSE Identifies the main purpose for this test.    

SORTEST

SORTEST_TEPR_CODE

 
TEST_PURPOSE_DESC Test's purpose description.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_SCORE Test score value for this test code, date and person.    

SORTEST

SORTEST_TEST_SCORE

 
TEST_SOURCE Test score source, or how the test score was entered. For example, magnetic tape, self-reported, etc.    

SORTEST

SORTEST_TSRC_CODE

 
TEST_SOURCE_DESC Test source description.    

FUNCTION

GOKODSF.F_GET_DESC

 
TEST_TYPE Type of test, e.g., admissions, post graduate, ACT, SAT, GRE, GMAT.    

NA

NA

 
TEST_TYPE_DESC Test type description.    

NA

NA

 


Ver: 8.3