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.Sewer.SewerArea
CATEGORYNot mapped
COMPAS (pre-populated)Not mapped
COMPONENTSHansen.AssetManagement.Sewer.SMNComponentType
ConditionNot mapped
CREWHansen.AssetManagement.AssetResponsibility
DIRECTIONHansen.AssetManagement.Sewer.SewerDirection
DISTRICTHansen.AssetManagement.Sewer.SewerDistrict
FLOWCONTROLNot mapped
JOINTTYPEHansen.AssetManagement.Sewer.SewerJointType
LININGMETHODNot mapped
LOCATIONHansen.AssetManagement.Sewer.SewerLocation
MATERIALHansen.AssetManagement.Sewer.SewerPipeType
OBMEASUOMHansen.AssetManagement.Sewer.SewerUnitOfMeasure
OBPOSHansen.AssetManagement.Sewer.SMNInspectionObservationPosition
OBSGROUPHansen.AssetManagement.InspectionTypeObservationGroup
OWNERSHIPHansen.AssetManagement.Sewer.SewerOwnership
PAYTYPENot mapped
PRECLEANINGHansen.AssetManagement.Sewer.SewerPreCleaning
ProjectHansen.AssetManagement.AssetProject
PURPOSENot mapped
ResultNot mapped
SERVICENot mapped
SHAPEHansen.AssetManagement.Sewer.SewerPipeShape
SUBAREAHansen.AssetManagement.Sewer.SewerSubArea
SURFACEHansen.AssetManagement.Sewer.SewerSurfaceCover
UNITOFMEAS (pre-populated)Hansen.AssetManagement.AssetUnitOfMeasure
USAGETYPE (pre-populated)Not mapped
USENot mapped
WEATHERHansen.AssetManagement.Sewer.SewerWeather