| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | Date of last update for this RCRESAR aid year code record. |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | Aid year code associated with the record listed. |
| Comment_Code Indexed - no
Format - Number (22)
May be Null? Y | ISIR comment code listed. |
| Comment_Code_Numb Indexed - yes
Format - Varchar2 (3)
May be Null? Y | Within the original Banner Financial Aid table RCRESAR, the comment column number this comment code was listed. |
| Comment_Desc Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR comment description. |
| Fa_Comments_Vertical_Pk Indexed - yes
Format - Varchar2 (700)
May be Null? Y | Internal warehouse primary key |
| Infc_Code Indexed - yes
Format - Varchar2 (28)
May be Null? Y | A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, EDE, etc. |
| Infc_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | The description from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, EDE, etc. |
| Penn_Id Indexed - yes
Format - Varchar2 (36)
May be Null? Y | Penn student ID used to reference student through out the university. |
| Pidm Indexed - yes
Format - Number (22)
May be Null? Y | Internal number assigned to student within Banner database. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | Date that this warehouse record was last refreshed. |
| Seq_No Indexed - yes
Format - Number (22)
May be Null? Y | Sequence number associated with the interface tape table record. |
| User_Id Indexed - no
Format - Varchar2 (120)
May be Null? Y | Last user to update the RCRESAR aid year code record. |
