Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA RACE Table . Pennant Financial Aid Home . Data Warehouse Home

FA_RACE 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 (7)
May be Null? Y

Last date the record was created or updated in the source.

Fed_Rept_Race_Code

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

For rows representing a detail category, this indicates the broader race categorization used for reporting to the Federal Government.

Fed_Rept_Race_Desc

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

Descriptive text name for the code in the FED_REPT_RACE column.

Penn_Id

Indexed - yes
Format - Varchar2 (36)
May be Null? Y

Penn's identitiy management system identification number

Pidm

Indexed - no
Format - Number (22)
May be Null? Y

internal identification number in source

Race_Code

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

Penn's code for the student's race. Includes the detail categories, and also includes detail categories for ethnicity.

Race_Desc

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

Descriptive text name for the code in the RACE column.

Refresh_Date

Indexed - no
Format - Date (7)
May be Null? Y

date DW record in STDT_RACE was last refreshed

St_Race_Pk

Indexed - yes
Format - Varchar2 (44)
May be Null? N

internal warehouse primary key, based on to_char(PIDM), RACE_CODE

FA RACE Table . Pennant Financial Aid 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