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 | Hansen.AssetManagement.Street.StreetBaseType |
| COMPAS | Hansen.AssetManagement.Street.StreetDirection |
| COMPONENTS | Hansen.AssetManagement.Street.SEGComponentType |
| CREW | Hansen.AssetManagement.AssetResponsibility |
| CURBTYPE | Not mapped |
| DISTRICT | Hansen.AssetManagement.Street.StreetDistrict |
| DIVIDERTYPE | Hansen.AssetManagement.Street.StreetDividerType |
| EXTRAITEM | Not mapped |
| FILLERTYPE | Not mapped |
| LOCATION | Hansen.AssetManagement.Street.StreetLocation |
| MATERIAL | Not mapped |
| OBGROUP | Hansen.AssetManagement.InspectionTypeObservationGroup |
| PAYTYPE | Hansen.Resources.PayType |
| PEDTRAFFIC | Not mapped |
| PVMNTTYPE | Hansen.AssetManagement.Street.StreetSurfaceType |
| SIDEWALKTYPE | Not mapped |
| STREETSIDE | Hansen.AssetManagement.Street.StreetSubArea |
| SUBAREA | Hansen.AssetManagement.Street.StreetSubArea |
| SURFACETYPE | Hansen.AssetManagement.Street.StreetSurfaceType |
| UNITOFMEAS | Hansen.AssetManagement.AssetUnitOfMeasure |
| USAGETYPE | Not mapped |