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.