Penn Computing

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

FA_BUDGET_GRP_BY_PERIOD 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 - yes
Format - Date
May be Null? Y

The date that information in this record was entered or last updated in Banner.

Aidy_Code

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

The aid year associated with information in this record.

Budget_Group_Code

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

The period budget group assigned to the applicant.

Budget_Group_Desc

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

The description of the period budget group assigned.

Fa_Budget_Grp_Prd_Pk

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

Internal warehouse primary key based on PIDM, AIDY_CODE, RUN_NAME, BUDGET_TYPE, BUDGET_COMPONENT_CODE.

Penn_Id

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

Penn ID for student or applicant.

Period

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

The period associated with information in this record.

Pidm

Indexed - no
Format - Number (9)
May be Null? N

The internal system student identification number.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Last time data was refreshed for this record in the data warehouse.

Run_Name

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

The name to uniquely identify the run of period budgeting that produced this record.

User_Id

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

The user ID of the person who inserted or last updated this record.

FA_BUDGET_GRP_BY_PERIOD 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