Question & Answer
Question
Problem codes
Answer
Problem codes
Problem codes are the formal classification of the reportedproblem. For example a seal failure or required repair.
The problem codes comma-separated value file defines theproblem codes to be used by IBM? Work Optimization for Water Utilities. The file mustbe named problem.csv.
Each line in theCSV file needs to be in the following format:
Problem_codeDescription
Where:
- Problem_code is a short form for a definedproblem code. Problem_code can be up to 20 charactersin length.
- Description is a description of the definedproblem code. Description can be up to 80 charactersin length.
If a value contains non-alphanumeric charactersfor example spaces or symbols the value must be enclosed in quotationmarks. Otherwise surrounding values with quotation marks is optional.Values cannot include double or single quotation marks. All valuesmust be separated by commas.
Thefollowing problem codes are defined as samples in IBM Work Optimization for Water Utilities:
| Problem code | Description |
|---|---|
| 1PR01OP002 | Reduced pumping |
| 1PR01OP024 | Chemical leakage |
| 1PR02ME002 | Mechanical seal failure |
| 1PR02ME006 | Failed inspection |
| 1PR02ME007 | Inspection - Passed |
| 1PR17XX001 | Improper operation |
| 1PR18PC008 | Position not fully open |
| 1PRO2ME006 | Failed inspection |
| 1PRO2ME007 | Inspection - Passed |
| 3RM17XX008 | Cleaning |
| A CPTRY003 | General carpentry or construction |
| A CPTRY004 | Structural reinforcement |
| A ELSYS001 | Interior lighting - Installation or replacement |
| A ELSYS002 | Interior lighting - Repair |
| A ELSYS003 | Interior lighting - Replace bulbs |
| A ELSYS004 | Interior lighting - Troubleshooting |
| A ELSYS005 | Exterior lighting - Installation or replacement |
| A ELSYS006 | Exterior lighting - Repair |
| A ELSYS007 | Exterior lighting - Replace bulbs |
| A ELSYS008 | Exterior lighting - Troubleshooting |
| A ELSYS009 | Electrical power - Switch installation or replacement |
| A ELSYS011 | Electrical power - Switch - Troubleshooting |
| A ELSYS012 | Electrical power - Outlet installation or replacement |
| A ELSYS013 | Electrical outlet - RepairA EXENV004" |
| A ELSYS014 | Electrical power - Outlet - Troubleshooting |
| A ELSYS015 | Electrical power - Troubleshooting |
| A EXENV002 | Interior doors and windows - Repair |
| A EXENV003 | Exterior doors or windows - Installation orreplacement |
| A EXENV008 | Exterior painting |
| A FNSHG006 | Furniture removal |
| A FNSHG011 | Break room appliances - Troubleshoting |
| A GRNDS016 | Exterior grounds - Repair |
| A GRNDS017 | Exterior grounds cleanup |
| A HVAC004 | HVAC system - Repair |
| A HVAC005 | HVAC system - Troubleshooting |
| A HVAC007 | HVAC system - Repair |
| A HVAC009 | HVAC system - Installation or replacement |
| A HVAC010 | HVAC system - Repair |
| A INFIN001 | Interior door locks - Installation or replacement |
| A INFIN002 | Interior locks - Repair |
| A INFIN003 | Interior locks - Re-keying |
| A INFIN007 | Floor tile - Installation or replacement |
| A INFIN009 | Ceiling components - Installation or replacement |
| A INFIN011 | Window dressing - Installation or replacement |
| A INFIN018 | Bathroom dispensers - Installation or replacement |
| A JNCST002 | Interior custodial cleaning |
| A JNCST004 | Exterior debris removal |
| A JNCST006 | Interior debris removal |
| A PLUMB003 | Plumbing - Installation or replacement |
| A PLUMB004 | Plumbing - Repair |
| A SASEC001 | Exterior door locks - Installation or replacement |
| A SASEC003 | Exterior locks - Re-keying |
| A SASEC010 | Fire protection system - Installation or replacement |
| A SASEC013 | Unsafe conditions |
| A SASEC017 | Investigate and report on incident |
| A SINE001 | Interior signage - Installation or replacement |
| A SINE003 | Exterior signage - Installation or replacement |
| A SP001 | Interior renovations |
| ABANDONED | Abandoned |
| AIRBUBBLES | Air bubbles |
| BOXOFFSET | Curb cock - Box offset |
| BOXTOOLOW | Valve box - Too low |
| BROKEFRAME | Meter - Broken frame and cover |
| BROKEN | Broken |
| BROKEPIT | Meter - Broken pit |
| C03 | Rust or corrosion |
| C07 | Improper alignment or tension |
| C10 | Improper installation |
| C13 | Defective - Machine design flaw |
| C14 | Missing parts |
| C15 | Tripped |
| C18 | Normal wear |
| C20 | Obstructed |
| C21 | Operator error |
| C22 | Electrical power - Failure or surge |
| C24 | Unknown |
| C26 | Electrical power - Outtage |
| C29 | Equipment out of service |
| C30 | Redirected labor resources |
| C34 | Conflicting priorities for operations and capitalconstruction |
| CA | Condition assessment |
| CAPDAMAGED | Running trap or clean-out cap - Damaged |
| CAPMISSING | Running trap or clean-out cap - Missing |
| CBLOOSE | Catch basin - Loose |
| CBTOOLOW | Catch basin - Too low |
| CLOG | Clog |
| CONTRVALVE | Control valve |
| COVER1 | Meter - Damaged or missing cover |
| CUTINROAD | Cut in roadway |
| CW | Water - Cloudy |
| DEBRIS | Debris |
| DEFECTIVE | Defective |
| DISCOLORED | Water - Discolored |
| DUMPING | Illegal dumping |
| DW | Water - Dirty |
| EXERCISE | Exercise |
| FRCVRTOOLO | Frame and cover - Too low |
| GENREPR | General repair |
| HIPRESSURE | High pressure |
| IMPROPER | Improper installation |
| INLETDEBRI | Debris at catch basin inlet |
| INOPERBL | Inoperable |
| INSPECTION | Inspection |
| INSTALL | Installed |
| LEAD | Lead service |
| LEAK | Leak |
| LEANING | Leaning |
| LOOSEPLATE | Plates - Loose |
| LOPRESSURE | Water - Low pressure |
| LOSTITEM | Lost item |
| METERTOOLO | Meter - Too low |
| MHCD | Manhole - Damaged cover |
| MHCLOOSE | Manhole - loose cover |
| MHCM | Manhole - Missing cover |
| MHDAMAGE | Manhole - Damaged |
| MHL | Manhole - Damaged lining |
| NEWCONN | New connection |
| NOACCESS | Inaccessible |
| NODRAIN | Water - Does not drain |
| NOFRAMECOV | Meter - Missing frame and cover |
| NOTFOUND | Not found |
| NOTUPGRADE | Not capable of upgrade |
| NOWATER | Water - Unavailable |
| NOZZLE_NC | Nozzle - Not compliant |
| OBSTRUCTED | Obstructed |
| OBSTRUCTN | Obstructed |
| ODOR | Odor |
| ODORCHLOR | Odor - Chlorine |
| ODORFOUL | Odor - Foul |
| OFFSETFRAM | Frame - Offset |
| P01 | No problem - Acceptable |
| P02 | Binding stuck or jammed |
| P03 | Cracked broken or sheared |
| P04 | Damaged bent or dented |
| P05 | Deteriorated or worn |
| P06 | Dirty oiled or littered |
| P07 | Electrical power - Grounded shorting or arcing |
| P08 | Improper balance or vibration |
| P09 | Incomplete |
| P10 | Inoperable |
| P12 | Leak - Internal |
| P13 | Loose or poorly connected |
| P15 | Missing |
| P16 | Not connected |
| P19 | Out of calibration |
| P23 | Unused |
| P29 | Electrial poewr - Defective diode |
| P30 | Electrical power - Blown fuses |
| P32 | No work performed |
| P33 | Partial work performed |
| P34 | Equipment removed from preventative maintenance |
| P35 | Inspection - No follow up rquired |
| P36 | Calibration - No follow up required |
| P37 | Calibration - Follow up required |
| P38 | Lubrication - No follow up required |
| P39 | Lubrication - Follow up required |
| P40 | Corrective maintenance - No follow up |
| P41 | Corrective maintenance - Follow up required |
| PITTOOHIGH | Meter - Pit too high |
| PITTOOLOW | Meter - Pit too low |
| R01 | Adjustment calibration or setting |
| R03 | Cleaning |
| R04 | Inspection |
| R05 | Inspection |
| R06 | Loosen |
| R09 | Defective - Manufacturing flaw |
| R11 | Rebuild |
| R12 | Repair |
| R13 | Replace |
| R14 | Reset |
| R19 | Reschedule work immediately |
| R27 | Rescheduling work upon favorable conditions |
| RECHARGREQ | Recharge requested |
| SETTERBROK | Setter - Broken |
| SETTLEMENT | Settlement |
| SHUTREQ | Valve - Shut off requested |
| SINKHOLE | Sinkhole |
| SKIN_IRRIT | Water - Causes skin irritation |
| STAGNANT | Water - Stagnant |
| TAPINSERT | Tap insertion |
| TASTEFOUL | Water - Foul taste |
| TASTEMETAL | Water - Metallic taste |
| TOOHIGH | Improper installation - Too high |
| TOPLOOSE | Top - Loose |
| TOPMISSING | Top - Missing |
| UNSAFECOND | Unsafe conditions |
| VLVSHUT | Valve - Shut off for system work or test |
| WHITEPART | Water - Contains white particles |
| X1P32 | No work performed |
| X1P33 | Partial work performed |
| X1P34 | Equipment removed from preventative maintenance |
| X1P40 | Corrective maintenance - No follow up |
| X2C32 | Unsafe conditions |
| X3R26 | Reschedule work upon equipment availability |
These values can be customized two ways:
- When IBM Work Optimization for Water Utilities isinitially installed all sample values can be replaced with valuesmatching the input that will be used in the production system.
- If additional values are required these values can be added.
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSMGP8","label":"Smarter Cities"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10758635