SENIORITY REPORTS

1
SENIORITY REPORTS

• Objective
• Review the types of seniority reports
• Access to IRIS and the Seniority Database
• How to run and print a seniority report
• When to run a seniority report
• and what bargaining units are
• covered by the reports.

2
SENIORITY REPORTS

• Interim Reporting Information System (IRIS)
• Seniority Reports will be produced in IRIS
• Utilizes Microsoft Access as the front end tool
• Use the IRIS Seniority Database
• Users must receive security access (Oracle
• username and password) to run the reports
  
• For Additional information on IRIS and security
  access, go to
• the OA Applications Division web site
  at http//www.hrm.state.pa.us/iris
• For assistance, contact Matt McKenzie, OA
  Applications
• Division

3
SENIORITY REPORTS

• How do I determine which report to run?

For example, if you have employees covered by the
AFSCME agreement, you previously received the
PTA86001 report and now will run the IRIS
Promotion BU Group Days report.
4
SENIORITY REPORTS

• RUN A SENIORITY REPORT
• Determine which report to run.
• Open your Access database.
• Click on the appropriate report icon name.
• To run an agency wide report, just complete the
  personnel area field.
• To run a report by furlough or promotion unit,
  complete the personnel area and furlough or
  promotion unit.
• To run a report by furlough unit and job,
  complete all 3 fields.

5
SENIORITY REPORTS

• When the Enter 2-Digit Business Area Code
  prompt box appears, insert the 2-digit business
  area and click OK.
• For agencies with multiple payroll areas (i.e.,
  Z2 Z3), entering the 2-digit business area will
  ensure that an agency-wide report is generated.

NOTE Always enter the business area so your
report will run faster.
6
SENIORITY REPORTS

• For an agency-wide report, leave the next
  prompt blank and click the OK button.
• For a report reflecting a particular furlough
  unit, enter the furlough unit and click the OK
  button.
• For a promotion seniority report, you will
  enter the promotion unit code as required and
  click the OK button.

7
SENIORITY REPORTS

• To run an agency-wide report, leave the job
  code field blank and just click the OK icon.
• Use this prompt box when you want to run a
  furlough or promotion seniority report for a
  particular job. You can also further define the
  report by running for a particular unit and job.

When using the job code field, input the IPPS
class code in this field (i.e., 00220 for Clerk
Typist 2).
8
SENIORITY REPORTS

• After you have completed all 3 prompt boxes,
  you will receive the Oracle ODBC Driver Connect
  prompt box.
• The Service Name should default to CMIC.
• Complete the User Name which is your 8 digit
  personnel number.
• Then complete the password field. A password
  will be provided by OA when you requested your
  security.
• Then click on the OK button to secure your report.

9
SENIORITY REPORTS

• Once you have completed all prompt boxes, you
  will receive the report.
• Click on the print icon to print the total
  report or use the File drop down menu and select
  print to change the print page option or number
  of copies to be printed.
• To run another report, just close (x) the report
  window and you will be returned to the first
  prompt box.

10
SENIORITY REPORTS

• Report Data Differences
• Emp No is now Pers No
• Emp Con is now Emp Sub
• Grp (i.e., F7)
• Emp Dur is now Emp Grp (i.e., P permanent)
• Typ Svc and Ts St is now Typ Svc (i.e., N,
  CS-Reg, CS-Prob, etc.)
• PAY MTH is no longer available in SAP
• PAY STAT is now PAY ST

11
SENIORITY REPORTS

• When Seniority Data Updates in SAP
• Military days - real time update
• BU Group Date real time update
• BU Group Days update daily based
• on time evaluation
• Job Days updates bi-weekly on the Wednesday cob
  after payday
• NOTE All IRIS data is downloaded from SAP as of
  Friday cob based on the above updates.

12
SENIORITY REPORTS

• Seniority Report Run Schedule

13
SENIORITY REPORTS

• Review
• Acquire IRIS access ASAP (see slide 2)!!!
• Download the IRIS Seniority database
• Determine which reports you need to run based on
  your departments bargaining units
• Determine when you need to run the reports based
  on report type and agency payroll area
• Run your reports, print and distribute/post

14
SENIORITY REPORTS

• For Assistance on data corrections contact
• Agency Labor Relations Department or
• Agency Seniority Coordinator
• OA Bureau of Labor Relations
• Submit an OA Help Desk Ticket
• For Assistance on IRIS contact
• Matt McKenzie, OA, Applications Division