Edit #8911 — 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": 17506, "name": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "make": "SPER", "model": "", "category": "", "confidence_score": 98.5, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "", "score": 84.93150684931507}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "score": 100}]}, "all_matches": [{"source": "spare", "source_id": 17506, "name": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "make": "SPER", "model": "", "category": "", "confidence_score": 98.5, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "", "score": 84.93150684931507}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "RING, GUIDE, LP, 140-160, SPERRE P/N 3300", "score": 100}]}, {"source": "spare", "source_id": 27253, "name": "BEARING, NEEDLE, 120-160, SPEERE P/N 3879", "make": "SPER", "model": "", "category": "", "confidence_score": 54.2, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "BEARING, NEEDLE, 120-160, SPEERE P/N 3879", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "BEARING, NEEDLE, 120-160, SPEERE", "score": 62.5}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "BEARING, NEEDLE, 120-160, SPEERE P/N 3879", "score": 40}]}, {"source": "spare", "source_id": 17517, "name": "GASKET, LP CYLINDER, SPERRE P/N 4081", "make": "SPER", "model": "", "category": "", "confidence_score": 49.4, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "GASKET, LP CYLINDER, SPERRE P/N 4081", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "GASKET, LP CYLINDER", "score": 58.82352941176471}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "GASKET, LP CYLINDER, SPERRE P/N 4081", "score": 25}]}, {"source": "spare", "source_id": 17589, "name": "RING, OIL SCRAPER, SPERRE P/N 3541", "make": "SPER", "model": "", "category": "", "confidence_score": 48.8, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "RING, OIL SCRAPER, SPERRE P/N 3541", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "RING, OIL SCRAPER, SPERRE P/N", "score": 57.57575757575757}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "RING, OIL SCRAPER, SPERRE P/N 3541", "score": 25}]}, {"source": "spare", "source_id": 17528, "name": "RING, OIL SCRAPER HV2/200-K5", "make": "SPER", "model": "", "category": "", "confidence_score": 48.3, "field_scores": [{"ocr_field": "manufacturer", "matched_field": "brand", "ocr_value": "SPER", "matched_value": "SPER", "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": "", "matched_value": "RING, OIL SCRAPER HV2/200-K5", "score": 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": "RING, GUIDE, LP. 140-160, SPERRE", "matched_value": "", "score": 53.333333333333336}, {"ocr_field": "part/model/serial numbers", "matched_field": "part_type+name+description", "ocr_value": "3300", "matched_value": "RING, OIL SCRAPER HV2/200-K5", "score": 33}]}], "match_confidence": 98.5, "ocr_input": {"manufacturer": "SPER", "equipment_type": null, "model_number": null, "serial_number": null, "part_number": "3300", "tag_number": null, "equipment_description": "RING, GUIDE, LP. 140-160, SPERRE", "visible_text": ["ICN 10008288", "Description: RING, GUIDE, LP. 140-160, SPERRE", "Manufacturer: SPER", "P/N 3300", "Part Number: 3300", "RIN 10157881", "Index Description: AUXILIARY SYSTEMS - RIG SERVICE", "Index#/SAP A.Code: 230102/710721", "Location: B237-B", "PGUeAA"]}}

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