CREDIT CARD MASTER Table
Contains information about credit cards and their users.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_ROOM |
The combined building and room number of a particular room or space within an MIT building: for example, N42-240X is room 240X in Building N42. |
VARCHAR2 |
16 |
CARDHOLDER_ID |
The MIT ID number of the credit card holder. |
VARCHAR2 |
9 |
CARDHOLDER_NAME |
The name of the credit card holder. |
VARCHAR2 |
35 |
COMPANY_TO_BANK_ID |
XXX |
VARCHAR2 |
10 |
CREDIT_CARD_ID |
Internal credit card identification number. MIT-assigned number, not to be confused with the actual credit card number. |
VARCHAR2 |
6 |
CREDIT_CARD_SAP_USERNAME |
XXX |
VARCHAR2 |
8 |
CREDIT_CARD_STATUS |
Code indicating status of credit card: C, I or X. |
VARCHAR2 |
10 |
CREDIT_CARD_TYPE |
Code indicating type of credit card: P or null. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
MERCHANT_BLOCKING_FLAG |
XXX |
VARCHAR2 |
1 |
MONTHLY_STATEMENT_FLAG |
XXX |
VARCHAR2 |
1 |
ORGANIZATION_NUMBER |
First four digits of the department number associated with the credit card. |
VARCHAR2 |
4 |
PHONE_NUMBER |
Phone number of the credit card holder or verifier. |
VARCHAR2 |
8 |
POST_NOT_PARK_FLAG |
XXX |
VARCHAR2 |
1 |
SEND_EMAIL_FLAG |
Flag indicating whether the credit card verifier receives email notification of new credit card transactions. Values: Y or N. |
VARCHAR2 |
1 |
SINGLE_TRANSACTION_LIMIT |
XXX |
NUMBER |
22 |
SPENDING_LIMIT |
XXX |
NUMBER |
22 |
THIRD_LINE_INFO |
XXX |
VARCHAR2 |
20 |
VALID_FROM_DATE |
XXX |
DATE |
8 |
VALID_TO_DATE |
XXX |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |