Copyright 2001 Keane Care, Inc. All Rights Reserved. ******************************************** APRDATxx - Payroll Employee Information File Revision: 283.1 Date: 19 Nov 2001 16:15:06 ******************************************** ************************************** * HEADER-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRDATHUU DIM 78 1-78 Undefined PRDATHVR DIM 1 79-79 Version number ************************************** * 1-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type PRD1STAT DIM 1 6-6 Active (Numeric 1 thru 4) No Pay Due (Numeric 5 thru 8) Inactive (Capital Letters) Terminated (Lower Case Letters a-d) Delete Term (Lower Case Letters e-h) Single Married A I T N D A I T N D Hourly 1,A,a,5,e 2,B,b,6,f Salaried 3,C,c,7,G 4,D,d,8,h PRD1DEPT DIM 7 7-13 Permanent Department PRD1NAME DIM 25 14-38 "Last Name","First Name" "MIddle Name" PRD1PRTC DIM 1 39-39 Reg Vac Excess* 0 U =Unrestricted, Not Locked 1 V =Unrestricted, Locked 2 W =Restricted, Not Locked +0 3 X =Restricted, Not Locked +1 4 Y =Restricted, Not Locked +2 5 Z =Restricted, Locked (* Vac Excess = Vacation Pay Caused Pay to Exceed Normal Last Pay Period) ** EXEMPTIONS DECLARED PRD1FDWH DIM 2 40-41 Federal Withholding Exemptions PRD1STWH DIM 2 42-43 State Withholding Exemptions PRD1INWH DIM 3 44-46 1ST Byte SDI: Blank = taxed N = non taxed X = exempt 2ND Byte FICA: same as SDI ** GROSS PAY ACCUMULATORS PRD1GRYR FORM 7.2 47-56 YTD Gross Pay PRD1GRQR FORM 7.2 57-66 QTD Gross Pay ** FEDERAL WITHOLDING PRD1FDY FORM 7.2 67-76 YTD Federal Income Tax W/H PRD1FDQ FORM 7.2 77-86 QTD Federal Income Tax W/H PRD1FCY FORM 5.2 87-94 YTD FICA Tax W/H PRD1FCQ FORM 5.2 95-102 QTD FICA Tax W/H PRD1FUXY FORM 6.2 103-111 YTD FUI Exempt PRD1FUXQ FORM 6.2 112-120 QTD FUI Exempt ** STATE W/H INC & IND INS TAX PRD1STD DIM 2 121-122 State Name or Abbreviation Number PRD1STY FORM 6.2 123-131 YTD State Income Tax W/H PRD1STQ FORM 6.2 132-140 QTD State Income Tax W/H PRD1USED DIM 2 141-142 City/User Name or Number Abbreviation PRD1USEY FORM 6.2 143-151 YTD SDI or User Witholding PRD1USEQ FORM 6.2 152-160 QTD SDI or User Witholding PRD1SUXY FORM 6.2 161-169 YTD SUI Exempt Field PRD1SUXQ FORM 6.2 170-178 QTD SUI Exempt Field PRD1WKHR FORM 4 179-182 Weeks or Hours Worked PRD1USWY FORM 6.2 183-191 YTD User Defined Tax Witheld PRD1USWQ FORM 6.2 192-200 QTD User Defined Tax Witheld PRD1F2NW DIM 1 201-201 FICA-2, No Witholding=Taxed N=Not Taxed X=Exempt PRD1F2WQ FORM 5.2 202-209 FICA-2, Witheld, QTD ACCUM'R PRD1F2WY FORM 5.2 210-217 FICA-2, Witheld, YTD ACCUM'R PRD1F2XQ FORM 5.2 218-225 FICA-2, Exempt, QTD ACCUM'R PRD1F2XY FORM 5.2 226-233 FICA-2, Exempt, YTD ACCUM'R PRD1_ERR DIM 2 234-235 Unused ************************************** * 2-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type ** PAYRATES PRD2RATE FORM 8 6-13 HRLY= $9999.9999 SAL=$999999.99 MTHLY PRD2OTNH FORM 8 14-21 HRLY= $9999.9999 Overtime Rate Salary 999.9 Normal Hours PRD2FDAD FORM 3 22-24 Additional Federal Witholding PRD2STAD FORM 3 25-27 Additional State Witholding ** USER FLEXIBLE ACCUMULATOR FIELDS PRD2USFA FORM 6.2 28-36 999999.99 User Felxible Field PRD2USFB FORM 6.2 37-45 999999.99 User Felxible Field PRD2USFC FORM 6.2 46-54 999999.99 User Felxible Field PRD2USFD FORM 6.2 55-63 999999.99 User Felxible Field PRD2USFE FORM 6.2 64-72 999999.99 User Felxible Field PRD2USFF FORM 6.2 73-81 999999.99 User Felxible Field PRD2USFG FORM 6.2 82-90 999999.99 User Felxible Field PRD2USFH FORM 6.2 91-99 999999.99 User Felxible Field PRD2USFI FORM 6.2 100-108 999999.99 User Felxible Field PRD2USFJ FORM 6.2 109-117 999999.99 User Felxible Field PRD2PMHR FORM 6.2 118-126 Permanent Hours prd2dl49 form 6.2 127-135 999999.99 User Felxible Field prd2dl50 form 6.2 136-144 999999.99 User Felxible Field prd2dl51 form 6.2 145-153 999999.99 User Felxible Field prd2dl52 form 6.2 154-162 999999.99 User Felxible Field prd2dl53 form 6.2 163-171 999999.99 User Felxible Field prd2dl54 form 6.2 172-180 999999.99 User Felxible Field prd2dl55 form 6.2 181-189 999999.99 User Felxible Field prd2dl56 form 6.2 190-198 999999.99 User Felxible Field prd2dl57 form 6.2 199-207 999999.99 User Felxible Field prd2dl58 form 6.2 208-216 999999.99 User Felxible Field prd2dl59 form 6.2 217-225 999999.99 User Felxible Field prd2dl60 form 6.2 226-234 999999.99 User Felxible Field prd2dl61 form 6.2 235-243 999999.99 User Felxible Field prd2dl62 form 6.2 244-252 999999.99 User Felxible Field prd2dl63 form 6.2 253-261 999999.99 User Felxible Field prd2dl64 form 6.2 262-270 999999.99 User Felxible Field prd2dl65 form 6.2 271-279 999999.99 User Felxible Field prd2dl66 form 6.2 280-288 999999.99 User Felxible Field prd2dl67 form 6.2 289-297 999999.99 User Felxible Field prd2dl68 form 6.2 298-306 999999.99 User Felxible Field prd2dl69 form 6.2 307-315 999999.99 User Felxible Field prd2dl70 form 6.2 316-324 999999.99 User Felxible Field prd2dl71 form 6.2 325-333 999999.99 User Felxible Field prd2dl72 form 6.2 334-342 999999.99 User Felxible Field prd2dl73 form 6.2 343-351 999999.99 User Felxible Field prd2dl74 form 6.2 352-360 999999.99 User Felxible Field prd2dl75 form 6.2 361-369 999999.99 User Felxible Field prd2dl76 form 6.2 370-378 999999.99 User Felxible Field prd2dl77 form 6.2 379-387 999999.99 User Felxible Field prd2dl78 form 6.2 388-396 999999.99 User Felxible Field prd2dl79 form 6.2 397-405 999999.99 User Felxible Field prd2dl80 form 6.2 406-414 999999.99 User Felxible Field prd2dl81 form 6.2 415-423 999999.99 User Felxible Field prd2dl82 form 6.2 424-432 999999.99 User Felxible Field prd2dl83 form 6.2 433-441 999999.99 User Felxible Field prd2dl84 form 6.2 442-450 999999.99 User Felxible Field prd2dl85 form 6.2 451-459 999999.99 User Felxible Field prd2dl86 form 6.2 460-468 999999.99 User Felxible Field prd2dl87 form 6.2 469-477 999999.99 User Felxible Field prd2dl88 form 6.2 478-486 999999.99 User Felxible Field prd2dl89 form 6.2 487-495 999999.99 User Felxible Field prd2dl90 form 6.2 496-504 999999.99 User Felxible Field prd2dl91 form 6.2 505-513 999999.99 User Felxible Field prd2dl92 form 6.2 514-522 999999.99 User Felxible Field prd2dl93 form 6.2 523-531 999999.99 User Felxible Field prd2dl94 form 6.2 532-540 999999.99 User Felxible Field prd2dl95 form 6.2 541-549 999999.99 User Felxible Field prd2dl96 form 6.2 550-558 999999.99 User Felxible Field prd2dl97 form 6.2 559-567 999999.99 User Felxible Field prd2dl98 form 6.2 568-576 999999.99 User Felxible Field prd2dl99 form 6.2 577-585 999999.99 User Felxible Field ************************************** * 3-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type ** TAX EXEMPT FINANCIAL FIELDS PRD3FEDY FORM 7.2 6-15 YTD Exempt FED $9999999.99 PRD3FEDQ FORM 7.2 16-25 QTD Exempt FED $9999999.99 PRD3FICY FORM 7.2 26-35 YTD Exempt FICA $9999999.99 PRD3FICQ FORM 7.2 36-45 QTD Exempt FICA $9999999.99 PRD3STTY FORM 7.2 46-55 YTD Exempt State $9999999.99 PRD3STTQ FORM 7.2 56-65 QTD Exempt State $9999999.99 PRD3SDIY FORM 7.2 66-75 YTD Exempt SDI $9999999.99 PRD3SDIQ FORM 7.2 76-85 QTD Exempt SDI $9999999.99 PRD3XUSY FORM 7.2 86-95 YTD Exempt User $9999999.99 PRD3XUSQ FORM 7.2 96-105 QTD Exempt User $9999999.99 ************************************** * 4-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type ** LOCAL TAX FIELDS PRD4LC1D DIM 2 6-7 Local Tax #1 Description PRD4L1WH DIM 2 8-9 Local Tax #1 Witholding Exemptions PRD4L1AD FORM 3 10-12 $999 Additional Local #1 Witholding PRD4LC1Y FORM 6.2 13-21 $999999.99 YTD Local Inc Tax W/H #1 PRD4LC1Q FORM 6.2 22-30 $999999.99 QTD Local Inc Tax W/H #1 PRD4LE1Y FORM 7.2 31-40 $9999999.99 YTD Exempt Local #1 PRD4LE1Q FORM 7.2 41-50 $9999999.99 QTD Exempt Local #1 PRD4LC2D DIM 2 51-52 Local Tax #2 Description PRD4L2WH DIM 2 53-54 Local Tax #2 Witholding Exemptions PRD4L2AD FORM 3 55-57 $999 Additional Local #2 Witholding PRD4LC2Y FORM 6.2 58-66 $999999.99 YTD Local Inc Tax W/H #2 PRD4LC2Q FORM 6.2 67-75 $999999.99 QTD Local Inc Tax W/H #2 PRD4LE2Y FORM 7.2 76-85 $9999999.99 YTD Exempt Local #2 PRD4LE2Q FORM 7.2 86-95 $9999999.99 QTD Exempt Local #2 ************************************** * 6-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type ** EMPLOYEE BENEFIT DATA ** BENEFIT NBR 1 PRD6COD1 DIM 2 6-7 Ident for Bene #1 in the Facility File PRD6PHR1 FORM 5.2 8-15 Permanent Hours Accumulated PRD61ST1 DIM 9 16-24 Date or Hours Since Last Transfer - Dual Field PRD6EDT1 DIM 8 25-32 Bene Effective Date - Annual (ccyymmdd) PRD6ACB1 FORM 4.4 33-41 Accrued Bal Frwd After Last Pay Period PRD6ACN1 FORM 4.4 42-50 *See New Balances Explanation Follwing PRD6AVB1 FORM 4.4 51-59 Avail Bal Frwd After Last Pay Period PRD6AVN1 FORM 4.4 60-68 *See New Balances Explanation Follwing PRD6USD1 FORM 4.2 69-75 Used Since Last Bebe Effective Date PRD6PRO1 DIM 1 76-76 Still Within Probation? (Y/N) ** BENEFIT NBR 2. PRD6COD2 DIM 2 77-78 Ident for Bene #2 in the Facility File PRD6PHR2 FORM 5.2 79-86 Permanent Hours Accumulated prd6lst2 dim 9 87-95 Date or Hours Since Last Transfer - Dual Field prd6edt2 dim 8 96-103 Bene Effective Date - Annual (ccyymmdd) PRD6ACB2 FORM 4.4 104-112 Accrued Bal Frwd After Last Pay Period PRD6ACN2 FORM 4.4 113-121 *See New Balances Explanation Follwing PRD6AVB2 FORM 4.4 122-130 Avail Bal Frwd After Last Pay Period PRD6AVN2 FORM 4.4 131-139 *See New Balances Explanation Follwing PRD6USD2 FORM 4.2 140-146 Used Since Last Bebe Effective Date PRD6PRO2 DIM 1 147-147 Still Within Probation? (Y/N) ** BENEFIT NBR 3. PRD6COD3 DIM 2 148-149 Ident for Bene #3 in the Facility File PRD6PHR3 FORM 5.2 150-157 Permanent Hours Accumulated prd6lst3 dim 9 158-166 Date or Hours Since Last Transfer - Dual Field prd6edt3 dim 8 167-174 Bene Effective Date - Annual (ccyymmdd) PRD6ACB3 FORM 4.4 175-183 Accrued Bal Frwd After Last Pay Period PRD6ACN3 FORM 4.4 184-192 *See New Balances Explanation Follwing PRD6AVB3 FORM 4.4 193-201 Avail Bal Frwd After Last Pay Period PRD6AVN3 FORM 4.4 202-210 *See New Balances Explanation Follwing PRD6USD3 FORM 4.2 211-217 Used Since Last Bebe Effective Date PRD6PRO3 DIM 1 218-218 Still Within Probation? (Y/N) ** BENEFIT NBR 4. PRD6COD4 DIM 2 219-220 Ident for Bene #4 in the Facility File PRD6PHR4 FORM 5.2 221-228 Permanent Hours Accumulated prd6lst4 dim 9 229-237 Date or Hours Since Last Transfer - Dual Field prd6edt4 dim 8 238-245 Bene Effective Date - Annual (ccyymmdd) PRD6ACB4 FORM 4.4 246-254 Accrued Bal Frwd After Last Pay Period PRD6ACN4 FORM 4.4 255-263 *See New Balances Explanation Follwing PRD6AVB4 FORM 4.4 264-272 Avail Bal Frwd After Last Pay Period PRD6AVN4 FORM 4.4 273-281 *See New Balances Explanation Follwing PRD6USD4 FORM 4.2 282-288 Used Since Last Bebe Effective Date PRD6PRO4 DIM 1 289-289 Still Within Probation? (Y/N) . ACCRUED & AVAILABLE NEW BALANCES: . PERFORM A DOUBLE PURPOSE. . WHEN THE COVER SHEET PROGRAM IS RUN, IF ANY VALUES ARE FOUND THEY ARE . ADJUSTMENTS. THEY REMAIN DEFINED AS ADJUSTMENTS UNTIL THE BENEFITS CAL- . CULATION AND UPDATE PROGRAM IS RUN. AT THAT TIME, THE ADJUSTMENTS ARE . WRITTEN TO THE BENEFIT REPORT TRANSACTIONS FILE AND THE NEW BALANCES . ARE INSERTED. NEW BALANCES WILL STAY UNTIL THE START NEW PERIOD PRO- . GRAM IS RUN. THEN THEY ARE MOVED TO PRD6AxBn AND SET TO 0. ************************************** * 8-RECORD * ************************************** Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type ** Direct Deposit information PRD8DDEP DIM 1 6-6 Direct Deposit acitve: Y = Yes N = No P = Pre-notification PRD8TYPE DIM 1 7-7 Account type: C = Checking account deposit S = Savings account deposit PRD8BNKN DIM 9 8-16 Bank routing number PRD8ACCT DIM 17 17-33 Employee bank account number ** Misc. information PRD8PPLN DIM 1 34-34 Pension Plan (Y/N) PRD8DCMP DIM 1 35-35 Deferred Compensation (Y/N) PRD8DAMT FORM 5.2 36-43 Deferred Compensation amount ** Timeclock information PRD8USTC DIM 1 44-44 Y=Employee uses timeclock PRD8TCTP DIM 1 45-45 B=Badge reader, C=Card reader PRD8CLAS DIM 15 46-60 Class name PRD8RSNM DIM 15 61-75 Restriction name PRD8CLOK DIM 15 76-90 Home clock name PRD8BADG DIM 9 91-99 Badge number ** W2 Update PRD8EICA DIM 8 100-107 EIC Amount (nnnnn.nn) PRD8XIPR DIM 8 108-115 Excess Insurance Premium (nnnnn.nn) PRD8FBEN DIM 8 116-123 Fringe Benefits (nnnnn.nn) PRD8AWWK DIM 10 124-133 Average Work Week Description PRD8NDMS DIM 10 134-143 # of Dependents/Marital Status PRD8$LYR DIM 10 144-153 Dollars Last Year PRD8UNST DIM 10 154-163 Unstatus (?) PRD8MISC DIM 10 164-173 Miscellaneous Information PRD8TELE DIM 15 174-188 Telephone Number PRD8LICN DIM 15 189-203 License Number PRD8ALIC DIM 15 204-218 Automobile License Number PRD8EMER DIM 15 219-233 Emergency PRD8ETEL DIM 15 234-248 Emergency Telephone Number PRD8DCBA DIM 8 249-256 Dependent Care Benefit Amount (nnnnn.nn) PRD8Y457 DIM 9 257-265 NQP - 'Y'es sec. 457 (PR1998) (nnnnnn.nn) PRD8N457 DIM 9 266-274 NQP - 'N'on sec. 457 (PR1998) (nnnnnn.nn) PRD8FILL DIM 29 275-303 Filler PRD8IT3P DIM 8 275-282 3rd Party Sick Pay PRD8IT3X DIM 8 283-290 3rd Party Sick Pay FIT W/H PRD8FILL DIM 13 291-303 Filler PRD8MVEX DIM 8 291-298 Moving Expenses PRD8FILL DIM 5 299-303 Filler ************************************** * A,W-RECORD * ************************************** ** 'A - W' RECORD - ACTIVE EMPLOYEES PAYROLL PERIOD INPUT Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type (A) PRDAACCT DIM 7 6-12 Account Charged for Wages PRDARATE FORM 3.4 13-20 $xxx.xxxx Rare of Pay PRDAHRRG FORM 3.2 21-26 xxx.xx Hours Regular PRDAHROT FORM 3.2 27-32 xxx.xx Hours Overtime PRDAHRVA FORM 3.2 33-36 xxx.xx Hours Vacation PRDAHRHL FORM 3.2 39-44 xxx.xx Hours Holiday PRDAHRSL FORM 3.2 45-50 xxx.xx Hours Sick Leave PRDAHRU1 FORM 3.2 51-56 xxx.xx Hours User 1 PRDAHRU2 FORM 3.2 57-62 xxx.xx Hours User 2 PRDAHRU3 FORM 3.2 63-68 xxx.xx Hours User 3 ************************************** * X-RECORD * ************************************** ** 'X' - ACTIVE EMPLOYEES PAYROLL PERIOD MISC PAYMENTS & DEDUCTIONS Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type (X) PRDX1AMT FORM 5.2 6-13 Amount to Included in Check(+) PRDX2AMT FORM 5.2 14-21 Amount to Included in Check(+) PRDX3AMT FORM 5.2 22-29 Amount to Included in Check(+) PRDX4AMT FORM 5.2 30-37 Amount to Included in Check(-) PRDX5AMT FORM 5.2 38-45 Amount to Included in Check(-) PRDX6AMT FORM 5.2 46-53 Amount to Included in Check(-) PRDX7AMT FORM 5.2 54-61 Amount to Included in Check(-) PRDX8AMT FORM 5.2 62-69 Not Used ************************************** * Y-RECORD * ************************************** ** 'Y' - ACTIVE EMPLOYEES PAYROLL PERIOD MISC PAYMENTS & DEDUCTIONS Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type (Y) PRDY1ACC FORM 7 6-12 Account Charged for Misc Pay & Rec PRDY1AMT FORM 5.2 13-20 Amount to Included in Check(+) PRDY2ACC FORM 7 21-27 Account Charged for Misc Pay & Rec PRDY2AMT FORM 5.2 28-35 Amount to Included in Check(+) PRDY3ACC FORM 7 36-42 Account Charged for Misc Pay & Rec PRDY3AMT FORM 5.2 43-50 Amount to Included in Check(+) PRDY4ACC FORM 7 51-57 Account Charged for Misc Pay & Rec PRDY4AMT FORM 5.2 58-65 Amount to Included in Check(+) ************************************** * Z-RECORD * ************************************** ** 'Z' - ACTIVE EMPLOYEES PAYROLL PERIOD MISC PAYMENTS & DEDUCTIONS Field Size Bytes Description ----- ---- ----- ----------- PRD1NUMB DIM 4 1-4 Individual Employee Number PRD1RECN DIM 1 5-5 Record Type (Z) PRDZ1ACC FORM 7 6-12 Account Charged for Misc Pay & Rec PRDZ1AMT FORM 5.2 13-20 Amount to Included in Check(-) PRDZ2ACC FORM 7 21-27 Account Charged for Misc Pay & Rec PRDZ2AMT FORM 5.2 28-35 Amount to Included in Check(-) PRDZ3ACC FORM 7 36-42 Account Charged for Misc Pay & Rec PRDZ3AMT FORM 5.2 43-50 Amount to Included in Check(-) PRDZ4ACC FORM 7 51-57 Account Charged for Misc Pay & Rec PRDZ4AMT FORM 5.2 58-65 Amount to Included in Check(-)