Code definition tables
Code definitions are exported from various tables in Infor Public Sector.
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 Public Sector.
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 |