Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ASA EARLYRETURN REQ DETAIL Table


Association of Student Activities Early Return Requests


Field Name

Description

Data Type

Length

APPROVED_RETURN_DATE

XXX

DATE

8

ASA_REQUEST_STATUS_KEY

Use this field to join together the ASA REQUEST STATUS table and another ASA fact table with the same-name field.

VARCHAR2

20

ASA_STUDENT_GROUP_KEY

Use this field to join together the ASA STUDENT GROUP table and another ASA Fact table with the same name field.

NUMBER

10

EARLY_RETURN_FULL_NAME

XXX

VARCHAR2

93

EARLY_RETURN_KRB_NAME

XXX

VARCHAR2

8

ER_SUMMER_CONTACT_EMAIL

XXX

VARCHAR2

30

ER_SUMMER_CONTACT_PHONE

XXX

VARCHAR2

14

PROCESSING_DATE

XXX

DATE

8

PROCESSING_EBM

XXX

VARCHAR2

8

PROCESSING_NOTES

XXX

VARCHAR2

500

REQUESTING_OFFICER_KRB_NAME

Kerberos name of the ASA student group officer who has made the request.

VARCHAR2

8

REQUEST_ID

ASA Request Identification Number

NUMBER

12

REQUEST_NOTES

XXX

VARCHAR2

1000

REQUEST_SUBMIT_DATE

The date when the request was submitted.

DATE

8

RESETTING_EBM

XXX

VARCHAR2

8

RESET_DATE

XXX

DATE

8

UPDATER

The person who last updated the information in the record.

VARCHAR2

20

UPDATE_DATE

Date this record was last updated by the source system.

DATE

8

WAREHOUSE_LOAD_DATE

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

DATE

8