DAPER CSIAU STUDENT FEED Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHARGE_TO_ACCOUNT |
XXX |
VARCHAR2 |
0 |
COURSE_1_DESC |
Descriptive text for COURSE_1 |
VARCHAR2 |
360 |
DATE_OF_BIRTH |
The person's date of birth. |
VARCHAR2 |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
720 |
EMERGENCY_CONTACT |
XXX |
VARCHAR2 |
0 |
EXPIRATION_DATE |
In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires. |
VARCHAR2 |
0 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
180 |
GENDER |
The person's gender. |
VARCHAR2 |
12 |
IS_ELIGIBLE_TO_REG |
A flag indicates whether the student is eligible to register for the current academic year: Y (Yes), N (No) |
VARCHAR2 |
12 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
720 |
LIBRARY_ID |
XXX |
VARCHAR2 |
128 |
MAIN_MEMBER_ACCOUNT |
XXX |
VARCHAR2 |
0 |
MARITAL_STATUS |
XXX |
VARCHAR2 |
0 |
MEMBERSHIP_TYPE_CODE |
XXX |
CHAR |
|
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
180 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
108 |
ONLINE_PASSWORD |
XXX |
VARCHAR2 |
0 |
ONLINE_STATUS |
XXX |
CHAR |
|
ONLINE_USERNAME |
XXX |
VARCHAR2 |
0 |
PHONE1 |
XXX |
VARCHAR2 |
0 |
PHONE2 |
XXX |
VARCHAR2 |
0 |
REGISTRATION_TYPE |
Describes how the student has registered. Cross Registered - a student that is taking courses at MIT but whose primary affiliation is with another university. Special - A student who has registered for one or more courses but is not enrolled in a degree program. Regular - A student who is enrolled in a degree program. Non-resident - A doctoral student who is not living or working on campus. This type of student has complete all requirements other than the thesis. |
VARCHAR2 |
600 |
SALUTE |
XXX |
VARCHAR2 |
0 |
SITE_ID |
XXX |
CHAR |
|
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
CHAR |
|
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
12 |
SWIM_TEST_COMPLETE_FLAG |
A value of "A" in this field indicates that the student has completed his/her swim test. Blank or an "I" shows that the swim test is not complte. "I" was entered when a swim test was initially marked as complete but later rescinded as an error. |
VARCHAR2 |
12 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
480 |
TERM_STATE |
The student's home state for the current term. |
VARCHAR2 |
24 |
TERM_STREET_1 |
Term address, street 1 |
VARCHAR2 |
420 |
TERM_STREET_2 |
Term address, street 2 |
VARCHAR2 |
420 |
TERM_ZIP |
The student's home zip code for the current term. |
VARCHAR2 |
108 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
VARCHAR2 |
8 |