Database view containing calendar field in Employee Job Salary

Description of Issue

User needs TRS view that contains the calendar field in Employee/Job Salary

Context
  • Enterprise ERP all versions

  • SSRS Reports

  • Tyler Reporting Services Views

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Employee Job/Salary

Cause

User needs TRS view for building custom reports

Resolution

To view this flag in Enterprise ERP, follow the steps below:

  1. Navigate to EERP menu > Human Capital Management > Human Resources > Employee Job/Pay Classification > Employee Job/Salary

  2. Click on CYCLES/OTHER tab to view Calendar field.

This calendar field is available in TRS view pr_job_pay under column s_calendar_code

Additional Information

Â