Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK CENTER Table


XXX


Field Name

Description

Data Type

Length

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

PLANT_CODE

XXX

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE

WORK_CENTER

XXX

VARCHAR2

40

WORK_CENTER_ACTIVITY

XXX

VARCHAR2

100

WORK_CENTER_ACTIVITY_CODE

XXX

VARCHAR2

6

WORK_CENTER_CODE

XXX

VARCHAR2

8

WORK_CENTER_COST_CENTER_ID

XXX

VARCHAR2

8

WORK_CENTER_COST_CENTER_NAME

XXX

VARCHAR2

40

WORK_CENTER_KEY

XXX

VARCHAR2

8

WORK_CENTER_VALID_FROM_DATE

XXX

DATE

WORK_CENTER_VALID_THRU_DATE

XXX

DATE