/
Database view containing calendar field in Employee Job Salary

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