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
BASETYPEHansen.AssetManagement.Street.StreetBaseType
COMPASHansen.AssetManagement.Street.StreetDirection
COMPONENTSHansen.AssetManagement.Street.SEGComponentType
CREWHansen.AssetManagement.AssetResponsibility
CURBTYPENot mapped
DISTRICTHansen.AssetManagement.Street.StreetDistrict
DIVIDERTYPEHansen.AssetManagement.Street.StreetDividerType
EXTRAITEMNot mapped
FILLERTYPENot mapped
LOCATIONHansen.AssetManagement.Street.StreetLocation
MATERIALNot mapped
OBGROUPHansen.AssetManagement.InspectionTypeObservationGroup
PAYTYPEHansen.Resources.PayType
PEDTRAFFICNot mapped
PVMNTTYPEHansen.AssetManagement.Street.StreetSurfaceType
SIDEWALKTYPENot mapped
STREETSIDEHansen.AssetManagement.Street.StreetSubArea
SUBAREAHansen.AssetManagement.Street.StreetSubArea
SURFACETYPEHansen.AssetManagement.Street.StreetSurfaceType
UNITOFMEASHansen.AssetManagement.AssetUnitOfMeasure
USAGETYPENot mapped