SFA_SLC_ACAD_YRSFA_SLC_HEI_CDSFA_SLC_COURSE_CDSFA_SLC_COURSE_NMSFA_SLC_SEQSFA_SLC_COURSE_YRSFA_SLC_CD_CYR(SQL Table) |
Index Back |
|---|---|
SLC HEI Course DB Course YearSLC HEI Course Database Course Year Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_SLC_ACAD_YR |
Character(4) | VARCHAR2(4) NOT NULL | SLC Acad Year |
| 2 | SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL | HEI Code |
| 3 | SFA_SLC_COURSE_CD |
Character(15) | VARCHAR2(15) NOT NULL | SLC Course Code |
| 4 | SFA_SLC_COURSE_NM |
Character(120) | VARCHAR2(120) NOT NULL | Course Name |
| 5 | SFA_SLC_SEQ |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | SFA_SLC_COURSE_YR |
Character(1) | VARCHAR2(1) NOT NULL | Year of Course |
| 7 | SFA_SLC_FEE_CAP | Number(4,0) | SMALLINT NOT NULL | Fee Cap |
| 8 | SFA_SLC_LIVE_DTTM | Character(25) | VARCHAR2(25) NOT NULL | Live Date |