EDB Updates

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

• Requirement
• System 2 System
• Real Time

4
EDB Update
CICS
5
EDB 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
TPRUNDATE 111-11-1111SUCCESSFUL
07/01/2008
000-11-1111SUCCESSFUL 07/01/2008
222-11-1234SUCCESSFUL
07/01/2008 333-11-1111SUCCESSFUL
07/01/2008 444-11-1111SUCCESS
FUL 07/01/2008
111-22-2222SUCCESSFUL 07/01/2008
000-22-3333SUCCESSFUL
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 - 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
PP1400XX - New
22
Questions