Last active
January 1, 2024 05:37
-
-
Save bvader/e4a20a792f2f4da97bec156980eb17ee to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
For Elastic Discuss Post | |
https://discuss.elastic.co/t/date-column-has-some-rows-with-null-strict-date-optional-time-causes-exception/350164/6?u=stephenb | |
PUT _index_template/reams-workorder-logs | |
{ | |
"index_patterns": [ | |
"reams-workorder-logs-*" | |
], | |
"template": { | |
"settings": { | |
"index.mapping.ignore_malformed": true | |
}, | |
"mappings": { | |
"_meta": { | |
"created_by": "file-data-visualizer" | |
}, | |
"properties": { | |
"message" : {"type": "keyword"}, | |
"@timestamp": { | |
"type": "date", | |
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S", | |
"ignore_malformed": true | |
}, | |
"r_xxx_mms_ar_workorder_xt_actfinish": { | |
"type": "date", | |
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S", | |
"ignore_malformed": true | |
}, | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_actlabhrs": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_actstart": { | |
"type": "date", | |
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S", | |
"ignore_malformed": true | |
}, | |
"r_xxx_mms_ar_workorder_xt_acttoolcost": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_amcrew": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ams": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_aos": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_apptrequired": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_assetnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_availstatusdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_backoutplan": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_business_date": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_calccalendar": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_calcorgid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_calcpriority": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_calcshift": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_calendar": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_changeby": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_changedate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_chargestore": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_cinum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_classstructureid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_commodity": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_commoditygroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_crewid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_dat_qlty": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_description": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_disabled": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_downtime": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_environment": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estdur": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_esttoolcost": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_externalrefid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_faildate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_failurecode": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_fdnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_fincntrlid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_flowaction": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_flowactionassist": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_flowid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_fromchainage": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_generatedforpo": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_genforpolineid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_genforporevision": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_haschildren": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_hasld": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_historyflag": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ifce_req": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ifce_sender": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ignorediavail": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ingestion_date": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ingestion_time": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_inspector": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_interruptible": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_istask": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_jobtaskid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_jpnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_justifypriority": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_langcode": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_launchentryname": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_lead": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_lms": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_location": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_los": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_measuredate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_measurementvalue": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_newchildclass": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_newserialnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_observation": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_oldserialnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_onbehalfof": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_orgid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_origrecordclass": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_origrecordid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_outtoolcost": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_owner": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ownergroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_ownersysid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_parent": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_partchangeout": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_persongroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscismobile": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscloop": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmcomstate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmcomtype": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmduedate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmextdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pmnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_pointnum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_problemcode": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_reasonforchange": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_remdur": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_repairfacility": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_reportdate": { | |
"type": "date", | |
"format": "strict_date_optional_time||yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd HH:mm:ss.SS||yyyy-MM-dd HH:mm:ss||yyyy-MM-dd HH:mm:ss.S", | |
"ignore_malformed": true | |
}, | |
"r_xxx_mms_ar_workorder_xt_reportedby": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_respondby": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_risk": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_route": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_routestopid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_rptstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_schedfinish": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_schedstart": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_sendersysid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_serviceaffect": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_siteid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_sneconstraint": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_sourcesysid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_status": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_statusdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_supervisor": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_suspendflow": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_sys_downtime": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_targcompdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_targetdesc": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_targstartdate": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_taskid": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_tochainage": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_user_schedstart": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_vendor": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_verification": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_whomischangefor": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wo_downtime": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_woclass": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wogroup": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_woisswap": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wonum": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wopriority": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_worklocation": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_workorderid": { | |
"type": "double" | |
}, | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_worktype": { | |
"type": "keyword" | |
}, | |
"r_xxx_mms_ar_workorder_xt_wosequence": { | |
"type": "keyword" | |
} | |
} | |
} | |
} | |
} | |
PUT _ingest/pipeline/reams-workorder-logs | |
{ | |
"description": "Ingest pipeline created by text structure finder", | |
"processors": [ | |
{ | |
"csv": { | |
"field": "message", | |
"target_fields": [ | |
"r_xxx_mms_ar_workorder_xt_workorderid", | |
"r_xxx_mms_ar_workorder_xt_actfinish", | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs", | |
"r_xxx_mms_ar_workorder_xt_actlabhrs", | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs", | |
"r_xxx_mms_ar_workorder_xt_actstart", | |
"r_xxx_mms_ar_workorder_xt_acttoolcost", | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id", | |
"r_xxx_mms_ar_workorder_xt_amcrew", | |
"r_xxx_mms_ar_workorder_xt_ams", | |
"r_xxx_mms_ar_workorder_xt_aos", | |
"r_xxx_mms_ar_workorder_xt_apptrequired", | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority", | |
"r_xxx_mms_ar_workorder_xt_assetnum", | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup", | |
"r_xxx_mms_ar_workorder_xt_availstatusdate", | |
"r_xxx_mms_ar_workorder_xt_backoutplan", | |
"r_xxx_mms_ar_workorder_xt_calccalendar", | |
"r_xxx_mms_ar_workorder_xt_calcorgid", | |
"r_xxx_mms_ar_workorder_xt_calcpriority", | |
"r_xxx_mms_ar_workorder_xt_calcshift", | |
"r_xxx_mms_ar_workorder_xt_calendar", | |
"r_xxx_mms_ar_workorder_xt_changeby", | |
"r_xxx_mms_ar_workorder_xt_changedate", | |
"r_xxx_mms_ar_workorder_xt_chargestore", | |
"r_xxx_mms_ar_workorder_xt_cinum", | |
"r_xxx_mms_ar_workorder_xt_classstructureid", | |
"r_xxx_mms_ar_workorder_xt_commodity", | |
"r_xxx_mms_ar_workorder_xt_commoditygroup", | |
"r_xxx_mms_ar_workorder_xt_crewid", | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup", | |
"r_xxx_mms_ar_workorder_xt_description", | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus", | |
"r_xxx_mms_ar_workorder_xt_disabled", | |
"r_xxx_mms_ar_workorder_xt_downtime", | |
"r_xxx_mms_ar_workorder_xt_environment", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops", | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs", | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs", | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs", | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost", | |
"r_xxx_mms_ar_workorder_xt_estdur", | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs", | |
"r_xxx_mms_ar_workorder_xt_estlabhrs", | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs", | |
"r_xxx_mms_ar_workorder_xt_esttoolcost", | |
"r_xxx_mms_ar_workorder_xt_externalrefid", | |
"r_xxx_mms_ar_workorder_xt_faildate", | |
"r_xxx_mms_ar_workorder_xt_failurecode", | |
"r_xxx_mms_ar_workorder_xt_fdnum", | |
"r_xxx_mms_ar_workorder_xt_fincntrlid", | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus", | |
"r_xxx_mms_ar_workorder_xt_flowaction", | |
"r_xxx_mms_ar_workorder_xt_flowactionassist", | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled", | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint", | |
"r_xxx_mms_ar_workorder_xt_fromchainage", | |
"r_xxx_mms_ar_workorder_xt_generatedforpo", | |
"r_xxx_mms_ar_workorder_xt_genforpolineid", | |
"r_xxx_mms_ar_workorder_xt_genforporevision", | |
"r_xxx_mms_ar_workorder_xt_haschildren", | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork", | |
"r_xxx_mms_ar_workorder_xt_hasld", | |
"r_xxx_mms_ar_workorder_xt_historyflag", | |
"r_xxx_mms_ar_workorder_xt_ifce_req", | |
"r_xxx_mms_ar_workorder_xt_ifce_sender", | |
"r_xxx_mms_ar_workorder_xt_ignorediavail", | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time", | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched", | |
"r_xxx_mms_ar_workorder_xt_inspector", | |
"r_xxx_mms_ar_workorder_xt_interruptible", | |
"r_xxx_mms_ar_workorder_xt_istask", | |
"r_xxx_mms_ar_workorder_xt_jobtaskid", | |
"r_xxx_mms_ar_workorder_xt_jpnum", | |
"r_xxx_mms_ar_workorder_xt_justifypriority", | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs", | |
"r_xxx_mms_ar_workorder_xt_langcode", | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate", | |
"r_xxx_mms_ar_workorder_xt_launchentryname", | |
"r_xxx_mms_ar_workorder_xt_lead", | |
"r_xxx_mms_ar_workorder_xt_lms", | |
"r_xxx_mms_ar_workorder_xt_location", | |
"r_xxx_mms_ar_workorder_xt_los", | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty", | |
"r_xxx_mms_ar_workorder_xt_measuredate", | |
"r_xxx_mms_ar_workorder_xt_measurementvalue", | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess", | |
"r_xxx_mms_ar_workorder_xt_newchildclass", | |
"r_xxx_mms_ar_workorder_xt_newserialnum", | |
"r_xxx_mms_ar_workorder_xt_observation", | |
"r_xxx_mms_ar_workorder_xt_oldserialnum", | |
"r_xxx_mms_ar_workorder_xt_onbehalfof", | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs", | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs", | |
"r_xxx_mms_ar_workorder_xt_orgid", | |
"r_xxx_mms_ar_workorder_xt_origrecordclass", | |
"r_xxx_mms_ar_workorder_xt_origrecordid", | |
"r_xxx_mms_ar_workorder_xt_outtoolcost", | |
"r_xxx_mms_ar_workorder_xt_owner", | |
"r_xxx_mms_ar_workorder_xt_ownergroup", | |
"r_xxx_mms_ar_workorder_xt_ownersysid", | |
"r_xxx_mms_ar_workorder_xt_parent", | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus", | |
"r_xxx_mms_ar_workorder_xt_partchangeout", | |
"r_xxx_mms_ar_workorder_xt_persongroup", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit", | |
"r_xxx_mms_ar_workorder_xt_pluscismobile", | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum", | |
"r_xxx_mms_ar_workorder_xt_pluscloop", | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate", | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate", | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog", | |
"r_xxx_mms_ar_workorder_xt_pmcomstate", | |
"r_xxx_mms_ar_workorder_xt_pmcomtype", | |
"r_xxx_mms_ar_workorder_xt_pmduedate", | |
"r_xxx_mms_ar_workorder_xt_pmextdate", | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate", | |
"r_xxx_mms_ar_workorder_xt_pmnum", | |
"r_xxx_mms_ar_workorder_xt_pointnum", | |
"r_xxx_mms_ar_workorder_xt_problemcode", | |
"r_xxx_mms_ar_workorder_xt_reasonforchange", | |
"r_xxx_mms_ar_workorder_xt_remdur", | |
"r_xxx_mms_ar_workorder_xt_repairfacility", | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid", | |
"r_xxx_mms_ar_workorder_xt_reportdate", | |
"r_xxx_mms_ar_workorder_xt_reportedby", | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime", | |
"r_xxx_mms_ar_workorder_xt_respondby", | |
"r_xxx_mms_ar_workorder_xt_risk", | |
"r_xxx_mms_ar_workorder_xt_route", | |
"r_xxx_mms_ar_workorder_xt_routestopid", | |
"r_xxx_mms_ar_workorder_xt_rptstatus", | |
"r_xxx_mms_ar_workorder_xt_schedfinish", | |
"r_xxx_mms_ar_workorder_xt_schedstart", | |
"r_xxx_mms_ar_workorder_xt_sendersysid", | |
"r_xxx_mms_ar_workorder_xt_serviceaffect", | |
"r_xxx_mms_ar_workorder_xt_siteid", | |
"r_xxx_mms_ar_workorder_xt_sneconstraint", | |
"r_xxx_mms_ar_workorder_xt_sourcesysid", | |
"r_xxx_mms_ar_workorder_xt_status", | |
"r_xxx_mms_ar_workorder_xt_statusdate", | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus", | |
"r_xxx_mms_ar_workorder_xt_supervisor", | |
"r_xxx_mms_ar_workorder_xt_suspendflow", | |
"r_xxx_mms_ar_workorder_xt_sys_downtime", | |
"r_xxx_mms_ar_workorder_xt_targcompdate", | |
"r_xxx_mms_ar_workorder_xt_targetdesc", | |
"r_xxx_mms_ar_workorder_xt_targstartdate", | |
"r_xxx_mms_ar_workorder_xt_taskid", | |
"r_xxx_mms_ar_workorder_xt_tochainage", | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish", | |
"r_xxx_mms_ar_workorder_xt_user_schedstart", | |
"r_xxx_mms_ar_workorder_xt_vendor", | |
"r_xxx_mms_ar_workorder_xt_verification", | |
"r_xxx_mms_ar_workorder_xt_whomischangefor", | |
"r_xxx_mms_ar_workorder_xt_wo_downtime", | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type", | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype", | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges", | |
"r_xxx_mms_ar_workorder_xt_woclass", | |
"r_xxx_mms_ar_workorder_xt_wogroup", | |
"r_xxx_mms_ar_workorder_xt_woisswap", | |
"r_xxx_mms_ar_workorder_xt_wonum", | |
"r_xxx_mms_ar_workorder_xt_wopriority", | |
"r_xxx_mms_ar_workorder_xt_worklocation", | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus", | |
"r_xxx_mms_ar_workorder_xt_worktype", | |
"r_xxx_mms_ar_workorder_xt_wosequence", | |
"r_xxx_mms_ar_workorder_xt_ingestion_time", | |
"r_xxx_mms_ar_workorder_xt_flowid", | |
"r_xxx_mms_ar_workorder_xt_dat_qlty", | |
"r_xxx_mms_ar_workorder_xt_ingestion_date", | |
"r_xxx_mms_ar_workorder_xt_business_date" | |
], | |
"ignore_missing": false | |
} | |
}, | |
{ | |
"date": { | |
"field": "r_xxx_mms_ar_workorder_xt_reportdate", | |
"timezone": "Asia/Singapore", | |
"formats": [ | |
"strict_date_optional_time", | |
"yyyy-MM-dd HH:mm:ss.SSS", | |
"yyyy-MM-dd HH:mm:ss.SS", | |
"yyyy-MM-dd HH:mm:ss", | |
"yyyy-MM-dd HH:mm:ss.S" | |
] | |
} | |
}, | |
{ | |
"date": { | |
"field": "r_xxx_mms_ar_workorder_xt_reportdate", | |
"timezone": "Asia/Singapore", | |
"target_field": "r_xxx_mms_ar_workorder_xt_reportdate", | |
"formats": [ | |
"strict_date_optional_time", | |
"yyyy-MM-dd HH:mm:ss.SSS", | |
"yyyy-MM-dd HH:mm:ss.SS", | |
"yyyy-MM-dd HH:mm:ss", | |
"yyyy-MM-dd HH:mm:ss.S" | |
] | |
} | |
} | |
] | |
} | |
POST _ingest/pipeline/reams-workorder-logs/_simulate | |
{ | |
"docs": [ | |
{ | |
"_source": { | |
"message": "1033718,NULL,0.0,0.0,0.0,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221" | |
} | |
} | |
] | |
} | |
DELETE reams-workorder-logs-test | |
POST reams-workorder-logs-test/_doc?pipeline=reams-workorder-logs | |
{ | |
"message": "1033718,NULL,0.0,0.0,0.0,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221" | |
} | |
POST reams-workorder-logs-test/_doc?pipeline=reams-workorder-logs | |
{ | |
"message": "1033718,NULL,0.1,0.2,0.3,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221" | |
} | |
GET reams-workorder-logs-test/_search | |
{ | |
"_source": ["*"], | |
"fields": ["*"] | |
} | |
# Results | |
{ | |
"took": 2, | |
"timed_out": false, | |
"_shards": { | |
"total": 1, | |
"successful": 1, | |
"skipped": 0, | |
"failed": 0 | |
}, | |
"hits": { | |
"total": { | |
"value": 2, | |
"relation": "eq" | |
}, | |
"max_score": 1, | |
"hits": [ | |
{ | |
"_index": "reams-workorder-logs-test", | |
"_id": "Ne-Dw4wBsqdyNt92i7oh", | |
"_score": 1, | |
"_ignored": [ | |
"r_xxx_mms_ar_workorder_xt_actfinish" | |
], | |
"_source": { | |
"r_xxx_mms_ar_workorder_xt_interruptible": "0", | |
"r_xxx_mms_ar_workorder_xt_aos": "0", | |
"r_xxx_mms_ar_workorder_xt_faildate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": "NULL", | |
"r_xxx_mms_ar_workorder_xt_failurecode": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reasonforchange": "NULL", | |
"r_xxx_mms_ar_workorder_xt_generatedforpo": "NULL", | |
"r_xxx_mms_ar_workorder_xt_workorderid": "1033718", | |
"r_xxx_mms_ar_workorder_xt_historyflag": "0", | |
"r_xxx_mms_ar_workorder_xt_lms": "0", | |
"r_xxx_mms_ar_workorder_xt_calcorgid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wopriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reportedby": "126692", | |
"r_xxx_mms_ar_workorder_xt_whomischangefor": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint": "NULL", | |
"r_xxx_mms_ar_workorder_xt_istask": "0", | |
"r_xxx_mms_ar_workorder_xt_calccalendar": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fromchainage": "NULL", | |
"r_xxx_mms_ar_workorder_xt_newchildclass": "WORKORDER", | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_worktype": "PM", | |
"r_xxx_mms_ar_workorder_xt_classstructureid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targstartdate": "2023-02-19 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_user_schedstart": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency": "11.0", | |
"r_xxx_mms_ar_workorder_xt_vendor": "NULL", | |
"r_xxx_mms_ar_workorder_xt_changeby": "126692", | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_genforpolineid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_status": "APPR", | |
"r_xxx_mms_ar_workorder_xt_taskid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_woclass": "WORKORDER", | |
"r_xxx_mms_ar_workorder_xt_calcpriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fdnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_origrecordid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_observation": "NULL", | |
"r_xxx_mms_ar_workorder_xt_amcrew": "NULL", | |
"r_xxx_mms_ar_workorder_xt_measuredate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_parent": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_tochainage": "NULL", | |
"r_xxx_mms_ar_workorder_xt_repairfacility": "NULL", | |
"r_xxx_mms_ar_workorder_xt_woisswap": "0", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmnum": "PM000000098438", | |
"r_xxx_mms_ar_workorder_xt_lead": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": "NULL", | |
"r_xxx_mms_ar_workorder_xt_respondby": "NULL", | |
"r_xxx_mms_ar_workorder_xt_sys_downtime": "NULL", | |
"r_xxx_mms_ar_workorder_xt_environment": "NULL", | |
"r_xxx_mms_ar_workorder_xt_haschildren": "0", | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_persongroup": "PWY", | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_flowaction": "NULL", | |
"r_xxx_mms_ar_workorder_xt_serviceaffect": "0", | |
"r_xxx_mms_ar_workorder_xt_actfinish": "NULL", | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": "2022-12-30 16:35:29.595", | |
"r_xxx_mms_ar_workorder_xt_los": "0", | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_origrecordclass": "NULL", | |
"r_xxx_mms_ar_workorder_xt_availstatusdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ingestion_date": "20230308", | |
"r_xxx_mms_ar_workorder_xt_actstart": "2022-12-27 04:03:12.526", | |
"r_xxx_mms_ar_workorder_xt_problemcode": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wonum": "WO00428934", | |
"r_xxx_mms_ar_workorder_xt_fincntrlid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_actlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_pluscismobile": "0", | |
"r_xxx_mms_ar_workorder_xt_jobtaskid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_ingestion_time": "2023-03-08 16:07:17.438", | |
"r_xxx_mms_ar_workorder_xt_location": "L000000000009", | |
"r_xxx_mms_ar_workorder_xt_externalrefid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched": "1", | |
"r_xxx_mms_ar_workorder_xt_justifypriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wosequence": "NULL", | |
"r_xxx_mms_ar_workorder_xt_schedstart": "2023-02-21 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_sneconstraint": "NULL", | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled": "0", | |
"r_xxx_mms_ar_workorder_xt_pmduedate": "2023-02-21", | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate": "2023-03-04", | |
"r_xxx_mms_ar_workorder_xt_flowactionassist": "0", | |
"r_xxx_mms_ar_workorder_xt_worklocation": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": "0", | |
"r_xxx_mms_ar_workorder_xt_inspector": "NULL", | |
"@timestamp": "2022-12-27T04:03:13.167+08:00", | |
"r_xxx_mms_ar_workorder_xt_dat_qlty": "FAIL", | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_jpnum": "JP00008836", | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": "1", | |
"r_xxx_mms_ar_workorder_xt_description": "2023 PWY PQA 11-Daily xxx General Inspection", | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_ignorediavail": "0", | |
"r_xxx_mms_ar_workorder_xt_suspendflow": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcomtype": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targcompdate": "2023-02-23 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_apptrequired": "0", | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure": "0", | |
"r_xxx_mms_ar_workorder_xt_langcode": "EN", | |
"r_xxx_mms_ar_workorder_xt_flowid": "0160a289-ee6a-4dca-94f7-4b3794caf1a7", | |
"r_xxx_mms_ar_workorder_xt_hasld": "0", | |
"r_xxx_mms_ar_workorder_xt_ifce_sender": "NULL", | |
"r_xxx_mms_ar_workorder_xt_orgid": "xxxMRT", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": "NULL", | |
"r_xxx_mms_ar_workorder_xt_genforporevision": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time": "NULL", | |
"r_xxx_mms_ar_workorder_xt_newserialnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_routestopid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscloop": "0", | |
"r_xxx_mms_ar_workorder_xt_reportdate": "2022-12-27T04:03:13.167+08:00", | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges": "1", | |
"r_xxx_mms_ar_workorder_xt_supervisor": "131758.0", | |
"r_xxx_mms_ar_workorder_xt_outtoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_sourcesysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pointnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_siteid": "xxx", | |
"r_xxx_mms_ar_workorder_xt_ifce_req": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ownersysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_partchangeout": "0", | |
"r_xxx_mms_ar_workorder_xt_risk": "NULL", | |
"r_xxx_mms_ar_workorder_xt_acttoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_assetnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targetdesc": "NULL", | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_route": "2023 PWY-ML-IS/12", | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": "NULL", | |
"r_xxx_mms_ar_workorder_xt_launchentryname": "NULL", | |
"r_xxx_mms_ar_workorder_xt_owner": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ams": "0", | |
"r_xxx_mms_ar_workorder_xt_changedate": "2022-12-30 16:35:29.11", | |
"r_xxx_mms_ar_workorder_xt_crewid": "PWY_PQA", | |
"r_xxx_mms_ar_workorder_xt_estdur": "3.0", | |
"r_xxx_mms_ar_workorder_xt_wogroup": "WO00428934", | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus": "WSCH", | |
"r_xxx_mms_ar_workorder_xt_rptstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_disabled": "0", | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty": "NULL", | |
"r_xxx_mms_ar_workorder_xt_oldserialnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_remdur": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ownergroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_esttoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": "NULL", | |
"r_xxx_mms_ar_workorder_xt_sendersysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_calcshift": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_statusdate": "2022-12-30 16:34:02.356", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": "DAYS", | |
"r_xxx_mms_ar_workorder_xt_commoditygroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_measurementvalue": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmextdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_schedfinish": "2023-02-21 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_wo_downtime": "NULL", | |
"r_xxx_mms_ar_workorder_xt_calendar": "NULL", | |
"r_xxx_mms_ar_workorder_xt_business_date": "20230221", | |
"message": "1033718,NULL,0.0,0.0,0.0,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221", | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": "1", | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": "0", | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": "0.0", | |
"r_xxx_mms_ar_workorder_xt_onbehalfof": "NULL", | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_downtime": "0", | |
"r_xxx_mms_ar_workorder_xt_backoutplan": "NULL", | |
"r_xxx_mms_ar_workorder_xt_chargestore": "0", | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcomstate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish": "NULL", | |
"r_xxx_mms_ar_workorder_xt_commodity": "NULL", | |
"r_xxx_mms_ar_workorder_xt_verification": "NULL", | |
"r_xxx_mms_ar_workorder_xt_cinum": "NULL" | |
}, | |
"fields": { | |
"r_xxx_mms_ar_workorder_xt_interruptible": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_aos": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_faildate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_failurecode": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reasonforchange": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_generatedforpo": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_historyflag": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_lms": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_workorderid": [ | |
1033718 | |
], | |
"r_xxx_mms_ar_workorder_xt_calcorgid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wopriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reportedby": [ | |
"126692" | |
], | |
"r_xxx_mms_ar_workorder_xt_whomischangefor": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_istask": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_calccalendar": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fromchainage": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_newchildclass": [ | |
"WORKORDER" | |
], | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_worktype": [ | |
"PM" | |
], | |
"r_xxx_mms_ar_workorder_xt_classstructureid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targstartdate": [ | |
"2023-02-19 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_user_schedstart": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency": [ | |
"11.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_vendor": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_changeby": [ | |
126692 | |
], | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_genforpolineid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_status": [ | |
"APPR" | |
], | |
"r_xxx_mms_ar_workorder_xt_taskid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_woclass": [ | |
"WORKORDER" | |
], | |
"r_xxx_mms_ar_workorder_xt_calcpriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fdnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_origrecordid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_observation": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_amcrew": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_measuredate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_parent": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_tochainage": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_repairfacility": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_woisswap": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmnum": [ | |
"PM000000098438" | |
], | |
"r_xxx_mms_ar_workorder_xt_lead": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_respondby": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_sys_downtime": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_environment": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_haschildren": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_persongroup": [ | |
"PWY" | |
], | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowaction": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_serviceaffect": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": [ | |
"2022-12-30 16:35:29.595" | |
], | |
"r_xxx_mms_ar_workorder_xt_los": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_origrecordclass": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_availstatusdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ingestion_date": [ | |
"20230308" | |
], | |
"r_xxx_mms_ar_workorder_xt_actstart": [ | |
"2022-12-27T04:03:12.526Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_problemcode": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wonum": [ | |
"WO00428934" | |
], | |
"r_xxx_mms_ar_workorder_xt_fincntrlid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_actlabhrs": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscismobile": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_jobtaskid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ingestion_time": [ | |
"2023-03-08 16:07:17.438" | |
], | |
"r_xxx_mms_ar_workorder_xt_location": [ | |
"L000000000009" | |
], | |
"r_xxx_mms_ar_workorder_xt_externalrefid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_justifypriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wosequence": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_schedstart": [ | |
"2023-02-21 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_sneconstraint": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmduedate": [ | |
"2023-02-21" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate": [ | |
"2023-03-04" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowactionassist": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_worklocation": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": [ | |
"0" | |
], | |
"@timestamp": [ | |
"2022-12-26T20:03:13.167Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_inspector": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_dat_qlty": [ | |
"FAIL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_jpnum": [ | |
"JP00008836" | |
], | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_description": [ | |
"2023 PWY PQA 11-Daily xxx General Inspection" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ignorediavail": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_suspendflow": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcomtype": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targcompdate": [ | |
"2023-02-23 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_apptrequired": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowid": [ | |
"0160a289-ee6a-4dca-94f7-4b3794caf1a7" | |
], | |
"r_xxx_mms_ar_workorder_xt_langcode": [ | |
"EN" | |
], | |
"r_xxx_mms_ar_workorder_xt_hasld": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ifce_sender": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_orgid": [ | |
"xxxMRT" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_genforporevision": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_newserialnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_routestopid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscloop": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_reportdate": [ | |
"2022-12-26T20:03:13.167Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_supervisor": [ | |
"131758.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_outtoolcost": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_sourcesysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pointnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_siteid": [ | |
"xxx" | |
], | |
"r_xxx_mms_ar_workorder_xt_ifce_req": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ownersysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_partchangeout": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_risk": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_acttoolcost": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_assetnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targetdesc": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_route": [ | |
"2023 PWY-ML-IS/12" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_launchentryname": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_owner": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ams": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_changedate": [ | |
"2022-12-30 16:35:29.11" | |
], | |
"r_xxx_mms_ar_workorder_xt_crewid": [ | |
"PWY_PQA" | |
], | |
"r_xxx_mms_ar_workorder_xt_estdur": [ | |
"3.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wogroup": [ | |
"WO00428934" | |
], | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus": [ | |
"WSCH" | |
], | |
"r_xxx_mms_ar_workorder_xt_rptstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_disabled": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_oldserialnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_remdur": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ownergroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_esttoolcost": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_sendersysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_calcshift": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_statusdate": [ | |
"2022-12-30 16:34:02.356" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": [ | |
"DAYS" | |
], | |
"r_xxx_mms_ar_workorder_xt_commoditygroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_measurementvalue": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmextdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_schedfinish": [ | |
"2023-02-21 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_downtime": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_business_date": [ | |
"20230221" | |
], | |
"r_xxx_mms_ar_workorder_xt_calendar": [ | |
"NULL" | |
], | |
"message": [ | |
"1033718,NULL,0.0,0.0,0.0,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221" | |
], | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_onbehalfof": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_downtime": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_backoutplan": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_chargestore": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcomstate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_commodity": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_verification": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_cinum": [ | |
"NULL" | |
] | |
}, | |
"ignored_field_values": { | |
"r_xxx_mms_ar_workorder_xt_actfinish": [ | |
"NULL" | |
] | |
} | |
}, | |
{ | |
"_index": "reams-workorder-logs-test", | |
"_id": "Nu-Dw4wBsqdyNt92kLp3", | |
"_score": 1, | |
"_ignored": [ | |
"r_xxx_mms_ar_workorder_xt_actfinish" | |
], | |
"_source": { | |
"r_xxx_mms_ar_workorder_xt_interruptible": "0", | |
"r_xxx_mms_ar_workorder_xt_aos": "0", | |
"r_xxx_mms_ar_workorder_xt_faildate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": "NULL", | |
"r_xxx_mms_ar_workorder_xt_failurecode": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reasonforchange": "NULL", | |
"r_xxx_mms_ar_workorder_xt_generatedforpo": "NULL", | |
"r_xxx_mms_ar_workorder_xt_workorderid": "1033718", | |
"r_xxx_mms_ar_workorder_xt_historyflag": "0", | |
"r_xxx_mms_ar_workorder_xt_lms": "0", | |
"r_xxx_mms_ar_workorder_xt_calcorgid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wopriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reportedby": "126692", | |
"r_xxx_mms_ar_workorder_xt_whomischangefor": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint": "NULL", | |
"r_xxx_mms_ar_workorder_xt_istask": "0", | |
"r_xxx_mms_ar_workorder_xt_calccalendar": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fromchainage": "NULL", | |
"r_xxx_mms_ar_workorder_xt_newchildclass": "WORKORDER", | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_worktype": "PM", | |
"r_xxx_mms_ar_workorder_xt_classstructureid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targstartdate": "2023-02-19 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_user_schedstart": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency": "11.0", | |
"r_xxx_mms_ar_workorder_xt_vendor": "NULL", | |
"r_xxx_mms_ar_workorder_xt_changeby": "126692", | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs": "0.1", | |
"r_xxx_mms_ar_workorder_xt_genforpolineid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_status": "APPR", | |
"r_xxx_mms_ar_workorder_xt_taskid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_woclass": "WORKORDER", | |
"r_xxx_mms_ar_workorder_xt_calcpriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_fdnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_origrecordid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_observation": "NULL", | |
"r_xxx_mms_ar_workorder_xt_amcrew": "NULL", | |
"r_xxx_mms_ar_workorder_xt_measuredate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_parent": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_tochainage": "NULL", | |
"r_xxx_mms_ar_workorder_xt_repairfacility": "NULL", | |
"r_xxx_mms_ar_workorder_xt_woisswap": "0", | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmnum": "PM000000098438", | |
"r_xxx_mms_ar_workorder_xt_lead": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": "NULL", | |
"r_xxx_mms_ar_workorder_xt_respondby": "NULL", | |
"r_xxx_mms_ar_workorder_xt_sys_downtime": "NULL", | |
"r_xxx_mms_ar_workorder_xt_environment": "NULL", | |
"r_xxx_mms_ar_workorder_xt_haschildren": "0", | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": "0.3", | |
"r_xxx_mms_ar_workorder_xt_persongroup": "PWY", | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_flowaction": "NULL", | |
"r_xxx_mms_ar_workorder_xt_serviceaffect": "0", | |
"r_xxx_mms_ar_workorder_xt_actfinish": "NULL", | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": "2022-12-30 16:35:29.595", | |
"r_xxx_mms_ar_workorder_xt_los": "0", | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_origrecordclass": "NULL", | |
"r_xxx_mms_ar_workorder_xt_availstatusdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ingestion_date": "20230308", | |
"r_xxx_mms_ar_workorder_xt_actstart": "2022-12-27 04:03:12.526", | |
"r_xxx_mms_ar_workorder_xt_problemcode": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wonum": "WO00428934", | |
"r_xxx_mms_ar_workorder_xt_fincntrlid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_actlabhrs": "0.2", | |
"r_xxx_mms_ar_workorder_xt_pluscismobile": "0", | |
"r_xxx_mms_ar_workorder_xt_jobtaskid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_ingestion_time": "2023-03-08 16:07:17.438", | |
"r_xxx_mms_ar_workorder_xt_location": "L000000000009", | |
"r_xxx_mms_ar_workorder_xt_externalrefid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched": "1", | |
"r_xxx_mms_ar_workorder_xt_justifypriority": "NULL", | |
"r_xxx_mms_ar_workorder_xt_wosequence": "NULL", | |
"r_xxx_mms_ar_workorder_xt_schedstart": "2023-02-21 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_sneconstraint": "NULL", | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled": "0", | |
"r_xxx_mms_ar_workorder_xt_pmduedate": "2023-02-21", | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate": "2023-03-04", | |
"r_xxx_mms_ar_workorder_xt_flowactionassist": "0", | |
"r_xxx_mms_ar_workorder_xt_worklocation": "NULL", | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": "0", | |
"r_xxx_mms_ar_workorder_xt_inspector": "NULL", | |
"@timestamp": "2022-12-27T04:03:13.167+08:00", | |
"r_xxx_mms_ar_workorder_xt_dat_qlty": "FAIL", | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_jpnum": "JP00008836", | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": "1", | |
"r_xxx_mms_ar_workorder_xt_description": "2023 PWY PQA 11-Daily xxx General Inspection", | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_ignorediavail": "0", | |
"r_xxx_mms_ar_workorder_xt_suspendflow": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcomtype": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targcompdate": "2023-02-23 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_apptrequired": "0", | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure": "0", | |
"r_xxx_mms_ar_workorder_xt_langcode": "EN", | |
"r_xxx_mms_ar_workorder_xt_flowid": "0160a289-ee6a-4dca-94f7-4b3794caf1a7", | |
"r_xxx_mms_ar_workorder_xt_hasld": "0", | |
"r_xxx_mms_ar_workorder_xt_ifce_sender": "NULL", | |
"r_xxx_mms_ar_workorder_xt_orgid": "xxxMRT", | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": "NULL", | |
"r_xxx_mms_ar_workorder_xt_genforporevision": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time": "NULL", | |
"r_xxx_mms_ar_workorder_xt_newserialnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_routestopid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscloop": "0", | |
"r_xxx_mms_ar_workorder_xt_reportdate": "2022-12-27T04:03:13.167+08:00", | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges": "1", | |
"r_xxx_mms_ar_workorder_xt_supervisor": "131758.0", | |
"r_xxx_mms_ar_workorder_xt_outtoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_sourcesysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pointnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_siteid": "xxx", | |
"r_xxx_mms_ar_workorder_xt_ifce_req": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ownersysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_partchangeout": "0", | |
"r_xxx_mms_ar_workorder_xt_risk": "NULL", | |
"r_xxx_mms_ar_workorder_xt_acttoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_assetnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": "NULL", | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": "0.0", | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": "NULL", | |
"r_xxx_mms_ar_workorder_xt_targetdesc": "NULL", | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_route": "2023 PWY-ML-IS/12", | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": "NULL", | |
"r_xxx_mms_ar_workorder_xt_launchentryname": "NULL", | |
"r_xxx_mms_ar_workorder_xt_owner": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ams": "0", | |
"r_xxx_mms_ar_workorder_xt_changedate": "2022-12-30 16:35:29.11", | |
"r_xxx_mms_ar_workorder_xt_crewid": "PWY_PQA", | |
"r_xxx_mms_ar_workorder_xt_estdur": "3.0", | |
"r_xxx_mms_ar_workorder_xt_wogroup": "WO00428934", | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus": "WSCH", | |
"r_xxx_mms_ar_workorder_xt_rptstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_disabled": "0", | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty": "NULL", | |
"r_xxx_mms_ar_workorder_xt_oldserialnum": "NULL", | |
"r_xxx_mms_ar_workorder_xt_remdur": "NULL", | |
"r_xxx_mms_ar_workorder_xt_ownergroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_esttoolcost": "0.0", | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": "NULL", | |
"r_xxx_mms_ar_workorder_xt_sendersysid": "NULL", | |
"r_xxx_mms_ar_workorder_xt_calcshift": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_statusdate": "2022-12-30 16:34:02.356", | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": "DAYS", | |
"r_xxx_mms_ar_workorder_xt_commoditygroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup": "NULL", | |
"r_xxx_mms_ar_workorder_xt_measurementvalue": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pmextdate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_schedfinish": "2023-02-21 00:00:00.0", | |
"r_xxx_mms_ar_workorder_xt_wo_downtime": "NULL", | |
"r_xxx_mms_ar_workorder_xt_calendar": "NULL", | |
"r_xxx_mms_ar_workorder_xt_business_date": "20230221", | |
"message": "1033718,NULL,0.1,0.2,0.3,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221", | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": "1", | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": "0", | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": "NULL", | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": "0.0", | |
"r_xxx_mms_ar_workorder_xt_onbehalfof": "NULL", | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": "NULL", | |
"r_xxx_mms_ar_workorder_xt_downtime": "0", | |
"r_xxx_mms_ar_workorder_xt_backoutplan": "NULL", | |
"r_xxx_mms_ar_workorder_xt_chargestore": "0", | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": "0", | |
"r_xxx_mms_ar_workorder_xt_pmcomstate": "NULL", | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish": "NULL", | |
"r_xxx_mms_ar_workorder_xt_commodity": "NULL", | |
"r_xxx_mms_ar_workorder_xt_verification": "NULL", | |
"r_xxx_mms_ar_workorder_xt_cinum": "NULL" | |
}, | |
"fields": { | |
"r_xxx_mms_ar_workorder_xt_interruptible": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_aos": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_faildate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_failurecode": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reasonforchange": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_generatedforpo": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_historyflag": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_lms": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_workorderid": [ | |
1033718 | |
], | |
"r_xxx_mms_ar_workorder_xt_calcorgid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wopriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reportedby": [ | |
"126692" | |
], | |
"r_xxx_mms_ar_workorder_xt_whomischangefor": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fnlconstraint": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_istask": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_calccalendar": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fromchainage": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_newchildclass": [ | |
"WORKORDER" | |
], | |
"r_xxx_mms_ar_workorder_xt_repfacsiteid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_worktype": [ | |
"PM" | |
], | |
"r_xxx_mms_ar_workorder_xt_classstructureid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targstartdate": [ | |
"2023-02-19 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_user_schedstart": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscfrequency": [ | |
"11.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_vendor": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_changeby": [ | |
126692 | |
], | |
"r_xxx_mms_ar_workorder_xt_actintlabhrs": [ | |
0.1 | |
], | |
"r_xxx_mms_ar_workorder_xt_genforpolineid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscphyloc": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_status": [ | |
"APPR" | |
], | |
"r_xxx_mms_ar_workorder_xt_taskid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_woclass": [ | |
"WORKORDER" | |
], | |
"r_xxx_mms_ar_workorder_xt_calcpriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_fdnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_origrecordid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_observation": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_amcrew": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_measuredate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_parent": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscoverduedate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_tochainage": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_repairfacility": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_woisswap": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_fail_remarks_ops": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmnum": [ | |
"PM000000098438" | |
], | |
"r_xxx_mms_ar_workorder_xt_lead": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelinprog": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_respondby": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_sys_downtime": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_environment": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_haschildren": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_actoutlabhrs": [ | |
0.3 | |
], | |
"r_xxx_mms_ar_workorder_xt_persongroup": [ | |
"PWY" | |
], | |
"r_xxx_mms_ar_workorder_xt_assetlocpriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowaction": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_serviceaffect": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_lastcopylinkdate": [ | |
"2022-12-30 16:35:29.595" | |
], | |
"r_xxx_mms_ar_workorder_xt_los": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ops_wkly_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_origrecordclass": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_availstatusdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ingestion_date": [ | |
"20230308" | |
], | |
"r_xxx_mms_ar_workorder_xt_actstart": [ | |
"2022-12-27T04:03:12.526Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_problemcode": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wonum": [ | |
"WO00428934" | |
], | |
"r_xxx_mms_ar_workorder_xt_fincntrlid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapproutlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_kpi_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_actlabhrs": [ | |
0.2 | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscismobile": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_jobtaskid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprtoolcost": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ingestion_time": [ | |
"2023-03-08 16:07:17.438" | |
], | |
"r_xxx_mms_ar_workorder_xt_location": [ | |
"L000000000009" | |
], | |
"r_xxx_mms_ar_workorder_xt_externalrefid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inctasksinsched": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_justifypriority": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_wosequence": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_schedstart": [ | |
"2023-02-21 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_sneconstraint": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowcontrolled": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmduedate": [ | |
"2023-02-21" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmnextduedate": [ | |
"2023-03-04" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowactionassist": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_worklocation": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_reqasstdwntime": [ | |
"0" | |
], | |
"@timestamp": [ | |
"2022-12-26T20:03:13.167Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_inspector": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_dat_qlty": [ | |
"FAIL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ala_asset_id": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_jpnum": [ | |
"JP00008836" | |
], | |
"r_xxx_mms_ar_workorder_xt_parentchgsstatus": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_description": [ | |
"2023 PWY PQA 11-Daily xxx General Inspection" | |
], | |
"r_xxx_mms_ar_workorder_xt_estatapprintlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ignorediavail": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_suspendflow": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcomtype": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targcompdate": [ | |
"2023-02-23 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_apptrequired": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_workpackmtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_flowid": [ | |
"0160a289-ee6a-4dca-94f7-4b3794caf1a7" | |
], | |
"r_xxx_mms_ar_workorder_xt_langcode": [ | |
"EN" | |
], | |
"r_xxx_mms_ar_workorder_xt_hasld": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ifce_sender": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_orgid": [ | |
"xxxMRT" | |
], | |
"r_xxx_mms_ar_workorder_xt_eqpt_failure_ops": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelactname": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_genforporevision": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inaccessible_time": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_newserialnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_routestopid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscloop": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_reportdate": [ | |
"2022-12-26T20:03:13.167Z" | |
], | |
"r_xxx_mms_ar_workorder_xt_woacceptscharges": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_supervisor": [ | |
"131758.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_outtoolcost": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_dirissuemtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estintlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_sourcesysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pointnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_siteid": [ | |
"xxx" | |
], | |
"r_xxx_mms_ar_workorder_xt_ifce_req": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ownersysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_partchangeout": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_risk": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_acttoolcost": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_assetnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_inaccessible_remarks": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_estoutlabhrs": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_tar_accesstype": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_targetdesc": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_assignedownergroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_route": [ | |
"2023 PWY-ML-IS/12" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_ptw_type": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_launchentryname": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_owner": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ams": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_changedate": [ | |
"2022-12-30 16:35:29.11" | |
], | |
"r_xxx_mms_ar_workorder_xt_crewid": [ | |
"PWY_PQA" | |
], | |
"r_xxx_mms_ar_workorder_xt_estdur": [ | |
"3.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wogroup": [ | |
"WO00428934" | |
], | |
"r_xxx_mms_ar_workorder_xt_firstapprstatus": [ | |
"WSCH" | |
], | |
"r_xxx_mms_ar_workorder_xt_rptstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_disabled": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_maint_act_ty": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_oldserialnum": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_remdur": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_ownergroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_esttoolcost": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcombpelenabled": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_sendersysid": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_calcshift": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscnextdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_statusdate": [ | |
"2022-12-30 16:34:02.356" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscfrequnit": [ | |
"DAYS" | |
], | |
"r_xxx_mms_ar_workorder_xt_commoditygroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_crewworkgroup": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_measurementvalue": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmextdate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_schedfinish": [ | |
"2023-02-21 00:00:00.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_wo_downtime": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_business_date": [ | |
"20230221" | |
], | |
"r_xxx_mms_ar_workorder_xt_calendar": [ | |
"NULL" | |
], | |
"message": [ | |
"1033718,NULL,0.1,0.2,0.3,2022-12-27 04:03:12.526,0.0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,126692,2022-12-30 16:35:29.11,0,NULL,NULL,NULL,NULL,PWY_PQA,NULL,2023 PWY PQA 11-Daily xxx General Inspection,NULL,0,0,NULL,NULL,NULL,0,0,0.0,0.0,0.0,0.0,3.0,0.0,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,WSCH,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,0,1,NULL,NULL,1,NULL,0,0,NULL,JP00008836,NULL,NULL,EN,2022-12-30 16:35:29.595,NULL,NULL,0,L000000000009,0,NULL,NULL,NULL,0,WORKORDER,NULL,NULL,NULL,NULL,NULL,NULL,xxxMRT,NULL,NULL,0.0,NULL,NULL,NULL,NULL,1,0,PWY,11.0,DAYS,0,0.0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2023-02-21,NULL,2023-03-04,PM000000098438,NULL,NULL,NULL,NULL,NULL,NULL,2022-12-27 04:03:13.167,126692,0,NULL,NULL,2023 PWY-ML-IS/12,NULL,NULL,2023-02-21 00:00:00.0,2023-02-21 00:00:00.0,NULL,0,xxx,NULL,NULL,APPR,2022-12-30 16:34:02.356,NULL,131758.0,0,NULL,2023-02-23 00:00:00.0,NULL,2023-02-19 00:00:00.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,WORKORDER,WO00428934,0,WO00428934,NULL,NULL,NULL,PM,NULL,2023-03-08 16:07:17.438,0160a289-ee6a-4dca-94f7-4b3794caf1a7,FAIL,20230308,20230221" | |
], | |
"r_xxx_mms_ar_workorder_xt_ignoresrmavail": [ | |
"1" | |
], | |
"r_xxx_mms_ar_workorder_xt_hasfollowupwork": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_ops_rpt_inputs": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_pluscjprevnum": [ | |
"0.0" | |
], | |
"r_xxx_mms_ar_workorder_xt_onbehalfof": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_storeroommtlstatus": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_downtime": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_backoutplan": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_chargestore": [ | |
0 | |
], | |
"r_xxx_mms_ar_workorder_xt_nestedjpinprocess": [ | |
"0" | |
], | |
"r_xxx_mms_ar_workorder_xt_pmcomstate": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_user_schedfinish": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_commodity": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_verification": [ | |
"NULL" | |
], | |
"r_xxx_mms_ar_workorder_xt_cinum": [ | |
"NULL" | |
] | |
}, | |
"ignored_field_values": { | |
"r_xxx_mms_ar_workorder_xt_actfinish": [ | |
"NULL" | |
] | |
} | |
} | |
] | |
} | |
} | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment