Penn Computing

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

CUMULATIVE_AID_CAREER Table - 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)

Departmental_Grant

Indexed - no
Format - Number
May be Null? Y

Total departmental grant for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Faculty_Staff_Benefits

Indexed - no
Format - Number
May be Null? Y

Total faculty & staff benefits for a student's career at Penn. Please see aidid_rules_table for details on awards that are included in this total.

Federal_Grant

Indexed - no
Format - Number
May be Null? Y

Total Federal grant aid offered for a student's career at PENN. Includes Pell Grant, Academic Competitiveness Grant (ACG), SMART Grant, and Supplemental Educational Opportunity Grant (SEOG). Please see aidid_rules_table for details on awards that are included in this total.

Grad_Plus_Loan

Indexed - no
Format - Number
May be Null? Y

Total Grad PLUS Loan for a student's career at Penn. Please see aidid_rules_table for details on awards that are included in this total.

Grant_From_Endowment

Indexed - no
Format - Number
May be Null? Y

Total grant from endowed scholarships for a student's career at Penn. Please see aidid_rules_table for details on awards that are included in this total.

Grant_From_Term_Gifts

Indexed - no
Format - Number
May be Null? Y

Total grant from term gifts for a student's career at Penn. Please see aidid_rules_table for details on awards that are included in this total.

Health_Professions_Loan

Indexed - no
Format - Number
May be Null? Y

Total health professions loan for a student's career at Penn, including Health Profession Loans and Primary Care Loans.  Please see aidid_rules_table for details on awards that are included in this total.

Institutional_Grant

Indexed - no
Format - Number
May be Null? Y

Total institutional grant aid offered for a student's career at PENN. This is the sum of unrestricted funds, funds from endowment, and term gift funds

Institutional_Loan

Indexed - no
Format - Number
May be Null? Y

Total institutional loan packaged in aid award for a student's career at Penn. Please see aidid_rules_table for details on awards that are included in this total.

Load_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this student's record was refreshed in the warehouse from the Student Aid Management system (SAM). Does not indicate a specific column in a table has changed; the entire student's record gets refreshed whenever there is any change in SAM.

Nursing_Loan

Indexed - no
Format - Number
May be Null? Y

Total nursing loan for a student's career at Penn. Includes awards for the undergraduate and graduate programs.  Please see aidid_rules_table for details on awards that are included in this total.

Other_Loan

Indexed - no
Format - Number
May be Null? Y

Total institutional loans for a student's career at Penn. Includes awards that are not included in the other institutional loan categories.  Please see aidid_rules_table for details on awards that are included in this total.

Other_Outside_Grant

Indexed - no
Format - Number
May be Null? Y

Total other outside grant for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Packaged_Loan

Indexed - no
Format - Number
May be Null? Y

Total loan amount awarded to students in their financial aid award package during their career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Penn_Guaranteed_Loan

Indexed - no
Format - Number
May be Null? Y

Total Penn guaranteed loan packaged in aid award for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Penn_Id

Indexed - no
Format - Char
May be Null? Y


The 8-digit identification number assigned to the student; populated from a lookup to an extract from the PennCommunity database

Perkins_Loan

Indexed - no
Format - Number
May be Null? Y

Total Perkins Loan for a student's career at PENN

Prior_Consolidated_Loan

Indexed - no
Format - Number
May be Null? Y

 

Prior_Perkins_Loan

Indexed - no
Format - Number
May be Null? Y

Total borrowing from the Perkins Loan program prior to Penn. This is loaded when the very 1st FAFSA record is loaded when a student is admitted to Penn only.

Prior_Stafford_Direct_Loan

Indexed - no
Format - Number
May be Null? Y

Student's borrowing from the Federal Stafford Loan Program or William Ford Direct Loan program, prior to their admission to Penn.   This is loaded when the very 1st FAFSA record is loaded when a student is admitted to Penn only.

Private_Loan

Indexed - no
Format - Number
May be Null? Y


Total borrowing from non-federal loan sources.

Sid

Indexed - yes
Format - Char
May be Null? N

Social security number from source system. This is a protected field

Stafford_Direct_Loan

Indexed - no
Format - Number
May be Null? Y

Total Stafford or Direct Loan (beginning in July 2010) for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

State_Grant

Indexed - no
Format - Number
May be Null? Y

Total State grant for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Total_Loan

Indexed - no
Format - Number
May be Null? Y

Total loan borrowed from Federal, institutional, and other sources for a student's career at Penn.  Please see aidid_rules_table for details on awards that are included in this total.

Unrestricted_Grant

Indexed - no
Format - Number
May be Null? Y

Total grant from unrestricted funds for a student's career at PENN

Work_Study

Indexed - no
Format - Number
May be Null? Y

Total work study offered for a student's career at PENN. Work study award types include Federal Work Study, Penn Work Study, and International Work Study.

FA_CUMULATIVE_AID_CAREER 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