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 | SFA_SLC_HEI_CD | Character(4) | VARCHAR2(4) NOT NULL | HEI Code |
2 | SFA_SLC_ACAD_YR | Character(4) | VARCHAR2(4) NOT NULL | SLC Acad Year |
3 | SFA_SLC_LOC_CD | Character(2) | VARCHAR2(2) NOT NULL | Location Code |
4 | SFA_SLC_FILE_SEQ | 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 |