SSM SUBJECT TYPE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_TYPE |
The type of a cluster subject. Valid cluster_type are: J (joint subjects), M (subjects that meet together), S (SWE - School-Wide Electives) |
VARCHAR2 |
1 |
CONVERTED_MASTER_SUBJECT_ID |
XXX |
VARCHAR2 |
8 |
SUBJECT_TYPE |
Subject type code as catagorized by the Sloan School of Management for its Tuition Revenue Sharing Project. The valid subject types are: Sloan, Co-Sloan, E Center, and Non-Sloan. |
VARCHAR2 |
20 |
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_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |