| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | Date the table where record is stored was last edited. |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | Aid year code associated with the record listed. |
| Comment_Code_01 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 1 code listed. |
| Comment_Code_02 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 2 code listed. |
| Comment_Code_03 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 3 code listed. |
| Comment_Code_04 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 4 code listed. |
| Comment_Code_05 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 5 code listed. |
| Comment_Code_06 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 6 code listed. |
| Comment_Code_07 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 7 code listed. |
| Comment_Code_08 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 8 code listed. |
| Comment_Code_09 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 9 code listed. |
| Comment_Code_10 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 10 code listed. |
| Comment_Code_11 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 11 code listed. |
| Comment_Code_12 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 12 code listed. |
| Comment_Code_13 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 13 code listed. |
| Comment_Code_14 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 14 code listed. |
| Comment_Code_15 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 15 code listed. |
| Comment_Code_16 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 16 code listed. |
| Comment_Code_17 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 17 code listed. |
| Comment_Code_18 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 18 code listed. |
| Comment_Code_19 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 19 code listed. |
| Comment_Code_20 Indexed - no
Format - Number (22)
May be Null? Y | ISIR Comment 20 code listed. |
| Comment_Desc_01 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 1 description listed. |
| Comment_Desc_02 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 2 description listed. |
| Comment_Desc_03 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 3 description listed. |
| Comment_Desc_04 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 4 description listed. |
| Comment_Desc_05 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 5 description listed. |
| Comment_Desc_06 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 6 description listed. |
| Comment_Desc_07 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 7 description listed. |
| Comment_Desc_08 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 8 description listed. |
| Comment_Desc_09 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 9 description listed. |
| Comment_Desc_10 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 10 description listed. |
| Comment_Desc_11 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 11 description listed. |
| Comment_Desc_12 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 12 description listed. |
| Comment_Desc_13 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 13 description listed. |
| Comment_Desc_14 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 14 description listed. |
| Comment_Desc_15 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 15 description listed. |
| Comment_Desc_16 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 16 description listed. |
| Comment_Desc_17 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 17 description listed. |
| Comment_Desc_18 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 18 description listed. |
| Comment_Desc_19 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 19 description listed. |
| Comment_Desc_20 Indexed - no
Format - Varchar2 (4000)
May be Null? Y | ISIR Comment 20 description listed. |
| Fa_Comments_Flat_Pk Indexed - yes
Format - Varchar2 (364)
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 | User who last edited the table where record. |
