Code definition tables
Code definitions are exported from various tables in Infor Operations and Regulations.
The code definition tables in the Access database all have the same columns.
| Access DB column | IPS property |
|---|---|
| CODE | Code |
| DESCRIPT | Description |
This table lists the code definition tables in the Access database and the corresponding source tables in Infor Operations and Regulations.
| Access DB table | IPS source |
|---|---|
| AREA | Hansen.AssetManagement.Sewer.SewerArea |
| CATEGORY | Not mapped |
| COMPAS (pre-populated) | Not mapped |
| COMPONENTS | Hansen.AssetManagement.Sewer.SMNComponentType |
| Condition | Not mapped |
| CREW | Hansen.AssetManagement.AssetResponsibility |
| DIRECTION | Hansen.AssetManagement.Sewer.SewerDirection |
| DISTRICT | Hansen.AssetManagement.Sewer.SewerDistrict |
| FLOWCONTROL | Not mapped |
| JOINTTYPE | Hansen.AssetManagement.Sewer.SewerJointType |
| LININGMETHOD | Not mapped |
| LOCATION | Hansen.AssetManagement.Sewer.SewerLocation |
| MATERIAL | Hansen.AssetManagement.Sewer.SewerPipeType |
| OBMEASUOM | Hansen.AssetManagement.Sewer.SewerUnitOfMeasure |
| OBPOS | Hansen.AssetManagement.Sewer.SMNInspectionObservationPosition |
| OBSGROUP | Hansen.AssetManagement.InspectionTypeObservationGroup |
| OWNERSHIP | Hansen.AssetManagement.Sewer.SewerOwnership |
| PAYTYPE | Not mapped |
| PRECLEANING | Hansen.AssetManagement.Sewer.SewerPreCleaning |
| Project | Hansen.AssetManagement.AssetProject |
| PURPOSE | Not mapped |
| Result | Not mapped |
| SERVICE | Not mapped |
| SHAPE | Hansen.AssetManagement.Sewer.SewerPipeShape |
| SUBAREA | Hansen.AssetManagement.Sewer.SewerSubArea |
| SURFACE | Hansen.AssetManagement.Sewer.SewerSurfaceCover |
| UNITOFMEAS (pre-populated) | Hansen.AssetManagement.AssetUnitOfMeasure |
| USAGETYPE (pre-populated) | Not mapped |
| USE | Not mapped |
| WEATHER | Hansen.AssetManagement.Sewer.SewerWeather |