MIT CARD DATA ALL Table
View exposing consolidated MIT card and person detail including names, card dates, department, position, address, clearance, lost-card indicators, verification attributes, and MIT identifiers.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDR |
Address or location associated with the cardholder record. |
VARCHAR2 |
40 |
AFFIL_ID |
Affiliate identifier associated with the cardholder, when applicable. |
VARCHAR2 |
9 |
CARDISLOST |
Indicator identifying whether the card has been reported lost (Y/N). |
CHAR |
|
CARD_MODIFIED_DATE |
Date the MIT card record was last modified. |
DATE |
|
CARD_VERIFICATION_CODE |
Verification code associated with the MIT card used for validation and security controls. |
VARCHAR2 |
128 |
CLEARANCE |
Clearance or access level associated with the MIT card. |
VARCHAR2 |
20 |
DEPT |
Department associated with the cardholder. |
VARCHAR2 |
75 |
END_DATE |
End date associated with the MIT card record. |
DATE |
|
EXPIRES |
Expiration date associated with the MIT card. |
DATE |
|
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
40 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
50 |
LIBRARY |
Library identifier associated with the cardholder. |
VARCHAR2 |
128 |
MAGSTRIPE |
Encoded magnetic stripe value associated with the MIT card used for physical access and transactions. |
VARCHAR2 |
128 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
128 |
PIK |
Unique card system identifier associated with the combined MIT card record. |
VARCHAR2 |
128 |
POSITION |
Position title or role associated with the cardholder. |
VARCHAR2 |
50 |
START_DATE |
Start date associated with the MIT card record. |
DATE |
|
THECOMMENT |
Administrative comment associated with the MIT card record. |
VARCHAR2 |
45 |
TYPE |
Code identifying the MIT card type. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |