SFA_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 |