EHS COMPLETED COURSES Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ARCHIVE_END_DATE |
XXX |
DATE |
|
ARCHIVE_START_DATE |
XXX |
DATE |
|
CDATE |
XXX |
DATE |
|
CLASSROOM_OPTION |
XXX |
VARCHAR2 |
15 |
COMPLETED |
XXX |
CHAR |
|
COMPLETE_BY_DATE |
XXX |
VARCHAR2 |
0 |
COMPLETION_DATE |
The end date. |
VARCHAR2 |
21 |
COURSE_OPTION_CODE |
XXX |
VARCHAR2 |
15 |
EHS_SOURCE |
XXX |
VARCHAR2 |
10 |
EXPIRATION_DATE |
In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires. |
VARCHAR2 |
21 |
IS_EXPIRED |
XXX |
VARCHAR2 |
1 |
IS_MOST_RECENT |
XXX |
VARCHAR2 |
1 |
KERBEROS_NAME |
The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system. |
VARCHAR2 |
8 |
OTHER_OPTION |
XXX |
VARCHAR2 |
15 |
PREREQ_COURSE_OPTION_CODE |
XXX |
VARCHAR2 |
0 |
REQUIREMENT |
XXX |
VARCHAR2 |
100 |
WEB_OPTION |
XXX |
VARCHAR2 |
15 |