SSM SUBJECT Table
This is a version of Subject Offered table built specifically for the Sloan School of Management.
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 |
CLUSTER_TYPE_DESC |
The description of a cluster type |
VARCHAR2 |
30 |
CONVERTED_MASTER_SUBJECT_ID |
XXX |
VARCHAR2 |
8 |
COURSE_NUMBER |
Course number or first part of the Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
3 |
COURSE_NUMBER_DESCRIPTION |
The descriptive text for COURSE_NUMBER. Eg. "Urban Studies and Planning" for COURSE_NUMBER 11. |
VARCHAR2 |
30 |
COURSE_NUMBER_SORT |
This field is used for sorting the records by Course Number in numeric order. |
VARCHAR2 |
3 |
HGN_CODE |
Code indentifies whether the subject can be taken at a graduate level: H (Higher level graduate program), G (Graduate program), N (Not for Graduate Credit). |
VARCHAR2 |
1 |
HGN_CODE_DESC |
Descriptive text for HGN_CODE which identifies whether the subject can be taken at a graduate level. H=Highler level graduate program; G=Graduate program; N=Not for graduate credit. |
VARCHAR2 |
30 |
IS_DESIGN_SECTION |
A flag indicating whether this subject record is a Design section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_LAB_SECTION |
A flag indicating whehter this subject record is a Lab section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_LECTURE_SECTION |
A flag indicating whether this subject record is a Lecture section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_MASTER_SECTION |
A 'Y' in this field indicates that this subject record is the "master" or the "main" record of the subject. It is not a section of the subject. It has a section ID of "000". |
VARCHAR2 |
1 |
IS_RECITATION_SECTION |
A flag indicating whether this subject is a Recitation section. Y=Yes, N=No |
VARCHAR2 |
1 |
MASTER_COURSE_DESCRIPTION |
The descriptive text for MASTER_COURSE_NUMBER, eg. "Urban Studies and Planning" for MASTER_COURSE_NUMBER 11. |
VARCHAR2 |
30 |
MASTER_COURSE_NUMBER |
Course number or the first part of the Master Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
3 |
MASTER_COURSE_NUMBER_SORT |
This field is used for sorting the Master Course Number in numeric order. |
VARCHAR2 |
3 |
MASTER_SUBJECT_ID |
The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this subject. |
VARCHAR2 |
8 |
MASTER_SUBJECT_ID_SORT |
This field is used for sorting the Master Subject ID in numeric order. |
VARCHAR2 |
8 |
MASTER_SUBJECT_KEY |
A special field created in the SUBJECT OFFERED table used for joining records in SUBJECT OFFERED to records in the INSTRUCTOR ROLE DETAIL table. This field is NOT for reporting. |
VARCHAR2 |
16 |
MEET_PLACE |
Place (classroom) where the section/class of this subject meets |
VARCHAR2 |
15 |
MEET_TIME |
Scheduled times when the section/class of this subject meets |
VARCHAR2 |
30 |
NUM_ENROLLED_STUDENTS |
Number of students enrolled in the section of the subject |
NUMBER |
5 |
OFFER_DEPT_NAME |
The name of the academic department which offers the subject/course |
VARCHAR2 |
30 |
OFFER_SCHOOL_NAME |
The school, for example "Architecture and Planning", which offers the subject. |
VARCHAR2 |
30 |
RESPONSIBLE_FACULTY_NAME |
The name of a faculty member/administrator who is responsible for the subject/class |
VARCHAR2 |
60 |
SECTION_ID |
The section code or number of the subject. Eg. L01, L02, R01, B01. |
VARCHAR2 |
3 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_ID_SORT |
This field is used for sorting the Subject ID in numeric order. |
VARCHAR2 |
8 |
SUBJECT_KEY |
Key identifying an entry in the SUBJECT OFFERED table. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
16 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
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_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |