Payroll FAQ
Open as: PDF or Word Document
Data Dictionary
Table of Contents
PR$PST : HOLDS TEMP NAMES FOR INCOMPLETE POSTING
PRAPLK : ACCOUNTS PAYABLE LINK FILE
PRDEDU : EMPLOYEE DEDUCTIONS FILE
PRDIST : GENERAL LEDGER DISTRIBUTION FILE
PREACC : EMPLOYEE ACCOUNTS FILE
PRSTDD : STANDARD DEDUCTION FILE
PRTAXS : TAX FILE (FWT,SWT,FICA,...)
PRX2AP : TRANSFER TO A/P FILE (APMAST)
PRX2GL : TRANSFER TO G/L FILE (GLTRAX)
PR$PST : HOLDS TEMP NAMES FOR INCOMPLETE POSTING No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TEMP_NAME C 8 0 TEMP_FILE UNCOMPLETED POSTING ARE IN 2 H_DELFLAG C 1 0 '*' IF RECORD WAS DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 2 FIELDS = 9 PRAPLK : ACCOUNTS PAYABLE LINK FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 A_VENDNO C 9 0 A/P VENDOR NUMBER 2 A_INVNO C 12 0 A/P INVOICE NUMBER 3 A_ACCT C 25 0 G/L ACCOUNT 4 A_AMOUNT N 11 2 AMOUNT TO POST TO A/P 5 A_DATE D 8 0 CHECK DATE BECOMES AP->PURDATE, DUEDATE 6 A_BATCH C 3 0 7 A_POSTED C 1 0 "Y" = POSTED TO A/P 8 A_NETSTAMP N 2 0 NETWORK SIGNATURE 9 A_DELFLAG C 1 0 "*"=RE-USABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 9 FIELDS = 72 Related Indexes PRAPLK : A_DELFLAG+A_VENDNO+DTOS(A_DATE)+A_POSTED+A_ACCT PRCHCK : CHECK FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRCHECK C 8 0 CHECK NUMBER 2 PRSEQNO C 5 0 POSTING SEQUENCE NUMBER 3 PREMPL C 9 0 EMPLOYEE NUMBER (ALIGNMENT= "{ALIGNMT}") 4 PRDATE D 8 0 CHECK DATE 5 PREND D 8 0 END DATE OF PAY PERIOD POSTED 6 PRDAYS N 3 0 NUMBER OF DAYS WORKED IN PAY PERIOD 7 PRGROSS N 9 2 GROSS INCOME (TAXABLE+NONTAXABLE) 8 C_CONTRACT N 9 2 AMOUNT OF GROSS THAT WAS CONTRACT 9 PRGTW N 9 2 GROSS TAXABLE WAGES 10 PRGSW N 9 2 GROSS STATE WAGES 11 PRGFW N 9 2 GROSS FICA WAGES 12 PRGMW N 9 2 GROSS MEDI WAGES 13 PRFWT N 9 2 FEDERAL WITHHELD 14 PRTXFR N 9 2 TAXABLE FRINGES 15 C_FRINGE N 9 2 TOTAL FRINGES (INCLUDES NONTAXABLE) 16 C_REIMB N 9 2 TOTAL REIMBURSEMENTS 17 PRNET N 9 2 AMOUNT OF CHECK 18 PRFICA N 9 2 FICA WITHHELD 19 PRMEDI N 9 2 MEDI WITHHELD 20 PRSWT N 9 2 STATE WITHHELD 21 PRSDI N 9 2 STATE DISAB. WITHHELD 22 PRLOC N 9 2 LOCAL TAXES WITHHELD 23 PRFUTA N 9 2 FUTA WITHHELD 24 PRSUTA N 9 2 SUTA WITHHELD 25 PRERFI N 9 2 EMPLOYER FICA 26 PRERME N 9 2 EMPLOYER MEDI 27 C_DEDU1 N 9 2 DEDUCTION 1 AMOUNT 28 C_DEDU2 N 9 2 DEDUCTION 2 AMOUNT 29 C_DEDU3 N 9 2 DEDUCTION 3 AMOUNT 30 C_DEDU4 N 9 2 DEDUCTION 4 AMOUNT 31 C_DEDU5 N 9 2 DEDUCTION 5 AMOUNT 32 C_DEDU6 N 9 2 DEDUCTION 6 AMOUNT 33 C_DEDU7 N 9 2 DEDUCTION 7 AMOUNT 34 C_DEDU8 N 9 2 DEDUCTION 8 AMOUNT 35 C_DEDU9 N 9 2 DEDUCTION 9 AMOUNT 36 C_DEDUA N 9 2 DEDUCTION A AMOUNT 37 C_DEDUB N 9 2 DEDUCTION B AMOUNT 38 C_DEDUC N 9 2 DEDUCTION C AMOUNT 39 C_DEDUD N 9 2 DEDUCTION D AMOUNT 40 C_DEDUE N 9 2 DEDUCTION E AMOUNT 41 C_DEDUF N 9 2 DEDUCTION F AMOUNT 42 C_DEDUG N 9 2 DEDUCTION G AMOUNT 43 C_DEDUH N 9 2 DEDUCTION H AMOUNT 44 C_DEDUI N 9 2 DEDUCTION I AMOUNT 45 C_DEDUJ N 9 2 DEDUCTION J AMOUNT 46 C_DEDUK N 9 2 DEDUCTION K AMOUNT 47 C_DEDUL N 9 2 DEDUCTION L AMOUNT 48 C_DEDUM N 9 2 DEDUCTION M AMOUNT 49 C_DEDUN N 9 2 DEDUCTION N AMOUNT 50 C_DEDUO N 9 2 DEDUCTION O AMOUNT 51 C_DEDUP N 9 2 DEDUCTION P AMOUNT 52 C_DEDUQ N 9 2 DEDUCTION Q AMOUNT 53 C_DEDUR N 9 2 DEDUCTION R AMOUNT 54 C_DEDUS N 9 2 DEDUCTION S AMOUNT 55 C_DEDUU N 9 2 DEDUCTION U AMOUNT 56 C_DEDUV N 9 2 DEDUCTION V AMOUNT 57 C_DEDUW N 9 2 DEDUCTION W AMOUNT 58 C_DEDUX N 9 2 DEDUCTION X AMOUNT 59 C_DEDUY N 9 2 DEDUCTION Y AMOUNT 60 C_DEDUZ N 9 2 DEDUCTION Z AMOUNT 61 PR401K N 9 2 401K DEDUCTIONS 62 PRVDATE D 8 0 VOIDED DATE (BLANK IF NOT VOIDED) 63 C_NETACNT C 25 0 NET G/L ACCOUNT 64 C_RETURN C 1 0 CKREC RETURNED? (YN) RECONCILED = 'C' 65 C_POSTAMT N 11 2 CKREC AMOUNT 66 C_STDATE D 8 0 CHECK RECONCILIATION STATEMENT DATE 67 C_NETSTAMP N 2 0 NETWORK SIGNATURE 68 C_DELFLAG C 1 0 DELETE FLAG (*) 69 C_ECHKSTAT C 1 0 CHECK OUTPUT TO ASCII FILE (Y,N) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 69 FIELDS = 593 Related Indexes PRCHCK : PREMPL+PRCHECK+DTOS(PREND) PRCKDT : DTOS(PRDATE)+PRCHECK PRCKNO : PRCHECK+DTOS(PRDATE) PRDEDU : EMPLOYEE DEDUCTIONS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PREMPL C 9 0 EMPLOYEE NUMBER 2 PRDESC C 15 0 DEDUCTION DESCRIPTION 3 PRSEQ C 1 0 DEDUCTION SEQUENCE NUMBER (1-9)(A-J) 4 PRCODE C 4 0 STANDARD DEDUCTION CODE 5 PRDSTATUS C 1 0 DEDUCTION STATUS CODE 6 PRFREQ C 1 0 ONETIME,PAYPERIOD,MONTHLY,NEVER 7 PRRATE C 1 0 RATE OR FIXED 8 PRTYPE C 1 0 GROSS,NET,GROSS-WH,NET-DEDU 9 PRTAXAB C 8 0 (SEE BELOW) 10 PRPER C 1 0 HOURLY,PAYPERIOD 11 PRPERIODS C 5 0 PAYPERIODS TO TAKE DEDUCTION 1-5 12 PRAMOUNT N 10 4 RATE OR FIXED AMOUNT TO DEDUCT 13 PRMAX N 9 2 MAX AMOUNT TO DEDUCT (0.00=NO MAX) 14 PRMAXBASE C 1 0 (Y)EAR-TO-DATE OR (F)ISCAL YEAR MAXIMUM 15 PRSTAT C 6 0 Y/N IN PR PERIODS TAKEN 16 PRMTDD N 9 2 MTD DEDUCTED 17 PRQTDD N 9 2 QTD DEDUCTED 18 PRYTDD N 9 2 YTD DEDUCTED 19 PRFTDD N 9 2 FISCAL DEDUCTED 20 PRLTDD N 9 2 LAST YEAR DEDUCTED 21 PRACNT C 25 0 G/L ACCOUNT 22 D_DIRECT C 1 0 'Y'ES IF DIRECT DEPOSIT 23 D_EMPLACCT C 20 0 EMPLOYEE'S DIRECT DEPOSIT ACCOUNT # 24 D_EMPLBANK C 20 0 EMPLOYEE'S DIRECT DEPOSIT BANK ROUTER # 25 D_PRENOTE C 1 0 (Y)ES IF PRENOTE NEEDS TO BE SENT. 26 D_APXFER C 1 0 TRANSFER TO A/P? (Y/N) 27 D_APVEND C 9 0 ACCOUNTS PAYABLE VENDOR 28 PRCPRT N 3 0 CURRENT # OF CHECKS TO BE PRINTED 29 D_PRPLAN C 1 0 PLAN LETTER FROM THE FPRPLAN STM 30 D_MISC C 30 0 DESCRIPTION FIELD 31 D_NETSTAMP N 2 0 NETWORK SIGNATURE 32 D_DELFLAG C 1 0 "*" = REUSABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 32 FIELDS = 232 Related Indexes PRDEDU : D_DELFLAG+PREMPL+PRSEQ PRDEPO : TAX DEPOSITS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRTAX C 6 0 TAX CODE 2 PRDATE D 8 0 DATE OF DEPOSIT 3 PRAMNT N 10 2 AMOUNT DEPOSITED 4 O_DELFLAG C 1 0 "*" = REUSABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 4 FIELDS = 25 RDEPT : DEPARTMENT FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 D_CODE C 3 0 DEPARTMENT CODE 2 D_NAME C 40 0 DEPARTMENT NAME 3 D_COMPCODE C 5 0 WORKMANS COMP CODE 4 D_DELFLAG C 1 0 DELETE FLAG 5 D_NETSTAMP N 2 0 NETWORK STAMP ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 5 FIELDS = 51 Related Indexes PRDEPT : D_DELFLAG+D_CODE PRDIST : GENERAL LEDGER DISTRIBUTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 D_ACCT C 25 0 G/L ACCOUNT 2 D_DATE D 8 0 TRANSACTION DATE (CHECK DATE) 3 D_BATCH C 3 0 4 D_AMT N 11 2 ACTUAL AMOUNT 5 D_ENCAMT N 11 2 ENCUMBRANCE AMOUNT 6 D_POSTED C 1 0 POSTED TO G/L ? (Y/N) 7 D_NETSTAMP N 2 0 NETWORK SIGNATURE 8 D_DELFLAG C 1 0 DELETE FLAG (*) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 8 FIELDS = 62 Related Indexes PRDIST : D_DELFLAG+D_ACCT+DTOS(D_DATE)+D_POSTED PRDBAT : D_DELFLAG+D_BATCH+D_ACCT+DTOS(D_DATE) PREACC : EMPLOYEE ACCOUNTS FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 A_EMPL C 9 0 EMPLOYEE NUMBER 2 A_TYPE C 2 0 PAY TYPE (G1, OT, ...) 3 A_DESC C 12 0 DESCRIPTION 4 A_TAX C 8 0 (SEE BELOW) 5 A_AUTO C 1 0 AUTOPOST? : "Y"ES / "N"O 6 A_AUTOQTY N 3 0 NUMBER OF AUTO POST PAYROLLS TIL NO AUTO 7 A_BASIS C 1 0 AUTO BASIS : "G"ROSS / "H"OURS 8 A_METHOD C 1 0 AUTO METHOD : "R"ATE / "F"LAT 9 A_CONTRACT C 1 0 'Y'ES IF THIS AMOUNT IS PART OF CONTRACT 10 A_AMOUNT N 11 4 AUTOAMOUNT : (EX."R"ATE TYPES=2.00=2%) 11 A_DISENCUF C 1 0 DISENCUMBER FICA EXPENSE 12 A_DISENCUM C 1 0 DISENCUMBER MEDI EXPENSE 13 A_DISENCUE C 1 0 DISENCUMBER EXPENSE 14 A_ACNT C 25 0 GROSS ACCOUNT 15 A_FICA C 25 0 ERFICA ACCOUNT 16 A_FRINGE C 25 0 ON FRINGE TYPES: FRINGE LIABILITY ACCT 17 A_JOB C 6 0 JOB CODE (ON FRINGES: AP VENDOR) 18 A_WORK C 4 0 WORK CODE (ON FRINGES: 1,2,3 = AP VENDOR 19 A_MTD N 10 2 MONTH-TO-DATE FOR THIS PAY TYPE 20 A_QTD N 10 2 QUARTER 21 A_YTD N 10 2 YEAR 22 A_FTD N 10 2 FISCAL 23 A_LTD N 10 2 LAST YEAR 24 A_PERIODS C 5 0 PERIODS TO TAKE FRINGE AUTO POST 25 A_TAKEN C 5 0 PERIODS TAKEN RESPECTIVE TO PERIOD 26 A_I_FRINGE C 13 0 INCLUDE THIS PAYTYPE IN BASE OF FRINGES 27 A_I_DEDUCT C 34 0 INCLUDE THIS PAYTYPE IN BASE OF DEDUCTS? 28 A_RATE N 11 4 HOURLY RATE FOR PAY TYPE "HOURLY" 29 A_MEDI C 25 0 ERMEDI ACCOUNT 30 A_PLAN C 1 0 FRINGE DEDUCTION PLAN LETTER IF ANY. 31 A_HOBATCH C 4 0 HO BATCH WHICH LAST UPDATED EMPLOYEE 32 A_COMPCODE C 5 0 WORKERS COMP CODE 33 A_PERDIEMF N 6 2 PER DIEM FACTOR (1 UNIT PAID = X HOURS) 34 A_NETSTAMP N 2 0 NETWORK SIGNATURE 35 A_DELFLAG C 1 0 "*" = REUSABLE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 35 FIELDS = 299 Related Indexes PREACC : A_DELFLAG+A_EMPL+FPRLINE(A_TYPE) PREMPL : EMPLOYEE FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PREMPL C 9 0 EMPLOYEE NUMBER 2 PRFIRST C 15 0 FIRST NAME 3 PRMIDDLE C 1 0 MIDDLE INITIAL 4 PRLAST C 25 0 LAST NAME 5 PREXT C 4 0 EXTENSION NAME 6 E_TITLE C 35 0 JOB TITLE 7 PRADDR C 70 0 ADDRESS 1,35 & 36,35 8 PRCITY C 25 0 CITY 9 E_STATE C 10 0 STATE 10 E_ZIP C 10 0 ZIP 11 PRPHONE C 13 0 PHONE # 12 PRSSNUM C 11 0 SOCIAL SECURITY NUMBER 13 PRDEPT C 3 0 DEPARTMENT 14 PRSTAT C 3 0 1=ACT,INACT,TERM/2=SEX,3=ETHNIC 15 PRCYCLE C 5 0 1=WK, BI, SMO, MO, QTR, YR 2=HR, SAL, TIMECARD 16 E_CYCLES N 2 0 PAY CYCLES PER YEAR 17 PRPAYR N 11 3 HOURLY OR SALARY RATE 18 PRREGU N 6 2 REGULAR HOURS 19 PRCONTRCT N 9 2 CONTRACT AMOUNT 20 E_HRRATE C 80 0 TIME CARD RATES 999.9999 21 PRDATE C 24 0 1=HIRE,9=BIRTH,17=TERMINATION 22 E_HIRE D 8 0 HIRE DATE (REPLACES PRDATE) 23 E_BIRTH D 8 0 BIRTH DATE (REPLACES PRDATE) 24 E_TERM D 8 0 TERMINATION DATE (REPLACES PRDATE) 25 E_MISC C 200 0 MISC. FIELD USED FOR NOTES OR CUSTOM 26 PRFLAG C 4 0 "NEW" IF NEW EMPLOYEE/"POST" IF POSTED 27 PRFWT C 7 0 1=S/M/H FILING STAT,2-3=#EXMPT,4- 6=SUPP 28 PRSWT C 7 0 1=S/M/H FILING STAT,2-3=#EXMPT,4- 6=SUPP 29 PRSTATUS C 8 0 STATUS FIELD FOR STATE TAX ROUTINES 30 PREXEMPT C 14 0 SEE BELOW 31 PRSTLOC C 8 0 1-2=STATE TAX AREA,3-5=LOCAL TAX AREA 32 E_CODE C 6 0 USER DEFINED CODE FOR WAGE SUMMARY REPO. 33 E_HRCODE C 50 0 TIME CARD RATE CODES AAAA| 34 E_FICATYPE C 1 0 FICA TYPE: "F"ICA OR "M"QGE 35 E_DECEASED C 1 0 DECEASED FLAG FOR W2 36 E_PENSION C 1 0 PENSION FLAG FOR W2 37 E_LEGALREP C 1 0 LEGAL REP FLAG FOR W2 38 E_DEFCOMP C 1 0 BOX 16 FOR W2 39 E_STATUTOR C 1 0 STATUTORY EMPLOYEE (W2) 40 E_VTDET C 1 0 (H)OURLY OR (S)ALARY FOR VT (ONLY) DET 41 PRLIFE N 4 0 1000S $ LIFE INSURANCE 42 E_FTE N 4 2 FTE VALUE 1 FTE = 520 HRS WORKED 43 E_UNINSURE C 1 0 UNINSURED FLAG 44 PRPDATE D 8 0 LAST POSTING DATE 45 PRCDATE D 8 0 LAST CHECK DATE 46 PRENDD C 112 0 ENDING DATE OF LAST 14 PAY PERIODS 47 PRMGROSS N 10 2 MTD GROSS 48 E_ECHECK C 1 0 ELECTRONIC CHECKS (Y/N) 49 E_NETACNT C 25 0 NET ACCOUNT 50 E_TAXACNT C 25 0 TAX EXPENSE (FUTA / SUTA) ACCOUNT 51 PRQGROSS N 10 2 QTD GROSS 52 PRYGROSS N 10 2 YTD GROSS 53 PRFGROSS N 10 2 FTD GROSS 54 PRLGROSS N 10 2 LAST YEAR GROSS 55 PRMGTW N 10 2 MTD GROSS TAXABLE WAGES 56 PRQGTW N 10 2 QTD GROSS TAXABLE WAGES 57 PRYGTW N 10 2 YTD GROSS TAXABLE WAGES 58 PRFGTW N 10 2 FTD GROSS TAXABLE WAGES 59 PRLGTW N 10 2 LAST YEAR GROSS TAXABLE WAGES 60 PRMGSW N 10 2 MTD GROSS STATE WAGES 61 PRQGSW N 10 2 QTD GROSS STATE WAGES 62 PRYGSW N 10 2 YTD GROSS STATE WAGES 63 PRFGSW N 10 2 FTD GROSS STATE WAGES 64 PRLGSW N 10 2 LAST YEAR GROSS STATE WAGES 65 PRMGFW N 8 2 MTD GROSS FICA WAGES 66 PRQGFW N 8 2 QTD GROSS FICA WAGES 67 PRYGFW N 9 2 YTD GROSS FICA WAGES 68 PRFGFW N 9 2 FTD GROSS FICA WAGES 69 PRLGFW N 9 2 LAST YEARS GROSS FICA WAGES 70 PRMGMW N 8 2 MONTH TO DATE GROSS MEDI WAGES 71 PRQGMW N 8 2 QUARTER TO DATE GROSS MEDI WAGES 72 PRYGMW N 9 2 YEAR TO DATE GROSS MEDI WAGES 73 PRFGMW N 9 2 FISCAL TO DATE GROSS MEDI WAGES 74 PRLGMW N 9 2 LAST YEARS GROSS MEDI WAGES 75 PRLGLW N 9 2 LAST YEARS GROSS LOCAL WAGES 76 PRLMOVE N 9 2 LAST YEARS MOVING EXPENSES (P) BOX 12 77 PRLHSA N 9 2 LAST YEARS EMPLOYER HSA (W) BOX 12 78 E_FTDCONTR N 9 2 CONTRACT AMOUNT PAID FTD 79 PRCONLBAL N 9 2 BALANCE OF CONTRACT FROM LAST YEAR FTD 80 PRMTXFR N 8 2 MTD TAXABLE FRINGE 81 PRQTXFR N 8 2 QTD TAXABLE FRINGE 82 PRYTXFR N 9 2 YTD TAXABLE FRINGE 83 PRFTXFR N 9 2 FTD TAXABLE FRINGE 84 PRLTXFR N 9 2 LAST YEAR TAXABLE FRINGE 85 PRM401K N 8 2 MTD 401K DEDUCTED 86 PRQ401K N 8 2 QTD 401K DEDUCTED 87 PRY401K N 9 2 YTD 401K DEDUCTED 88 PRF401K N 9 2 FTD 401K DEDUCTED 89 PRL401K N 9 2 LAST YEAR 401K DEDUCTED 90 PRMNET N 10 2 MTD NET 91 PRQNET N 10 2 QTD NET 92 PRYNET N 10 2 YTD NET 93 PRFNET N 10 2 FTD NET 94 PRLNET N 10 2 LAST YEAR NET 95 PRMHOUR N 8 2 MTD HOUR 96 PRQHOUR N 8 2 QTD HOUR 97 PRYHOUR N 8 2 YTD HOUR 98 PRFHOUR N 8 2 FTD HOUR 99 PRLHOUR N 8 2 LAST YEAR HOUR 100 PRMFWT N 8 2 MTD FWT 101 PRQFWT N 8 2 QTD FWT 102 PRYFWT N 9 2 YTD FWT 103 PRFFWT N 9 2 FTD FWT 104 PRLFWT N 9 2 LAST YEAR FWT 105 PRMSWT N 8 2 MTD SWT 106 PRQSWT N 8 2 QTD SWT 107 PRYSWT N 9 2 YTD SWT 108 PRFSWT N 9 2 FTD SWT 109 PRLSWT N 9 2 LAST YEAR SWT 110 PRMFICA N 8 2 MTD FICA 111 PRQFICA N 8 2 QTD FICA 112 PRYFICA N 9 2 YTD FICA 113 PRFFICA N 9 2 FTD FICA 114 PRLFICA N 9 2 LAST YEAR FICA 115 PRMERFI N 8 2 MTD EMPLOYER FICA 116 PRQERFI N 8 2 QTD EMPLOYER FICA 117 PRYERFI N 9 2 YTD EMPLOYER FICA 118 PRFERFI N 9 2 FTD EMPLOYER FICA 119 PRLERFI N 9 2 LAST YEAR EMPLOYER FICA 120 PRMMEDI N 8 2 MONTH TO DATE MEDI 121 PRQMEDI N 8 2 QUARTER TO DATE MEDI 122 PRYMEDI N 9 2 YEAR TO DATE MEDI 123 PRFMEDI N 9 2 FISCAL TO DATE MEDI 124 PRLMEDI N 9 2 LAST YEARS MEDI 125 PRMERME N 8 2 MONTH TO DATE EMPLOYERS MEDI 126 PRQERME N 8 2 QUARTER TO DATE EMPLOYERS MEDI 127 PRYERME N 9 2 YEAR TO DATE EMPLOYERS MEDI 128 PRFERME N 9 2 FISCAL TO DATE EMPLOYERS MEDI 129 PRLERME N 9 2 LAST YEARS EMPLOYER MEDI 130 PRMLOC N 8 2 MTD LOCAL TAX 131 PRQLOC N 8 2 QTD LOCAL TAX 132 PRYLOC N 9 2 YTD LOCAL TAX 133 PRFLOC N 9 2 FTD LOCAL TAX 134 PRLLOC N 9 2 LAST YEAR LOCAL TAX 135 PRMSDI N 8 2 MTD SDI 136 PRQSDI N 8 2 QTD SDI 137 PRYSDI N 9 2 YTD SDI 138 PRFSDI N 9 2 FTD SDI 139 PRLSDI N 9 2 LAST YEAR SDI 140 PRMFUTA N 8 2 MTD FUTA 141 PRQFUTA N 8 2 QTD FUTA 142 PRYFUTA N 9 2 YTD FUTA 143 PRFFUTA N 9 2 FTD FUTA 144 PRLFUTA N 9 2 LAST YEAR FUTA 145 PRMSUTA N 8 2 MTD SUTA 146 PRQSUTA N 8 2 QTD SUTA 147 PRYSUTA N 9 2 YTD SUTA 148 PRFSUTA N 9 2 FTD SUTA 149 PRLSUTA N 9 2 LAST YEAR SUTA 150 PRSICK C 38 0 SICK ACCRUAL (SEE BELOW) 151 PRPERS C 38 0 PERSONAL (SEE BELOW) 152 PRVACA C 38 0 VACATION (SEE BELOW) 153 PRLV1 C 38 0 LEAVE 1 (SEE BELOW) 154 PRLV2 C 38 0 LEAVE 2 (SEE BELOW) 155 PRLV3 C 38 0 LEAVE 3 (SEE BELOW) 156 PRLV4 C 38 0 LEAVE 4 (SEE BELOW) 157 PRLV5 C 38 0 LEAVE 5 (SEE BELOW) 158 PRLV6 C 38 0 LEAVE 6 (SEE BELOW) 159 PRLEIC N 9 2 LAST YEARS EIC PAYMENTS 160 PRLDCB N 9 2 LAST YEARS DBC PAYMENTS 161 PRLSST N 9 2 LAST YEARS SOCIAL SECURITY TIPS 162 PRLALL N 9 2 LAST YEARS ALLOCATED TIPS 163 PRLNON N 9 2 LAST YEARS (DISBURSEMENTS FROM NON PLANS) 164 PRL3GW N 9 2 LAST YEARS GROSS FROM 3RD PARTY PAYER 165 PRL3TW N 9 2 LAST YEARS TAXABLE WAGES FROM 3RD PARTY 166 PRL3FW N 9 2 LAST YEARS FWT FROM 3RD PARTY PAYERS 167 PRL3FICA N 9 2 LAST YEARS EMPLOYEE FICA ON 3RD PARTY PAY 168 PRL3MEDI N 9 2 LAST YEARS EMPLOYEE MEDI ON 3RD PARTY PAY 169 E_HOBATCH C 4 0 HO BATCH WHICH LAST UPDATED EMPLOYEE 170 E_COMPCODE C 5 0 WORKERS COMP CODE DEFAULT 171 E_NETSTAMP N 2 0 NETWORK STAMP 172 E_DELFLAG C 1 0 DELETE FLAG (*) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 172 FIELDS = 2225 Related Indexes PREDEP : PRDEPT+PREMPL PRELAS : UPPE(PRLAST) PREMPL : PREMPL PRLEAV : LEAVE TRACKING FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PREMPL C 9 0 EMPLOYEE NUMBER 2 L_DATE D 8 0 DATE LEAVE WAS TAKEN 3 L_UNITS N 6 2 THE AMOUNT OF TIME TAKEN 4 L_MISC C 30 0 USER DEFINED NOTES 5 L_TYPE C 2 0 TYPE OF LEAVE - HP,SP,PP,VP,L1-L6 6 L_NETSTAMP N 2 0 NETWORK STAMP 7 L_DELFLAG C 1 0 "*" IF DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 7 FIELDS = 58 Related Indexes PRLEAV : L_DELFLAG+PREMPL+DTOS(L_DATE)+L_TYPE PRPOST : POSTING FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRSEQNO C 5 0 POSTING SEQUENCE NUMBER 2 PREMPL C 9 0 EMPLOYEE NUMBER 3 PREND D 8 0 END DATE OF PAY PERIOD 4 PRTYPE C 2 0 SEE BELOW 5 PRQTY N 9 2 HOURS/DAYS,MAX DEDU,GROSS WAGES FOR TAX 6 PRRATE N 10 4 PAYRATE OR RATE(%,$) OF DEDUCTION 7 PRAMOUNT N 10 2 PAY,AMT OF DEDU,AMT OF TAX 8 PRCHECK C 8 0 CHECK NUMBER 9 PRSTATUS C 1 0 SEE BELOW 10 PRLINE C 3 0 LINE NUMBER IN THIS POSTING (SEE BELOW) 11 P_DIRECT L 1 0 IF A DEDUCTION, IS IT DIRECT DEPOSIT? 12 P_TAX C 8 0 SEE BELOW 13 P_DISENCUM C 1 0 DISENCUMBER? 14 PRACNT C 25 0 G/L ACCOUNT 15 PRDESC C 15 0 SEE BELOW 16 PRFLAG C 27 0 SEE BELOW 17 P_I_FRINGE C 13 0 INCLUDE THIS POSTING IN FRINGES? 18 P_I_DEDUCT C 34 0 INCLUDE THIS POSTING IN DEDUCTS? 19 P_CONTRACT C 1 0 'Y' THIS AMOUNT IS INCLUDED IN CONTRACT 20 P_COMPCODE C 5 0 WORKERS COMP CODE 21 P_NETSTAMP N 2 0 NETWORK SIGNATURE 22 P_DELFLAG C 1 0 DELETE FLAG (*) 23 PRDEPT C 3 0 24 PRSTDD D 8 0 BANK STATEMENT DATE CLEARED ON ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 24 FIELDS = 209 Related Indexes PRPLKP : PRSEQNO PRPOST : P_DELFLAG+PREMPL+PRSEQNO+PRLINE PRPWRK : P_DELFLAG+UPPE(PRSTATUS)+PREMPL+PRSEQNO+PRLINE+PRACNT PRWKDP : P_Delflag+UPPE(Prstatus)+Prdept+Prempl+Prseqno+Prline+Pracnt PRSTDD : STANDARD DEDUCTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRDESC C 15 0 DEDUCTION DESCRIPTION 2 PRSEQ C 4 0 DEDUCTION SEQUENCE NUMBER (1-9)(A-J) 3 PRFREQ C 1 0 ONETIME,PAYPERIOD,MONTHLY,NEVER 4 PRRATE C 1 0 RATE OR FIXED 5 PRTYPE C 1 0 GROSS,NET,GROSS-WH,NET-DEDU 6 PRTAXAB C 8 0 (SEE BELOW) 7 PRPER C 1 0 HOURLY,PAYPERIOD 8 PRPERIODS C 5 0 PAYPERIODS TO TAKE DEDUCTION 1-5 9 PRAMOUNT N 10 4 RATE OR FIXED AMOUNT TO DEDUCT 10 PRMAX N 9 2 MAX AMOUNT TO DEDUCT (0.00=NO MAX) 11 PRMAXBASE C 1 0 'Y'EAR TO DATE, 'F'ISCAL YEAR MAXIMUM 12 PRACNT C 25 0 G/L ACCOUNT 13 D_DIRECT C 1 0 'Y'ES IF DIRECT DEPOSIT 14 D_APXFER C 1 0 'Y'ES IF TRANSFER TO A/P 15 D_APVEND C 9 0 ACCOUNTS PAYABLE VENDOR 16 D_PRPLAN C 1 0 PLAN LETTER FROM THE PRPLAN DBF 17 D_OLDCODE C 4 0 MISC. DESCRIPTION FIELD 18 D_NETSTAMP N 2 0 NETWORK SIGNATURE 19 D_DELFLAG C 1 0 DELETE FLAG (*) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 19 FIELDS = 100 Related Indexes PRSTDD : D_delflag+Prseq PRSYST : SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_GLLINK C 1 0 LINK TO GENERAL LEDGER? (Y/N) 2 S_GLCOMP C 2 0 GENERAL LEDGER ENTITY TO LINK TO 3 S_GLNXTBAT N 3 0 4 S_APLINK C 1 0 LINK TO ACCOUNTS PAYABLE? (Y/N) 5 S_APCOMP C 2 0 ACCOUNTS PAYABLE ENTITY TO LINK TO 6 S_APNXTBAT N 3 0 7 S_TRACKJC C 1 0 TRACK JOB COSTING? (Y/N) 8 S_ADDEMPL C 1 0 ADD NEW EMPLOYEES DURING HR TRANSFER?Y/N 9 S_NET C 25 0 G/L NET (CASH) ACCOUNT (DEFAULT) 10 S_DUETO C 25 0 G/L DUE TO ACCOUNT 11 S_DUEFROM C 25 0 G/L DUE FROM ACCOUNT 12 S_ENCACCT C 25 0 G/L ENCUMBRANCE ACCOUNT 13 S_TAXACCT C 25 0 G/L TAX EXPENSE ACCOUNT (DEFAULT) 14 S_ERFICA C 25 0 G/L EMPLOYER FICA ACCOUNT (DEFAULT) 15 S_ERMEDI C 25 0 G/L EMPLOYER MEDI ACCOUNT (DEFAULT) 16 S_ENCUM C 1 0 DISENCUMBER ? (YN) 17 S_ONEENC C 1 0 1 ENCUM ACCOUNT("Y") OR 1 PER FUND("N") 18 S_ONEWH C 1 0 1 W/H ACCOUNT("Y") OR 1 PER FUND("N") 19 S_VOIDATE C 1 0 (A)CTUAL OR (V)OID DATE 20 S_FEDID C 10 0 FEDERAL TAX ID 21 S_FEDPIN C 4 0 FEDERAL PIN NUMBER 22 S_STATEID C 15 0 STATE TAX ID 23 S_69NUM C 10 0 "69" NUMBER 24 S_FEDWH N 11 2 AMOUNT OF ONE FED. WITHHOLDING ALLOWANC 25 S_FICAMAX N 11 2 MAXIMUM YEARLY WAGES SUBJECT TO FICA/MED 26 S_W2MAX N 11 2 MAXIMUM LAST YEAR FICA MAX (FOR W-2) 27 S_EICMAX N 11 2 MAXIMUM YEARLY ADVANCE EIC PAID 28 S_WARRTTL C 30 0 TITLE TO APPEAR ON CHECK WARRANT REPORT 29 S_CKFORM C 2 0 CHECK FORM (00,01,...) 30 S_W2FORM C 2 0 W2 FORM (00,01,...) 31 S_TFFORM C 2 0 PREPRINTED TAX FORM (00,01,...) 32 S_LASTEND D 8 0 LAST PAYROLL ENDING DATE USED 33 S_QTRDT D 8 0 DATE OF LAST QUARTER CLOSE 34 S_QTRNUM C 1 0 CURRENT QUARTER NUMBER 35 S_FISCYR D 8 0 DATE OF LAST FISCAL YEAR CLOSE 36 S_YEAR N 4 0 CURRENT YEAR 37 S_PERIOD N 2 0 CURRENT PERIOD 38 S_W2YEAR N 4 0 YEAR FOR W-2 REPORTING 39 S_NXTPOST C 5 0 NEXT POSTING SEQUENCE NUMBER 40 S_LSTCHCK N 8 0 LAST PRINTED CHECK NUMBER 41 S_PRENUMB C 1 0 PRENUMBERED CHECKS? (Y/N) 42 S_LSTECHK N 7 0 LAST E-CHECK NUMBER USED 43 S_ENET C 1 0 SHOW NET AMT OF E-CHECK ON STUB+REPORTS 44 S_ORDER C 1 0 DEFAULT ORDER (LAST ONE USED) 45 S_ER_HC C 1 0 EMPLOYER PROVIDED HEALTH CARE 46 S_WEEKLY N 5 2 WEEKLY ANNUALIZING FACTOR FOR CALC 47 S_BIWEEK N 5 2 BI-WEEKLY " 48 S_SEMIMO N 5 2 SEMI-MONTHLY " 49 S_MONTHY N 5 2 MONTHLY " 50 S_QTERLY N 5 2 QUARTERLY " 51 S_YEARLY N 5 2 YEARLY " 52 S_MTDGROS N 11 2 MONTH-TO-DATE GROSS 53 S_QTDGROS N 11 2 QUARTER-TO-DATE GROSS 54 S_YTDGROS N 11 2 YEAR-TO-DATE GROSS 55 S_FTDGROS N 11 2 FISCAL-TO-DATE GROSS 56 S_MTDNET N 11 2 MTD NET 57 S_QTDNET N 11 2 QTD NET 58 S_YTDNET N 11 2 YTD NET 59 S_FTDNET N 11 2 FTD NET 60 S_QTDFDEP N 11 2 QTD FEDERAL DEPOSITS 61 S_QTDSDEP N 11 2 QTD STATE DEPOSITS 62 S_MTDFDED N 11 2 MTD FEDERAL TAXES DEDUCTED 63 S_QTDFDED N 11 2 QTD FEDERAL TAXES DEDUCTED 64 S_YTDFDED N 11 2 YTD FEDERAL TAXES DEDUCTED 65 S_FTDFDED N 11 2 FTD FEDERAL TAXES DEDUCTED 66 S_MTDSDED N 11 2 MTD STATE TAXES DEDUCTED 67 S_QTDSDED N 11 2 QTD STATE TAXES DEDUCTED 68 S_YTDSDED N 11 2 YTD STATE TAXES DEDUCTED 69 S_FTDSDED N 11 2 FTD STATE TAXES DEDUCTED 70 S_DESCL1 C 8 0 LEAVE 1 DESCRIPTION 71 S_DESCL2 C 8 0 LEAVE 2 DESCRIPTION 72 S_DESCL3 C 8 0 LEAVE 3 DESCRIPTION 73 S_DESCL4 C 8 0 LEAVE 4 DESCRIPTION 74 S_DESCL5 C 8 0 LEAVE 5 DESCRIPTION 75 S_DESCL6 C 8 0 LEAVE 6 DESCRIPTION 76 S_DEFLPAY C 1 0 DEFAULT 0.00 AS THE LEAVE PAY RATE? 77 S_MISCFELD C 100 0 MISC FIELD DESCRIPTIONS IN EMPL MAINT 78 S_WARRBOT M 0 0 WARRANT BOTTOM MEMO 79 S_INC_REIM C 1 0 INCLUDE REIMBURSMENTS IN NET DEDUCTIONS 80 S_PRWAIT N 5 1 SECONDS OF DELAY DURING CHECK UPDATES 81 S_F05 C 30 0 FUNCTION KEY F5 82 S_F06 C 30 0 FUNCTION KEY F6 83 S_F07 C 30 0 FUNCTION KEY F7 84 S_F08 C 30 0 FUNCTION KEY F8 85 S_F09 C 30 0 FUNCTION KEY F9 86 S_F10 C 30 0 FUNCTION KEY F10 87 S_F11 C 30 0 FUNCTION KEY F11 88 S_F12 C 30 0 FUNCTION KEY F12 89 S_BAKDATE D 8 0 LAST TEMPORARY BACKUP DATE 90 S_BAKTIME C 8 0 LAST TEMPORARY BACKUP TIME 91 S_NETSTAMP N 2 0 NETWORK SIGNATURE 92 S_JANUARY N 2 0 JAN IS WHAT PERIOD FOR UPPER LEFT CORNER 93 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA 94 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 95 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED 96 S_DIDMI C 1 0 MIDDLE INITIAL CONVERSION (F/C/N) 97 S_BANK1 C 40 0 BANK NAME 1 98 S_BANK2 C 40 0 BANK NAME 2 99 S_BANK3 C 40 0 BANK NAME 3 100 S_BANK4 C 40 0 BANK NAME 4 101 S_ABA C 9 0 ABA NUMBER 102 S_BANKACCT C 15 0 BANK ACCOUNT NUMBER 103 S_BANKCODE C 4 0 BANK CODE 104 S_FEDCODE C 6 0 FED CODE 105 S_ACCT1 C 40 0 ACCOUNT OWNER NAME 1 106 S_ACCT2 C 40 0 ACCOUNT OWNER NAME 2 107 S_ACCT3 C 40 0 ACCOUNT OWNER NAME 3 108 S_ACCT4 C 40 0 ACCOUNT OWNER NAME 4 109 S_USECALF C 1 0 USE THE FRINGE BENEFIT SPREAD DEPT ROUTI 110 S_CALF_NUM C 13 0 FRINGES TO USE THE ROUTINE ON 111 S_CALF_MAX N 12 2 MAXIMUM AMOUNT FOR 1ST FRING ON LIST 112 S_CALF_ST N 2 0 REPLACEMENT STARTS AT 113 S_CALF_LN N 2 0 REPLACEMENT CONTINUES FOR 114 S_NEWSCR C 1 0 USE NEW POSTING SCREEN ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 114 FIELDS = 1416 PRTAXS : TAX FILE (FWT,SWT,FICA,...) No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRTAX C 6 0 TAX CODE (SEE BELOW) 2 PRDESC C 15 0 DESCRIPTION OF TAX 3 PRTABL C 1 0 Y=USE MPRWITH# FILE AS TABLE 4 PRRATE N 7 5 RATE TO DEDUCT IN DECIMAL (NOT %) 5 PRBASE N 9 2 MAX EMPL TAXABLE GROSS (0.00=NO MAX) 6 PRMAX N 9 2 MAX AMT THAT CAN BE TAKEN (0=NO MAX) 7 PRACNT C 25 0 G/L ACCOUNT 8 PRSUTATYP C 1 0 SUTA PAID BY EMPLOYER OR EMPLOYEE (R/E) 9 X_APVEND C 9 0 ACCOUNTS PAYABLE VENDOR 10 PRWITH1 N 10 2 QTD WITHHELD IN QUARTER 1 11 PRWITH2 N 10 2 QTD WITHHELD IN QUARTER 2 12 PRWITH3 N 10 2 QTD WITHHELD IN QUARTER 3 13 PRWITH4 N 10 2 QTD WITHHELD IN QUARTER 4 14 PRDEP1 N 10 2 QTD DEPOSITED IN QUARTER 1 15 PRDEP2 N 10 2 QTD DEPOSITED IN QUARTER 2 16 PRDEP3 N 10 2 QTD DEPOSITED IN QUARTER 3 17 PRDEP4 N 10 2 QTD DEPOSITED IN QUARTER 4 18 X_NETSTAMP N 2 0 NETWORK SIGNATURE 19 PRSTATE C 1 0 ACCUMULATE GSW FOR STATE EXEMPT EMPLOYEE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 19 FIELDS = 165 Related Indexes PRTAXS : PRTAX PRTCHK : TEMPORARY CHECK FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRCHECK C 8 0 2 PRSEQNO C 5 0 3 PREMPL C 9 0 4 PRLAST C 25 0 LAST NAME: SAME AS PREMPL->PRLAST 5 PRFIRST C 15 0 FIRST NAME: SAME AS PREMPL->PRFIRST 6 PRDATE D 8 0 7 PREND D 8 0 8 PRDAYS N 3 0 9 PRGROSS N 9 2 10 C_CONTRACT N 9 2 AMOUNT OF GROSS THAT IS CONTRACT 11 PRGTW N 9 2 12 PRGSW N 9 2 13 PRGFW N 9 2 14 PRGMW N 9 2 GROSS MEDI WAGES 15 PRFWT N 9 2 16 PRTXFR N 9 2 17 C_FRINGE N 9 2 18 C_REIMB N 9 2 19 PRNET N 9 2 20 PRDNET N 9 2 NET DIRECT DEPOSITS 21 PRFICA N 9 2 22 PRMEDI N 9 2 MEDI WITHHELD 23 PRSWT N 9 2 24 PRSDI N 9 2 25 PRLOC N 9 2 26 PRFUTA N 9 2 FEDERAL UNEMPLOYMENT TAX 27 PRSUTA N 9 2 STATE UNEMPLOYMENT TAX 28 PRERFI N 9 2 EMPLOYER FICA 29 PRERME N 9 2 EMPLOYER MEDI 30 PR401K N 9 2 31 PRVDATE D 8 0 32 C_NETACNT C 25 0 33 C_RETURN C 1 0 34 C_POSTAMT N 11 2 35 C_NETSTAMP N 2 0 NETWORK SIGNATURE 36 C_DELFLAG C 1 0 37 TT_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 38 DT_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 39 OT_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 40 R9_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 41 R8_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 42 R7_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 43 R6_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 44 R5_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 45 R4_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 46 R3_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 47 R2_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 48 R1_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 49 FD_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 50 FC_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 51 FB_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 52 FA_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 53 F9_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 54 F8_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 55 F7_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 56 F6_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 57 F5_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 58 F4_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 59 F3_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 60 F2_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 61 F1_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 62 O9_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 63 O8_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 64 O7_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 65 O6_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 66 O5_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 67 O4_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 68 O3_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 69 O2_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 70 O1_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 71 H9_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 72 H8_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 73 H7_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 74 H6_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 75 H5_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 76 H4_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 77 H3_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 78 H2_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 79 H1_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 80 HA_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 81 HB_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 82 HC_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 83 HD_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 84 HE_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 85 HF_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 86 HG_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 87 HH_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 88 HI_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 89 HJ_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 90 HK_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 91 HL_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 92 HM_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 93 HN_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 94 HO_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 95 HQ_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 96 HR_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 97 HS_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 98 HT_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 99 HU_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 100 HV_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 101 HW_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 102 HX_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 103 HY_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 104 HZ_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 105 G9_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 106 G8_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 107 G7_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 108 G6_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 109 G5_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 110 G4_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 111 G3_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 112 G2_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 113 G1_INFO M 0 0 PAY TYPE (MEMORY VARIABLES) 114 GR_AMT N 10 2 115 HR_AMT N 10 2 116 OT_AMT N 10 2 117 DT_AMT N 10 2 118 TT_AMT N 10 2 119 TO_AMT N 10 2 120 SP_AMT N 10 2 121 VP_AMT N 10 2 122 HP_AMT N 10 2 123 PP_AMT N 10 2 124 L1_AMT N 10 2 125 L2_AMT N 10 2 126 L3_AMT N 10 2 127 L4_AMT N 10 2 128 L5_AMT N 10 2 129 L6_AMT N 10 2 130 F1_AMT N 10 2 131 F2_AMT N 10 2 132 F3_AMT N 10 2 133 F4_AMT N 10 2 134 F5_AMT N 10 2 135 F6_AMT N 10 2 136 F7_AMT N 10 2 137 F8_AMT N 10 2 138 F9_AMT N 10 2 139 FA_AMT N 10 2 140 FB_AMT N 10 2 141 FC_AMT N 10 2 142 FD_AMT N 10 2 143 R1_AMT N 10 2 144 R2_AMT N 10 2 145 R3_AMT N 10 2 146 R4_AMT N 10 2 147 R5_AMT N 10 2 148 R6_AMT N 10 2 149 R7_AMT N 10 2 150 R8_AMT N 10 2 151 R9_AMT N 10 2 152 HR_HRS N 10 2 153 OT_HRS N 10 2 154 DT_HRS N 10 2 155 TT_HRS N 10 2 156 SP_HRS N 10 2 157 VP_HRS N 10 2 158 HP_HRS N 10 2 159 PP_HRS N 10 2 160 L1_HRS N 10 2 161 L2_HRS N 10 2 162 L3_HRS N 10 2 163 L4_HRS N 10 2 164 L5_HRS N 10 2 165 L6_HRS N 10 2 166 SP_RATE N 11 4 167 VP_RATE N 11 4 168 HP_RATE N 11 4 169 PP_RATE N 11 4 170 L1_RATE N 11 4 171 L2_RATE N 11 4 172 L3_RATE N 11 4 173 L4_RATE N 11 4 174 L5_RATE N 11 4 175 L6_RATE N 11 4 176 GR_YTD N 10 4 177 GR_FTD N 10 2 178 NT_YTD N 10 2 179 FW_YTD N 10 2 180 SW_YTD N 10 2 181 FI_YTD N 10 2 182 ME_YTD N 10 2 YEAR TO DATE MEDI WITHHELD 183 SD_YTD N 10 2 184 SU_YTD N 10 2 YTD SUTA TAX 185 LT_YTD N 10 2 186 D_INFO_1 M 10 2 HOLDS C_DEDU? VARIABLES 187 D_INFO_2 M 10 2 HOLDS D?_DES VARIABLES 188 D_INFO_3 M 10 2 HOLDS D?_YTD VARIABLES 189 P00_YTD N 10 2 190 P02_YTD N 10 2 191 P04_YTD N 10 2 192 P06_YTD N 10 2 193 P08_YTD N 10 2 194 P20_YTD N 10 2 195 P40_YTD N 10 2 196 PRDEPT C 3 0 197 PRSTATUS C 1 0 198 P080_YTD N 10 2 SICK PAY YTD 199 P081_YTD N 10 2 VACTION PAY YTD 200 P082_YTD N 10 2 HOLIDAY PAY YTD 201 P083_YTD N 10 2 PERSONAL PAY YTD 202 P084_YTD N 10 2 LEAVE 1 PAY YTD 203 P085_YTD N 10 2 LEAVE 2 PAY YTD 204 P086_YTD N 10 2 LEAVE 3 PAY YTD 205 P087_YTD N 10 2 LEAVE 4 PAY YTD 206 P088_YTD N 10 2 LEAVE 5 PAY YTD 207 P089_YTD N 10 2 LEAVE 6 PAY YTD 208 SP_ACC N 8 3 YTD SICK HOURS ACCRUED 209 VP_ACC N 8 3 YTD VACA HOURS ACCRUED 210 PP_ACC N 8 3 YTD PERSONAL HOURS ACCRUED 211 L1_ACC N 8 3 YTD LEAVE 1 HOURS ACCRUED 212 L2_ACC N 8 3 ETC 213 L3_ACC N 8 3 ETC 214 L4_ACC N 8 3 ETC 215 L5_ACC N 8 3 ETC 216 L6_ACC N 8 3 ETC 217 SP_TAK N 8 3 YTD SICK HOURS TAKEN 218 VP_TAK N 8 3 ETC 219 PP_TAK N 8 3 ETC 220 L1_TAK N 8 3 ETC 221 L2_TAK N 8 3 ETC 222 L3_TAK N 8 3 ETC 223 L4_TAK N 8 3 ETC 224 L5_TAK N 8 3 ETC 225 L6_TAK N 8 3 ETC 226 SP_EARN N 8 3 SICK HOURS EARNED THIS PERIOD 227 VP_EARN N 8 3 ETC 228 PP_EARN N 8 3 ETC 229 L1_EARN N 8 3 ETC 230 L2_EARN N 8 3 ETC 231 L3_EARN N 8 3 ETC 232 L4_EARN N 8 3 ETC 233 L5_EARN N 8 3 ETC 234 L6_EARN N 8 3 ETC ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 234 FIELDS = 1477 PRWITH : TAX TABLE FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PRTAX C 6 0 TAX CODE (FWT,SWT+STATE,LOC+CODE) 2 PRTSTAT C 1 0 MARITAL STATUS 3 PRMINW N 9 2 MINIMUM WAGE FOR THIS TAX AND RATE 4 PRMINT N 8 2 MINIMUM TAX FOR THIS CATEGORY 5 PRRATE N 5 3 ADDITIONAL TAX RATE ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 5 FIELDS = 29 Related Indexes PRWITH : PRTAX+PRTSTAT+STR(INT(PRMINW)) PRX2AP : TRANSFER TO A/P FILE (APMAST) No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 PVENDNO C 9 0 VENDOR NUMBER 2 PINVNO C 12 0 INVOICE NUMBER 3 REF C 8 0 PURCHASE ORDER NUMBER 4 CHECKNO C 8 0 CHECK NUMBER 5 POSTAT C 1 0 U=UNPAID,P=PAID,V=VOID 6 PCOMPANY C 35 0 VENDOR COMPANY NAME 7 PADDRESS1 C 35 0 VENDOR ADDRESS 1 8 PADDRESS2 C 35 0 VENDOR ADDRESS 2 9 PCITY C 25 0 VENDOR CITY 10 PSTATE C 10 0 VENDOR STATE 11 PZIP C 10 0 VENDOR ZIP 12 PPRIORITY C 2 0 CHECKING ACCOUNT CODE (MN=MANUAL) 13 PURDATE D 8 0 DATE OF PURCHASE (INVOICE DATE) 14 DUEDATE D 8 0 DATE PAYMENT DUE 15 CHECKDATE D 8 0 DATE OF CHECK 16 PURAMT N 11 2 FULL AMOUNT OF PURCHASE 17 DISAMT N 11 2 DISCOUNT AMOUNT 18 PAIDAMT N 11 2 AMOUNT PAID 19 CHECKACC C 25 0 G/L NET ACCOUNT NUMBER 20 M_FUNDESC C 15 0 FUND DESCRIPTION 21 M_FISCYR C 9 0 FISCAL YEAR (1234-1234) 22 M_INVDESC C 25 0 INVOICE DESCRIPTION 23 M_DISPERC N 5 2 DISCOUNT PERCENTAGE 24 M_DISDAY N 2 0 # DAYS TO CALC DISCOUNT DUE DATE 25 M_DUEDAY N 2 0 # DAYS TO CALC FINAL DUE DATE 26 M_VOUCHER C 8 0 VOUCHER NUMBER 27 M_FROMPO C 1 0 "Y"=INVOICE STARTED AS A PO 28 M_1099 C 1 0 "Y"=INVOICE IS A 1099 PAYMENT 29 M_MISCFLG C 1 0 USED DURING:REPRINT & WARRANT REPO 30 M_GL_POST C 1 0 "Y"=POSTED TO G/L " " = NOT POSTED 31 M_GL_INV C 1 0 "Y"=INVOICE HAS BEEN POSTED 32 M_GL_CHK C 1 0 "Y"=CHECK HAS BEEN POSTED 33 M_GL_BAT C 3 0 GL BATCH NUMBER 34 M_MANUAL C 1 0 'Y' OR 'N' IF MANUAL 35 M_NETSTAMP N 2 0 NETWORK SIGNATURE 36 M_DELFLAG C 1 0 "*" FOR RE-USABLE RECORD ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 36 FIELDS = 351 PRX2GL : TRANSFER TO G/L FILE (GLTRAX) No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TRSACT C 25 0 ACCOUNT NUMBER 2 TRSDES C 25 0 TRANSACTION DESCRIPTION 3 TRSREF C 12 0 REFERENCE NUMBER 4 TRSDATE D 8 0 TRANSACTION DATE 5 TRSAMT N 15 2 AMOUNT 6 TRSID C 1 0 0=SPECIAL,1=POSTING,2=REFERENCE 7 TRSMODU C 2 0 MODULE THAT GENERATED THIS POSTING 8 TRSCOMPID C 2 0 COMPANY ID THAT GENERATED THIS POSTING 9 TRSTYPE C 1 0 TRANSACTION TYPE (SEE BELOW) 10 TRSPD C 2 0 G/L PERIOD OF POSTING 11 TRSDELFLAG C 1 0 ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 11 FIELDS = 94
