SPACT ACCESS Table
View exposing sponsored-access request detail including sponsored person and sponsor identifiers, organization, office address, cost object, access dates, MIT ID and card status, medical and health-check indicators, creation and update audit fields, and status comments.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_OBJECT |
Cost object associated with the record. |
NUMBER |
10 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
135 |
CREATED_ON |
Created on associated with the record. |
DATE |
|
DAILY_HEALTH_CHECK |
Daily health check associated with the record. |
NUMBER |
3 |
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
150 |
END_DATE |
Date associated with end. |
DATE |
|
ENFORCE_MEDICAL |
Enforce medical associated with the record. |
NUMBER |
3 |
EXISTING_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
NUMBER |
3 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
765 |
ID_CARD_EMAIL_SENT |
Id card email sent associated with the record. |
NUMBER |
3 |
ID_CARD_STATUS |
Id card status associated with the record. |
VARCHAR2 |
4 |
KERBEROS_ID_STATUS |
Kerberos id status associated with the record. |
VARCHAR2 |
4 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
765 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
27 |
MIT_ID_CARD_NEEDED |
Mit id card needed associated with the record. |
NUMBER |
3 |
MIT_ID_DELIVERY_METHOD |
Mit id delivery method associated with the record. |
VARCHAR2 |
4 |
MIT_ID_STATUS |
Mit id status associated with the record. |
VARCHAR2 |
4 |
OFFICE_ADDRESS |
Office address associated with the record. |
VARCHAR2 |
768 |
ORGANIZATION |
Organization associated with the record. |
VARCHAR2 |
765 |
PAID_BY_MIT |
Paid by mit associated with the record. |
NUMBER |
3 |
REASON_FOR_ACCESS |
Reason for access associated with the record. |
VARCHAR2 |
768 |
REQUEST_MIT_MEDICAL |
Request mit medical associated with the record. |
NUMBER |
3 |
SPONSOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
27 |
START_DATE |
Date associated with start. |
DATE |
|
STATUS |
Status associated with the record. |
VARCHAR2 |
4 |
STATUS_COMMENTS |
Status comments associated with the record. |
VARCHAR2 |
768 |
UPDATED_BY |
Updated by associated with the record. |
VARCHAR2 |
135 |
UPDATED_ON |
Updated on associated with the record. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |