Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_IM_AVAIL_INC_CHART . Pennant Financial Aid Home . Data Warehouse Home

FA_IM_AVAIL_INC_CHART Table - Data Element Index

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

Data element Definition
Aid_Year_Code

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

Financial aid year code associated with record.

Entered_By

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

The user who entered this record.

Entered_On

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

Date that the ranges and amount for this aid year record were entered.

Last_Edited_By

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

The user who last edited this record.

Last_Edited_On

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

The date this record was last edited.

Pk_Im_Avail_Inc_Chart

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

Internal warehouse primary key

Range_Add_Back

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

The amount associated with this range and record.

Range_High

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

The maximum income associated with this record.

Range_Low

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

The minimum income associated with this record.

Range_Percent

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

The percent associated with this range and record.

Refresh_Date

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

Date that this warehouse record was last refreshed.

FA IM AVAIL INC CHART 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