DAPER CSIAU STUDENT FEED Table
View exposing athletics student feed records used for cross-system tracking of student participation and eligibility.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHARGE_TO_ACCOUNT |
Charge to account as provided by the source. |
VARCHAR2 |
0 |
COURSE_1_DESC |
Description of course 1 desc. |
VARCHAR2 |
360 |
DATE_OF_BIRTH |
Date of birth as provided by the source. |
VARCHAR2 |
8 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
720 |
EMERGENCY_CONTACT |
Emergency contact as provided by the source. |
VARCHAR2 |
0 |
EXPIRATION_DATE |
Date associated with expiration. |
VARCHAR2 |
0 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
180 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
12 |
IS_ELIGIBLE_TO_REG |
Indicator identifying whether eligible to reg (Y/N). |
VARCHAR2 |
12 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
720 |
LIBRARY_ID |
Business identifier for the library. |
VARCHAR2 |
128 |
MAIN_MEMBER_ACCOUNT |
Main member account as provided by the source. |
VARCHAR2 |
0 |
MARITAL_STATUS |
Marital status as provided by the source. |
VARCHAR2 |
0 |
MEMBERSHIP_TYPE_CODE |
Code identifying membership type. |
CHAR |
|
MIDDLE_NAME |
Middle name as provided by the source. |
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 |
Online password as provided by the source. |
VARCHAR2 |
0 |
ONLINE_STATUS |
Online status as provided by the source. |
CHAR |
|
ONLINE_USERNAME |
Online username as provided by the source. |
VARCHAR2 |
0 |
PHONE1 |
Phone number associated with the record. |
VARCHAR2 |
0 |
PHONE2 |
Phone number associated with the record. |
VARCHAR2 |
0 |
REGISTRATION_TYPE |
Registration type as provided by the source. |
VARCHAR2 |
600 |
SALUTE |
Salute as provided by the source. |
VARCHAR2 |
0 |
SITE_ID |
Business identifier for the site. |
CHAR |
|
STATUS |
Status as provided by the source. |
CHAR |
|
STUDENT_YEAR |
Student year as provided by the source. |
VARCHAR2 |
12 |
SWIM_TEST_COMPLETE_FLAG |
Swim test complete flag as provided by the source. |
VARCHAR2 |
12 |
TERM_CITY |
Term city as provided by the source. |
VARCHAR2 |
480 |
TERM_STATE |
Term state as provided by the source. |
VARCHAR2 |
24 |
TERM_STREET_1 |
Term street 1 as provided by the source. |
VARCHAR2 |
420 |
TERM_STREET_2 |
Term street 2 as provided by the source. |
VARCHAR2 |
420 |
TERM_ZIP |
Term zip as provided by the source. |
VARCHAR2 |
108 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
VARCHAR2 |
8 |