Public Queries for Punch Time


Overview

The eight queries listed below (and detailed in the next section) may be helpful when reviewing Punch Time for a pay period or specific range of dates:

  • Reported Punch Time Details:
    • By EmplID: MTL_ RPTD_PUNCH_EMPL
    • By Group: MTL_ RPTD_PUNCH_GRP
    • By Supervisor: MTL_RPTD_PUNCH_SUPVR
  • Punch Time (by Static Group) that Needs Approval:
    • List of employees that need approval: MTL_ RPTD_PUNCH_NA_GROUP
    • Detailed list of reported time rows that need approval: MTL_ RPTD_PUNCH_NA_GRP_DETAIL
  • Punch Time (by Supervisor) that Needs Approval:
    • Detailed list of reported time rows that need approval: MTL_RPTD_PUNCH_NA_SUPVR_DETAIL
  • Punch Time (by TCD) that Needs Approval:
    • Detailed list of reported time rows that need approval: MTL_RPTD_PUNCH_NA_TCD_DETAIL
  • Exception Time:
    • By Group: MTL_EXCEPTION_GROUP
  • Each Punch Time query requires that you specify the DUR (Date Under Report) Begin/End Dates. This enables the queries to retrieve the Reported Time for each date in a specified range. When these queries are run for a current pay period, they do not include Prior Period Adjustments (PPAs). These queries only display PPAs when the input date range includes the report dates of the PPAs.
  • If you click Run to Excel for any of these queries, please note that Excel will translate the punch times into military time. If you want standard time, click Run to HTML. A new page will open with the query results. Click CSV Text File from the Download results in field. You can open the CSV Text File in Excel.
  • The Run an Existing (Public) Query Using Query Viewer - Step-by-Step Procedure, available on My LINC, can be used as a guide for running any public query.

Navigation

NavBar > Navigator > Reporting Tools > Query > Query Viewer


Static Group Queries Description
MTL_ RPTD_PUNCH_EMPL For one employee at a time, this query provides the reported time details for the specified date range.
MTL_RPTD_PUNCH_GRP For all the employees in a Static Group, this query provides the reported time details for the specified date range.
MTL_RPTD_PUNCH_SUPVR For a supervisor, this query provides the reported time details for the supervisor's employees within the specified date range.
MTL_ RPTD_PUNCH_NA_GROUP For a Static Group, this query list the employees who have reported time that needs approval in the specified date range.
MTL_ RPTD_PUNCH_NA_GRP_DETAIL For a Static Group, this query provides the reported time details for the employees with reported time that needs approval.
MTL_ RPTD_PUNCH_NA_TCD_DETAIL For a specific Time Collection Device (TCD) ID, this query provides the reported time details for the employees with reported time that needs approval.
MTL_RPTD_PUNCH_NA_SUPVR_DETAIL For a supervisor, this query provides the reported time details for the employees with reported time that needs approval.
MTL_ RPTD_PUNCH_NA_TCD_DETAIL For a Static Group and a TCD, this query list the employees who have reported time that needs approval in the specified date range.
MTL_ EXCEPTION_GROUP For a Static Group, this query determines if Exception Time (Errors) was created instead of Payable Time.