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.Street.StreetArea |
| BASETYPE | Not mapped |
| COMPAS | Hansen.AssetManagement.Street.StreetDirection |
| COMPONENTS | Hansen.AssetManagement.Street.SWComponentType |
| CREW | Hansen.AssetManagement.AssetResponsibility |
| CURBTYPE | Hansen.AssetManagement.Street.StreetCurbType |
| DISTRICT | Hansen.AssetManagement.Street.StreetDistrict |
| DIVIDERTYPE | Not mapped |
| FILLERTYPE | Hansen.AssetManagement.Street.StreetFillerType |
| LOCATION | Hansen.AssetManagement.Street.StreetLocation |
| MATERIAL | Hansen.AssetManagement.Street.StreetConstructMaterial |
| OBGROUP | Hansen.AssetManagement.InspectionTypeObservationGroup |
| PEDTRAFFIC (prepopulated) | Not mapped |
| PVMENTTYPE | Hansen.AssetManagement.Street.StreetSurfaceType |
| SIDEWALKTYPE | Hansen.AssetManagement.Street.StreetSidewalkType |
| STREETSIDE | Hansen.AssetManagement.Street.StreetDirection |
| SUBAREA | Hansen.AssetManagement.Street.StreetSubArea |
| SURFACETYPE | Hansen.AssetManagement.Street.StreetSurfaceType |
| UNITOFMEAS | Hansen.AssetManagement.AssetUnitOfMeasure |