Build SSN Information File for Health and Welfare - 3105

Purpose: Creates SSN file for Health & Welfare.

 
FREQUENCY:Nightly
CREATED IN:AU443135
USERS:Health & Welfare
 
 
FILE LAYOUT
 
DSN=HWB.S44.AU443105.SSNINFO
      
THE SAME RECORD CAN BE REPEATED UP TO 5 TIMES.    
RECORD SIZE = 180 BYTES       
 
FIELD NAME
COLUMN BEGIN
LENGTH
SSN
(A09) 
(1-9)
PIPE-1
(A01) Value='|'
(10)
CSS-HRS
(A10) format = 9999999.99
(11-20) 
PIPE-2
(A01) Value='|'
(21)
VAC-LV-BAL-HRS
(A08) format=99999.99
(22-29)
PIPE-3
(A01) Value='|'
(30)
SICK-LV-BAL-HRS
(A08) format=99999.99
(31-38)
PIPE-4
(A01) Value='|'
(39)
TERM-RSN-CD
(A02) this field is no longer reported 10-24-2012
(40-41)
PIPE-5
(A01) Value='|'
(42)
TERMINATION-DATE
(A09) format= CCYYMMDD (FYI:date does have a leading zero) this field is no longer reported 10-24-2012
(43-51)
PIPE-6
(A01) Value='|'
(52)
ALIAS-EFF-DATE
(A08) format=CCYYMMDD
(53-60)
PIPE-7
(A01) Value='|'
(61)
ALIAS-LAST-NAME
(A22)
(62-83)
PIPE-8
(A01) Value='|'
(84)
ALIAS-FIRST-NAME
(A14)
(85-98)
PIPE-9
(A01) Value='|'
(99)
ALIAS-MIDDLE-NAME
(A14)
(100-113)
PIPE-10
(A01) Value='|'
(114)
TERM-AGENCY
(A03)
(115-117)
PIPE-11
(A01) Value='|'
(118)
TERM-PAY-GROUP
(A02)
(119-120)
PIPE-12
(A01) Value='|'
(121)
AGY-TERM-RSN-CD
(A02)
(122-123)
PIPE-13
(A01) Value='|'
(124)
AGY-TERM-DATE
(A08)  format=CCYYMMDD
(125-132)
PIPE-14
(A01)  Value='|'
(133)
AGY-CSS-HRS
(A10)  format 9999999.99
(134-143)
PIPE-15
(A01) Value='|'
(144)
AGY-LAST-PAID-DATE
(A08)  format=CCYYMMDD
(145-152)
PIPE-16
(A01) Value='|'
(153)
AGY-8MO-TEMP-DATE
(A08) format=CCYYMMDD
(154-161)
PIPE-17
(A01) Value='|'
(162)
PRIOR-SSN
(A09) format=999999999
(163-171)
PIPE-18
(A01) Value='|'
(172)
SSN-CHANGE-DATE
(A08)  format=CCYYMMDD
(173-180)