1 / 22

EDB Updates

EDB Updates. Archie Demarest State of Colorado. Janice Chang Montgomery County. EDB Update . An Alternative method for updating the EDB in a VSAM environment. EDB Update . HR. Payroll. Requirement: System 2 System Real Time . EDB Update . HR Transactions. Key Changes.

chaney
Download Presentation

EDB Updates

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EDB Updates Archie Demarest State of Colorado Janice Chang Montgomery County

  2. EDB Update An Alternative method for updating the EDB in a VSAM environment

  3. EDB Update HR Payroll • Requirement: • System 2 System • Real Time

  4. EDB Update HR Transactions Key Changes Updated EDB Evaluation, Edit and Transformation UPD0LL Reformat and Update CICS

  5. EDB Update EDB Update Transactions Updated EDB Evaluation, Edit, and Transformation Reformat and Update Batch UPD0LL (Converted for Batch)

  6. EDB Update Alternatives to X2 transactions in the DB2 Environment

  7. HRMS Forms Package This is the Integral Forms manual available on OnBoard. It lists the hundreds of cards available for batch input.

  8. Example Form - Personal Data The forms depict both a printed format for use in data entry as well as the batch card layout.

  9. Example Batch Card Key Fields Data Fields Personal Data

  10. Data Element table Personal Data (F5)

  11. Data Element table Personal Data (F5) • TABLE KEY DATA • 0256F5 ADDL SSN/SIN • 0257F5 ACTUAL MRT STAT • 0261F5 BLOOD TYPE • 0273F5 SSN/SIN • 0274F5 SEX • 0275F5 DATE OF BIRTH • 0276F5 ETHNICITY • 0277F5 HANDICAP • 0281F5 EDUCATION LEVEL • 0282F5 EDUC LEVEL YEAR • 0283F5 MILITARY STATUS • 0284F5 DEF COMP CTCHUP • 0501F7 ALT ADDR STREET

  12. Data Element Definition Add your own data elements to a batch card specifying start and end position on the card, edit pattern and historical significance.

  13. EDB Update Programs

  14. Create Audit File Montgomery County created an electronic audit file for feedback to the sending system. It can be used by the sending system to audit the results of their updates.

  15. Example Audit File ********************************************************** EMPLID ;STATUS ;REASON ;TP;RUNDATE 111-11-1111;SUCCESSFUL; ; ;07/01/2008 000-11-1111;SUCCESSFUL; ; ;07/01/2008 222-11-1234;SUCCESSFUL; ; ;07/01/2008 333-11-1111;SUCCESSFUL; ; ;07/01/2008 444-11-1111;SUCCESSFUL; ; ;07/01/2008 111-22-2222;SUCCESSFUL; ; ;07/01/2008 000-22-3333;SUCCESSFUL; ; ;07/01/2008 **********************************************************

  16. Cards for EPAF

  17. New Hire 17 different card types are used instead of 61 X2 transactions to create the following segments and screens for a new hire: Segment 01 – EDB_BAS – screen 3 (Personnel Action data) Segment 02 – EDB_PER – screen 5 (Personnel Data Form) Segment 03 – EDB_PAY – screen 7, 8 (Payroll & Tax Data) Segment 10 – EDB_PEN – screen 10 (Pension Plan data) Segment 20 – EDB_JOB, & EDB_ACT screen 4 (Job Assignment data) Segment 36 – EDB_LAB – screen 9 & 16 (Job Performance data & Labor Relations) Segment 70 – EDB_JHS – Job history

  18. EDB Load An Alternative method for Reloading the VSAM EDB

  19. EDB Load PP1400XX PP1400XX - Old EDB NXE SXE

  20. EDB Load • PP1400XX Modification: • Remove “Write” actions for VSAM file updates • Replace with “Write” actions for PS File updates • Add IDCAMS utilities after successful completion of PP1400XX • Eliminates splits and increased processing for the NXE and the SXE • Cleaner Files • Faster Execution

  21. EDB Load EDB EDB PP1400XX IDCAMS IDCAMS IDCAMS NXE NXE SXE SXE PP1400XX - New

  22. Questions

More Related