SFA_SLC_ACAD_YRSFA_SLC_HEI_CDSFA_SLC_COURSE_CDSFA_SLC_COURSE_NMSFA_SLC_SEQSFA_SLC_CODE_TYPE1=ucas
2=jacs
3=ucasSuffix
SFA_SLC_CD_CCD(SQL Table) |
Index Back |
|---|---|
SLC HEI Course DB Course CodeSLC HEI Course Database Course Code and Type 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_CODE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Code Type
1=ucas 2=jacs 3=ucasSuffix |
| 7 | SFA_SLC_CODE | Character(4) | VARCHAR2(4) NOT NULL | Course Code |