Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SUBJECT AUDIT DETAIL Table


Degree audit data.


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

DEGREE_LEVEL

In SUBJECT_AUDIT_DETAIL: 'U'=Undergraduate, 'G'=Graduate

VARCHAR2

40

DESIGN_UNITS

Engineering design points

NUMBER

2

ENROLLMENT_KEY

Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting.

VARCHAR2

15

GIR_WEIGHT

Weight for General Institute Requirement (GIR).

NUMBER

3.1

GMOD_CODE

XXX

VARCHAR2

1

GMOD_DESC

XXX

VARCHAR2

30

GRADE

Grade symbol or letter

VARCHAR2

5

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

LAB_UNITS

The number of credit units assigned for laboratory, design, or fieldwork of a subject

NUMBER

2

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

LECTURE_UNITS

The number of credit units assigned for lecture and recitation of a subject.

NUMBER

2

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

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PREP_UNITS

Total units for preparation of the course

NUMBER

5

REQUIREMENT_DESCRIPTION

The degree requirement that this subject has fulfilled. Some of the requirements are: Calc I, Calc II, Phys I, Phys II, Chem, Biology, Phys II, CIH, Units beyond GIRS, REST subj, LAB, HASS-D subj, H units, H+G units, (CIHW + CIH), HASS subj, etc.

VARCHAR2

20

REQUIREMENT_TYPE

Requirement type.

VARCHAR2

1

REQUIREMENT_UNITS

Number of units fulfilled with this subject for this requirement.

NUMBER

2

REQ_ID

XXX

NUMBER

22

STUDENT_AUDIT_SUMMARY_KEY

Use this field to join together the STUDENT_AUDIT_SUMMARY and the SUBJECT_AUDIT_DETAIL tables for the degree audit profile and the subject details.

NUMBER

8

STUDENT_SUBJ_REG_ID

XXX

NUMBER

22

STUDENT_TERM_ENROLLMENT_KEY

Use this field to join to the STUDENT TERM ENROLLMENT table

VARCHAR2

15

SUBJECT_ATTRIBUTE_LIST

List of attributes this subject fulfills for degree requirements. Each attribute is separated by a comma in the list. Some examples of subject attribute lists are: "PHY1", "REST", "HA,HE", "CIH,HA,HD3,HE", "CAL1", "CIHW,HE,HH". You may look at the SUBJECT_ATTRIBUTE table for more information about each of the subject attribute.

VARCHAR2

60

SUBJECT_ID

The subject ID (eg.18.01, 15.012, 21W.731)

VARCHAR2

8

SUBJECT_REG_STATUS

Subject Registration Status.

VARCHAR2

2

SUBJECT_REG_STATUS_CODE

Subject registration code. Eg. RE (Registered), RL (Registered Listener), DE (Dropped Early, Not recorded), DR (Dropped after 5th week, on record), ET (Early thesis), AP (Advanced Placement), etc. You may query the SUBJECT_REG_STATUS table for more information about subject registration status.

VARCHAR2

2

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

THESIS_IND

'U' indicates that this is a undergraduate thesis subject, 'G' indicates that this is a graduate thesis subject.

VARCHAR2

1

TOTAL_UNITS

Total number of credit units of a subject.

NUMBER

2

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8