EM ENROLLMENT CAPS SNAPSHOT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CAP |
XXX |
NUMBER |
5 |
CI_ATTRIBUTE |
XXX |
VARCHAR2 |
10 |
ENROLLMENT_CAP_KEY |
XXX |
VARCHAR2 |
100 |
PRIMARY_INSTRUCTOR_ID |
XXX |
VARCHAR2 |
64 |
PRIMARY_INSTRUCTOR_NAME |
XXX |
VARCHAR2 |
64 |
SECONDARY_INSTRUCTOR_ID |
XXX |
VARCHAR2 |
128 |
SECONDARY_INSTRUCTOR_NAME |
XXX |
VARCHAR2 |
128 |
SECTION |
The section ID |
VARCHAR2 |
3 |
SECTION_REGISTRATION |
XXX |
VARCHAR2 |
10 |
SNAPSHOT_NAME |
XXX |
VARCHAR2 |
25 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
10 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
150 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WAREHOUSE_CREATE_DATE |
XXX |
DATE |
|
WAREHOUSE_CREATE_USER |
XXX |
VARCHAR2 |
1 |