{ "name": "dmMapping_DIM_WORK_ORDER", "description": "DIM_WORK_ORDER Azure Foundation to Azure Data Mart Mapping", "version": "2.5", "updateDttm": "15/02/2022 15:58PM", "mappings": [ { "ELLIPSE": { "method": "ellipseItem", "tables": [ { "database": "foundation", "schema": "AZ_FH_ELLIPSE", "table": "ADS_FND_MSF620", "primaryKey": [ { "column": "DSTRCT_CODE", "seqno": 1 }, { "column": "WORK_ORDER", "seqno": 2 } ] } ], "columns": [ { "column": "D_WORK_ORDER_KEY", "type": "BIGINT", "allowNulls": "No", "mapType": "autoGenerate" }, { "column": "EQUIP_NO", "type": "VARCHAR", "length": 12, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "EQUIP_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "HIGHEST_TASK", "type": "VARCHAR", "length": 3, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "HIGHEST_TASK", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "LAST_MODIFICATION_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "LAST_MOD_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "LAST_MOD_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "LAST_MODIFICATION_USER", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "LAST_MOD_USER", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "MAINTENANCE_TYPE", "type": "VARCHAR", "length": 2, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "MAINT_TYPE", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "MAN_EFFORT", "type": "VARCHAR", "length": 3, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "MAN_EFFORT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "NO_OF_TASKS", "type": "VARCHAR", "length": 3, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "NO_OF_TASKS", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "ORIGINATOR_ID", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "ORIGINATOR_ID", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "PARENT_WORK_ORDER_KEY", "type": "BIGINT", "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PARENT_WO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "PLAN_FINISH_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PLAN_FIN_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "PLAN_FIN_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "PLAN_START_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PLAN_STR_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "PLAN_STR_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "PO_ITEM_NO", "type": "VARCHAR", "length": 3, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PO_ITEM_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "PO_NO", "type": "VARCHAR", "length": 6, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PO_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "PROJECT_NO", "type": "VARCHAR", "length": 30, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "PROJECT_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "RAISED_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "RAISED_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "RAISED_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "REQUIRED_BY_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "REQ_BY_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "REQ_BY_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "REQUIRED_FINISH_DATE", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "REQ_FIN_DATE", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "REQUIRED_START_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "REQ_START_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "REQ_START_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "RESPONDED_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(concat(#1,' ',#2), 'yyyyMMdd hh:mm:ss')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "RESPONDED_DATE", "type": "VARCHAR2", "seqno": 1 }, { "column": "RESPONDED_TIME", "type": "VARCHAR2", "seqno": 2 } ] } }, { "column": "STD_JOB_NO", "type": "VARCHAR", "length": 6, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "STD_JOB_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "UNIT_OF_WORK", "type": "VARCHAR", "length": 4, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "UNIT_OF_WORK", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "UOW_RATE", "type": "DECIMAL", "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "UOW_RATE", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WO_DESC", "type": "VARCHAR", "length": 100, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WO_DESC", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WO_STATUS_M", "type": "VARCHAR", "length": 1, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WO_STATUS_M", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WO_STATUS_U", "type": "VARCHAR", "length": 2, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WO_STATUS_U", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WO_TYPE", "type": "VARCHAR", "length": 2, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WO_TYPE", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WORK_GROUP", "type": "VARCHAR", "length": 1, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WORK_GROUP", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "WORK_ORDER", "type": "VARCHAR", "length": 8, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "WORK_ORDER", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "ACTUAL_FINISH_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "ACTUAL_FINISH_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "ACTUAL_START_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "ACTUAL_START_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "ASSIGN_PERSON", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "ASSIGN_PERSON", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "AUTHORISED_BY", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "AUTHORISED_BY", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "AUTHORISED_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "AUTHORISED_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "AUTHORISED_POSITION", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "AUTHORISED_POSITION", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CLOSED_COMMIT_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CLOSED_COMMIT_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CLOSED_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CLOSED_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CLOSED_STATUS", "type": "VARCHAR", "length": 5, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CLOSED_STATUS", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CLOSED_STATUS_DESC", "type": "VARCHAR", "length": 100, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CLOSED_STATUS_DESC", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "COMPLETED_BY", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "COMPLETED_BY", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "COMPLETED_CODE", "type": "VARCHAR", "length": 5, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "COMPLETED_CODE", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CREATION_DT", "type": "DATETIME", "allowNulls": "Yes", "transform": "to_date(#1, 'yyyyMMdd')", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CREATION_DT", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CREATION_USER", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CREATION_USER", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CREW", "type": "VARCHAR", "length": 10, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CREW", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "CUST_NO", "type": "VARCHAR", "length": 6, "allowNulls": "Yes", "mapType": "map", "source": { "schema": "AZ_FH_ELLIPSE", "table": "AZ_FND_MSF620", "columns": [ { "column": "CUST_NO", "type": "VARCHAR2", "seqno": 1 } ] } }, { "column": "DM_INSERT_DT", "type": "DATETIME", "allowNulls": "Yes", "mapType": "insertDT" }, { "column": "DM_UPDATE_DT", "type": "DATETIME", "allowNulls": "Yes", "mapType": "updateDT" }, { "column": "SOURCE_SYSTEM_KEY", "type": "VARCHAR", "length": 100, "allowNulls": "Yes", "mapType": "sourcePK" }, { "column": "SOURCE_SYSTEM_NAME", "type": "VARCHAR", "length": 50, "allowNulls": "Yes", "mapType": "staticValue", "value": "ELLIPSE" }, { "column": "SOURCE_SYSTEM_KEY_VALUE", "type": "VARCHAR", "length": 100, "allowNulls": "Yes", "mapType": "sourcePKValues" } ] } } ] }