Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse CREDIT CARD ACCT ASSIGNMENT Table


Contains information about default account assignment rules for credit cards.


Field Name

Description

Data Type

Length

ACCOUNT_ASSIGNMENT_POSITION

XXX

VARCHAR2

3

ACCOUNT_ASSIGNMENT_RULE

XXX

VARCHAR2

6

CHANGE_DATE

XXX

DATE

8

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

CREDIT_CARD_ID

Internal credit card identification number. MIT-assigned number, not to be confused with the actual credit card number.

VARCHAR2

6

GL_ACCOUNT_KEY

Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

10

LAST_CHANGED_BY

Username of the person who last changed/modified/updated this record.

VARCHAR2

8

PERCENTAGE_TO_DISTRIBUTE

XXX

NUMBER

22

SHORT_TEXT

XXX

VARCHAR2

30

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