EPM public queries: TAS Legacy

Article
Read time: 6 minutes

This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.

EPM public query names and descriptions for TAS Legacy

  • Accrual Earnings (DOCX) - This query returns an employee’s leave accrual earnings and balances recorded in TAS.
  • Annual Attendance (DOCX) - This query returns time and attendance records for an employee recorded in TAS. The results mimic the Annual Attendance Report.
  • Attendance Accruals (DOCX) - This query returns an employee’s leave accrual earnings along with his or her time and attendance entries recorded in TAS.
  • Available Hours (DOCX) - This query returns employee master profile information including leave accrual balances recorded in TAS.
  • Search by Name (DOCX) - This query is used to determine if an employee has more than one Employee ID recorded in TAS.
  • Search by SSN (DOCX) - This query is used to determine an employee’s Employee ID(s) recorded in TAS.
  • Unique Attendance Records (DOCX) - This query returns unique time and attendance records, eliminating any duplicate rows, for an employee recorded in TAS.
  • War Service (DOCX) - This query returns an employee’s war service entries recorded in TAS.

More resources

EPM Public Queries