Edit #19358 — 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

{"manufacturer": "W&O", "equipment_type": "VALVE PRESS, RELIEF", "model_number": null, "serial_number": null, "part_number": "JSV-FF21-CN-15X25", "tag_number": null, "equipment_description": "VALVE PRESS, RELIEF, 15A X 25A JIS", "visible_text": ["ICN: 10017546", "NEW", "RIN: 10426315", "Description: VALVE PRESS, RELIEF, 15A X 25A JIS", "Manufacturer: W&O", "Part Number: JSV-FF21-CN-15X25", "Index Description: AUXILIARY PUMP SYSTEMS - AUXILI", "Index#/SAP A.Code: 234701/", "Riq Req Number: 0094116395", "Packing List Number: 292848 - 8", "Purchase Order Number: 0001727857", "Location: RMS-MARINE", "Requested By: Simpson", "RMS Job: PSV", "Reason: Requested by the marine department under rms task 2290029137007 Raised to cover the cost of replacement pressure relief valves used on the", "\uac00\ubcbc\uc6b4 \ucda9\uaca9\uc73c\ub85c\ub3c4 \uce58\uba85\uc801\uc778 \uc81c\ud488\uc190\uc0c1\uc774 \uc0dd\uae38 \uc218 \uc788\uc73c\ub2c8 \ucde8\uae09\uc5d0 \uac01\ubcc4\ud55c \uc8fc\uc758 \ubc14\ub78d\ub2c8\ub2e4."]}

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": 66651, "name": "VALVE PRESS, RELIEF, 15A X 25A JIS PSV, 15A X 25A JIS PSV\n\nSC480&SUS304\n\nPLEASE ADVISE PRESSURE AND MEDIA\n\nJIS B 2210 10K RFXJIS B 2210 10K FF", "make": "W&O", "model": "", "category": "", "confidence_score": 93.9, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "W&O", "matched_value": "W&O", "score": 100}, {"ocr_field": "model_number", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "", "matched_value": "JSV-FF21-CN-15X25", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "VALVE PRESS, RELIEF", "matched_value": "VALVE PRESS, RELIEF, 15A X 25A JIS PSV, 15A X 25A JIS PSV\n\nSC480&SUS304\n\nPLEASE ADVISE PRESSURE AND MEDIA\n\nJIS B 2210 10K RFXJIS B 2210 10K FF", "score": 24.0506329113924}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "VALVE PRESS, RELIEF, 15A X 25A JIS", "matched_value": "", "score": 39.30635838150289, "boilerplate_discounted": false}, {"ocr_field": "part/model/serial numbers", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "jsvff21cn15x25", "matched_value": "JSV-FF21-CN-15X25", "score": 100}]}, "all_matches": [{"source": "spare", "source_id": 66651, "name": "VALVE PRESS, RELIEF, 15A X 25A JIS PSV, 15A X 25A JIS PSV\n\nSC480&SUS304\n\nPLEASE ADVISE PRESSURE AND MEDIA\n\nJIS B 2210 10K RFXJIS B 2210 10K FF", "make": "W&O", "model": "", "category": "", "confidence_score": 93.9, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "W&O", "matched_value": "W&O", "score": 100}, {"ocr_field": "model_number", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "", "matched_value": "JSV-FF21-CN-15X25", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "VALVE PRESS, RELIEF", "matched_value": "VALVE PRESS, RELIEF, 15A X 25A JIS PSV, 15A X 25A JIS PSV\n\nSC480&SUS304\n\nPLEASE ADVISE PRESSURE AND MEDIA\n\nJIS B 2210 10K RFXJIS B 2210 10K FF", "score": 24.0506329113924}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "VALVE PRESS, RELIEF, 15A X 25A JIS", "matched_value": "", "score": 39.30635838150289, "boilerplate_discounted": false}, {"ocr_field": "part/model/serial numbers", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "jsvff21cn15x25", "matched_value": "JSV-FF21-CN-15X25", "score": 100}]}, {"source": "spare", "source_id": 66652, "name": "VALVE, PRESS RELIEF, 25A X 40A JIS PSV", "make": "W&O", "model": "", "category": "", "confidence_score": 85.6, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "W&O", "matched_value": "W&O", "score": 100}, {"ocr_field": "model_number", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "", "matched_value": "JSV-FF21-CN-25X40", "score": 0}, {"ocr_field": "equipment_type", "matched_field": "part_name", "ocr_value": "VALVE PRESS, RELIEF", "matched_value": "VALVE, PRESS RELIEF, 25A X 40A JIS PSV", "score": 63.1578947368421}, {"ocr_field": "serial_number", "matched_field": "attributes.serial_number", "ocr_value": "", "matched_value": "", "score": 0}, {"ocr_field": "equipment_description", "matched_field": "description", "ocr_value": "VALVE PRESS, RELIEF, 15A X 25A JIS", "matched_value": "", "score": 83.33333333333334, "boilerplate_discounted": false}, {"ocr_field": "part/model/serial numbers", "matched_field": "spare_part_number/mfg_part_number", "ocr_value": "jsvff21cn15x25", "matched_value": "JSV-FF21-CN-25X40", "score": 78}]}], "match_confidence": 93.9, "ocr_input": {"manufacturer": "W&O", "equipment_type": "VALVE PRESS, RELIEF", "model_number": null, "serial_number": null, "part_number": "JSV-FF21-CN-15X25", "tag_number": null, "equipment_description": "VALVE PRESS, RELIEF, 15A X 25A JIS", "visible_text": ["ICN: 10017546", "NEW", "RIN: 10426315", "Description: VALVE PRESS, RELIEF, 15A X 25A JIS", "Manufacturer: W&O", "Part Number: JSV-FF21-CN-15X25", "Index Description: AUXILIARY PUMP SYSTEMS - AUXILI", "Index#/SAP A.Code: 234701/", "Riq Req Number: 0094116395", "Packing List Number: 292848 - 8", "Purchase Order Number: 0001727857", "Location: RMS-MARINE", "Requested By: Simpson", "RMS Job: PSV", "Reason: Requested by the marine department under rms task 2290029137007 Raised to cover the cost of replacement pressure relief valves used on the", "\uac00\ubcbc\uc6b4 \ucda9\uaca9\uc73c\ub85c\ub3c4 \uce58\uba85\uc801\uc778 \uc81c\ud488\uc190\uc0c1\uc774 \uc0dd\uae38 \uc218 \uc788\uc73c\ub2c8 \ucde8\uae09\uc5d0 \uac01\ubcc4\ud55c \uc8fc\uc758 \ubc14\ub78d\ub2c8\ub2e4."]}}

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 #19358 in identification_materials