Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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