STUDENT AUDIT STRIP Table
Student's degree audit strip text. There are multiple records for the mulitple lines of strip text for a student. The LINE_TYPE field identifies the types of line (Beginning, Detail, Ending, etc.) and the LINE_SEQ_NUMBER field can be used to sequence/order the lines of text into a statement/paragraph.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
AUDIT_ID |
An identifier for the student audit record in STUDENT_AUDIT_SUMMARY and STUDENT_AUDIT_STRIP. |
NUMBER |
8 |
AUDIT_STRIP_TEXT |
Line of text in a student's audit record. |
VARCHAR2 |
78 |
LINE_SEQ_NUMBER |
Sequence numbers (eg. 1, 2, 3? ) for the lines of audit strip text in a student's audit record. Use this field to order the AUDIT_STRIP_TEXT field which contains the line of audit strip text. |
NUMBER |
2 |
LINE_TYPE |
Type of the line of audit strip text. The types are: B (Beginning), D (Detail), M (Middle), E (Ending). |
VARCHAR2 |
1 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |