Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD APPLICATION DETAIL Table


Each record in this table represents an application to a graduate program at MIT. Information included in the record: entry term, entry date, graduate program applied, degree objective, decision and reply status of the application, and name, demographic, geographical region and previously attended schools of the applicant.


Field Name

Description

Data Type

Length

ADM_GRAD_APPLICANT_KEY

Graduate admissions applicant key. This field is used to join ADM GRAD APPLICANT table and a Graduate Admissions fact table (e.g. ADM GRAD APPLICATION DETAIL, ADM GRAD TEST SCORE DETAIL and ADM GRAD ATTENDED SCHOOL).

VARCHAR2

8

ADM_GRAD_APPLICATION_KEY

XXX

VARCHAR2

10

ADM_GRAD_ATTD_SCH_1_KEY

Use this field to join the ADM GRAD ATTD SCH 1 table to the ADM GRAD APPLICATION DETAIL table to get the last school attended by the applicant to attain a Bachelor Degree

VARCHAR2

20

ADM_GRAD_ATTD_SCH_2_KEY

Use this field to join the ADM GRAD ATTD SCH 2 table to the ADM GRAD APPLICATION DETAIL table to get the last school attended by the applicant.

VARCHAR2

20

ADM_GRAD_CITIZENSHIP_KEY

Graduate Admissions Citizenship Key. Use this field to join the ADM GRAD CITIZENSHIP table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

4

ADM_GRAD_DECISION_KEY

Graduate Admissions Decision Status Key. Use this field to join the ADM GRAD DECISION table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

7

ADM_GRAD_DEGREE_OBJECTIVE_KEY

Graduate Admissions Degree Objective Key. Use this field to join the ADM GRAD DEGREE OBJECTIVE table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

6

ADM_GRAD_DEMOGRAPHIC_KEY

Graduate Admissions Demographic Key. Use this field to join the ADM GRAD DEMOGRAPHIC table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

3

ADM_GRAD_ENROLL_SCHOOL_KEY

Key field used to join to the ADM_GRAD_ENROLL_SCHOOL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

ADM_GRAD_FEE_STATUS_KEY

Graduate Admissions Fee Status Key. Use this field to join the ADM GRAD FEE STATUS table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

2

ADM_GRAD_HOME_ADDR_GEO_KEY

Graduate Admissions Home Address Geo Key. Use this field to join the ADM GRAD HOME ADDR GEO table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

12

ADM_GRAD_PROGRAM_KEY

Graduate Admissions Program Key. Use this field to join the ADM GRAD PROGRAM table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

20

ADM_GRAD_REPLY_ADDR_GEO_KEY

Graduate Admissions Reply Address Geo Key. Use this field to join the ADM GRAD REPLY ADDR GEO table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

12

ADM_GRAD_REPLY_KEY

Graduate Admissions Reply Status Key. Use this field to join the ADM GRAD REPLY table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

3

ADM_GRAD_SURVEY_KEY

Use this field to join together the ADM_GRAD_SURVEY and ADM_GRAD_APPLICATION_DETAIL tables for graduate admissions survey data.

VARCHAR2

10

ADM_GRAD_TIME_KEY

Graduate Admissions Time Key. Use this field to join the ADM GRAD TIME table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

6

APPLICATION_COUNT

A counter, always contains a value of 1, used to count application.

NUMBER

1

APPLICATION_CREATED_BY

The person who created the application record in the Graduate Admissions system.

VARCHAR2

20

APPLICATION_CREATED_DATE

Date when the application record was created in the Graduate Admissions system.

DATE

8

APPLICATION_RECEIVED_DATE

Date when the application was received.

DATE

8

APPLICATION_SOURCE

The source of origination of this application. Eg.: "Paper Form", "Collegenet online application", "WWW PDF Downloadable Form".

VARCHAR2

30

APPLICATION_UPDATED_BY

The person who last modified the application record in the Graduate Admissions system.

VARCHAR2

20

APPLICATION_UPDATED_DATE

Date when the application record was last modified in the Graduate Admissions system.

DATE

8

DECISION_MADE_OFFICIAL_BY

The person who approves of the decision of the graduate admissions application.

VARCHAR2

20

DECISION_OFFICIAL_DATE

The date when the decision of the application becomes official.

DATE

8

LATEST_DECISION_DATE

The latest date when a decision was made on the application.

DATE

8

LATEST_REPLY_DATE

The latest date when a reply was sent in for the application.

DATE

8

ONLINE_APPLICATION_ID

XXX

VARCHAR2

40

WAREHOUSE_LOAD_DATE

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

DATE

8