SFA_SLC_SSACHDR(SQL Table) |
Index Back |
---|---|
SLC SSAC HeaderSLC Student Support Attendance Confirmation Staging Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(4) | VARCHAR2(4) NOT NULL | HEI Code | |
2 | Character(4) | VARCHAR2(4) NOT NULL | SLC Acad Year | |
3 | Character(2) | VARCHAR2(2) NOT NULL | Location Code | |
4 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
5 | SFA_SLC_REC_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Record Type |
6 | SFA_SLC_FILE_TYPE | Character(2) | VARCHAR2(2) NOT NULL | File Type |
7 | SFA_FILE_PATH | Character(250) | VARCHAR2(250) NOT NULL | File Path |
8 | SFA_FILE_NAME | Character(128) | VARCHAR2(128) NOT NULL | File Name |
9 | SFA_SLC_PROC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Status
K=Skip P=Processed S=Suspended U=Unprocessed Default Value: U |
10 | SFA_SLC_PROC_DTTM | DateTime(26) | TIMESTAMP | Processed Date/Time |