Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse CREDIT CARD MASTER OLD Table


This table is occasionally used to load old credit card master data to compare it with current data. Its structure is identical to CREDIT_CARD_MASTER


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