SFA_SLC_ACAD_YRSFA_SLC_HEI_CDSFA_SLC_COURSE_CDSFA_SLC_COURSE_NMSFA_SLC_SEQSFA_SLC_COURSE_YRSFA_SLC_TERM_NBRSFA_SLC_CD_CTRM(SQL Table) |
Index Back |
|---|---|
SLC HEI Course DB Course TermSLC HEI Course Database Course Year Term 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_TERM_NBR |
Character(1) | VARCHAR2(1) NOT NULL | Term Number |
| 8 | SFA_SLC_CAMPUS_CD | Character(1) | VARCHAR2(1) NOT NULL | Campus Code |
| 9 | SFA_SLC_START_DT | Date(10) | DATE | Start Date |
| 10 | SFA_SLC_END_DT | Date(10) | DATE | End Date |
| 11 | SFA_SLC_LIVE_DTTM | Character(25) | VARCHAR2(25) NOT NULL | Live Date |