[{"column":"heat_id","physical_metallurgical_meaning":"Unique identifier per pour","range_or_values":"H-2025-00001..H-2025-05000","type":"string"},{"column":"timestamp","physical_metallurgical_meaning":"Pour timestamp (IST)","range_or_values":"2025-01-01..2025-12-31","type":"datetime"},{"column":"shift","physical_metallurgical_meaning":"Production shift (A 06-14, B 14-22, C 22-06)","range_or_values":"A,B,C","type":"categorical"},{"column":"operator_id","physical_metallurgical_meaning":"Operator on duty \u2014 A=OP-104 (12y), B=OP-217 (4y), C=OP-308 (8y)","range_or_values":"OP-104,OP-217,OP-308","type":"categorical"},{"column":"furnace_id","physical_metallurgical_meaning":"Induction furnace; F1 lining 6 months older than F2","range_or_values":"F1,F2","type":"categorical"},{"column":"mold_line_id","physical_metallurgical_meaning":"Mold preparation line","range_or_values":"ML-1,ML-2","type":"categorical"},{"column":"pattern_id","physical_metallurgical_meaning":"Pattern asset","range_or_values":"PT-A,PT-B,PT-C","type":"categorical"},{"column":"pattern_age_cycles","physical_metallurgical_meaning":"Pour cycles since pattern installed; wear curve drives dim_NC","range_or_values":"0-1500","type":"int"},{"column":"season","physical_metallurgical_meaning":"Indian seasonal bucket","range_or_values":"Winter,Pre_monsoon,Monsoon,Post_monsoon","type":"categorical"},{"column":"ambient_temp_C","physical_metallurgical_meaning":"Ambient air temperature","range_or_values":"16-38","type":"float"},{"column":"ambient_humidity_pct","physical_metallurgical_meaning":"Ambient relative humidity (drives porosity)","range_or_values":"40-95","type":"float"},{"column":"sand_moisture_pct","physical_metallurgical_meaning":"Green sand moisture by weight (drives porosity non-linearly)","range_or_values":"2.5-6.0","type":"float"},{"column":"mold_hardness_B","physical_metallurgical_meaning":"Mold compaction hardness (B-scale)","range_or_values":"72-92","type":"float"},{"column":"mold_temp_C","physical_metallurgical_meaning":"Mold temperature at pour","range_or_values":"22-55","type":"float"},{"column":"binder_pct","physical_metallurgical_meaning":"Bentonite + additive percentage in sand","range_or_values":"1.4-2.4","type":"float"},{"column":"mold_permeability","physical_metallurgical_meaning":"GFN permeability number","range_or_values":"80-160","type":"float"},{"column":"C_pct","physical_metallurgical_meaning":"Carbon content (IS 210 FG260 range)","range_or_values":"3.10-3.60","type":"float"},{"column":"Si_pct","physical_metallurgical_meaning":"Silicon content (graphitizer)","range_or_values":"1.80-2.40","type":"float"},{"column":"Mn_pct","physical_metallurgical_meaning":"Manganese content (S neutralizer)","range_or_values":"0.50-0.90","type":"float"},{"column":"S_pct","physical_metallurgical_meaning":"Sulphur content","range_or_values":"0.06-0.12","type":"float"},{"column":"P_pct","physical_metallurgical_meaning":"Phosphorus content (improves fluidity)","range_or_values":"0.05-0.12","type":"float"},{"column":"Cr_pct","physical_metallurgical_meaning":"Chromium content (carbide former \u2014 keep low)","range_or_values":"0.00-0.20","type":"float"},{"column":"carbon_equivalent","physical_metallurgical_meaning":"CE = C + (Si+P)/3; eutectic band 4.0-4.3","range_or_values":"3.85-4.45","type":"float"},{"column":"mn_s_ratio_ok","physical_metallurgical_meaning":"True if Mn >= 1.7*S + 0.3","range_or_values":"True,False","type":"bool"},{"column":"pour_temp_C","physical_metallurgical_meaning":"Tundish pour temperature","range_or_values":"1340-1480","type":"float"},{"column":"superheat_C","physical_metallurgical_meaning":"pour_temp_C minus liquidus (1180\u00b0C)","range_or_values":"160-300","type":"float"},{"column":"pour_rate_kg_per_s","physical_metallurgical_meaning":"Mass flow during pour","range_or_values":"4.5-10.5","type":"float"},{"column":"pour_delay_min","physical_metallurgical_meaning":"Tap-to-pour delay","range_or_values":"0-15","type":"float"},{"column":"cooling_rate_C_per_min","physical_metallurgical_meaning":"Average cooling rate from solidus to 600\u00b0C","range_or_values":"4-22","type":"float"},{"column":"fade_time_min","physical_metallurgical_meaning":"Inoculation fade time (loss of inoculant effect)","range_or_values":"0-30","type":"float"},{"column":"inoculant_dose_pct","physical_metallurgical_meaning":"Inoculant addition (FeSi-based)","range_or_values":"0.10-0.30","type":"float"},{"column":"core_moisture_pct","physical_metallurgical_meaning":"Core sand moisture","range_or_values":"2.0-5.0","type":"float"},{"column":"furnace_temp_drift_C","physical_metallurgical_meaning":"Cumulative drift from furnace baseline this campaign","range_or_values":"0-18","type":"float"},{"column":"bore_diameter_mm","physical_metallurgical_meaning":"CMM measurement \u2014 USL 89.55 LSL 89.45 (Cpk target 1.18)","range_or_values":"89.40-89.60","type":"float"},{"column":"deck_height_mm","physical_metallurgical_meaning":"CMM measurement \u2014 USL 220.08 LSL 219.92 (Cpk target 1.45)","range_or_values":"219.85-220.15","type":"float"},{"column":"wall_thickness_mm","physical_metallurgical_meaning":"CMM measurement \u2014 USL 4.65 LSL 4.35 (Cpk target 1.62)","range_or_values":"4.15-4.85","type":"float"},{"column":"surface_roughness_Ra_um","physical_metallurgical_meaning":"Surface roughness Ra in microns","range_or_values":"2.5-9.5","type":"float"},{"column":"casting_weight_kg","physical_metallurgical_meaning":"Final casting mass","range_or_values":"205-225","type":"float"},{"column":"yield_pct","physical_metallurgical_meaning":"Sound casting mass / total poured mass","range_or_values":"82-98","type":"float"},{"column":"defect_class","physical_metallurgical_meaning":"Predicted defect type \u2014 see metallurgical_assumptions.json","range_or_values":"9 classes + None","type":"categorical"},{"column":"severity","physical_metallurgical_meaning":"Outcome severity","range_or_values":"None,Minor_Rework,Major_Rework,Scrap","type":"categorical"},{"column":"disposition","physical_metallurgical_meaning":"Final disposition","range_or_values":"OK,Rework,Scrap,Customer_Reject","type":"categorical"},{"column":"customer_complaint","physical_metallurgical_meaning":"Whether a customer complaint was logged downstream","range_or_values":"True,False","type":"bool"},{"column":"warranty_risk_score","physical_metallurgical_meaning":"Predicted warranty claim risk","range_or_values":"0-10","type":"float"},{"column":"oem_customer","physical_metallurgical_meaning":"Receiving OEM","range_or_values":"OEM-TATA,OEM-MAHINDRA,OEM-ASHOK_LEYLAND","type":"categorical"}]
