MIT CARD STUDENT FEED Table
View exposing student identity and enrollment feed records used for MIT card eligibility and provisioning including academic, registration, contact, confidentiality, and term attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
Academic course or program associated with the student. |
VARCHAR2 |
11 |
CURRENT_CLASS |
Current class year associated with the student. |
VARCHAR2 |
4 |
CURRENT_ENROLL_STATUS |
Current enrollment status associated with the student. |
VARCHAR2 |
50 |
CURRENT_PLUS_1_ENROLL_STATUS |
Enrollment status associated with the next academic term. |
VARCHAR2 |
50 |
CURRENT_PLUS_1_REG_TYPE |
Registration type associated with the next academic term. |
VARCHAR2 |
50 |
CURRENT_PLUS_2_ENROLL_STATUS |
Enrollment status associated with the second future academic term. |
VARCHAR2 |
50 |
CURRENT_PLUS_2_REG_TYPE |
Registration type associated with the second future academic term. |
VARCHAR2 |
50 |
CURRENT_TERM |
Current academic term associated with the student. |
VARCHAR2 |
6 |
CURRENT_TERM_PLUS_1 |
Next academic term associated with the student. |
VARCHAR2 |
6 |
CURRENT_TERM_PLUS_2 |
Second future academic term associated with the student. |
VARCHAR2 |
6 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DEGREE_CANDIDATE_TERM |
Term associated with degree candidacy. |
VARCHAR2 |
14 |
DORM_ADDRESS |
Dormitory address associated with the student. |
VARCHAR2 |
30 |
DORM_ROOM |
Dormitory room associated with the student. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
Email address associated with the student. |
VARCHAR2 |
60 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
15 |
FLAGS |
Concatenated or encoded status flags associated with the student card provisioning record. |
CHAR |
|
GENDER |
Gender value associated with the student record. |
VARCHAR2 |
1 |
HOME_ADDRESS1 |
Primary home address line associated with the student. |
VARCHAR2 |
60 |
HOME_ADDRESS2 |
Secondary home address line associated with the student. |
VARCHAR2 |
60 |
HOME_CITY |
Home city associated with the student. |
VARCHAR2 |
80 |
HOME_COUNTRY |
Home country associated with the student. |
VARCHAR2 |
100 |
HOME_STATE |
Home state associated with the student. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
Home postal code associated with the student. |
VARCHAR2 |
9 |
IS_BIRTHDATE_CONFIDNTL |
Indicator identifying whether date of birth is confidential (Y/N). |
VARCHAR2 |
1 |
IS_COURSE_CONFIDNTL |
Indicator identifying whether course information is confidential (Y/N). |
VARCHAR2 |
1 |
IS_DEGREE_CANDIDATE |
Indicator identifying whether the student is a degree candidate (Y/N). |
VARCHAR2 |
1 |
IS_ELIGIBLE |
Indicator identifying whether the student is eligible for card provisioning (Y/N). |
VARCHAR2 |
1 |
IS_E_MAIL_CONFIDNTL |
Indicator identifying whether email address is confidential (Y/N). |
VARCHAR2 |
1 |
IS_HOME_ADDR_CONFIDNTL |
Indicator identifying whether home address is confidential (Y/N). |
VARCHAR2 |
1 |
IS_NEW_GRADUATE_STUDENT |
Indicator identifying whether the student is a new graduate student (Y/N). |
CHAR |
|
IS_REGISTERED |
Indicator identifying whether the student is registered (Y/N). |
VARCHAR2 |
1 |
IS_SERIOUS_CONFIDNTL |
Indicator identifying whether the student record has a serious confidentiality restriction (Y/N). |
VARCHAR2 |
1 |
IS_TERM_ADDR_CONFIDNTL |
Indicator identifying whether term address is confidential (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_CONFIDNTL |
Indicator identifying whether class year is confidential (Y/N). |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
Uppercase Kerberos username associated with the student used for matching and integration. |
VARCHAR2 |
8 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
60 |
LEGAL_FIRST_NAME |
Legal first name associated with the student. |
VARCHAR2 |
60 |
LEGAL_LAST_NAME |
Legal last name associated with the student. |
VARCHAR2 |
60 |
LEGAL_MIDDLE_NAME |
Legal middle name associated with the student. |
VARCHAR2 |
60 |
MIDDLE_NAME |
Middle name associated with the person. |
VARCHAR2 |
15 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ORIGINAL_CLASS |
Original class year associated with the student. |
VARCHAR2 |
4 |
PIDM |
Source-system person identifier associated with the student record. |
VARCHAR2 |
8 |
RANK_IDS |
Rank or sequencing value associated with the student record. |
NUMBER |
|
REGISTRATION_GROUP |
Registration group associated with the student record. |
VARCHAR2 |
50 |
REGISTRATION_TYPE |
Registration type associated with the student record. |
VARCHAR2 |
100 |
REGULAR_TERM_COMPLETED_GRAD |
Count of completed regular graduate terms associated with the student. |
NUMBER |
|
REGULAR_TERM_COMPLETED_UG |
Count of completed regular undergraduate terms associated with the student. |
NUMBER |
|
REG_ENDED_EARLY_DATE |
Date the student registration ended early, if applicable. |
DATE |
|
REG_ENDED_EARLY_REASON |
Reason the student registration ended early, if applicable. |
VARCHAR2 |
31 |
REG_IN_3091 |
Indicator associated with registration in 3091 status. |
VARCHAR2 |
1 |
STUDENT_TYPE |
Student type associated with the record. |
VARCHAR2 |
20 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
SUMMER_TERM_COMPLETED_GRAD |
Count of completed summer graduate terms associated with the student. |
NUMBER |
|
SUMMER_TERM_COMPLETED_UG |
Count of completed summer undergraduate terms associated with the student. |
NUMBER |
|
TERM_CODE |
Academic term code associated with the student record. |
VARCHAR2 |
6 |