SUBJECT ENROLLABLE Table
View exposing subject enrollable-status records used to identify whether subjects are available for enrollment.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_LIST |
Cluster list associated with the record. |
VARCHAR2 |
4000 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
OFFER_DEPT_CODE |
Code identifying offer dept. |
VARCHAR2 |
4 |
OFFER_SCHOOL_CODE |
Code identifying offer school. |
VARCHAR2 |
2 |
SUBJECT_GROUP_ID |
Business identifier for the subject group. |
VARCHAR2 |
32 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
15 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
60 |
SUBJECT_TITLE_LONG |
Subject title long associated with the record. |
VARCHAR2 |
300 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
ULT_MASTER_SUBJECT_ID |
Business identifier for the ult master subject. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |