CREDIT CARD VERIFIER Table
Contains information about credit card verifiers.
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 |
CREDIT_CARD_ID |
Internal credit card identification number. MIT-assigned number, not to be confused with the actual credit card number. |
VARCHAR2 |
6 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
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 |
SEND_EMAIL_FLAG |
Flag indicating whether the credit card verifier receives email notification of new credit card transactions. Values: Y or N. |
VARCHAR2 |
1 |
VERIFIER_USERNAME |
The uppercase Kerberos ID or SAP username of the credit card verifier. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |