Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_TEST Table . Pennant Student Records Home . Data Warehouse Home

V_TEST Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? N

Last date the record was entered or updated in the source. Source field: STVORIG_ACTIVITY_DATE

Admr_Code

Indexed - no
Format - Varchar2(4)
May be Null? Y

Source field: STVTESC_ADMR_CODE

Assessment_Form

Indexed - no
Format - Varchar2(1)
May be Null? Y

Source field: STVTESC_ASSESSMENT_FORM

Date_Type

Indexed - no
Format - Varchar2(1)
May be Null? Y

Identifies if the test scores for this test type will be numeric or alphanumeric. Source field: STVTESC_DATA_TYPE

Max_Value

Indexed - no
Format - Varchar2(15)
May be Null? Y

The maximum score for this test type. Source field: STVTESC_MAX_VALUE

Min_Value

Indexed - no
Format - Varchar2(15)
May be Null? Y

The minimum score for this test type. Source field: STVTESC_MIN_VALUE

Mis_Code

Indexed - no
Format - Varchar2(4)
May be Null? Y

Source field: STVTESC_MIS_CODE

Num_Positions

Indexed - no
Format - Number
May be Null? Y

The number of positions allowed for the score of this test type. Source field:  STVTESC_NO_POSITIONS

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

Test_Code

Indexed - no
Format - Varchar2(6)
May be Null? N

Code for the type of test. Source field: STVTESC_CODE

Test_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Descriptive text title of the Test type. Source field:  STVTESC_DESC

V_TEST Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania