MIT CARD DATA Table
View exposing MIT card master records including card identifiers, MIT and library identifiers, card type, expiration, sponsorship, clearance, and card status attributes used for card lifecycle management and access control.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFILIATE_ID |
Affiliate identifier associated with the cardholder, when applicable. |
VARCHAR2 |
9 |
CARD_COMMENT |
Administrative comment associated with the MIT card record. |
VARCHAR2 |
45 |
CARD_EXPIRE_DATE |
Expiration date of the MIT card. |
DATE |
|
CARD_IMAGE_DATE |
Date the card image was captured or last updated. |
DATE |
|
CARD_IS_LOST |
Indicator identifying whether the card has been reported lost (Y/N). |
CHAR |
|
CARD_MODIFIED_DATE |
Date the card record was last modified. |
DATE |
|
CARD_TYPE |
Code identifying the MIT card type. |
VARCHAR2 |
3 |
CARD_TYPE_DESC |
Description of the MIT card type. |
VARCHAR2 |
60 |
CARD_VERIFICATION_CODE |
Verification code associated with the MIT card used for validation and security controls. |
VARCHAR2 |
128 |
CLEARANCE_CODE |
Code representing clearance or access level associated with the MIT card. |
VARCHAR2 |
20 |
DLC_SPONSOR |
Department, laboratory, or center responsible for sponsoring the cardholder. |
VARCHAR2 |
255 |
LIBRARY_ID |
Identifier linking the cardholder to library system records. |
VARCHAR2 |
128 |
MAG_STRIPE |
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 |
PATRON_ID |
Unique identifier for the cardholder within the card management system. |
NUMBER |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |