| Data element |
Definition |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? N | The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc. |
| Aidy_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | The description of the valid aid year. |
| Aidy_End_Date Indexed - no
Format - Date (7)
May be Null? Y | This is the official end date of the aid year. |
| Aidy_End_Year Indexed - no
Format - Number (22)
May be Null? Y | The year and century of the Aid Year End date. Example: If the Aid Year End Date = 30-JUN-1991, then Aid Year End Year = 1991. |
| Aidy_Start_Date Indexed - no
Format - Date (7)
May be Null? Y | This is the official start date of the aid year. |
| Aidy_Start_Year Indexed - no
Format - Number (22)
May be Null? Y | The year and century of the Aid Year Start date. Example: If the Aid Year Start Date = 01-JUL-1990, then Aid Year Start Year = 1990. |
| Aidy_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | This code defines if this Aid Year is an active year. |
| Fa_Aidy_Period_Pk Indexed - yes
Format - Varchar2 (76)
May be Null? N | |
| Legacy_Sam_Term Indexed - no
Format - Varchar2 (20)
May be Null? Y | Calculated legacy SAM term for a given period and aid year. |
| Legacy_Srs_Term Indexed - no
Format - Varchar2 (20)
May be Null? Y | Calculated legacy SRS term code for for term code associated with period and aid year. |
| Period_Active_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | This code defines if this Aid Year is an active year. |
| Period_Ar_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates if the term code is used for accounts receivable transactions for the period. |
| Period_Code Indexed - yes
Format - Varchar2 (60)
May be Null? Y | The code to define the enrollment or payment period for this record. |
| Period_Description Indexed - no
Format - Varchar2 (120)
May be Null? Y | The description of the enrollment or payment period. |
| Period_End_Date Indexed - no
Format - Date (7)
May be Null? Y | The end date of this enrollment or payment period. |
| Period_Sap_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates if the term code is used for satisfactory academic progress data for the period. |
| Period_Start_Date Indexed - no
Format - Date (7)
May be Null? Y | The start date of this enrollment or payment period. |
| Period_Student_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates if the term code is used for student data for the period. |
| Period_Term_Code Indexed - no
Format - Varchar2 (24)
May be Null? Y | The term code associated with the period. |
| Period_Term_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | The term description associated with the period. |
| Period_Term_End_Date Indexed - no
Format - Date (7)
May be Null? Y | This field identifies the term start date and is formatted DD-MON-YY. |
| Period_Term_Start_Date Indexed - no
Format - Date (7)
May be Null? Y | This field specifies the term associated with the term code. The term is identified by the academic year and term number and is formatted YYYYTT. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | Date the warehouse table was last refreshed |
| Stu_Fa_End_Period Indexed - no
Format - Number (22)
May be Null? Y | This field identifies the term end date and is fomatted DD-MON-YY. |
| Stu_Fa_Period Indexed - no
Format - Number (22)
May be Null? Y | This field identifies the financial aid award beginning period. |
| Stu_Fa_Proc_Yr Indexed - no
Format - Varchar2 (16)
May be Null? Y | This field identifies the financial aid processing start and end years (e.g. The financial aid processing year 1988 - 1989 is formatted 8889.). |
| Stu_Fa_Summer_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | SUMMER INDICATOR: Indicates a summer term to financial aid. |
| Stu_Fa_Term Indexed - no
Format - Varchar2 (4)
May be Null? Y | This field identifies the financial aid award term. |
