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. |
|