SFA_SLC_HEI_CDPrompt Table: SFA_SLC_HEI_VW
SFA_SLC_ACAD_YRPrompt Table: SFA_SLC_ACYR_VW
SFA_SLC_COURSE_PERAUT=AUT
SPR=SPR
SUM=SUM
WIN=WIN
SFA_SLC_LIAB_PRD1=1
2=2
3=3
SFA_SLC_LIAB(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table: SFA_SLC_HEI_VW |
| 2 | SFA_SLC_ACAD_YR |
Character(4) | VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table: SFA_SLC_ACYR_VW |
| 3 | SFA_SLC_COURSE_PER |
Character(3) | VARCHAR2(3) NOT NULL |
Course Start Period
AUT=AUT SPR=SPR SUM=SUM WIN=WIN |
| 4 | SFA_SLC_LIAB_PRD |
Character(1) | VARCHAR2(1) NOT NULL |
Liability Period
1=1 2=2 3=3 |
| 5 | SFA_SLC_LBSTART_DT | Date(10) | DATE NOT NULL | Start Date |
| 6 | SFA_SLC_LBEND_DT | Date(10) | DATE NOT NULL | End Date |