| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SFA_SLC_ACAD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table:
SFA_SLC_ACYRVW2
|
| 2 |
SFA_SLC_HEI_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table:
SFA_SLC_HEI_VW2
|
| 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
Default Value: 1
|
| 6 |
SFA_SLC_CRSE_TITLE |
Character(120) |
VARCHAR2(120) NOT NULL |
Course Title
|
| 7 |
SFA_SLC_CRSE_DESCR |
Character(120) |
VARCHAR2(120) NOT NULL |
Course Name
|
| 8 |
SFA_SLC_CRSE_DURTN |
Number(2,0) |
SMALLINT NOT NULL |
Course Duration
|
| 9 |
SFA_SLC_CRSE_TYPE2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Type
ACCE=Accelerated
ART=Art Teacher
EMER=Emergency
FRAN=Franchised
OTHE=Other
PART=Part Time
PGCE=PGCE
|
| 10 |
SFA_SLC_CRSE_QUAL |
Character(8) |
VARCHAR2(8) NOT NULL |
Qualification
|
| 11 |
SFA_SLC_CRSE_ATTND |
Character(2) |
VARCHAR2(2) NOT NULL |
Method of Attendance
DL=Full Time Distance Learning
FE=Full Time and Extended
FP=Full Time and Part Time
FS=Full Time plus Sandwich
FT=Full Time
OT=Other - Unknown
PT=Part Time
|
| 12 |
SFA_SLC_CRSE_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Status
C=Closed
O=Open
|
| 13 |
SFA_SLC_CRSE_UCAS |
Character(1) |
VARCHAR2(1) NOT NULL |
UCAS Course
Y/N Table Edit
Default Value: N
|
| 14 |
SFA_SLC_UCAS_SUFFX |
Character(1) |
VARCHAR2(1) NOT NULL |
UCAS Suffix
|
| 15 |
SFA_SLC_RESULT_NBR |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Result Number
|
| 16 |
SFA_SLC_RESULT_MSG |
Character(100) |
VARCHAR2(100) NOT NULL |
Result Message
|
| 17 |
SFA_SLC_LAST_DTTM |
Character(25) |
VARCHAR2(25) NOT NULL |
Last Updated DateTime
|
| 18 |
SFA_SLC_CD_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Database Status
1=Data Received from SLC
2=Data successfully sent to SLC
3=Error sending to SLC
4=Data rejected by SLC
5=Data will be sent to SLC
6=Obsolete Data
Default Value: 5
|
| 19 |
SFA_SLC_LIVE_DTTM |
Character(25) |
VARCHAR2(25) NOT NULL |
Live Date
|
| 20 |
SFA_SLC_HEI_CRSECD |
Character(30) |
VARCHAR2(30) NOT NULL |
HEI Course Code
|