MIT CARD DATA Table
Contains MIT Card information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFILIATE_ID |
XXX |
VARCHAR2 |
9 |
CARD_COMMENT |
XXX |
VARCHAR2 |
20 |
CARD_EXPIRE_DATE |
XXX |
DATE |
8 |
CARD_IMAGE_DATE |
XXX |
DATE |
8 |
CARD_IS_LOST |
XXX |
CHAR |
4 |
CARD_MODIFIED_DATE |
XXX |
DATE |
8 |
CARD_TYPE |
XXX |
VARCHAR2 |
3 |
CARD_TYPE_DESC |
XXX |
VARCHAR2 |
60 |
CARD_VERIFICATION_CODE |
XXX |
VARCHAR2 |
128 |
CLEARANCE_CODE |
XXX |
VARCHAR2 |
20 |
DLC_SPONSOR |
XXX |
VARCHAR2 |
255 |
LIBRARY_ID |
XXX |
VARCHAR2 |
128 |
MAG_STRIPE |
XXX |
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 |
9 |
PATRON_ID |
XXX |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |