Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SETTLEMENT RULE CURRENT Table


Current Settlement Rules


Field Name

Description

Data Type

Length

COMPANY_CODE

Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory.

VARCHAR2

4

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

FISCAL_PERIOD_FIRST_USE

The fiscal period in which the settlement rule was first applied

VARCHAR2

6

FISCAL_PERIOD_LAST_USE

The fiscal period in which the settlement rule was last applied

VARCHAR2

6

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

SETTLEMENT_PERCENT

Shows the percent to each settlement receiver.

NUMBER

22

SETTLEMENT_RECEIVER_CODE

The Cost Collector ID of the Settlement Receiver

VARCHAR2

17

SETTLEMENT_RECEIVER_DESC

The Cost Collector name of the Settlement Receiver

VARCHAR2

50

SETTLEMENT_RECEIVER_KEY

Key Field used for joining tables. This field should only be used for joining data, NOT for reporting.

VARCHAR2

17

SETTLEMENT_RECEIVER_TYPE

Cost Collector Type of the Settlement Receiver, e.g., Cost Center, Internal Order, Project WBS, Fixed Asset or G/L Account

VARCHAR2

20

SETTLEMENT_TYPE

Type of Settlement: Full or Periodic

VARCHAR2

30

SETTLEMENT_TYPE_CODE

A three character code for Settlement Type: GES for Full or PER for Periodic

VARCHAR2

3

VALID_FROM_FISCAL_PERIOD

The earliest fiscal period which the settlement rule is valid

VARCHAR2

6

VALID_THRU_FISCAL_PERIOD

The fiscal period through which the settlement rule is valid

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8