Configuring lookups

To configure lookups to use labor metric security:

  1. Browse to the page that contains the DBLookups you want to configure.
  2. Click Turn ON Config Mode.
  3. Click the diamond symbol next to the lookup you want to configure.
  4. Modify the SELECT statement in the Field Parameters field to select data from the LABMET_SEC_GRP table and determine the employee's labor metric security group in the WHERE clause.
    For example, to filter time codes for employees who are assigned to labor metric security groups based on their calculation groups, use this query:
    SELECT TIME_CODE.TCODE_NAME, TIME_CODE.TCODE_NAME Name
    FROM EMPLOYEE, LABMET_SEC_GRP, TIME_CODE
    WHERE
    EMPLOYEE.EMP_ID = #request.EMP_ID# AND
    EMPLOYEE.CALCGRP_ID = LABMET_SEC_GRP.CALCGRP_ID AND
    TIME_CODE.LMS_ID = LABMET_SEC_GRP.LMS_ID AND
    (TO_TIMESTAMP(concat(substr('#request.WORK_DATE#', 1, 8),
    substr('#request.WORK_DATE#', 10, 6))) BETWEEN LMSG_START_WRKS AND
    LMSG_END_WRKS) AND
    (SYSDATE BETWEEN LMSG_START_SYSDATE AND LMSG_END_SYSDATE)

    The specific SELECT statement depends on which labor metric is being filtered and how employees are assigned to labor metric security groups.

  5. Click Save.
  6. Click Turn OFF Config Mode.