Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COSTING SHEET Table


View exposing costing sheet reference data including costing sheet, step, surcharge base, range, manual indicator, overhead credit, and warehouse load date attributes.


Field Name

Description

Data Type

Length

COSTING_SHEET_KEY

Surrogate key identifying the costing sheet.

VARCHAR2

6

COSTING_SHEET_NAME

Costing sheet name as provided by the source.

VARCHAR2

30

FROM_STEP_NUMBER

From step number as provided by the source.

NUMBER

MANUAL_INDICATOR

Manual indicator as provided by the source.

VARCHAR2

1

OVH_CREDIT_KEY

Surrogate key identifying the ovh credit.

VARCHAR2

3

STEP_NAME

Step name as provided by the source.

VARCHAR2

30

STEP_NUMBER

Step number as provided by the source.

NUMBER

SURCHARGE_BASE_KEY

Surrogate key identifying the surcharge base.

VARCHAR2

4

THRU_STEP_NUMBER

Thru step number as provided by the source.

NUMBER

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE