Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


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

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.