Core-CT EPM Hot Topics
Date: 4/30/2015
Changes to Position Reporting Table Query Impacts
The following Salary Grade fields have been removed from the HR EPM Position
Reporting Table (CTW_POSITION).
MIN_RT_ANNUAL - Minimum Pay Rate-Annual
MID_RT_ANNUAL - Midpoint Pay Rate-Annual MAX_RT_ANNUAL - Maximum Pay
Rate-Annual and CT_SALGRADE_DESCR - Salary Grade Description
These fields are more accurately populated when related to job data. The
table CTW_SAL_GRADE can be joined to CTW_EMPLOYEE(VW) by the following fields:
SAL_ADMIN_PLAN = SAL_ADMIN_PLAN
SAL_GRADE = SAL_GRADE
SETID = SETID_DEPT
Impacts to Users: Queries that use impacted fields will need to be opened and
saved prior to running. When opening an existing query using an impacted record
the following pop-up error message comes up:
‘One or more records used in this query have changed. The query has be
adjusted to reflect this. (50,370(0,0)'
All impacted CORE-CT public queries have been saved and are ready to run.
Any questions or concerns, please log an EPM Footprints Ticket.
Thank you for your cooperation.
Return to Core-CT EPM Hot Topics Home Page
|