Penn Computing

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

ST_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
May be Null? Y

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

Fed_Rept_Race_Code

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

This code indicates the broader race categorization used for reporting to the Federal Government. Used in the "Rollup-Race" field in the STUDENT table.

Fed_Rept_Race_Desc

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

Descriptive text name for the code in the FED_REPT_RACE column.

Penn_ID

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

The student's Penn_ID. Penn's identity management system identification number.

Pidm

Indexed - no
Format - Number
May be Null? Y

internal identification number in source

Race_Code

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

Penn's code for the student's race. Race codes can be for the detail categories within a federal race reporting group. The ST_RACE table also includes detail categories for ethnicity.

Race_Desc

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

Descriptive text name for the code in the RACE column.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date the warehouse record in ST_RACE was last refreshed

St_Race_Pk

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

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

ST_RACE 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