Penn Computing

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

V_ACAD_AWARD_CAT Table - Data Element Index

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

Data element Definition
Acad_Award_Cat_Code

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

Code for the degree Award Category. Source field:  STVACAT_CODE

Acad_Award_Cat_Desc

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

Descriptive text title of the degree Award Category code. Source field: STVACAT_DESC.

Activity_Date

Indexed - no
Format - Date
May be Null? N

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

Nsc_Credential_Code

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

NSC credential level code assigned to the award category code, used by the national student clearinghouse report, and the degree verification report. Source field: STVACAT_NSC_CREDENTIAL_CDE

Nslds_Credential_Code

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

V_ACAD_AWARD_CAT

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

V_ACAD_AWARD_CAT 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