Load Data Reference and Transaction Data

EBS Data Collection

For data collected by EBS:

Entity Initial Process Flow Incremental Process Flow Error Table
Organization MTH_PLANTS_DIM_EBS_INIT_PF MTH_PLANTS_DIM_EBS_INCR_PF N/A
Production Schedule MTH_WO_EBS_INIT_PF MTH_WO_EBS_INCR_PF MTH_PRODUCTION_SCHEDULES_ERR
Material Produced MTH_WO_EBS_INIT_PF MTH_WO_EBS_INCR_PF MTH_PROD_MTL_PRODUCED_ERR
Equipment Shifts MTH_EQUIP_SHIFTS_EBS_INIT_PF MTH_EQUIP_SHIFTS_EBS_INCR_PF MTH_EQUIPMENT_SHIFTS_ERR
Equipment Entities MTH_EQUIP_ENT_EBS_INIT_PF MTH_EQUIP_ENT_EBS_INCR_PF MTH_EQUIP_ENTITIES_ERR
Item MTH_ITEMS_DIM_EBS_INIT_PF MTH_ITEMS_DIM_EBS_INCR_PF MTH_ITEMS_ERR
Item Cost MTH_ITEM_COST_EBS_INIT_PF MTH_ITEM_COST_EBS_INCR_PF MTH_ITEM_COST_ERR
Item Category MTH_ITEM_HRCHY_EBS_INIT_PF MTH_ITEM_HRCHY_EBS_INCR_PF N/A
Resource MTH_RES_DIM_EBS_INIT_PF MTH_RES_DIM_EBS_INCR_PF MTH_RESOURCES_ERR
Resource Cost MTH_RES_COST_EBS_INIT_PF MTH_RES_COST_EBS_INCR_PF MTH_RESURCE_COST_ERR
Workday Shifts MTH_WORKDAY_SHIFTS_EBS_INIT_PF MTH_WORKDAY_SHIFTS_EBS_INCR_PF MTH_WORKDAY_SHIFTS_ERR
Sales Orders MTH_WO_SALES_ORDERS_EBS_INIT_PF MTH_WO_SALES_ORDERS_EBS_INCR_PF MTH_WO_SALES_ORDERS_ERR

CSV (Comma Separated Values) Template Data Collection

For data collected by .CSV templates:

Entity CSV File XS Mapping Initial PF Incremental PF Error Table
System MTH_SYSTEMS_SETUP.csv MTH_SYSTEMS_SETUP_XS_ALL_MAP N/A N/A N/A
Organization MTH_ORG.csv MTH_ORG_XS_ALL_MAP&MTH_PLANTS_ORG_ALL_MAP N/A N/A N/A
Workday Shifts MTH_WORKDAY_SHIFTS.csv MTH_WORKDAY_SHIFTS_XS_ALL_MAP MTH_WORKDAY_SHIFTS_EXT_INIT_PF MTH_WORKDAY_SHIFTS_EXT_INCR_PF MTH_WORKDAY_SHIFTS_ERR
Item Master MTH_ITEMS_MASTER.csv MTH_ITEM_MASTER_XS_ALL_MAP MTH_ITEMS_DIM_EXT_INIT_PF MTH_ITEMS_DIM_EXT_INCR_PF MTH_ITEMS_ERR
Item Categories MTH_ITEM_CATEGORY.csv MTH_ITEM_CATEGORIES_XS_MAP MTH_CAT_DIM_EXT_INIT_PF MTH_CAT_DIM_EXT_INCR_PF N/A
Item Hierarchy MTH_ITEM_HIERARCHY.csv MTH_ITEM_HIERARCHY_XS_MAP MTH_ITEM_HRCHY_EXT_INIT_PF MTH_ITEM_HRCHY_EXT_INCR_PF MTH_ITEM_HIERARCHY_ERR
Item Cost MTH_ITEM_COST.csv MTH_ITEM_COST_XS_MAP MTH_ITEM_COST_EXT_INIT_PF MTH_ITEM_COST_EXT_INCR_PF MTH_ITEM_COST_ERR
Equipment Entities MTH_ENTITY_MASTER.csv MTH_EQUIP_ENT_XS_ALL_MAP MTH_EQUIP_ENT_EXT_INIT_PF MTH_EQUIP_ENT_EXT_INCR_PF MTH_EQUIP_ENTITIES_ERR
Equipment Master MTH_EQUIP_MASTER.csv MTH_EQUIP_XS_ALL_MAP MTH_EQUIP_DIM_EXT_INIT_PF MTH_EQUIP_DIM_EXT_INCR_PF MTH_EQUIPMENTS_ERR
Equipment Hierarchy MTH_EQUIP_HRCHY_DEF.csv MTH_EQUIP_HRCHY_XS_ALL_MAP MTH_EQUIP_HRCHY_EXT_INIT_PF MTH_EQUIP_HRCHY_EXT_INCR_PF MTH_EQUIP_HIERARCHY_ERR
Equipment Standard Rates MTH_EQUIP_STANDARD_RATES.csv MTH_EQUIP_STD_RATES_XS_ALL_MAP MTH_EQUIP_STD_RATE_EXT_INIT_PF MTH_EQUIP_STD_RATE_EXT_INCR_PF MTH_EQUIP_STANDARD_RATES_ERR
Equipment Production Schedule MTH_EQUIP_PROD_SCHEDULE.csv MTH_EQUIP_PROD_SCHD_XS_ALL_MAP MTH_EQUIP_PRD_SCHD_EXT_INIT_PF MTH_EQUIP_PRD_SCHD_EXT_INCR_PF MTH_EQUIP_PROD_SCHEDULE_ERR
Planned Usage MTH_ENTITY_PLANNED_USAGE.csv MTH_ENT_PLANNED_USG_XS_MAP MTH_PLANNED_USG_EXT_INIT_PF MTH_PLANNED_USG_EXT_INCR_PF MTH_ENTITY_PLANNED_USAGE_ERR
Asset MTH_ASSET_MASTER.csv MTH_ASSET_XS_MAP MTH_ASSET_EXT_INIT_PF MTH_ASSET_EXT_INCR_PF MTH_ASSET_ERR
Resource MTH_RESOURCES.csv MTH_RESOURCE_XS_ALL_MAP MTH_RES_DIM_EXT_INIT_PF MTH_RES_DIM_EXT_INCR_PF MTH_RESOURCES_ERR
Resource Cost MTH_RESOURCE_COST.csv MTH_RESOURCE_COST_XS_ALL_MAP MTH_RES_COST_EXT_INIT_PF MTH_RES_COST_EXT_INCR_PF MTH_RESOURCE_COST_ERR
Production Schedule MTH_PROD_SCHEDULES.csv MTH_WO_XS_ALL_MAP MTH_WO_EXT_INIT_PF MTH_WO_EXT_INCR_PF MTH_PRODUCTION_SCHEDULES_ERR
Material Produced MTH_PROD_MTL_PRODUCED.csv MTH_WO_ITEMS_XS_ALL_MAP MTH_WO_ITEMS_EXT_INIT_PF MTH_WO_ITEMS_EXT_INCR_PF MTH_PROD_MTL_PRODUCED_ERR
Material Produced Transactions MTH_MTL_PRODUCED_TXN.csv MTH_MTL_PRD_TXN_XS_ALL_MAP MTH_MTL_PRD_TXN_EXT_INIT_PF MTH_MTL_PRD_TXN_EXT_INCR_PF MTH_PROD_MTL_PRODUCED_TXN_ERR
Produced Transaction Lots MTH_MTL_PRODUCED_TXN_LOT.csv MTH_MTL_PRD_TXN_LOT_XS_ALL_MAP MTH_MTL_PRD_TX_LOT_EXT_INIT_PF MTH_MTL_PRD_TX_LOT_EXT_INCR_PF MTH_MTL_PRODUCED_TXN_LOT_ERR
Production Segments MTH_PROD_SEGMENTS.csv MTH_PROD_SEGMENTS_XS_ALL_MAP MTH_PROD_SEG_EXT_INIT_PF MTH_PROD_SEG_EXT_INCR_PF MTH_PRODUCTION_SEGMENTS_ERR
Production Sub Segments MTH_PROD_SUB_SEGMENTS.csv MTH_PROD_SUB_SEG_XS_OPM_MAP MTH_PROD_SUB_SEG_EXT_INIT_PF MTH_PROD_SUB_SEG_EXT_INCR_PF MTH_PROD_SUB_SEGMENTS_ERR
Production Segment Transactions MTH_PROD_SEGMENTS_TXN.csv MTH_PROD_SEG_TXN_XS_ALL_MAP MTH_WO_SEG_EXT_INIT_PF MTH_WO_SEG_EXT_INCR_PF MTH_PROD_SEGMENTS_TXN_ERR
Material Consumed MTH_MTL_CONSUMED.csv MTH_MTL_CNS_XS_ALL_MAP MTH_MTL_CMD_EXT_INIT_PF MTH_MTL_CMD_EXT_INCR_PF MTH_PROD_MTL_CONSUMED_ERR
Consumed Transactions MTH_MTL_CONSUMED_TXN.csv MTH_MTL_CNS_TXN_XS_ALL_MAP MTH_MTL_CMD_TXN_EXT_INIT_PF MTH_MTL_CMD_TXN_EXT_INCR_PF MTH_PROD_MTL_CONSUMED_TXN_ERR
Consumed Transaction Lots MTH_MTL_CONSUMED_TXN_LOT.csv MTH_MTL_CNS_TXN_LOT_XS_ALL_MAP MTH_MTL_CMD_TX_LOT_EXT_INIT_PF MTH_MTL_CMD_TX_LOT_EXT_INCR_PF MTH_MTL_CONSUMED_TXN_LOT_ERR
Tag Data Source MTH_TAG_DATA_SOURCES.csv MTH_TAG_DATA_SRCS_XS_ALL_MAP MTH_TAG_DATA_SRCS_EXT_INIT_PF MTH_TAG_DATA_SRCS_EXT_INCR_PF MTH_TAG_DATA_SOURCES_ERR
Tag Master MTH_TAG_MASTER_UI.csv MTH_TAG_MASTER_XS_MAP MTH_TAG_MASTER_EXT_INIT_PF MTH_TAG_MASTER_EXT_INCR_PF MTH_TAG_MASTER_ERR
Resource Requirement MTH_RES_REQ.csv MTH_RES_REQ_XS_ALL_MAP MTH_RES_REQ_EXT_INIT_PF MTH_RES_REQ_EXT_INCR_PF MTH_RESOURCE_REQUIREMENTS_ERR
Resource Transactions MTH_RES_TXN.csv MTH_RES_TXN_XS_ALL_MAP MTH_RES_TXN_EXT_INIT_PF MTH_RES_TXN_EXT_INCR_PF MTH_RESOURCE_TXN_ERR
Sales Orders MTH_WO_SALES_ORDERS.csv MTH_WO_SALES_ORDERS_XS_ALL_MAP MTH_WO_SALES_ORDER_EXT_INIT_PF MTH_WO_SALES_ORDER_EXT_INCR_PF MTH_WO_SALES_ORDERS_ERR
Equipment Shifts MTH_EQUIP_SHIFTS.csv MTH_EQUIP_SHIFTS_XS_MAP MTH_EQUIP_SHIFTS_EXT_INIT_PF MTH_EQUIP_SHIFTS_EXT_INCR_PF MTH_EQUIPMENT_SHIFTS_ERR
Meter Reading MTH_METER_READINGS.csv MTH_METER_READINGS_XS_ALL_MAP MTH_METER_READINGS_EXT_INIT_PF MTH_METER_READINGS_EXT_INCR_PF MTH_METER_READINGS_ERR
Equipment Output MTH_EQUIP_OUTPUT.csv MTH_EQUIP_OUTPUT_XS_ALL_MAP MTH_EQUIP_OUTPUT_EXT_INIT_PF MTH_EQUIP_OUTPUT_EXT_INCR_PF MTH_EQUIP_OUTPUT_ERR
Equipment Status MTH_EQUIP_STATUS.csv MTH_EQUIP_STATUS_XS_ALL_MAP MTH_EQUIP_STATUS_EXT_INIT_PF MTH_EQUIP_STATUS_EXT_INCR_PF MTH_EQUIP_STATUSES_ERR

If you load the status readings through CSV template, then you must provide equipment status readings for all the 24 hours. When you provide From Date and To Date in the CSV template, the application subtracts one second from the To Date while loading the Status information. If the reading time for the equipment status is outside a valid shift, then the reading should be provided using a catchall shift reference. If continuous readings are not provided, then the MOC application errors out the readings.

If you are loading the energy meter readings or equipment output for the following entities using CSV, you must pass the reading time as one second less than the actual reading time as the MOC application considers the end of the hour as XX:59:59 for separating the hourly boundaries by one second: