Customer-defined data

Customers can create custom data in core database tables in Infor Workforce Management (WFM). This custom data can be created through maintenance forms or through data import. Custom data can be used to create custom DBLookups or to satisfy other configuration requirements. These features can also interact with custom data:
  • Reports can be created in Cognos Analytics to return custom data using tabular SQL.

    For details on the custom data tables, see Customer-defined data maintenance forms.

    Note: If a custom report is created that joins to the custom data tables, an outer join should be used, because there is no database constraint to enforce referential integrity.
  • Custom scripting can be used to access or edit custom data. The custom scripting methods are documented in the WFM Java API Javadoc.
  • The WFM public API can be used to access or edit custom data. The public API methods are documented in the Swagger documentation.

Customer-defined data should be used for custom configuration requirements or to create custom DBLookups within maintenance forms. Customer-defined data should not be used for transactional data, due to potential impacts on performance if the tables contain large numbers of records.