Database lookup fields in Central Staffing

Database lookup fields, or DBLookup fields, in Central Staffing do not support the standard primary and secondary input fields method used to access data from other fields. Instead, certain DBLookup fields in these screens have a set of parameters available to them to allow them to connect to specific field values. A Parameters button is displayed next to fields with available parameters when Central Staffing is open in Config mode. This button can be clicked to view the list of available parameters for the field. These parameters are referenced using the format #control.parameterName# when configuring the Field Parameters for a field.

This is useful for configuring fields that are used in Central Staffing transactions multiple times on different rows. The field behavior depends on the field values corresponding with the specified parameters on the same row. For example, you can configure the Department labor metric field in the Edit Shift pop-up to filter department names that match the UDF1 field value selected for the same work or on-call detail. The Field Parameters would look like this:

sourceType=SQL source='SELECT DEPT_ID,DEPT_NAME,DEPT_DESC FROM DEPARTMENT where DEPT_NAME=?' 
orderBy='DEPT_NAME' 
sourceKeyField='DEPT_ID' 
sourceLabelField='DEPT_NAME' 
labelFieldStatus=edit title='LOOKUP_DEPARTMENT'
sourceParams='STRING==#control.shiftDtlUdf1#'

See "DBLookups" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide for more details.