FA_AWARD_AGG_SUMMARY_MV . Pennant Financial Aid Home . Data Warehouse Home

Aidy_Code Penn_Id Pidm Prev_Aidy_Code Prev_Aidy_Ind Prv_Totl_Accept Prv_Totl_Authorized Prv_Totl_Cancel Prv_Totl_Decline Prv_Totl_Grnt_Accept Prv_Totl_Grnt_Authorized Prv_Totl_Grnt_Cancel Prv_Totl_Grnt_Decline Prv_Totl_Grnt_Memo Prv_Totl_Grnt_Offer Prv_Totl_Grnt_Paid Prv_Totl_Loan_Accept Prv_Totl_Loan_Authorized Prv_Totl_Loan_Cancel Prv_Totl_Loan_Decline Prv_Totl_Loan_Memo Prv_Totl_Loan_Offer Prv_Totl_Loan_Paid Prv_Totl_Memo Prv_Totl_Offer Prv_Totl_Othr_Accept Prv_Totl_Othr_Authorized Prv_Totl_Othr_Cancel Prv_Totl_Othr_Decline Prv_Totl_Othr_Memo Prv_Totl_Othr_Offer Prv_Totl_Othr_Paid Prv_Totl_Paid Prv_Totl_Schl_Accept Prv_Totl_Schl_Authorized Prv_Totl_Schl_Cancel Prv_Totl_Schl_Decline Prv_Totl_Schl_Memo Prv_Totl_Schl_Offer Prv_Totl_Schl_Paid Prv_Totl_Work_Accept Prv_Totl_Work_Authorized Prv_Totl_Work_Cancel Prv_Totl_Work_Decline Prv_Totl_Work_Memo Prv_Totl_Work_Offer Prv_Totl_Work_Paid Totl_Accept Totl_Authorized Totl_Cancel Totl_Decline Totl_Grnt_Accept Totl_Grnt_Authorized Totl_Grnt_Cancel Totl_Grnt_Decline Totl_Grnt_Memo Totl_Grnt_Offer Totl_Grnt_Paid Totl_Loan_Accept Totl_Loan_Authorized Totl_Loan_Cancel Totl_Loan_Decline Totl_Loan_Memo Totl_Loan_Offer Totl_Loan_Paid Totl_Memo Totl_Offer Totl_Othr_Accept Totl_Othr_Authorized Totl_Othr_Cancel Totl_Othr_Decline Totl_Othr_Memo Totl_Othr_Offer Totl_Othr_Paid Totl_Paid Totl_Schl_Accept Totl_Schl_Authorized Totl_Schl_Cancel Totl_Schl_Decline Totl_Schl_Memo Totl_Schl_Offer Totl_Schl_Paid Totl_Work_Accept Totl_Work_Authorized Totl_Work_Cancel Totl_Work_Decline Totl_Work_Memo Totl_Work_Offer Totl_Work_Paid

Data element	Definition
Aidy_Code Indexed - yes Format - Varchar2(16) May be Null? Y	The aid year code for the record within the table.
Penn_Id Indexed - no Format - Varchar2(36) May be Null? Y	The student or Penn ID for the financial aid applicant.
Pidm Indexed - yes Format - Number(22) May be Null? Y	Personal identification number within the Banner data base to track individuals within tables.
Prev_Aidy_Code Indexed - no Format - Varchar2(16) May be Null? Y	Aid year code for the previous aid year.
Prev_Aidy_Ind Indexed - no Format - Char(4) May be Null? Y	Indicates that financial aid applicant had financial aid awarded the previous aid year. Y indicates that financial aid was previously awarded.
Prv_Totl_Accept Indexed - no Format - Number(22) May be Null? Y	Total accepted amount offered for financial aid applicant. Prior aid year.
Prv_Totl_Authorized Indexed - no Format - Number(22) May be Null? Y	Total authorized amount for financial aid applicant. Prior aid year.
Prv_Totl_Cancel Indexed - no Format - Number(22) May be Null? Y	Total canceled amount for financial aid applicant. Prior aid year.
Prv_Totl_Decline Indexed - no Format - Number(22) May be Null? Y	Total declined amount for financial aid applicant. Prior aid year.
Prv_Totl_Grnt_Accept Indexed - no Format - Number(22) May be Null? Y	Total grant amount accepted by the applicant for the aid year. Prior aid year.
Prv_Totl_Grnt_Authorized Indexed - no Format - Number(22) May be Null? Y	Total grant amount authorized for the applicant within the aid year. Prior aid year.
Prv_Totl_Grnt_Cancel Indexed - no Format - Number(22) May be Null? Y	Total grant amount canceled for the applicant within the aid year. Prior aid year.
Prv_Totl_Grnt_Decline Indexed - no Format - Number(22) May be Null? Y	Total grant amount declined by the applicant for an aid year. Prior aid year.
Prv_Totl_Grnt_Memo Indexed - no Format - Number(22) May be Null? Y	Total grant amount memoed for the applicant within the aid year. Prior aid year.
Prv_Totl_Grnt_Offer Indexed - no Format - Number(22) May be Null? Y	Total grant amount offered to the applicant for the aid year. Prior aid year.
Prv_Totl_Grnt_Paid Indexed - no Format - Number(22) May be Null? Y	Total grant amount paid for the applicant within the aid year. Prior aid year.
Prv_Totl_Loan_Accept Indexed - no Format - Number(22) May be Null? Y	Total loan amount accepted. Prior aid year.
Prv_Totl_Loan_Authorized Indexed - no Format - Number(22) May be Null? Y	Total loan amount authorized. Prior aid year.
Prv_Totl_Loan_Cancel Indexed - no Format - Number(22) May be Null? Y	Total loan amount cancelled. Prior aid year.
Prv_Totl_Loan_Decline Indexed - no Format - Number(22) May be Null? Y	Total loan amount declined. Prior aid year.
Prv_Totl_Loan_Memo Indexed - no Format - Number(22) May be Null? Y	Total loan amount memoed. Prior aid year.
Prv_Totl_Loan_Offer Indexed - no Format - Number(22) May be Null? Y	Total loan amount offered. Prior aid year.
Prv_Totl_Loan_Paid Indexed - no Format - Number(22) May be Null? Y	Total loan amount paid Prior aid year.
Prv_Totl_Memo Indexed - no Format - Number(22) May be Null? Y	Total memoed for financial aid applicant. Prior aid year.
Prv_Totl_Offer Indexed - no Format - Number(22) May be Null? Y	Total offered for aid year for financial aid applicant. Prior aid year.
Prv_Totl_Othr_Accept Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount accepted. Prior aid year.
Prv_Totl_Othr_Authorized Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount authorized. Prior aid year.
Prv_Totl_Othr_Cancel Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount cancelled. Prior aid year.
Prv_Totl_Othr_Decline Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount declined. Prior aid year.
Prv_Totl_Othr_Memo Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount memoed. Prior aid year.
Prv_Totl_Othr_Offer Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount offered. Prior aid year.
Prv_Totl_Othr_Paid Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount paid. Prior aid year.
Prv_Totl_Paid Indexed - no Format - Number(22) May be Null? Y	Total paid for financial aid applicant. Prior aid year.
Prv_Totl_Schl_Accept Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount accepted. Prior aid year.
Prv_Totl_Schl_Authorized Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount authoirzed. Prior aid year.
Prv_Totl_Schl_Cancel Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount cancelled. Prior aid year.
Prv_Totl_Schl_Decline Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount declined. Prior aid year.
Prv_Totl_Schl_Memo Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount memoed. Prior aid year.
Prv_Totl_Schl_Offer Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount offered. Prior aid year.
Prv_Totl_Schl_Paid Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount paid. Prior aid year.
Prv_Totl_Work_Accept Indexed - no Format - Number(22) May be Null? Y	Total accepted work study amount. Prior aid year.
Prv_Totl_Work_Authorized Indexed - no Format - Number(22) May be Null? Y	Total work study amount authorized. Prior aid year.
Prv_Totl_Work_Cancel Indexed - no Format - Number(22) May be Null? Y	Total work study amount cancelled Prior aid year.
Prv_Totl_Work_Decline Indexed - no Format - Number(22) May be Null? Y	Total work study amount declined. Prior aid year.
Prv_Totl_Work_Memo Indexed - no Format - Number(22) May be Null? Y	Total work study memoed. Prior aid year.
Prv_Totl_Work_Offer Indexed - no Format - Number(22) May be Null? Y	Total work study offered. Prior aid year.
Prv_Totl_Work_Paid Indexed - no Format - Number(22) May be Null? Y	Total work study paid. Prior aid year.
Totl_Accept Indexed - no Format - Number(22) May be Null? Y	Total accepted amount offered for financial aid applicant.
Totl_Authorized Indexed - no Format - Number(22) May be Null? Y	Total authorized amount for financial aid applicant.
Totl_Cancel Indexed - no Format - Number(22) May be Null? Y	Total canceled amount for financial aid applicant.
Totl_Decline Indexed - no Format - Number(22) May be Null? Y	Total declined amount for financial aid applicant.
Totl_Grnt_Accept Indexed - no Format - Number(22) May be Null? Y	Total grant amount accepted by the applicant for the aid year.
Totl_Grnt_Authorized Indexed - no Format - Number(22) May be Null? Y	Total grant amount authorized for the applicant within the aid year.
Totl_Grnt_Cancel Indexed - no Format - Number(22) May be Null? Y	Total grant amount canceled for the applicant within the aid year.
Totl_Grnt_Decline Indexed - no Format - Number(22) May be Null? Y	Total grant amount declined by the applicant for an aid year.
Totl_Grnt_Memo Indexed - no Format - Number(22) May be Null? Y	Total grant amount memoed for the applicant within the aid year.
Totl_Grnt_Offer Indexed - no Format - Number(22) May be Null? Y	Total grant amount offered to the applicant for the aid year.
Totl_Grnt_Paid Indexed - no Format - Number(22) May be Null? Y	Total grant amount paid for the applicant within the aid year.
Totl_Loan_Accept Indexed - no Format - Number(22) May be Null? Y	Total loan amount accepted.
Totl_Loan_Authorized Indexed - no Format - Number(22) May be Null? Y	Total loan amount authorized.
Totl_Loan_Cancel Indexed - no Format - Number(22) May be Null? Y	Total loan amount cancelled.
Totl_Loan_Decline Indexed - no Format - Number(22) May be Null? Y	Total loan amount declined.
Totl_Loan_Memo Indexed - no Format - Number(22) May be Null? Y	Total loan amount memoed.
Totl_Loan_Offer Indexed - no Format - Number(22) May be Null? Y	Total loan amount offered.
Totl_Loan_Paid Indexed - no Format - Number(22) May be Null? Y	Total loan amount paid
Totl_Memo Indexed - no Format - Number(22) May be Null? Y	Total memoed for financial aid applicant.
Totl_Offer Indexed - no Format - Number(22) May be Null? Y	Total offered for aid year for financial aid applicant.
Totl_Othr_Accept Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount accepted.
Totl_Othr_Authorized Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount authorized.
Totl_Othr_Cancel Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount cancelled.
Totl_Othr_Decline Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount declined.
Totl_Othr_Memo Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount memoed.
Totl_Othr_Offer Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount offered.
Totl_Othr_Paid Indexed - no Format - Number(22) May be Null? Y	Total other (non-grant, non-scholarship, non-loan, non-workstudy) amount paid.
Totl_Paid Indexed - no Format - Number(22) May be Null? Y	Total paid for financial aid applicant.
Totl_Schl_Accept Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount accepted.
Totl_Schl_Authorized Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount authoirzed.
Totl_Schl_Cancel Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount cancelled.
Totl_Schl_Decline Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount declined.
Totl_Schl_Memo Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount memoed.
Totl_Schl_Offer Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount offered.
Totl_Schl_Paid Indexed - no Format - Number(22) May be Null? Y	Total scholarship amount paid.
Totl_Work_Accept Indexed - no Format - Number(22) May be Null? Y	Total accepted work study amount.
Totl_Work_Authorized Indexed - no Format - Number(22) May be Null? Y	Total work study amount authorized.
Totl_Work_Cancel Indexed - no Format - Number(22) May be Null? Y	Total work study amount cancelled
Totl_Work_Decline Indexed - no Format - Number(22) May be Null? Y	Total work study amount declined.
Totl_Work_Memo Indexed - no Format - Number(22) May be Null? Y	Total work study memoed.
Totl_Work_Offer Indexed - no Format - Number(22) May be Null? Y	Total work study offered.
Totl_Work_Paid Indexed - no Format - Number(22) May be Null? Y	Total work study paid.

FA_AWARD_AGG_SUMMARY_MV . Pennant Financial Aid Home . Data Warehouse Home