Database view containing user defined fields in position control

Owned by Knowledge Assistant
Dec 28, 2023
1 min read
Description of Issue

Need database view containing user defined fields in position control to build a custom report

Context

  • EERP(Munis)

  • Position Control

  • Tyler Reporting Services Views

  • SSRS Reports

Cause

View database column overlay only displays the base table names and not the corresponding TRS views

Resolution

To view Position control user defined fields in EERP, follow the steps below:

  1. Navigate to EERP Menu > Human Capital Management > Human Resources > Position Control and Budgeting > Position Control

  2. Search for any position code and click on tab USER DEFINED FIELDS to view data for available user defined fields

This information is available through TRS view pr_position_user_def.

Additional Information