A Person and Position ePAR is a document used to begin or change values on an employee’s job data or position data. The City of Fort Worth expenses payroll by position. The position ePAR document's the authorization from the various business units as to what funding an employee’s salary and benefits are to be charged to. The position ePAR also identifies who each employee reports to for time and labor approvals. The person ePAR document's changes to the employee's pay and/or status changes. HR Records must process these transactions within five business days of receipt from the business unit. This measure is extremely important to ensure that employees pay and funding is correct. Our target is to stay within 95% being completed on time.

Data Source:

Query Name: Z_HR_KPI_EPAR_MATRIX

Click Edit query Z_HR_KPI_EPAR_MATRIX

Click on the Criteria Tab on query to edit the Effective dates.

Run the Query and then Download to Excel and save AS141>KPI Matrix ePAR HIRS

Calculation Formula:

Name: Position ePAR MO YR.xls

Before performing calculations delete the following column: By (P)

Add a blank column (R)

When an ePAR has to be manually processed no date is entered in the “Prcss Dttm” field column “Q”. Place a filter on the “Q” column and identifies the blank fields. Copy and paste the Last “Upd DtTime” from column ”U”

Column V

New Column HRIS Received late (must type the formula into the cell)(column heading “HRIS Received Late”) (format column to Number with no decimal places)

=IF(K2>E2,”YES”,”NO”)

Copy down

Column W

New Column # Days Department late to HRIS (column heading “# Days Between M,Q (Dept Approved & Processed)

=NETWORKDAYS(M2,Q2)

Column X

New Column Days for HRIS to Process (column “#Days HRIS to Process after Budget Approved)

=NETWORKDAYS(N2,Q2)

Column Y

New Column #Days after the effective date

=NETWORKDAYS (K2,M2)

Column Z

New Column # Days Budget to Process after Dept Approved.

=NETWORKDAYS(M2,N2)

Column AA

New column # Days Processed after Effective date

=NETWORKDAYS(K2,E2)

Sort Column W # Days between dept approval and processed

Hide Columns B-V (Columns A and W has to be side by side to complete the next function.

Go to Data and select Subtotal

Select #Days Between Dept Approved & HRIS Processed, count and Request IDs (See screenshot below)

Update Master Log Position EPAR found on AS141> KPI Matrix ePAR HRIS> Master Log Positin ePAR