EHS COURSE OPTIONS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ARCHIVE_END_DATE |
XXX |
DATE |
|
ARCHIVE_START_DATE |
XXX |
DATE |
|
COURSE_EQUIV_ID |
XXX |
NUMBER |
12 |
COURSE_OPTION_CODE |
XXX |
VARCHAR2 |
15 |
COURSE_OPTION_CODE_CLASS |
XXX |
VARCHAR2 |
15 |
COURSE_OPTION_CODE_WEB |
XXX |
VARCHAR2 |
15 |
COURSE_OPTION_TYPE |
XXX |
VARCHAR2 |
2 |
COURSE_OPTION_TYPE_CLASS |
XXX |
VARCHAR2 |
2 |
COURSE_OPTION_TYPE_WEB |
XXX |
VARCHAR2 |
2 |
EHS_SOURCE |
XXX |
VARCHAR2 |
10 |
IS_BASE_COURSE |
XXX |
VARCHAR2 |
1 |
IS_REFRESHER_COURSE |
XXX |
VARCHAR2 |
1 |
RANKING_COURSE |
XXX |
NUMBER |
|
STATUS_CODE |
This field represents the status of the trainee's Kerberos username according to the Athena user accounts system. Normally, the field is set to 'A' (Active). If the username has been marked for deletion, but the trainee has not yet been moved from current tables to the archive tables, then this field is 'I' (Inactive). |
VARCHAR2 |
1 |