Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_AIDID_RULES Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

AIDID_RULES - Data Element Index

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



 

Data element

Definition

Object name in Business Objects universe (if different from data element name)

Begin_Aidid

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

The first value in a range of Aid IDs used in the aggregate bucket load process.

 
Begin_Aid_Year

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

The first year in a range of SAM years to which this definition applies.

 
End_Aidid

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

The final value in a range of Aid IDs used in the aggregate bucket load process.

 
End_Aid_Year

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

The final year in a range of SAM years to which this definition applies.

 
Exclude_From_Calcs

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

An indicator of whether this definition should be excluded from all calculations. 

 
Paid or Offered    
Rule_Header

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

The Rule Header is the definition name and used to identify the rules for each bucket.

 
Rule_Name

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

Short description of the rule.

 
Rule_Header_Group1    
Rule_Header_Group2    
Rule_Header_Group3    
Rule_Header_Group4    
Unique_Id

Indexed - yes
Format - Number
May be Null? Y

Primary Key of the table.  Has no meaning.

 
FA_AIDID_RULES Table   Tables and Data Elements   FinAid 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