| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The date that information in this record was entered or last updated in Banner. |
| Aidy_Code Indexed - yes
Format - Varchar2 (4)
May be Null? N | The aid year code to be associated with information in this record. |
| Disb_Ind Indexed - no
Format - Varchar2 (2)
May be Null? Y | Indicates whether the tracking requirement must be satisfied for the fund to disburse. |
| Established_Date Indexed - no
Format - Date
May be Null? Y | The date the tracking requirement was established. |
| Fa_Tr_St_Code Indexed - no
Format - Varchar2(2)
May be Null? N | The status of the tracking requirement. |
| Fa_Tr_St_Date Indexed - no
Format - Date
May be Null? Y | The last date on which the status of this requirement was updated. |
| Fa_Tr_St_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | The status description of the tracking requirement. |
| Fund_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The fund code associated with the tracking requirement. |
| Fund_Title Indexed - no
Format - Varchar(30)
May be Null? N | Description of fund. |
| Memo_Ind Indexed - no
Format - Varchar2(2)
May be Null? Y | Indicates whether the tracking requirement must be satisfied in order to memo. |
| Mpn_First_Disb_Date Indexed - no
Format - Date
May be Null? Y | The date of the first Perkins disbursement made for this Perkins Master Promissory Note. |
| Mpn_Signed_Date Indexed - no
Format - Date
May be Null? Y | The date the student signed the Perkins Master Promissory Note. |
| Mpn_Tr_Req_Sat_Date Indexed - no
Format - Date
May be Null? Y | Indicates FFA eligibility. The date the Perkins Master Promissory Note tracking requirement was satisfied. |
| Pckg_Ind Indexed - no
Format - Varchar2(2)
May be Null? Y | Indicates whether the tracking requirement must be satisfied in order for the fund to be packaged. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Student or applicant Penn ID. |
| Perk_Mpn_Exp_Date Indexed - no
Format - Date
May be Null? Y | The expiration date of the Perkins multi-award year Master Promissory Note. |
| Perk_Mpn_Flag Indexed - no
Format - Varchar2(2)
May be Null? Y | Checked indicates the requirement is a Perkins Master Promissory Note. |
| Pidm Indexed - no
Format - Number(8)
May be Null? N | The internal system-generated student identification number for the student in this record. |
| Pk_Fa_Tr_Req Indexed - no
Format - Number(8)
May be Null? Y | Primay key for database processing needs, using AIDY_CODE, PIDM, TR_REQ_CODE, REQ_SURROGATE_ID. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date information was last updated to data warehouse. |
| Req_Surrogate_Id Indexed - no
Format - Number(19)
May be Null? Y | Unique ID from source requirements table. |
| Sat_Ind Indexed - no
Format - Varchar2(2)
May be Null? Y | Indicates if the tracking requirement has been satisfied. |
| Tr_Req_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The code associated with the tracking requirement. |
| Tr_Req_Desc_Long Indexed - no
Format - Varchar2(60)
May be Null? Y | The long description of the tracking code. |
| Tr_Req_Desc_Short Indexed - no
Format - Varchar2(20)
May be Null? Y | The short description of the tracking code. |
| User_Id Indexed - no
Format - Varchar2(30)
May be Null? Y | The user ID of the person who inserted or last updated this record. |
| User_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Name of individual who last inserted or last updated this record. |
| User_Penn_Id Indexed - no
Format - Varchar2(12)
May be Null? Y | The Penn ID for person who last inserted or last updated this record. |
| Stdn_Ind Indexed - no
Format - Number(6)
May be Null? Y | The Voice Response message number assigned to the recorded message that describes the tracking requirement code. |
