Office of the Assistant Secretary for Administration and Management

Program Support Center

Human Resources

October 12, 2007

The following items have been moved (migrated) to Production for use by Agencies beginning on October 12, 2007.

Ticket IM122854A
1. SQL script runs to populate the hire_dt on the CAN rollover rows. The program to insert a CAN rollover row for each employee did not populate the hire_dt therefore a script needs to be run to update this information.
Ticket IM122471
1. Clear out the before and after tax amounts on savings plans when the tsp status code is not Y or W, a tsp action cannot be saved it there are tax amounts in the fields and the code is not Y or W
Ticket IM124167 :
1. This change will remove the access to process PAY034, so that user’s won’t be able to run the process using this navigation Payroll Interface-> Reports-> Presheet Audit.
Ticket IM124871 :
1. Will remove the access to People soft Ping Options under Utilities menu for all of the users. Only administrators in 8.0 used to have access to People soft Ping Option pages ,this change will do the same in 8.9 too, only administrator’s will be able to access People soft ping Option page.
Ticket IM124055
1. Added GVT_WORK_SCHED, GVT_LEG_AUTH_2, GVT_STATUS_TYPE, GVT_PAY_RATE_DETER, AND GVT_POI to HE_QRY_JOB_VW view so they could be reported on in the query HE0069A
Ticket IM124243
1. Modified the criteria used in HE0298 query to include any employee with a pay rate determinant other than ‘0’.

EHRP Public Queries

Name	Purpose	Parameters	Data Provided
HE0069A- Hires/noa- dates bwtn prompt	Indentifies hires between dates entered at prompts and gives noa information for hire row	Effdt from Effdt to Setid Deptid like	Deptid Emplid Name Hire Dt Service Dt Descr GVT OCC Series Grade Step Barg Unit Gvt Tenure Gvt Work Sched Gvt Noa Code He NOA Ext Gvt Pay Plan Gvt Vet Pref Gvt Leg Auth 1 Gvt Leg Auth 2 Gvt Status Type Pay Rate Determinant CAN POI Total Salary Hire Date Effseq
HE0298 – Retained Rate Employees	The query returns all retained rate employees based on pay rate determinant other than ‘0’	Business Unit, Deptid Like	Emplid Rcd Name Deptid Pay Plan Grade Step Base Pay Loc Adjust Total Pay Pay Rate Determinant

Last revised: March 13, 2008