SFA_SLC_ACRXRES(SQL Table) |
Index Back |
|---|---|
SLC ACRX PopSelect ResultsSLC Attendance Confirmation Report Export Population Select Results Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 4 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 5 | SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL | HEI Code |
| 6 | SFA_SLC_ISSUE_DT |
Date(10) | DATE | Issue Date |
| 7 | SFA_SLC_LIAB_PRD |
Character(1) | VARCHAR2(1) NOT NULL |
Liability Period
1=1 2=2 3=3 Default Value: 1 |
| 8 | SFA_SLC_SSN | Character(13) | VARCHAR2(13) NOT NULL | Student Support Nbr |
| 9 | SFA_SLC_FILE_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
File Type
ACR=Attendance Confirmation Reqst EXT=Extended SISF SCA=Short Course Attendance SIS=Student Information Service |
| 10 | SFA_SLC_ACAD_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Academic Load
B=Both Full Time and Part Time F=Full Time N=None P=Part Time |
| 11 | SFA_SLC_CALC_FTE | Number(5,1) | DECIMAL(4,1) NOT NULL | Calculated FTE |
| 12 | SFA_SLC_OVR_FTE | Number(5,1) | DECIMAL(4,1) NOT NULL | Override FTE |
| 13 | SFA_SLC_ZERO_FTE | Character(1) | VARCHAR2(1) NOT NULL | Report Zero |