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
AREAHansen.AssetManagement.Street.StreetArea
BASETYPENot mapped
COMPASHansen.AssetManagement.Street.StreetDirection
COMPONENTSHansen.AssetManagement.Street.SWComponentType
CREWHansen.AssetManagement.AssetResponsibility
CURBTYPEHansen.AssetManagement.Street.StreetCurbType
DISTRICTHansen.AssetManagement.Street.StreetDistrict
DIVIDERTYPENot mapped
FILLERTYPEHansen.AssetManagement.Street.StreetFillerType
LOCATIONHansen.AssetManagement.Street.StreetLocation
MATERIALHansen.AssetManagement.Street.StreetConstructMaterial
OBGROUPHansen.AssetManagement.InspectionTypeObservationGroup
PEDTRAFFIC (prepopulated)Not mapped
PVMENTTYPEHansen.AssetManagement.Street.StreetSurfaceType
SIDEWALKTYPEHansen.AssetManagement.Street.StreetSidewalkType
STREETSIDEHansen.AssetManagement.Street.StreetDirection
SUBAREAHansen.AssetManagement.Street.StreetSubArea
SURFACETYPEHansen.AssetManagement.Street.StreetSurfaceType
UNITOFMEASHansen.AssetManagement.AssetUnitOfMeasure