Biweekly Leave Balance Download File for Requesting Agencies-FileXXX4941

Purpose:  Generates a biweekly leave balance download file for agencies to use internally.
 
File: XXX.S44.AU444941.LEAVEBAL

 
FREQUENCY:Biweekly
CREATED IN JOB(S):AU444941
 
                       
Files are currently being created for:
 
CRA.S44.AU444941.LEAVEBAL
DEQ.S44.AU444941.LEAVEBAL
HWB.S44.AU444941.LEAVEBAL
JCD.S44.AU444941.LEAVEBAL
TXA.S44.AU444941.LEAVEBAL
 
Agency Leave Balance File Layout: 
All hours and amount fields have a decimal point.  All amounts and hours are considered to be positive numbers.  Balances cannot go below zero, thus the dollar value of the balances cannot be less than zero.  Year to date taken hours likewise should not be less than zero.
 
 FIELD NAMECOLUMN BEGINLENGTH/DESCRIPTION
AGENCY1(N03)
PAY GROUP4(N02)
PAY LOCATION6(A/N-04)
SSN10(N09
EMPLOYEE NAME19(A50)
PAYROLL NUMBER69(N05)
PAYROLL END DATE74(N08)  YYYYMMDD
POSITION82(N04)
PAY STATUS86(A01)
LEAVE CODE87(A02)
FLSA89(A01)
PAY BASIS90(A01)
PAY RATE917.1
AGENCY CSS HRS1017.1
STATEWIDE CSS HRS1107.1
AGY YTD SICK HRS TAKEN1197.1
SICK BALANCE1287.1
SICK BALANCE DOLLAR VALUE1379.2
AGENCY YTD VAC HRS TAKEN1497.1
VACATION BALANCE1587.1
VACATION BALANCE DOLLAR VALUE1679.2
AGENCY YTD CURRENT COV  COMP HRS TAKEN1797.1
CURRENT COV COMP BALANCE1887.1
CURRENT COV COMP BALANCE DOLLAR VALUE1979.2
AGENCY YTD RHH HRS TAKEN2097.1
RHH BALANCE2187.1
RHH BALANCE DOLLAR VALUE2279.2
AGENCY YTD PREV 6 MO COV COMP HRS TAKEN2397.1
PREV 6 MO COV COMP BALANCE2487.1
PREV 6 MO COV COMP BALANCE DOLLAR VALUE2579.2
AGENCY YTD MILITARY HRS TAKEN2697.1
MILITARY BALANCE2787.1
MILITARY BALANCE DOLLAR VALUE2879.2
AGENCY YTD ON CALL HRS TAKEN2997.1
ON CALL BALANCE3087.1
ON CALL BALANCE DOLLAR VALUE3179.2
AGENCY YTD EXEMPT COMP HRS TAKEN3297.1
EXEMPT COMP BALANCE3387.1
EXEMPT COMP BALANCE DOLLAR VALUE3479.2
FILLER (BLANK)359(A41)