Database view for Position Control Position Change Requests EERP module

Where can you find projected changes from Position Control - Position Change / Requests module in the EERP SQL database that haven't taken place yet?

• EERP
• OnPrem, SaaS Hosted
• Tyler Reporting Services (TRS)
• SSRS
• Crystal Reports
• SQL

To view this module in EERP:

1. In Tyler Menu, navigate to Enterprise ERP >Human Capital Management > Human Resources > Position Control and Budgeting > Position Control
2. In the top ribbon, click Position Change

The database view pr_proj_pos_ctl shows projected changes to positions that are occurring in the future. The official positions can be found in pr_position_ctl.

Values in the a_projection column correspond to what the change is, and description of these values can be found here: Proj codes in payroll tables

Projection number 400 is used for Position Control - Position Change / Requests

Changes in GL account information:

The a_position_code and a_projection can be filtered to find the org and object to tie back to the GL account that would be used in the proposed change:

select

pc_org,

pc_object,

a_project,

 *

from pr_proj_pos_ctl

where a_position_code = 'XXXX' 

and a_projection = 1234

pc_org and pc_object from pr_proj_pos_ctl correspond to a_org and a_object in gl_long_account.