{
  "name": "",
  "description": "",
  "version": "",
  "updateDttm": "",
  "SCDType":4,
  "mappings": [
    {
      "ELLIPSE": {
        "method": "ellipseItem",
		"tables": [
		    {
			    "database":"foundation",
				"schema":"AZ_FH_ELLIPSE",
			    "table":"ADS_FND_MSF620",
				"primaryKey":[
					    {"column":"WORK_ORDER"}
				]
			}
		],
		
        "columns": [
          {
            "column": "D_WORK_ORDER_KEY",
            "type": "int",
            "allowNulls": "No",
            "mapType": "autoGenerate"
          },
          {
            "column": "SYSTEM_OF_RECORD",
            "type": "varchar",
            "length": 24,
            "allowNulls": "No",
            "mapType": "staticValue",
            "value": "ELLIPSE"
          },
          {
            "column": "ACTUAL_FINISH_DATE",
            "type": "DATE",
            "allowNulls": "Yes",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "ACTUAL_FINISH_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "ACTUAL_START_DATE",
            "type": "DATE",
             "allowNulls": "Yes",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "ACTUAL_START_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "ASSIGN_PERSON",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "ASSIGN_PERSON",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "AUTHORISED_BY",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "AUTHSD_BY",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "AUTHORISED_DATE",
            "type": "DATE",
            "length": 8,
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "AUTHSD_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "AUTHORISED_POSITION",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "AUTHSD_POSITION",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CLOSED_COMMIT_DATE",
            "type": "DATE",
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CLOSED_COMMIT_DT",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CLOSED_DATE",
            "type": "DATE",
 			"transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CLOSED_DT",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CLOSED_STATUS",
            "type": "VARCHAR",
            "length": 1,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CLOSED_STATUS",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "COMPLETED_BY",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "COMPLETED_BY",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "COMPLETED_CODE",
            "type": "VARCHAR",
            "length": 2,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "COMPLETED_CODE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CREATION_DATE",
            "type": "DATE",
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CREATION_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CREATION_USER",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CREATION_USER",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CREW",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CREW",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "CUST_NO",
            "type": "VARCHAR",
            "length": 6,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "CUST_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "EQUIP_NO",
            "type": "VARCHAR",
            "length": 12,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "EQUIP_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "HIGHEST_TASK",
            "type": "VARCHAR",
            "length": 3,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "HIGHEST_TASK",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "LAST_MODIFICATION_DATE",
            "type": "DATE",
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "LAST_MOD_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "LAST_MODIFICATION_USER",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "LAST_MOD_USER",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "MAINTENANCE_TYPE",
            "type": "VARCHAR",
            "length": 2,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "MAINT_TYPE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "MAN_EFFORT",
            "type": "VARCHAR",
            "length": 3,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "MAN_EFFORT",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "NO_OF_TASKS",
            "type": "VARCHAR",
            "length": 3,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "NO_OF_TASKS",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "ORIGINATOR_ID",
            "type": "VARCHAR",
            "length": 10,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "ORIGINATOR_ID",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PARENT_WORK_ORDER",
            "type": "VARCHAR",
            "length": 8,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PARENT_WO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PLAN_FINISH_DATE",
            "type": "DATE",
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PLAN_FIN_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PLAN_START_DATE",
            "type": "DATE",
            "allowNulls": "No",
			"transform":"to_date(#1, 'yyyyMMdd')",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PLAN_STR_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PO_ITEM_NO",
            "type": "VARCHAR",
            "length": 3,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PO_ITEM_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PO_NO",
            "type": "VARCHAR",
            "length": 6,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PO_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "PROJECT_NO",
            "type": "VARCHAR",
            "length": 8,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "PROJECT_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "RAISED_DATE",
            "type": "DATE",
            "transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "RAISED_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "REQUIRED_BY_DATE",
            "type": "DATE",
            "transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "REQ_BY_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "REQUIRED_FINISH_DATE",
            "type": "VARCHAR",
            "transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "Yes",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "REQ_FIN_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "REQUIRED_START_DATE",
            "type": "DATE",
            "transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "REQ_START_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "RESPONDED_DATE",
            "type": "VARCHAR",
            "transform":"to_date(#1, 'yyyyMMdd')",
            "allowNulls": "Yes",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "RESPONDED_DATE",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "RESPONDED_TIME",
            "type": "VARCHAR",
            "length": 6,
            "allowNulls": "Yes",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "RESPONDED_TIME",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "STD_JOB_NO",
            "type": "VARCHAR",
            "length": 6,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "STD_JOB_NO",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "UNIT_OF_WORK",
            "type": "VARCHAR",
            "length": 4,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "UNIT_OF_WORK",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "UNIT_OF_WORK_RATE",
            "type": "NUMERIC",
            "percision": 21,
            "scale": 4,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "UOW_RATE",
              "type": "NUMBER"
            }
          },
          {
            "column": "WORK_GROUP",
            "type": "VARCHAR",
            "length": 7,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "WORK_GROUP",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "WORK_ORDER",
            "type": "VARCHAR",
            "length": 8,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "WORK_ORDER",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "WO_DESC",
            "type": "VARCHAR",
            "length": 40,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "WO_DESC",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "WO_STATUS",
            "type": "VARCHAR",
            "length": 1,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "WO_STATUS_M",
              "type": "VARCHAR2"
            }
          },
          {
            "column": "WO_TYPE",
            "type": "VARCHAR",
            "length": 2,
            "allowNulls": "No",
            "mapType": "map",
            "source": {
              "schema": "AZ_FH_ELLIPSE",
              "table": "ADS_FND_MSF620",
              "column": "WO_TYPE",
              "type": "VARCHAR2"
            }
          }
        ]
      }
    }
  ]
}