Edit #10315 — identification_materials

id

INTEGER · required

Auto-generated

job_id

INTEGER · required

picker_id

INTEGER · required

source_type

VARCHAR(13) · required

match_type

VARCHAR(13) · required

match_status

VARCHAR(6) · required

qr_code_string

VARCHAR(120) · required

storage_qr_string

VARCHAR(200) · required

storage_label

VARCHAR(200) · required

nameplate_image_path

VARCHAR(300)

equipment_image_path

VARCHAR(300)

extraction_status

VARCHAR(30)

extraction_result

JSON

extraction_retries

INTEGER · required

matched_iadc_material_id

INTEGER

matched_spare_material_id

INTEGER

match_confidence

DOUBLE PRECISION

match_details

JSON

{"match_type": "SPARE", "match_status": "GREEN", "best_match": {"source": "spare", "source_id": 26117, "name": "CARTRIDGE, AFTER FILTER", "make": "ARD", "model": "", "category": "", "confidence_score": 80.0, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "ARD", "matched_value": "ARD", "score": 100}, {"ocr_field": "model_number", "matched_field": "part_type/mfg_part_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "AIR DRYER", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 37.5}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "CARTRIDGE, AFTER FILTER", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 100.0}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "07319", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 0}]}, "all_matches": [{"source": "spare", "source_id": 26117, "name": "CARTRIDGE, AFTER FILTER", "make": "ARD", "model": "", "category": "", "confidence_score": 80.0, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "ARD", "matched_value": "ARD", "score": 100}, {"ocr_field": "model_number", "matched_field": "part_type/mfg_part_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "AIR DRYER", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 37.5}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "CARTRIDGE, AFTER FILTER", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 100.0}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "07319", "matched_value": "CARTRIDGE, AFTER FILTER", "score": 0}]}, {"source": "spare", "source_id": 26116, "name": "CARTRIDGE, PREFILTER", "make": "ARD", "model": "", "category": "", "confidence_score": 67.4, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "ARD", "matched_value": "ARD", "score": 100}, {"ocr_field": "model_number", "matched_field": "part_type/mfg_part_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "AIR DRYER", "matched_value": "CARTRIDGE, PREFILTER", "score": 41.379310344827594}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "CARTRIDGE, AFTER FILTER", "matched_value": "", "score": 79.06976744186046}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "07319", "matched_value": "CARTRIDGE, PREFILTER", "score": 0}]}, {"source": "spare", "source_id": 19136, "name": "CARTRIDGE, LOGI PHM31", "make": "VAR", "model": "", "category": "", "confidence_score": 45.3, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "ARD", "matched_value": "VAR", "score": 66.66666666666667}, {"ocr_field": "model_number", "matched_field": "part_type/mfg_part_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "AIR DRYER", "matched_value": "CARTRIDGE, LOGI PHM31", "score": 26.66666666666667}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "CARTRIDGE, AFTER FILTER", "matched_value": "CARTRIDGE, LOGI PHM31", "score": 54.54545454545454}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "07319", "matched_value": "CARTRIDGE, LOGI PHM31", "score": 40}]}, {"source": "spare", "source_id": 20838, "name": "BEARING, ROLLER", "make": "VAR", "model": "6311 JEM", "category": "", "confidence_score": 45.1, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "ARD", "matched_value": "VAR", "score": 66.66666666666667}, {"ocr_field": "model_number", "matched_field": "part_type/mfg_part_number", "ocr_value": "", "matched_value": "6311 JEM", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "AIR DRYER", "matched_value": "BEARING, ROLLER", "score": 50.0}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "CARTRIDGE, AFTER FILTER", "matched_value": "PIPE HANDLING TOOLS - IRON ROUG", "score": 52.63157894736843}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "07319", "matched_value": "6311 JEM", "score": 44}]}], "match_confidence": 80.0, "ocr_input": {"manufacturer": "ARD", "equipment_type": "AIR DRYER", "model_number": null, "serial_number": null, "part_number": "0731-9", "tag_number": null, "equipment_description": "CARTRIDGE, AFTER FILTER", "visible_text": ["MCP", "BOX CERTIFICATE", "THIS SINGLE WALL", "MEETS ALL CONSTRUC", "REMENTS OF APPLIC", "EIGHT CLASSIFICATIO N", "I.G. 275 LBS", "I.B. 138 LBS", "N.G.S. 95 LBS", "IMIT 95 INCHES", "OSS 95 LBS", "IRELAND", "RIN 671364", "EICN: RIN000000059399", "Description: CARTRIDGE, AFTER FILTER", "Manufacturer: ARD", "Part Number: 0731-9", "Index Description: AIR DRYER", "Index Number/SAP Acct Code: 132502/", "Rig Requisition Number: 0094104639", "Packing List Number: EGLHOPHO11AAII3 - 118", "Purchase Order Number: 0000313249", "SMO/RMS:", "Location: D441", "Requested By: LAPIERRE", "Reason: Stock Replenishment", "ICN 15039008"]}}

material_id

INTEGER

cross_reference_id

VARCHAR(50)

manual_selected_name

VARCHAR(200)

notes

TEXT

created_at

TIMESTAMP · required

updated_at

TIMESTAMP · required

is_active

BOOLEAN · required

disposition

VARCHAR(50) · required

admin_notes

TEXT

admin_status

VARCHAR(20) · required

reviewed_by

INTEGER

reviewed_at

TIMESTAMP

condition

VARCHAR(20)

grade

VARCHAR(30)

nameplate_image_paths

JSON

equipment_image_paths

JSON

origin

VARCHAR(20) · required

Edit row #10315 in identification_materials