Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WORK ORDER FUNC LOCATION 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

FUNCTIONAL_LOCATION

XXX

VARCHAR2

40

FUNCTIONAL_LOCATION_CODE

XXX

VARCHAR2

30

FUNCTIONAL_LOCATION_ZONE

XXX

VARCHAR2

40

FUNC_LOCATION_SYSTEM_STATUS

XXX

VARCHAR2

40

FUNC_LOC_COST_CENTER_ID

XXX

VARCHAR2

8

FUNC_LOC_COST_CENTER_NAME

XXX

VARCHAR2

40

PLANT_CODE

XXX

VARCHAR2

4

SUPERIOR_FUNC_LOCATION

XXX

VARCHAR2

40

SUPERIOR_FUNC_LOCATION_CODE

XXX

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

WORK_ORDER_FUNC_LOCATION_KEY

XXX

VARCHAR2

30