ĐĎॹá>ţ˙ ţ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙Root Entry˙˙˙˙˙˙˙˙€čćɅÇÎ@Contents˙˙˙˙˙˙˙˙Ď_SummaryInformation(˙˙˙˙˙˙˙˙˙˙˙˙ ˙˙˙˙˙˙˙˙˙˙˙˙ţ˙˙˙ý˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙Root Entry˙˙˙˙˙˙˙˙°ö‹Ę…Ç@Contents˙˙˙˙˙˙˙˙ MSummaryInformation(˙˙˙˙˙˙˙˙˙˙˙˙ ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ţ˙˙˙ý˙˙˙ý˙˙˙ý˙˙˙ý˙˙˙ţ˙˙˙ţ˙˙˙  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ Ą˘Ł¤ĽŚ§¨ŠŞŤŹ­ŽŻ°ą˛ł´ľśˇ¸šşťź˝žżŔÁÂĂÄĹĆÇČÉʕ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙–—™˙˙˙˙šœ˙˙˙˙ţ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ţ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ţ˙ŕ…ŸňůOhŤ‘+'łŮŕ…ŸňůOhŤ‘+'łŮ0đ XlxŒ˜  Ŕ Ě Řä Untitledt.1 Ruth HewettChristian A. Strasser339@°ŒsĘ…Ç@°ŒsĘ…ÇR&R× Windows!Qaˇ“ 699U699012–˙˙˙˙˙˙˙˙˙˙˙˙4@7M:\Best Software\Abra Suite\Programs\Data\prCkHist.DBFLAbraMicrLArialLTahoma˙˙˙@ PRCKHIST|U‚x+.+ FŒ 0˙IsInteractRRUNIN()|€d?& Gˆ ˙CompSelectRTrim(CLookup("CompSelect", "CURRTEXTVL", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.dbf", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.cdx", "PARAMORD"))|€d?& Hˆ ˙PayGrpSelRTrim(CLookup("PayGrpSel ", "CURRTEXTVL", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.dbf", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.cdx", "PARAMORD"))|€d?& Iˆ ˙ChkRngBegRTrim(CLookup("ChkRngBeg ", "CURRTEXTVL", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.dbf", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.cdx", "PARAMORD"))|€d?& Jˆ ˙ChkRngEndRTrim(CLookup("ChkRngEnd ", "CURRTEXTVL", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.dbf", "m:\bestso~1\abrasu~1\programs\otherprg\extparam\promptinfo.cdx", "PARAMORD"))|L‚P¨ó KŒ0˙CtrlLink1|_€Z& Lˆ€˙DBF_rrMaster table nameDBF()|\€Z& Mˆ‚Ą˙Date_rrToday's dateDATE()|\€Z& Nˆ€˙Time_rrCurrent timeTIME()|j€Z&2 Oˆ€@2˙Query_rrCurrent query expressionQUERY()|i€Z& Pˆ€˙Repname_rrCurrent report nameREPNAME()|]‚Pęg& Qˆ€˙ShowPer"Monthly Pay Rate:"zF‚PH 0 AMOUNTzH‚Z& €BANKACCTzH‚Z& € BANKROUTzG‚Z& €0 BASEPAYzI‚Z& €0 CAFETERIAzH‚Z& €CASHACCTzI‚Z& €CASHJOBCDzH‚Z& €CASHORG1zH‚Z& €CASHORG2zH‚Z& €CASHORG3zH‚Z& €CASHORG4zH‚Z& €CASHORG5zH‚Z& €CASHPROJzG‚Z& ‚ĄCHADATEzJ‚Z& ĄCHARGEDATEzI‚Pü5ó 0CHKAMOUNTzH‚Z& €0CHKCOUNTzG‚Pb=ó CHKDATEzH‚PÄ ó 0CHKGROUPzI‚P*-ó CHKNUMBERzI‚Z& €CHKSTATUSzI‚Z& ‚ĄCLEARDATEzG‚PŽó COMPANYzI‚Z& €0 DEBTGROSSzG‚Z& €0 DEBTTAXzJ‚PóHĄ €0 DEDUCTIONSzH‚Z& €0 DEFERREDzI‚Z& €0 DEPAMOUNTzF‚Z& €0 EICTAXzE‚Pň9ó  EMPNOzH‚P HĄ €0 FEDGROSSzF‚Z& €0 FEDTAXzI‚Z& €0 FMEDGROSSzH‚Z& !€0 FMEDONLYzG‚Z& "€0 FMEDTAXzI‚Z& #€0 FSOCGROSSzH‚Z& $€0 FSOCONLYzG‚Z& %€0 FSOCTAXzJ‚Z& &€0 FUND1GROSSzH‚Z& '€0 FUND1TAXzJ‚Z& (€0 FUND2GROSSzH‚Z& )€0 FUND2TAXzI‚Z& *€0 FUTAGROSSzI‚Z& +€0 HRSWORKEDzJ‚Z& ,€0 LOCALGROSSzH‚Z& -€0 LOCALTAXzG‚Z& .€NEXTCHKzH‚PVó /PAYGROUPzI‚Z& 0‚ĄPAYPERIODzG‚Z& 1€0 PREMPAYzI‚Z& 2€RECONFLAGzH‚Z& 3€0 REIMBPAYzH‚Z& 4€0 RR1GROSSzF‚Z& 5€0 RR1TAXzH‚Z& 6€0 RR2GROSSzF‚Z& 7€0 RR2TAXzI‚Z& 8€0 RRHIGROSSzG‚Z& 9€0 RRHITAXzH‚Z& :€0 SDIGROSSzF‚Z& ;€0 SDITAXzJ‚Z& <€0 STATEGROSSzH‚Z& =€0 STATETAXzI‚Z& >€0 SUTAGROSSzG‚Z& ?€0 SUTATAXzE‚P…HĄ @€0 TAXESzJ‚Z& A€0 TAXONLYPAYzJ‚PŸHĄ B€0 TOTALGROSSzD‚Pşó CTYPEzI‚Z& D€0 WORKGROSSzG‚Z& E€0 WORKTAX{C‚Z*I´ R{C‚d KÔ S|Ĺ€d& Tˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(PRCKHIST->COMPANY+PRCKHIST->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|˛€d& Uˆ€_TYPECheck TypeCASE(PRCKHIST->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")Go&"˙ CtrlLinkPRTCTRL.DBF˙PRTCTRLzG‚x' V€COMPSELzG‚x' W€PGRPSELzG‚x' X€0FORMSELzH‚x' Y€LASTGOODzG‚x' ZREPRINTG p6 EMPNOhrpersnl.DBFhrPersnl.CDXEMPNOHRPERSNLzJ‚x' [!P_ACCUMCURzH‚x' \€P_ACTIVEzI‚x' ]€P_ALLOCBYzH‚x' ^€0P_ANNUALzJ‚x' _‚ĄP_ANYCHANGzI‚x' `€P_AUTOHOLzI‚x' a€P_AUTOILLzI‚x' b!P_AUTOPAYzI‚x' c€P_AUTOPERzI‚x' d€P_AUTOREGzI‚x' e€P_AUTOVACzI‚x' f‚ĄP_BEN_EXPzG‚x' g‚ĄP_BIRTHzG‚x' h€P_BONUSzJ‚x' i€0 P_BONUSAMTzH‚x' j€P_BUSEXTzJ‚x' k€ P_BUSPHONEzJ‚x' l€ P_CELLULARzJ‚x' m€0P_CFICATIPzI‚x' n‚ĄP_CHADATEzI‚x' o€ P_CITIZENzG‚x' p€P_COBRAzI‚Pó qP_COMPANYzJ‚x' r€0P_COMPARATzI‚x' s€0P_CURTIPSzJ‚x' t€0P_DEPINSURzI‚x' u€0P_DEPNDTSzI‚x' v€P_DISAVETzJ‚Z& w‚ĄP_DISCHARGzJ‚x' x€P_EEOCLASSzI‚x' y‚ĄP_EFFDATEzE‚x' z!P_EICzJ‚x' {€P_EICMSTATzJ‚x'@ |€@P_EMPEMAILzH‚x' }€P_EMPLOYzG‚Z†At ~ P_EMPNOzI‚x' €P_EMPTYPEzH‚x' €€P_EXEMPTzG‚x' €P_FCITYzJ‚x' ‚€ P_FCOUNTRYzI‚x' ƒ€P_FCOUNTYzG‚PvWó „P_FNAMEzH‚x' …€P_FSTATEzJ‚x' †€P_FSTREET1zJ‚x' ‡€P_FSTREET2zJ‚x' ˆ€P_FUNCTIONzF‚x' ‰€ P_FZIPzF€d&$ Š€$P_GUIDzJ‚x' ‹€P_HANDICAPzG‚PÚ{ó ŒP_HCITYzJ‚x' € P_HCOUNTRYzI‚x' Ž€P_HCOUNTYzH‚x' € P_HPHONEzH‚P>ó P_HSTATEzJ‚P˘Ťó ‘P_HSTREET1zJ‚P Ťó ’P_HSTREET2zF‚Pj ?ó “ P_HZIPzI‚x' ”‚ĄP_I9RENEWzI‚x' •€P_I9VERIFzI‚x' –€0 P_ILLACCRzJ‚x' —€0 P_ILLCARRYzJ‚x' ˜€0 P_ILLCLOSEzH‚x' ™€P_ILLINDzI‚x' š€0 P_ILLRATEzJ‚x' ›€0 P_ILLTAKENzH‚x' œ€ P_JMISC1zH‚x' €P_JMISC2zH‚x' ž€0 P_JMISC3zH‚x' Ÿ€0 P_JMISC4zI‚x'  €P_JOBCODEzI‚x' Ą‚ĄP_JOBDATEzJ‚x' ˘€P_JOBGROUPzJ‚P"—& Ł€P_JOBTITLEzJ‚x' ¤€P_LABORINDzI‚x' Ľ‚ĄP_LASTCHKzJ‚x' Ś‚ĄP_LASTHIREzJ‚x' §‚ĄP_LEAVERETzH‚PÎ ó ¨@P_LEVEL1zH‚Pâ ó Š@P_LEVEL2zH‚x' Ş€ P_LEVEL3zH‚x' Ť€ P_LEVEL4zH‚x' Ź€ P_LEVEL5zG‚Pâ ó ­@P_LNAMEzH‚x' Ž€0 P_LNORMUzJ‚x' Ż€ P_LOCATIONzJ‚x' °‚ĄP_LPAYDATEzJ‚x' ą€P_LPAYFREQzI‚x' ˛€0P_LSALARYzJ‚x' ł‚ĄP_LSTPAYDTzH‚x' ´€0 P_LUNITRzJ‚x' ľ€P_MAILSTOPzI‚x' ś€P_MARRIEDzD‚Pâ ó ˇ@P_MIzJ‚x' ¸€ P_MILITARYzG‚x' š€P_MISC1zG‚x' ş€ P_MISC2zG‚x' ť€P_MISC3zG‚x' ź€0 P_MISC4zI‚x' ˝‚ĄP_NEXTPAYzJ‚x' ž‚ĄP_NEXTPERFzJ‚x' ż€P_NICKNAMEzJ‚x' Ŕ€0 P_NORMUNITzG‚x'P Á€PP_NOTESzJ‚x' ‚ĄP_ORIGHIREzI‚x' Ă€0 P_OTHERIDzJ‚x' ĀP_OTHERVETzG‚x' ŀ P_PAGERzI‚x' ƂĄP_PAYDATEzI‚x' ǀP_PAYFREQzJ‚x' ȀP_PAYGROUPzI‚x' ɀP_PAYSTATzI‚x' ʁ!P_PENSIONzI‚x' Ë€0 P_PERACCRzJ‚x' Ě€0 P_PERCARRYzJ‚x' Í€0 P_PERCLOSEzJ‚x' ΂ĄP_PERFDATEzH‚x' πP_PERINDzI‚x' Đ€0 P_PERRATEzJ‚x' Ń€0 P_PERTAKENzJ‚x' Ň€0 P_QFICATIPzJ‚x' Ó€0P_QTDUNTAXzJ‚x' Ô€0 P_QTIPALLOzJ‚x' Ő€0 P_QTIPSREPzF‚x' րP_RACEzH‚x' ׀P_RATINGzH‚x' ؀P_REASONzH‚x' ـP_RECALCzI‚x' ڀP_RECRUTRzH‚x' ۀP_REHIREzH‚PXN& Ü€0P_SALARYzJ‚x' ݀P_SALGRADEzI‚x' ހP_SALHOURzG‚x' ߀P_SALUTzJ‚x' ŕ€P_SEASONALzI‚x' ႡP_SENDATEzE‚x' â€P_SEXzG‚x' ă€P_SHIFTzJ‚x' ä€0P_SHIFTPREzH‚x' ĺ€P_SMOKERzH‚x' ć€P_SOURCEzE‚ZOt ç P_SSNzI‚x' č!P_STATUTEzH€x' é€P_SUP2COzJ€x'@ ę€@P_SUP2MAILzH€x' ë€ P_SUP2NOzI€x' ě€P_SUP2VISzJ‚x'@ í€@P_SUPEMAILzI€x' î€P_SUPERCOzI‚x' ď€ P_SUPERNOzJ‚x' đ€P_SUPERVISzI€d& ń€P_SYNCBPSzJ‚x' ň‚ĄP_TERMDATEzJ‚x' ó€P_TERMREASzJ‚x' ô€P_TERMTYPEzH‚x' ő€P_TSTAMPzI‚x' ö€P_UNIONCDzI‚x' ÷‚ĄP_UNIONDTzI‚x' ř€P_UNITPAYzJ‚x' ů€0 P_UNITRATEzI‚x' ú€0 P_VACACCRzJ‚x' ű€0 P_VACCARRYzJ‚x' ü€0 P_VACCLOSEzH‚x' ý€P_VACINDzI‚x' ţ€0 P_VACRATEzJ‚x' ˙€0 P_VACTAKENzI‚x' €P_VIETNAMzI‚x' ‚ĄP_VISAEXPzJ‚x' € P_VISATYPEzJ‚x' €P_WORKCODEzJ‚x' €P_WORKCOMPzJ‚x' €0P_WORKRATEzJ‚x' €0 P_YFICATIPzJ‚x' €0P_YTDUNTAXzJ‚x' €0 P_YTIPALLOzJ‚x' €0 P_YTIPSREP|Ô€d& ˆ€_ACTIVEActive (Active/Terminated/etc)CASE(HRPERSNL->P_ACTIVE, "A", "Active", "T", "Terminated", "O", "On Leave", "D", "Deceased", " ")|¤€d& Œ€0_AN1000Annual Pay Rounded to ThousandROUND(ROUND((HRPERSNL->P_ANNUAL + 499.999)/1000, 0)*1000, 2)|q€d& Œ€0_ANNUALEmployee's Annual PayHRPERSNL->P_ANNUAL|ł€d& ˆ€ _COBRAAutomatically Add for COBRA (Yes/No)CASE(HRPERSNL->P_COBRA, "Y", "Yes", "N", "No", "P", "Pending", "n/a")|œ€d& ˆ€_DISAVETDisabled Veteran (Yes/No)CASE(HRPERSNL->P_DISAVET, "Y", "Yes", "N", "No", "n/a")|‰€d& ˆ€_EEOCLASSEEO ClassificationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "EE" + "N" +HRPERSNL->P_EEOCLASS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "N" + HRPERSNL->P_EEOCLASS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|‚€d& ˆ€_EMPLOYEmployment StatusIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "EM" + "N" +HRPERSNL->P_EMPLOY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "N" + HRPERSNL->P_EMPLOY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ź€d& ˆ€_EXEMPTExempt Status (Exempt/Non-Exempt)CASE(HRPERSNL->P_EXEMPT, "Y", "Exempt", "N", "Non-Exempt", "n/a")|‰€d& ˆ€_FSTATEForwarding Address StateIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + HRPERSNL->P_FSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "N" +HRPERSNL->P_FSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|v€d& ˆ€_HSTATEStateIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + HRPERSNL->P_HSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "N" +HRPERSNL->P_HSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|¸€d& ˆ€_I9VERIFI-9 Verification on File? (Yes/No/Pend)CASE(HRPERSNL->P_I9VERIF, "Y", "Yes", "N", "No","P", "Pending", "n/a")|ˆ€d& ˆ€_JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + HRPERSNL->P_JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "N" +HRPERSNL->P_JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|„€d& ˆ€_JOBGROUPEEO Job GroupIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "JG" + "N" + HRPERSNL->P_JOBGROUP + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "N" +HRPERSNL->P_JOBGROUP + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|z€d& ˆ€_LEVEL1DivisionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + HRPERSNL->P_LEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "N" + HRPERSNL->P_LEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))||€d& ˆ€_LEVEL2DepartmentIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + HRPERSNL->P_LEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "N" + HRPERSNL->P_LEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|z€d& ˆ€_LEVEL3LocationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + HRPERSNL->P_LEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "N" + HRPERSNL->P_LEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|}€d& ˆ€_LEVEL4Not DefinedIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + HRPERSNL->P_LEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "N" + HRPERSNL->P_LEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|}€d& ˆ€_LEVEL5Not DefinedIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + HRPERSNL->P_LEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "N" + HRPERSNL->P_LEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|ƒ€d& ˆ€_LOCATIONWork LocationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "LO" + "N" +HRPERSNL->P_LOCATION+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "N" + HRPERSNL->P_LOCATION + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ý€d& ˆ€ _MARRIEDMarital Status (Married/Single/etc)CASE(HRPERSNL->P_MARRIED, "M", "Married", "S", "Single","W", "Widowed", "D", "Divorced", "O", "Other", " n/a")|j€d&& ˆ€&_NAME1Name: Last, First MiddleRTRIM(HRPERSNL->P_LNAME)+IIF(ISBLANK(HRPERSNL->P_FNAME), "", IIF(NOT ISBLANK(HRPERSNL->P_LNAME),"," +RTRIM(HRPERSNL->P_FNAME),""+RTRIM(HRPERSNL->P_FNAME)))+ IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_MI), "", IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_LNAME), LEFT(HRPERSNL->P_MI, 1), IIF(ISBLANK(HRPERSNL->P_LNAME) AND NOT ISBLANK(HRPERSNL->P_FNAME), " ",IIF(ISBLANK(HRPERSNL->P_FNAME) AND NOT ISBLANK(HRPERSNL->P_LNAME), ", "+LEFT(HRPERSNL->P_MI,1), IIF(NOT ISBLANK(HRPERSNL->P_FNAME)," ", "")+LEFT(HRPERSNL->P_MI,1)))))|Z€d&& ˆ€&_NAME2Name: First Middle LastRTRIM(HRPERSNL->P_FNAME)+IIF(ISBLANK(HRPERSNL->P_MI), " ",IIF(ISBLANK(HRPERSNL->P_FNAME), LEFT(HRPERSNL->P_MI, 1), " "+ LEFT(HRPERSNL->P_MI, 1)))+ IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_MI), RTRIM(HRPERSNL->P_LNAME)," "+ RTRIM(HRPERSNL->P_LNAME))|˝€d& ˆ€_PAYFREQPay FrequencyCASE(HRPERSNL->P_PAYFREQ, "W", "Weekly", "B", "Biweekly","S", "Semi-Monthly", "M", "Monthly", " ")|n€d& !ˆ€_RACERaceIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ET" + "N" +HRPERSNL->P_RACE+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "N" + HRPERSNL->P_RACE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|‰€d& "ˆ€_RATINGPerformance Review RatingIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RT" + "N" +HRPERSNL->P_RATING+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "N" + HRPERSNL->P_RATING + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|~€d& #ˆ€_REASONAbsence ReasonIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RE" + "N" +HRPERSNL->P_REASON+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "N" + HRPERSNL->P_REASON + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d& $ˆ€_REHIRERehire (Yes/No)CASE(HRPERSNL->P_REHIRE, "Y", "Yes", "N", "No", "n/a")|‚€d& %ˆ€_SALGRADESalary GradeIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "SG" + "N" +HRPERSNL->P_SALGRADE+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "N" + HRPERSNL->P_SALGRADE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|–€d& &ˆ€_SALHOURSalary or HourlyCASE(HRPERSNL->P_SALHOUR, "S", "Salary", "H", "Hourly", "")|œ€d& 'ˆ€_SEASONALSeasonal Worker (Yes/No)CASE(HRPERSNL->P_SEASONAL, "Y", "Yes", "N", "No", "n/a")|›€d& (ˆ€_SEXGender (Male/Female/Unknown)CASE(HRPERSNL->P_SEX, "F", "Female", "M", "Male", "n/a")|w€d& )ˆ€_SHIFTWork ShiftIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +HRPERSNL->P_SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "N" + HRPERSNL->P_SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d& *ˆ€_SMOKERSmoker (Yes/No)CASE(HRPERSNL->P_SMOKER, "Y", "Yes", "N", "No", "n/a")|ˆ€d& +ˆ€_TERMREASTermination ReasonIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RE" + "N" +HRPERSNL->P_TERMREAS+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "N" + HRPERSNL->P_TERMREAS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|§€d& ,ˆ€_TERMTYPETermination TypeCASE(HRPERSNL->P_TERMTYPE, "V", "Voluntary", "I", "Involuntary", "Unknown")|x€d& -ˆ€_UNIONCDUnionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "UC" + "N" +HRPERSNL->P_UNIONCD+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "N" + HRPERSNL->P_UNIONCD + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d& .ˆ€_UNITPAYUnits of PayIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "UP" + "N" +HRPERSNL->P_UNITPAY+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "N" + HRPERSNL->P_UNITPAY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ą€d& /ˆ€DEDLINKCLinking field for Catchup 401(k)HRPERSNL->P_EMPNO + HRPERSNL->P_COMPANY + 'CUP ' + 'H'Gp; COMPANYsyemploy.DBFsyemploy.CDXEMPLOYERSYEMPLOYzJ‚Pâ ó 0@E_ADDRESS1zJ‚x' 1€ E_ADDRESS2zI‚x' 2€0E_AGEWARNzH‚x' 3!E_ATABRAzJ‚x' 4!E_ATACCRUEzG‚x' 5€0E_ATDECzI‚x' 6€E_ATUNITSzG‚x' 7€E_AUDITzI‚x' 8€E_BANKCLRzJ‚x' 9€ E_BANKPHONzJ‚x' :!E_BENEABRAzI€d& ;‚ĄE_BPSSYNCzH‚x' <€0E_CASENOzF‚Pâ ó =@E_CITYzI‚x' >€E_COMPANYzI‚x' ?€E_CONTACTzI‚x' @€E_COUNTRYzH‚x' A€E_COUNTYzJ‚x' B€ E_DESTROUTzG‚x'# C€#E_EMAILzE‚x' D€ E_FAXzG‚x' E€ E_FEDIDzI‚x' F€ E_FIELDSWzI‚x' G‚ĄE_FISC_YRzI‚x' H€0E_GLJOBCDzH‚x' I€0E_GLMAINzH‚x' J€0E_GLORG1zH‚x' K€0E_GLORG2zH‚x' L€0E_GLORG3zH‚x' M€0E_GLORG4zH‚x' N€0E_GLORG5zH‚x' O€0E_GLPROJzH‚x' P€E_ILLINDzI‚x' Q€0 E_ILLRATEzF‚x' R€E_J250zJ‚x' S€E_JAPPRENTzH‚x' T€E_JCCITYzJ‚x' U€E_JCCOUNTYzG‚x' V€E_JCITYzH‚x'# W€#E_JCNAMEzJ‚x'2 X€2E_JCONTACTzJ‚x' Y€ E_JCONTROLzH‚x' Z€E_JCONUMzI‚x' [€E_JCOUNTYzI‚x' \€ E_JCPHONEzI‚x' ]€E_JCSTATEzJ‚x'# ^€#E_JCSTREETzI‚x' _€E_JCTITLEzI‚x' `€E_JCVALIDzG‚x' a€ E_JCZIPzG‚x' b€ E_JDUNSzG‚x'P c€PE_JINFOzI‚x' d€E_JLASTYRzH‚Z& e€E_JNAICSzG‚x'# f€#E_JNAMEzF‚x' g€E_JSICzH‚x' h€E_JSTATEzI‚x'# i€#E_JSTREETzG‚x' j€E_JTESTzH‚x' k€E_JTITLEzG‚x' l€E_JTYPEzG‚x' m€E_JUNITzF‚x' n€ E_JZIPzJ‚x' o‚ĄE_LASTPAIDzH‚x' p€E_METHODzG‚x' q€E_MISC1zG‚x' r€E_MISC2zG‚x' s€E_MISC3zG‚x' t€E_MISC4zG‚x' u€E_MISC5zG‚x' v€E_MISC6zG‚x' w€E_MISC7zG‚x' x€E_MISC8zF‚Pâ ó y@E_NAMEzJ‚x' z€0 E_NORMUNITzI‚x' {€E_NUMERICzJ‚x' |€ E_ORIGROUTzI‚x' }€E_PAYFREQzH‚x' ~€0E_PAYNUMzH‚x' €E_PERINDzI‚x' €€0 E_PERRATEzG‚x' € E_PHONEzJ‚x' ‚€0E_POSITIONzH‚x' ƒ‚ĄE_QTRENDzI‚x' „€E_SGVALIDzH‚x' …€E_SIGOPTzG‚Pâ ó †@E_STATEzJ‚x' ‡!E_TRAINENTzH‚x' ˆ€E_VACINDzI‚x' ‰€0 E_VACRATEzE‚Pâ ó Š@E_ZIP{C‚ZĚ# ‹#y{C‚Z⸠Œ 0{C‚Z¸¨ ={C€Zܨ Ž†{C€ZH¨  Š{C‚Œ‚Ô# #y|„€d& ‘ˆ€_JCSTATEEEO Report StateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_JCSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_JCSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ž€d& ’ˆ€_JSTATEEEO Parent/Jurisdiction StateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_JSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_JSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|s€d& “ˆ€_STATEStateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_STATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_STATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|`‚P +ó ”Œ CKnumval(prckhist->CHKNUMBER){C‚ZŇ2´ •Ž ”{C€dŒO –Ž”{C‚ŒnNÔ —Ž ”|o‚Pâ ó ˜ˆ@PgrpLinkprckhist->COMPANY+prckhist->PAYGROUPGp= PgrpLinkprpaygrp.DBFprpaygrp.CDXCOMPGROUPprpaygrpzF‚Z& ™ACCILLzF‚Z& šACCPERzF‚Z& ›ACCVACzG‚Z& œ€ACHFLAGzH‚Pâ ó @BANKACCTzI‚Z& ž€BANKACCT2zI‚P ]ó Ÿ!BANKCLEARzH‚Pâ ó  @BANKNAMEzI‚Pâ ó Ą@BANKROUTEzH‚Z& ˘€CASHACCTzI‚Z& Ł€CASHJOBCDzH‚Z& ¤€CASHORG1zH‚Z& Ľ€CASHORG2zH‚Z& Ś€CASHORG3zH‚Z& §€CASHORG4zH‚Z& ¨€CASHORG5zH‚Z& Š€CASHPROJzI‚Z& Ş‚ĄCHECKDATEzJ‚Z&P Ť€PCHKMESSAGEzI‚Z& Ź€CHKNUMBERzI‚Z& ­€0CHKOFFSETzJ‚Z& Ž€0CHKOFFSET2zH‚Z& Ż€CHKPRINTzH‚Z&# °€#CHKSTOCKzG‚Z& ą€COMPANYzJ‚Z& ˛€CURRENTQTRzH‚Z& ł€DDAPRINTzF‚Z& ´€DDDESCzG‚Z&# ľ€#DDSTOCKzI‚Z& ś€DEPNUMBERzH‚Z& ˇ€DESCRIPTzH‚Z& ¸FINALPAYzJ‚Z& šFINALQTRCLzJ‚Z& ş€GLDISTFLGSzH‚Z& ťINACTIVEzJ‚Z& źINCRPAYNUMzJ‚Z&I& ˝‚LASTPERIODzJ‚Z& ž€0MICROFFSETzH‚Z& żOVERFLOWzJ‚Z& ŔOVERRIDEDDzG‚Z& Á€PAYFREQzH‚Z& €PAYGROUPzI‚Z& Ă€0PAYNUMBERzI‚Z&P Ä€PPRINTEXPRzH‚Z& Ĺ‚ĄPROCDATEzI‚Z& ƁPROCESSONzH‚Z& Ç€PROCTIMEzH‚Z& Č€ PROCTYPEzH‚Z& É€ PROCUSERzH‚Z& ʁPROJECTSzH‚Z& Ë€ PROJNAMEzJ‚Z& Ě‚ĄQTRENDDATEzF‚Z& ́RECALCzD‚Z& ΀RULEzJ‚Z& Ď€SAVEDFLAGSzI‚Z& Đ€STOCKDESCzH‚Z&P Ń€PTIMEEXPRzH‚Z& Ň€TIMESRCHzJ‚Z& Ó‚ĄTRIALCHECKzH‚Z& ԁTRIALPAYzI‚Z&Iœ ŐTRIALPENDzJ‚Z& ցTRIALQTRCLzG‚Z& ×€0TSALLOCzH‚Z& Ř€0TSCHRGDTzH‚Z& Ů€0TSEARNCDzG‚Z& Ú€0TSHOURSzG‚Z& Ű€0TSJOBCDzF‚Z& Ü€0TSORG1zF‚Z& Ý€0TSORG2zF‚Z& Ţ€0TSORG3zF‚Z& ߀0TSORG4zF‚Z& ŕ€0TSORG5zE‚Z& á€0TSPAYzF‚Z& â€TSPICTzF‚Z& ă€0TSPROJzG‚Z& ä€0TSSHIFTzG‚Z& ĺ€0TSTAXCD{C‚Pr—Ě ć {C‚P^ZÄ ç!Ÿ{C€dJ1 č Ą|Ÿ€d& 鈀_FINALPAYFinal Payroll Status (Yes/No)CASE(prpaygrp->FINALPAY,.T., "True", .F., "False", "")|¨€d& ęˆ€_FINALQTRCFinal Quarter Close Status (Yes/No)CASE(prpaygrp->FINALQTRCL,.T., "True", .F., "False", "")| €d& 눀_OVERFLOWPrint Overflow Checks (Yes/No)CASE(prpaygrp->OVERFLOW,.T., "True", .F., "False", "")|Ÿ€d& ěˆ€_TRIALPAYTrial Payroll Status (Yes/No)CASE(prpaygrp->TRIALPAY,.T., "True", .F., "False", "")|Ť€d& 툀_TRIALQTRCTrial Quarter Close Attempted (Yes/No)CASE(prpaygrp->TRIALQTRCL,.T., "True", .F., "False", "")|k‚Pâ ó îˆ@RegLinkprckhist->EMPNO+prckhist->COMPANY|m‚P– Wó ďˆ!IsZeroiif(CHKAMOUNT=0,"NON-NEGOTIABLE",""){C‚ @Ž( đŠ!ď|a‚PÚ ó ńŒ0ChkCentsMOD(CHKAMOUNT*100,100)||‚Pâ ó ňˆ@ShowCentiif(ChkCents=0,"00/100",str(ChkCents,2,0)+"/100")|Š‚ZŒą\ óˆ€HDivDescCLOOKUP(P_COMPANY+"L1"+"N"+P_LEVEL1+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|Ş‚ZĚą\ ôˆ€HCustDescCLOOKUP(P_COMPANY+"L2"+"N"+P_LEVEL2+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|s‚Zńt őˆEmpNametrim(P_LNAME)+", "+trim(P_FNAME)+" "+P_MI|m‚Pâ ó öˆ@ShowAmtSTRREP(str(CHKAMOUNT,10,2)," ","*"){C‚ZXO” ÷Š ö|˝‚Pâ ó řˆ@BnkAcctShoLeft(prpaygrp->BANKACCT, 4) + " " + SubStr(prpaygrp->BANKACCT, 5, 2) + " " + SubStr(prpaygrp->BANKACCT, 7, 15){C€dţw ůŠř|i‚Pâ ó úˆ@NameShowUpper(P_FNAME - " " + P_LNAME){C‚ndD( űŠ(ú|o‚Pâ ó üˆ@AddrShowUpper(P_HSTREET1 - "/" + P_HSTREET2){C‚nd4( ýŠ(ü||‚Pâ ó ţˆ@CSZShowEEUpper(P_HCITY - ", " + P_HSTATE - " " + P_HZIP){C‚nd˙$$ ˙Š$ţ|]‚Pâ ó ˆ@ERAddrShoUpper(E_ADDRESS1){C‚ZâÄ Š |‚Pâ ó ˆ@CSZShoERUpper(E_CITY - ", " + E_STATE - " " + Left(E_ZIP, 5)){C‚Z´% Š%|Œ‚Pŕ ó Œ0SplAmtLnthLen(Upper(SpellNum(CHKAMOUNT))+" AND " + ShowCent + " DOLLARS")|Ś‚P&â ó ˆ@ChkAmtREPLICATE("* ", 55 - SplAmtLnth) - Upper(SpellNum(CHKAMOUNT))+" AND " + ShowCent + " DOLLARS"{C‚n&Z't7 Š7|k‚Pâ ó ˆ@BankAddrLk"***" + "BK" + "N" + BANKROUTEGp? BankAddrLkhrtables.dbfhrtables.CDXTABLECODEBankInfozB‚P& €C1zB‚P& €C2zB‚P& €C3zB‚P& €C4zD‚P& €CODEzG‚P& €COMPANYzD‚P& €DESCzF‚P& €GLCOMPzB‚P& €0N1zB‚P& €0N2zB‚P& €0 N3zD‚P& €RULEzE‚P& €TABLEzF‚P& €TCCOMPzC‚Pâ ó @UD1zC‚Pâ ó @UD2zC‚P& €UD3{C‚Pr—Ŕ {C‚Pr—´ |–€d& ˆChkBtchLnkPRCKHIST->EMPNO + PRCKHIST->COMPANY + DtoC(PRCKHIST->CHARGEDATE, 1) + "E"Gp9 ChkBtchLnkprHPost.DBFprHPost.CDXEMPNOBatchInfzH‚d& €0ALLOCCNTzH‚d& €ALLOCINDzH‚d& €0ALLOCORDzH‚d& €0ALLOCSETzF‚d& €0AMOUNTzJ‚d& !€0ARREARSAMTzI‚d& "ATTPOSTEDzH‚d& #€CALCRULEzG‚d& $‚ĄCHADATEzJ‚d& %‚ĄCHARGEDATEzG‚d& &‚ĄCHKDATEzH‚d& '€0CHKGROUPzI‚d& (€CHKNUMBERzG‚d& )€COMPANYzJ‚d& *€0DEDUCTIONSzH‚d& +€DESCRIPTzE‚d& ,€ EMPNOzF‚d& -€0ERLIABzG‚d& .€JOBCODEzI‚d& /€ ORGLEVEL1zI‚d& 0€ ORGLEVEL2zI‚d& 1€ ORGLEVEL3zI‚d& 2€ ORGLEVEL4zI‚d& 3€ ORGLEVEL5zH‚d& 4€PAYGROUPzG‚d& 5€0 PAYRATEzH‚d& 6€POSTCODEzH‚d& 7€POSTTYPEzJ‚d& 8€0 PREVARREARzG‚P[¨ 9PROJECTzH‚d& :€0 QUANTITYzI‚d& ;RETROINCLzE‚d& <€SHIFTzI‚d& =SHIFTINCLzF‚d& >€SOURCEzF‚d& ?€STATUSzG‚d& @€TAXTYPEzD‚d& A€TYPEzH‚d& B€0WAGEBASEzH‚d& C€WORKCODE{C‚P[œ D9|z€d& Eˆ€_JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(BatchInf->COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + BatchInf->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "JC" + "N" +BatchInf->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|u€d& Fˆ€_ORGLEVEL1DivisionIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + BatchInf->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L1" + "N" + BatchInf->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|w€d& Gˆ€_ORGLEVEL2DepartmentIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + BatchInf->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L2" + "N" + BatchInf->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|u€d& Hˆ€_ORGLEVEL3LocationIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + BatchInf->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L3" + "N" + BatchInf->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|x€d& Iˆ€_ORGLEVEL4Not DefinedIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + BatchInf->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L4" + "N" + BatchInf->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|x€d& Jˆ€_ORGLEVEL5Not DefinedIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + BatchInf->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L5" + "N" + BatchInf->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ĺ€d& Kˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(BatchInf->COMPANY+BatchInf->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|Ś€d& Lˆ€_POSTTYPEPosting TypeCASE(BatchInf->POSTTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|i€d& Mˆ€_SHIFTWork ShiftIIf(IIf(CLOOKUP(BatchInf->COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +BatchInf->SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "SF" + "N" + BatchInf->SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|¤€d& Nˆ€_TAXTYPETax Table TypeCASE(BatchInf->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "n/a")|˛€d& Oˆ€_TYPECheck TypeCASE(BatchInf->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")|†€d& Pˆ€_WORKCODEWork State For Posting RecordIIf(IIf(CLOOKUP(BatchInf->COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + BatchInf->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "ST" + "N" +BatchInf->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Š€dQ& Qˆ RprntChkLnkPRCKHIST->COMPANY + PRCKHIST->PAYGROUP + PRCKHIST->CHKNUMBERGpľ RprntChkLnk\Best Software\Abra Suite\Programs\OtherPrg\ChkReprint\reprinttrak.dbf\Best Software\Abra Suite\Programs\OtherPrg\ChkReprint\reprinttrak.CDXCMPGRPCKNOreprintszI‚d& R€ REPRINTIDzJ‚d& S‚ĄREPRINTDTEzJ‚d& T€REPRINTTMEzJ‚d& U€ REPRINTUSRzI‚d& V€ REPRINTPCzJ‚d& W€REPRINTCMPzJ‚d& X€REPRINTPGPzJ‚d& Y€ REPRINTEMPzJ‚d& Z€REPRINTCHKzJ€Px˜ [0REPRINTCNT{C€PxŒ \0[G p2 RegLinkprearn.DBFprearn.CDXEMPNOprearnzF‚Z& ]€0 AMOUNTzG‚Z& ^€0 BALANCEzH‚Z& _€0 BALANCEPzH‚Z& `€CALCRULEzG‚Z& a‚ĄCHADATEzG‚Z& b€COMPANYzI‚Z& c€0 CURAMOUNTzH‚Z& d€0CURHOURSzH‚P2[  eDESCRIPTzH‚Pâ ó f@EARNCODEzE‚Z& g€ EMPNOzD‚Z& h€0 GOALzI‚Z& i€0 MTDAMOUNTzH‚Z& j€0MTDHOURSzH‚Z& k€PAYGROUPzI‚Z& l€0 QTDAMOUNTzJ‚Z& m€0 QTDAMOUNTPzH‚Z& n€0QTDHOURSzI‚Z& o€0QTDHOURSPzI‚Z& p‚ĄSTARTDATEzF‚Z& q€STATUSzH‚Z& r‚ĄSTOPDATEzD‚Pâ ó sTYPEzF‚Z& t€ USERIDzI‚P˘ Kó u0 YTDAMOUNTzJ‚Z& v€0 YTDAMOUNTPzH‚PÄ )ó w2YTDHOURSzI‚Z& x€0YTDHOURSPG p2  RegLinkprdeds.DBFprdeds.CDXEMPNOPRDEDSzF‚Z& y€ACTIVEzF‚Z& z€0 AMOUNTzJ‚Z& {€0 ARREARSAMTzG‚Z& |€0 BALANCEzH‚Z& }€0 BALANCEPzH‚Z& ~€CALCRULEzG‚Z& ‚ĄCHADATEzG‚Z& €€COMPANYzI‚Z& €0 CURAMOUNTzI‚Z& ‚€0 CUREMPLYRzG‚Pâ ó ƒ@DEDCODEzH‚P2[  „DESCRIPTzE‚Z& …€ EMPNOzD‚Z& †€0 GOALzF‚Z& ‡€ MEMBERzI‚Z& ˆ€0 MTDAMOUNTzI‚Z& ‰€0 MTDEMPLYRzH‚Z& Š€PAYGROUPzI‚Z& ‹€0 QTDAMOUNTzJ‚Z& Œ€0 QTDAMOUNTPzI‚Z& €0 QTDEMPLYRzJ‚Z& Ž€0 QTDEMPLYRPzI‚Z& ‚ĄSTARTDATEzH‚Z& ‚ĄSTOPDATEzD‚Pâ ó ‘TYPEzF‚Z& ’€ USERIDzH‚Z& “€0WITHHOLDzI‚P9H  ”0 YTDAMOUNTzJ‚Z& •€0 YTDAMOUNTPzI‚Z& –€0 YTDEMPLYRzJ‚Z& —€0 YTDEMPLYRPG p5  RegLinkprtaxes.DBFprtaxes.CDXEMPNOPRTAXESzG‚Z& ˜‚ĄCHADATEzH‚Z& ™€CODETYPEzG‚Z& š€COMPANYzI‚Z& ›€0CURAMOUNTzH‚Z& œ€0CURWAGESzE‚Z& € EMPNOzF‚Z& ž!EXEMPTzI‚PŹ Aó Ÿ0 EXEMPTCNTzH‚Z&  €0EXTRAAMTzI‚Z& Ą€EXTRATYPEzI‚Pâ ó ˘MARSTATUSzI‚Z& Ł€0MTDAMOUNTzH‚Z& ¤€0MTDWAGESzJ‚Z& Ľ€0 OEXEMPTCNTzH‚Z& Ś€PAYGROUPzI‚Z& §€0QTDAMOUNTzJ‚Z& ¨€0QTDAMOUNTPzH‚Z& Š€0QTDWAGESzI‚Z& Ş€0QTDWAGESPzF‚Z& Ť€STATUSzG‚Pâ ó Ź@TAXCODEzG‚P2ľ  ­TAXDESCzG‚Z& Ž€TAXTYPEzD‚Pâ ó ŻTYPEzF‚Z& °€ USERIDzH‚Z& ą€0WITHHOLDzI‚P9H  ˛2 YTDAMOUNTzJ‚Z& ł€0YTDAMOUNTPzH‚PŐHz ´€0YTDWAGESzI‚Z& ľ€0YTDWAGESP{C‚P2[  śe|Á€d& ˇˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(prearn->COMPANY+prearn->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")}V‚P˝( ¸„2wüCatYTDhrs}V‚PŸHĄ  š„€0 uüChkYTDgrs|W‚Pâ ó şˆ@CodeLink"E"+EARNCODEGp9 CodeLinkprcodes.DBFprcodes.CDXCODETYPEPRCODESzH‚Z& ť!ACCRINCLzI‚Z& ź!ALLCHECKSzH‚Z& ˝€ALLOCINDzJ‚Z& ž!ALWAYSBEERzF‚Z& ż€0 AMOUNTzG‚Z& Ŕ!ARREARSzH‚Z& Á€0ARRPRIORzG‚Z& !AUTOADDzH‚Z& Á!BALRESETzG‚Z& Ä€ BENCODEzH‚Z& Ĺ€CALCRULEzH‚Z& Ć€CATEGORYzH‚Z& Ç€0CHKGROUPzD‚Z& Č€CODEzH‚Z& É€CODETYPEzG‚Z& Ę€COMPANYzH‚Z& Ë€0DEDPRIORzG‚Z& Ě€DEDTYPEzH‚Pâ ó ÍEARNTYPEzI‚Z& ΀EEPAYACCTzJ‚Z& Ď€EEPAYJOBCDzI‚Z& Đ€EEPAYORG1zI‚Z& Ń€EEPAYORG2zI‚Z& Ň€EEPAYORG3zI‚Z& Ó€EEPAYORG4zI‚Z& Ô€EEPAYORG5zI‚Z& Ő€EEPAYPROJzH‚Z& Ö€EMPLYINDzH‚Z& ×€0EMPLYMAXzI‚Z& Ř€0EMPLYPCNTzG‚Z& Ů€EXPACCTzH‚Z& Ú€EXPJOBCDzG‚Z& Ű€EXPORG1zG‚Z& Ü€EXPORG2zG‚Z& Ý€EXPORG3zG‚Z& Ţ€EXPORG4zG‚Z& ߀EXPORG5zG‚Z& ŕ€EXPPROJzG‚Z& á€0FEDPCNTzF‚Z& â!FLSAOTzJ‚Z& ă€GLDISTFLGSzD‚Z& ä€0 GOALzH‚Z& ĺ!OTACCRUEzG‚Z& ć€PAYACCTzH‚Z& ç€PAYCYCLEzE‚Z& č€ PAYEEzH‚Z& é€ PAYJOBCDzG‚Z& ę€ PAYORG1zG‚Z& ë€ PAYORG2zG‚Z& ě€ PAYORG3zG‚Z& í€ PAYORG4zG‚Z& î€ PAYORG5zG‚Z& ď€ PAYPROJzG‚Z& đ€PAYTYPEzJ‚Z& ń€0 RATEFACTORzF‚Z& ň€REASONzI‚Z& ó!RETROINCLzD‚Z& ô€RULEzI‚Z& ő!SHIFTINCLzI‚Z& ö‚ĄSTARTDATEzH‚Z& ÷‚ĄSTOPDATEzH‚Z& ř€STUBDESCzI‚Z& ů€TAKECYCLEzI‚Z& ú€TAXMETHODzF‚Z& ű€TCCOMPzG‚Z& ü€UNITPAYzH‚Z& ý!WCOMPTAX}f‚Pœ Qó ţ„0 uüEARNTYPE <> "T"ChkYTDcash|s€PŒaj ˙ˆ€ ShowReimbiif(EARNTYPE="R"," (Reimbursement)","")}W‚P9H  „0 uüEcatYTDamt}W‚P˝(  „2wüEcatYTDhrs{C‚P2[ „|Á€Z& ˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(PRDEDS->COMPANY+PRDEDS->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")}V‚P˘ Kó „0 ”üChkYTDded}W‚P9H „2 ”üDcatYTDAmt|{‚Pć ó Œ0DetOrdiif(scanning(Prearn),1,iif(scanning(Prtaxes),2,3))|‚P” Yó Œ0ScanYTDcase(DetOrd, 1,PREARN->YTDAMOUNT, 2,PRTAXES->YTDAMOUNT, 3,PRDEDS->YTDAMOUNT, 0)|‘‚Pâ ó ˆscanTypecase(DetOrd, 1,PREARN->TYPE, 2,PRTAXES->TYPE, 3,PRDEDS->TYPE, " "){C‚P2ľ ­{C‚P9H 2 ˛| €Z& ˆ€ _TAXTYPETax Table TypeCASE(PRTAXES->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "")|ž‚Pâ ó ˆ@scanCodecase(DetOrd, 1,PREARN->EARNCODE, 2,PRTAXES->TAXCODE, 3,PRDEDS->DEDCODE, " ")|t‚Pâ ó ˆscanCatcase(DetOrd, 1,"E", 2,"T", 3,"D", " ")|ˇ‚Pâ ó ˆ@DetailLinkprckhist->EMPNO + prckhist->COMPANY + str(prckhist->CHKGROUP,2) + PRCKHIST->CHKNUMBER + scanCat + scanCode}V‚P9H „0 üCatYTDamt}V‚PŐHw „€2 ´üCatYTDwag}g‚P HĄ  „€0 ´üTAXCODE = "FED "ChkYTDfwag}V‚P˘ Kó „2 ˛üChkYTDtaxG”8EMPNO+COMPANY+STR(CHKGROUP,2)+CHKNUMBER+DETAILTYPE+CODEoE DetailLinkprDeHist.DBFC:\Temp\1003268\prDeHist.rrxprDeHistzF‚PH  2 AMOUNTzG‚P& ‚ĄCHADATEzH‚P& €0CHKCOUNTzH‚P& €0CHKGROUPzI‚PČ-  CHKNUMBERzD‚Pâ ó @CODEzG‚Pâ ó @COMPANYzJ‚P& €0DEDUCTIONSzJ‚Pâ ó DETAILTYPEzE‚Pâ ó @EMPNOzF‚P& €0ERLIABzH‚P& €PAYGROUPzD‚P& €TYPEzE‚PO.  2UNITSzH‚PďHj !€2 WAGEBASE{C‚PH  "2 {C‚PH  #2 {C‚PO.  $2 {C‚PH  %2 {C‚PH &2 {C‚PGH '2 |y€d& (ˆ€ _CODEEarning or Deduction DescriptionIIf(IIf(CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"Y"+"_ENT_","COMPANY","PRCODES.DBF","PRCODES.CDX","COMPTYPECD")=prDeHist->COMPANY,.T.,.F.), CLOOKUP("***"+prDeHist->DETAILTYPE+"N"+prDeHist->CODE+"","STUBDESC","PRCODES.DBF","PRCODES.CDX","COMPTYPECD"),IIf(IIf(CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"Y"+"_CO_","COMPANY","PRCODES.DBF","PRCODES.CDX","COMPTYPECD")=prDeHist->COMPANY,.T.,.F.), CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"N"+prDeHist->CODE+"","STUBDESC","PRCODES.DBF","PRCODES.CDX","COMPTYPECD"),""))|¨€d& )ˆ€ _DETAILTYPDetail TypeCASE(prDeHist->DETAILTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|Ĺ€d& *ˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(prDeHist->COMPANY+prDeHist->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|˛€d& +ˆ€ _TYPECheck TypeCASE(prDeHist->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")}V‚PH ,„2 üCatCurAmt}V‚PďHw -„€2 !üCatCurWag}V‚PO. .„2 üCatCurHrs|Ÿ‚Pâ ó /ˆ@ScanDesccase(DetOrd, 1,PREARN->DESCRIPT, 2,PRTAXES->TAXDESC, 3,PRDEDS->DESCRIPT, " ")|¤‚Pd  0ˆ1 ShowWHiif(inlist(TAXCODE,"FED ","NY ","NJ-A","NJ-B"),MARSTATUS+"-"+ltrim(str(EXEMPTCNT,2,0)),""){C‚Pd 1Š10|ˇ‚Pâ ó 2ˆ@PostLinkiif(DETAILTYPE="E",prDeHist->EMPNO+prDeHist->COMPANY+"E"+prDeHist->CODE+str(prckhist->CHKGROUP,2),space(19))G”3EMPNO+COMPANY+POSTTYPE+POSTCODE+ STR(CHKGROUP,2,0)o@ PostLinkprHPost.DBFC:\Temp\1003268\prhpost.rrxprhpostzH‚Z& 3€0ALLOCCNTzH‚Z& 4€ALLOCINDzH‚Z& 5€0ALLOCORDzH‚Z& 6€0ALLOCSETzF‚Z& 7€0AMOUNTzJ‚Z& 8€0ARREARSAMTzI‚Z& 9ATTPOSTEDzH‚Z& :€CALCRULEzG‚Z& ;‚ĄCHADATEzJ‚Z& <‚ĄCHARGEDATEzG‚Z& =‚ĄCHKDATEzH‚Z& >€0CHKGROUPzI‚Z& ?€CHKNUMBERzG‚Pâ ó @@COMPANYzJ‚Z& A€0DEDUCTIONSzH‚Z& B€DESCRIPTzE‚Z& C€ EMPNOzF‚Z& D€0ERLIABzG‚Z& E€JOBCODEzI‚Pâ ó F@ORGLEVEL1zI‚Pâ ó G@ORGLEVEL2zI‚Z& H€ ORGLEVEL3zI‚Z& I€ ORGLEVEL4zI‚Z& J€ ORGLEVEL5zH‚Z& K€PAYGROUPzG‚Z& L€0 PAYRATEzH‚Z& M€POSTCODEzH‚Z& N€POSTTYPEzJ‚Z& O€0 PREVARREARzG‚P[* P€PROJECTzH‚Z& Q€0 QUANTITYzI‚Z& RRETROINCLzE‚Z& S€SHIFTzI‚Z& TSHIFTINCLzF‚Z& U€SOURCEzF‚Z& V€STATUSzG‚Z& W€TAXTYPEzD‚Z& X€TYPEzH‚Z& Y€0WAGEBASEzH‚Z& Z€WORKCODE|s€d& [ˆ€ _JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(prhpost->COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + prhpost->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "JC" + "N" +prhpost->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|n€d& \ˆ€ _ORGLEVEL1DivisionIIf(IIf(CLOOKUP(prhpost->COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + prhpost->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L1" + "N" + prhpost->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|p€d& ]ˆ€ _ORGLEVEL2DepartmentIIf(IIf(CLOOKUP(prhpost->COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + prhpost->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L2" + "N" + prhpost->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|n€d& ^ˆ€ _ORGLEVEL3LocationIIf(IIf(CLOOKUP(prhpost->COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + prhpost->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L3" + "N" + prhpost->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|q€d& _ˆ€ _ORGLEVEL4Not DefinedIIf(IIf(CLOOKUP(prhpost->COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + prhpost->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L4" + "N" + prhpost->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|q€d& `ˆ€ _ORGLEVEL5Not DefinedIIf(IIf(CLOOKUP(prhpost->COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + prhpost->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L5" + "N" + prhpost->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ă€d& aˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(prhpost->COMPANY+prhpost->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|Ľ€d& bˆ€ _POSTTYPEPosting TypeCASE(prhpost->POSTTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|b€d& cˆ€ _SHIFTWork ShiftIIf(IIf(CLOOKUP(prhpost->COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +prhpost->SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "SF" + "N" + prhpost->SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ł€d& dˆ€ _TAXTYPETax Table TypeCASE(prhpost->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "n/a")|ą€d& eˆ€ _TYPECheck TypeCASE(prhpost->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")|€d& fˆ€ _WORKCODEWork State For Posting RecordIIf(IIf(CLOOKUP(prhpost->COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + prhpost->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "ST" + "N" +prhpost->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|ş‚Pâ ó gˆ@ CDivDescCLOOKUP(prhpost->COMPANY+"L1"+"N"+prhpost->ORGLEVEL1+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|ť‚Pâ ó hˆ@ CCustDescCLOOKUP(prhpost->COMPANY+"L2"+"N"+prhpost->ORGLEVEL2+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")}d‚ZĚąD i€hüCCustDesc<>" "ChkCust}b‚ZŒąD j€güCDivDesc<>" "ChkDiv}k‚PH k„2 üprDeHist->AMOUNT <> 0DedDtlAmt|‹‚P"  lŒ2 PdAtRateIIf(prDeHist->UNITS <> 0, prDeHist->AMOUNT / prDeHist->UNITS, 0)|v‚PŇ“  mˆChkDtlMtchPRCKHIST->CHKNUMBER = prDeHist->CHKNUMBER{C‚P9H n†0 {C‚P9H o†0 {C‚PH p†2 ,{C‚PH q†2 ,{C‚P˝(  r†2{C‚P9H  s†0 |]€Z& tŒˆ0ţPage_rrPage numberPAGENO()|f€Z& uŒ„0ţRecno_rrReport record numberRECNO()|l‚P:H vĚ0 ChkYTDnetChkYTDcash-(ChkYTDtax+ChkYTDded)  <<€0 SUTAGROSSzG‚Z& ?€0 SUTATAXzE‚P…HĄ @€0 TAXESzJ‚Z& A€0 TAXONLYPAYzJ‚PŸHĄ B€0 TOTALGROSSzD‚Pşó CTYPEzI‚Z& D€0 WORKGROSSzG‚Z& E€0 WORKTAX{C‚Z*I´ R{C‚d KÔ S|Ĺ€d# Tˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(PRCKHIST->COMPANY+PRCKHIST->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|˛€d# Uˆ€_TYPECheck TypeCASE(PRCKHIST->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")Go&"˙ CtrlLinkPRTCTRL.DBF˙PRTCTRLzG‚x' V€COMPSELzG‚x' W€PGRPSELzG‚x' X€0FORMSELzH‚x' Y€LASTGOODzG‚x' ZREPRINTG p6 EMPNOhrpersnl.DBFhrPersnl.CDXEMPNOHRPERSNLzJ‚x' [!P_ACCUMCURzH‚x' \€P_ACTIVEzI‚x' ]€P_ALLOCBYzH‚x' ^€0P_ANNUALzJ‚x' _‚ĄP_ANYCHANGzI‚x' `€P_AUTOHOLzI‚x' a€P_AUTOILLzI‚x' b!P_AUTOPAYzI‚x' c€P_AUTOPERzI‚x' d€P_AUTOREGzI‚x' e€P_AUTOVACzI‚x' f‚ĄP_BEN_EXPzG‚x' g‚ĄP_BIRTHzG‚x' h€P_BONUSzJ‚x' i€0 P_BONUSAMTzH‚x' j€P_BUSEXTzJ‚x' k€ P_BUSPHONEzJ‚x' l€ P_CELLULARzJ‚x' m€0P_CFICATIPzI‚x' n‚ĄP_CHADATEzI‚x' o€ P_CITIZENzG‚x' p€P_COBRAzI‚Pó qP_COMPANYzJ‚x' r€0P_COMPARATzI‚x' s€0P_CURTIPSzJ‚x' t€0P_DEPINSURzI‚x' u€0P_DEPNDTSzI‚x' v€P_DISAVETzJ‚Z& w‚ĄP_DISCHARGzJ‚x' x€P_EEOCLASSzI‚x' y‚ĄP_EFFDATEzE‚x' z!P_EICzJ‚x' {€P_EICMSTATzJ‚x'@ |€@P_EMPEMAILzH‚x' }€P_EMPLOYzG‚Z†At ~ P_EMPNOzI‚x' €P_EMPTYPEzH‚x' €€P_EXEMPTzG‚x' €P_FCITYzJ‚x' ‚€ P_FCOUNTRYzI‚x' ƒ€P_FCOUNTYzG‚PvWó „P_FNAMEzH‚x' …€P_FSTATEzJ‚x' †€P_FSTREET1zJ‚x' ‡€P_FSTREET2zJ‚x' ˆ€P_FUNCTIONzF‚x' ‰€ P_FZIPzF€d#$ Š€$P_GUIDzJ‚x' ‹€P_HANDICAPzG‚PÚ{ó ŒP_HCITYzJ‚x' € P_HCOUNTRYzI‚x' Ž€P_HCOUNTYzH‚x' € P_HPHONEzH‚P>ó P_HSTATEzJ‚P˘Ťó ‘P_HSTREET1zJ‚P Ťó ’P_HSTREET2zF‚Pj ?ó “ P_HZIPzI‚x' ”‚ĄP_I9RENEWzI‚x' •€P_I9VERIFzI‚x' –€0 P_ILLACCRzJ‚x' —€0 P_ILLCARRYzJ‚x' ˜€0 P_ILLCLOSEzH‚x' ™€P_ILLINDzI‚x' š€0 P_ILLRATEzJ‚x' ›€0 P_ILLTAKENzH‚x' œ€ P_JMISC1zH‚x' €P_JMISC2zH‚x' ž€0 P_JMISC3zH‚x' Ÿ€0 P_JMISC4zI‚x'  €P_JOBCODEzI‚x' Ą‚ĄP_JOBDATEzJ‚x' ˘€P_JOBGROUPzJ‚P"—& Ł€P_JOBTITLEzJ‚x' ¤€P_LABORINDzI‚x' Ľ‚ĄP_LASTCHKzJ‚x' Ś‚ĄP_LASTHIREzJ‚x' §‚ĄP_LEAVERETzH‚PÎ ó ¨@P_LEVEL1zH‚Pâ ó Š@P_LEVEL2zH‚x' Ş€ P_LEVEL3zH‚x' Ť€ P_LEVEL4zH‚x' Ź€ P_LEVEL5zG‚Pâ ó ­@P_LNAMEzH‚x' Ž€0 P_LNORMUzJ‚x' Ż€ P_LOCATIONzJ‚x' °‚ĄP_LPAYDATEzJ‚x' ą€P_LPAYFREQzI‚x' ˛€0P_LSALARYzJ‚x' ł‚ĄP_LSTPAYDTzH‚x' ´€0 P_LUNITRzJ‚x' ľ€P_MAILSTOPzI‚x' ś€P_MARRIEDzD‚Pâ ó ˇ@P_MIzJ‚x' ¸€ P_MILITARYzG‚x' š€P_MISC1zG‚x' ş€ P_MISC2zG‚x' ť€P_MISC3zG‚x' ź€0 P_MISC4zI‚x' ˝‚ĄP_NEXTPAYzJ‚x' ž‚ĄP_NEXTPERFzJ‚x' ż€P_NICKNAMEzJ‚x' Ŕ€0 P_NORMUNITzG‚x'P Á€PP_NOTESzJ‚x' ‚ĄP_ORIGHIREzI‚x' Ă€0 P_OTHERIDzJ‚x' ĀP_OTHERVETzG‚x' ŀ P_PAGERzI‚x' ƂĄP_PAYDATEzI‚x' ǀP_PAYFREQzJ‚x' ȀP_PAYGROUPzI‚x' ɀP_PAYSTATzI‚x' ʁ!P_PENSIONzI‚x' Ë€0 P_PERACCRzJ‚x' Ě€0 P_PERCARRYzJ‚x' Í€0 P_PERCLOSEzJ‚x' ΂ĄP_PERFDATEzH‚x' πP_PERINDzI‚x' Đ€0 P_PERRATEzJ‚x' Ń€0 P_PERTAKENzJ‚x' Ň€0 P_QFICATIPzJ‚x' Ó€0P_QTDUNTAXzJ‚x' Ô€0 P_QTIPALLOzJ‚x' Ő€0 P_QTIPSREPzF‚x' րP_RACEzH‚x' ׀P_RATINGzH‚x' ؀P_REASONzH‚x' ـP_RECALCzI‚x' ڀP_RECRUTRzH‚x' ۀP_REHIREzH‚PXN& Ü€0P_SALARYzJ‚x' ݀P_SALGRADEzI‚x' ހP_SALHOURzG‚x' ߀P_SALUTzJ‚x' ŕ€P_SEASONALzI‚x' ႡP_SENDATEzE‚x' â€P_SEXzG‚x' ă€P_SHIFTzJ‚x' ä€0P_SHIFTPREzH‚x' ĺ€P_SMOKERzH‚x' ć€P_SOURCEzE‚ZOt ç P_SSNzI‚x' č!P_STATUTEzH€x' é€P_SUP2COzJ€x'@ ę€@P_SUP2MAILzH€x' ë€ P_SUP2NOzI€x' ě€P_SUP2VISzJ‚x'@ í€@P_SUPEMAILzI€x' î€P_SUPERCOzI‚x' ď€ P_SUPERNOzJ‚x' đ€P_SUPERVISzI€d# ń€P_SYNCBPSzJ‚x' ň‚ĄP_TERMDATEzJ‚x' ó€P_TERMREASzJ‚x' ô€P_TERMTYPEzH‚x' ő€P_TSTAMPzI‚x' ö€P_UNIONCDzI‚x' ÷‚ĄP_UNIONDTzI‚x' ř€P_UNITPAYzJ‚x' ů€0 P_UNITRATEzI‚x' ú€0 P_VACACCRzJ‚x' ű€0 P_VACCARRYzJ‚x' ü€0 P_VACCLOSEzH‚x' ý€P_VACINDzI‚x' ţ€0 P_VACRATEzJ‚x' ˙€0 P_VACTAKENzI‚x' €P_VIETNAMzI‚x' ‚ĄP_VISAEXPzJ‚x' € P_VISATYPEzJ‚x' €P_WORKCODEzJ‚x' €P_WORKCOMPzJ‚x' €0P_WORKRATEzJ‚x' €0 P_YFICATIPzJ‚x' €0P_YTDUNTAXzJ‚x' €0 P_YTIPALLOzJ‚x' €0 P_YTIPSREP|Ô€d# ˆ€_ACTIVEActive (Active/Terminated/etc)CASE(HRPERSNL->P_ACTIVE, "A", "Active", "T", "Terminated", "O", "On Leave", "D", "Deceased", " ")|¤€d# Œ€0_AN1000Annual Pay Rounded to ThousandROUND(ROUND((HRPERSNL->P_ANNUAL + 499.999)/1000, 0)*1000, 2)|q€d# Œ€0_ANNUALEmployee's Annual PayHRPERSNL->P_ANNUAL|ł€d# ˆ€ _COBRAAutomatically Add for COBRA (Yes/No)CASE(HRPERSNL->P_COBRA, "Y", "Yes", "N", "No", "P", "Pending", "n/a")|œ€d# ˆ€_DISAVETDisabled Veteran (Yes/No)CASE(HRPERSNL->P_DISAVET, "Y", "Yes", "N", "No", "n/a")|‰€d# ˆ€_EEOCLASSEEO ClassificationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "EE" + "N" +HRPERSNL->P_EEOCLASS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "EE" + "N" + HRPERSNL->P_EEOCLASS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|‚€d# ˆ€_EMPLOYEmployment StatusIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "EM" + "N" +HRPERSNL->P_EMPLOY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "EM" + "N" + HRPERSNL->P_EMPLOY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ź€d# ˆ€_EXEMPTExempt Status (Exempt/Non-Exempt)CASE(HRPERSNL->P_EXEMPT, "Y", "Exempt", "N", "Non-Exempt", "n/a")|‰€d# ˆ€_FSTATEForwarding Address StateIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + HRPERSNL->P_FSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "N" +HRPERSNL->P_FSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|v€d# ˆ€_HSTATEStateIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + HRPERSNL->P_HSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ST" + "N" +HRPERSNL->P_HSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|¸€d# ˆ€_I9VERIFI-9 Verification on File? (Yes/No/Pend)CASE(HRPERSNL->P_I9VERIF, "ý˙˙˙      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€Y", "Yes", "N", "No","P", "Pending", "n/a")|ˆ€d# ˆ€_JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + HRPERSNL->P_JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "JC" + "N" +HRPERSNL->P_JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|„€d# ˆ€_JOBGROUPEEO Job GroupIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "JG" + "N" + HRPERSNL->P_JOBGROUP + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "JG" + "N" +HRPERSNL->P_JOBGROUP + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|z€d# ˆ€_LEVEL1DivisionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + HRPERSNL->P_LEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L1" + "N" + HRPERSNL->P_LEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))||€d# ˆ€_LEVEL2DepartmentIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + HRPERSNL->P_LEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L2" + "N" + HRPERSNL->P_LEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|z€d# ˆ€_LEVEL3LocationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + HRPERSNL->P_LEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L3" + "N" + HRPERSNL->P_LEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|}€d# ˆ€_LEVEL4Not DefinedIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + HRPERSNL->P_LEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L4" + "N" + HRPERSNL->P_LEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|}€d# ˆ€_LEVEL5Not DefinedIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + HRPERSNL->P_LEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "L5" + "N" + HRPERSNL->P_LEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|ƒ€d# ˆ€_LOCATIONWork LocationIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "LO" + "N" +HRPERSNL->P_LOCATION+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "LO" + "N" + HRPERSNL->P_LOCATION + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ý€d# ˆ€ _MARRIEDMarital Status (Married/Single/etc)CASE(HRPERSNL->P_MARRIED, "M", "Married", "S", "Single","W", "Widowed", "D", "Divorced", "O", "Other", " n/a")|j€d#& ˆ€&_NAME1Name: Last, First MiddleRTRIM(HRPERSNL->P_LNAME)+IIF(ISBLANK(HRPERSNL->P_FNAME), "", IIF(NOT ISBLANK(HRPERSNL->P_LNAME),"," +RTRIM(HRPERSNL->P_FNAME),""+RTRIM(HRPERSNL->P_FNAME)))+ IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_MI), "", IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_LNAME), LEFT(HRPERSNL->P_MI, 1), IIF(ISBLANK(HRPERSNL->P_LNAME) AND NOT ISBLANK(HRPERSNL->P_FNAME), " ",IIF(ISBLANK(HRPERSNL->P_FNAME) AND NOT ISBLANK(HRPERSNL->P_LNAME), ", "+LEFT(HRPERSNL->P_MI,1), IIF(NOT ISBLANK(HRPERSNL->P_FNAME)," ", "")+LEFT(HRPERSNL->P_MI,1)))))|Z€d#& ˆ€&_NAME2Name: First Middle LastRTRIM(HRPERSNL->P_FNAME)+IIF(ISBLANK(HRPERSNL->P_MI), " ",IIF(ISBLANK(HRPERSNL->P_FNAME), LEFT(HRPERSNL->P_MI, 1), " "+ LEFT(HRPERSNL->P_MI, 1)))+ IIF(ISBLANK(HRPERSNL->P_FNAME+HRPERSNL->P_MI), RTRIM(HRPERSNL->P_LNAME)," "+ RTRIM(HRPERSNL->P_LNAME))|˝€d# ˆ€_PAYFREQPay FrequencyCASE(HRPERSNL->P_PAYFREQ, "W", "Weekly", "B", "Biweekly","S", "Semi-Monthly", "M", "Monthly", " ")|n€d# !ˆ€_RACERaceIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "ET" + "N" +HRPERSNL->P_RACE+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "ET" + "N" + HRPERSNL->P_RACE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|‰€d# "ˆ€_RATINGPerformance Review RatingIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RT" + "N" +HRPERSNL->P_RATING+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RT" + "N" + HRPERSNL->P_RATING + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|~€d# #ˆ€_REASONAbsence ReasonIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RE" + "N" +HRPERSNL->P_REASON+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "N" + HRPERSNL->P_REASON + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d# $ˆ€_REHIRERehire (Yes/No)CASE(HRPERSNL->P_REHIRE, "Y", "Yes", "N", "No", "n/a")|‚€d# %ˆ€_SALGRADESalary GradeIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "SG" + "N" +HRPERSNL->P_SALGRADE+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "SG" + "N" + HRPERSNL->P_SALGRADE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|–€d# &ˆ€_SALHOURSalary or HourlyCASE(HRPERSNL->P_SALHOUR, "S", "Salary", "H", "Hourly", "")|œ€d# 'ˆ€_SEASONALSeasonal Worker (Yes/No)CASE(HRPERSNL->P_SEASONAL, "Y", "Yes", "N", "No", "n/a")|›€d# (ˆ€_SEXGender (Male/Female/Unknown)CASE(HRPERSNL->P_SEX, "F", "Female", "M", "Male", "n/a")|w€d# )ˆ€_SHIFTWork ShiftIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +HRPERSNL->P_SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "SF" + "N" + HRPERSNL->P_SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d# *ˆ€_SMOKERSmoker (Yes/No)CASE(HRPERSNL->P_SMOKER, "Y", "Yes", "N", "No", "n/a")|ˆ€d# +ˆ€_TERMREASTermination ReasonIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "RE" + "N" +HRPERSNL->P_TERMREAS+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "RE" + "N" + HRPERSNL->P_TERMREAS + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|§€d# ,ˆ€_TERMTYPETermination TypeCASE(HRPERSNL->P_TERMTYPE, "V", "Voluntary", "I", "Involuntary", "Unknown")|x€d# -ˆ€_UNIONCDUnionIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "UC" + "N" +HRPERSNL->P_UNIONCD+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "UC" + "N" + HRPERSNL->P_UNIONCD + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|€d# .ˆ€_UNITPAYUnits of PayIIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP("***" + "UP" + "N" +HRPERSNL->P_UNITPAY+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = HRPERSNL->P_COMPANY, True, False), CLOOKUP(HRPERSNL->P_COMPANY + "UP" + "N" + HRPERSNL->P_UNITPAY + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ą€d# /ˆ€DEDLINKCLinking field for Catchup 401(k)HRPERSNL->P_EMPNO + HRPERSNL->P_COMPANY + 'CUP ' + 'H'Gp; COMPANYsyemploy.DBFsyemploy.CDXEMPLOYERSYEMPLOYzJ‚Pâ ó 0@E_ADDRESS1zJ‚x' 1€ E_ADDRESS2zI‚x' 2€0E_AGEWARNzH‚x' 3!E_ATABRAzJ‚x' 4!E_ATACCRUEzG‚x' 5€0E_ATDECzI‚x' 6€E_ATUNITSzG‚x' 7€E_AUDITzI‚x' 8€E_BANKCLRzJ‚x' 9€ E_BANKPHONzJ‚x' :!E_BENEABRAzI€d# ;‚ĄE_BPSSYNCzH‚x' <€0E_CASENOzF‚Pâ ó =@E_CITYzI‚x' >€E_COMPANYzI‚x' ?€E_CONTACTzI‚x' @€E_COUNTRYzH‚x' A€E_COUNTYzJ‚x' B€ E_DESTROUTzG‚x'# C€#E_EMAILzE‚x' D€ E_FAXzG‚x' E€ E_FEDIDzI‚x' F€ E_FIELDSWzI‚x' G‚ĄE_FISC_YRzI‚x' H€0E_GLJOBCDzH‚x' I€0E_GLMAINzH‚x' J€0E_GLORG1zH‚x' K€0E_GLORG2zH‚x' L€0E_GLORG3zH‚x' M€0E_GLORG4zH‚x' N€0E_GLORG5zH‚x' O€0E_GLPROJzH‚x' P€E_ILLINDzI‚x' Q€0 E_ILLRATEzF‚x' R€E_J250zJ‚x' S€E_JAPPRENTzH‚x' T€E_JCCITYzJ‚x' U€E_JCCOUNTYzG‚x' V€E_JCITYzH‚x'# W€#E_JCNAMEzJ‚x'2 X€2E_JCONTACTzJ‚x' Y€ E_JCONTROLzH‚x' Z€E_JCONUMzI‚x' [€E_JCOUNTYzI‚x' \€ E_JCPHONEzI‚x' ]€E_JCSTATEzJ‚x'# ^€#E_JCSTREETzI‚x' _€E_JCTITLEzI‚x' `€E_JCVALIDzG‚x' a€ E_JCZIPzG‚x' b€ E_JDUNSzG‚x'P c€PE_JINFOzI‚x' d€E_JLASTYRzH‚Z& e€E_JNAICSzG‚x'# f€#E_JNAMEzF‚x' g€E_JSICzH‚x' h€E_JSTATEzI‚x'# i€#E_JSTREETzG‚x' j€E_JTESTzH‚x' k€E_JTITLEzG‚x' l€E_JTYPEzG‚x' m€E_JUNITzF‚x' n€ E_JZIPzJ‚x' o‚ĄE_LASTPAIDzH‚x' p€E_METHODzG‚x' q€E_MISC1zG‚x' r€E_MISC2zG‚x' s€E_MISC3zG‚x' t€E_MISC4zG‚x' u€E_MISC5zG‚x' v€E_MISC6zG‚x' w€E_MISC7zG‚x' x€E_MISC8zF‚Pâ ó y@E_NAMEzJ‚x' z€0 E_NORMUNITzI‚x' {€E_NUMERICzJ‚x' |€ E_ORIGROUTzI‚x' }€E_PAYFREQzH‚x' ~€0E_PAYNUMzH‚x' €E_PERINDzI‚x' €€0 E_PERRATEzG‚x' € E_PHONEzJ‚x' ‚€0E_POSITIONzH‚x' ƒ‚ĄE_QTRENDzI‚x' „€E_SGVALIDzH‚x' …€E_SIGOPTzG‚Pâ ó †@E_STATEzJ‚x' ‡!E_TRAINENTzH‚x' ˆ€E_VACINDzI‚x' ‰€0 E_VACRATEzE‚Pâ ó Š@E_ZIP{C‚ZĚ# ‹#y{C‚Z⸠Œ 0{C‚Z¸¨ ={C€Zܨ Ž†{C€ZH¨  Š{C‚Œ‚Ô# #y|„€d# ‘ˆ€_JCSTATEEEO Report StateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_JCSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_JCSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ž€d# ’ˆ€_JSTATEEEO Parent/Jurisdiction StateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_JSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_JSTATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|s€d# “ˆ€_STATEStateIIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + SYEMPLOY->E_STATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = SYEMPLOY->E_COMPANY, True, False), CLOOKUP(SYEMPLOY->E_COMPANY + "ST" + "N" +SYEMPLOY->E_STATE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|`‚P +ó ”Œ CKnumval(prckhist->CHKNUMBER){C‚ZŇ2´ •Ž ”{C€dŒO –Ž”{C‚ŒnNÔ —Ž ”|o‚Pâ ó ˜ˆ@PgrpLinkprckhist->COMPANY+prckhist->PAYGROUPGp= PgrpLinkprpaygrp.DBFprpaygrp.CDXCOMPGROUPprpaygrpzF‚Z& ™ACCILLzF‚Z& šACCPERzF‚Z& ›ACCVACzG‚Z& œ€ACHFLAGzH‚Pâ ó @BANKACCTzI‚Z& ž€BANKACCT2zI‚P ]ó Ÿ!BANKCLEARzH‚Pâ ó  @BANKNAMEzI‚Pâ ó Ą@BANKROUTEzH‚Z& ˘€CASHACCTzI‚Z& Ł€CASHJOBCDzH‚Z& ¤€CASHORG1zH‚Z& Ľ€CASHORG2zH‚Z& Ś€CASHORG3zH‚Z& §€CASHORG4zH‚Z& ¨€CASHORG5zH‚Z& Š€CASHPROJzI‚Z& Ş‚ĄCHECKDATEzJ‚Z&P Ť€PCHKMESSAGEzI‚Z& Ź€CHKNUMBERzI‚Z& ­€0CHKOFFSETzJ‚Z& Ž€0CHKOFFSET2zH‚Z& Ż€CHKPRINTzH‚Z&# °€#CHKSTOCKzG‚Z& ą€COMPANYzJ‚Z& ˛€CURRENTQTRzH‚Z& ł€DDAPRINTzF‚Z& ´€DDDESCzG‚Z&# ľ€#DDSTOCKzI‚Z& ś€DEPNUMBERzH‚Z& ˇ€DESCRIPTzH‚Z& ¸FINALPAYzJ‚Z& šFINALQTRCLzJ‚Z& ş€GLDISTFLGSzH‚Z& ťINACTIVEzJ‚Z& źINCRPAYNUMzJ‚Z&I& ˝‚LASTPERIODzJ‚Z& ž€0MICROFFSETzH‚Z& żOVERFLOWzJ‚Z& ŔOVERRIDEDDzG‚Z& Á€PAYFREQzH‚Z& €PAYGROUPzI‚Z& Ă€0PAYNUMBERzI‚Z&P Ä€PPRINTEXPRzH‚Z& Ĺ‚ĄPROCDATEzI‚Z& ƁPROCESSONzH‚Z& Ç€PROCTIMEzH‚Z& Č€ PROCTYPEzH‚Z& É€ PROCUSERzH‚Z& ʁPROJECTSzH‚Z& Ë€ PROJNAMEzJ‚Z& Ě‚ĄQTRENDDATEzF‚Z& ́RECALCzD‚Z& ΀RULEzJ‚Z& Ď€SAVEDFLAGSzI‚Z& Đ€STOCKDESCzH‚Z&P Ń€PTIMEEXPRzH‚Z& Ň€TIMESRCHzJ‚Z& Ó‚ĄTRIALCHECKzH‚Z& ԁTRIALPAYzI‚Z&Iœ ŐTRIALPENDzJ‚Z& ցTRIALQTRCLzG‚Z& ×€0TSALLOCzH‚Z& Ř€0TSCHRGDTzH‚Z& Ů€0TSEARNCDzG‚Z& Ú€0TSHOURSzG‚Z& Ű€0TSJOBCDzF‚Z& Ü€0TSORG1zF‚Z& Ý€0TSORG2zF‚Z& Ţ€0TSORG3zF‚Z& ߀0TSORG4zF‚Z& ŕ€0TSORG5zE‚Z& á€0TSPAYzF‚Z& â€TSPICTzF‚Z& ă€0TSPROJzG‚Z& ä€0TSSHIFTzG‚Z& ĺ€0TSTAXCD{C‚Pr—Ě ć {C‚P^ZÄ ç!Ÿ{C€dJ1 č Ą|Ÿ€d# 鈀_FINALPAYFinal Payroll Status (Yes/No)CASE(prpaygrp->FINALPAY,.T., "True", .F., "False", "")|¨€d# ęˆ€_FINALQTRCFinal Quarter Close Status (Yes/No)CASE(prpaygrp->FINALQTRCL,.T., "True", .F., "False", "")| €d# 눀_OVERFLOWPrint Overflow Checks (Yes/No)CASE(prpaygrp->OVERFLOW,.T., "True", .F., "False", "")|Ÿ€d# ěˆ€_TRIALPAYTrial Payroll Status (Yes/No)CASE(prpaygrp->TRIALPAY,.T., "True", .F., "False", "")|Ť€d# 툀_TRIALQTRCTrial Quarter Close Attempted (Yes/No)CASE(prpaygrp->TRIALQTRCL,.T., "True", .F., "False", "")|k‚Pâ ó îˆ@RegLinkprckhist->EMPNO+prckhist->COMPANY|m‚P– Wó ďˆ!IsZeroiif(CHKAMOUNT=0,"NON-NEGOTIABLE",""){C‚ @Ž( đŠ!ď|a‚PÚ ó ńŒ0ChkCentsMOD(CHKAMOUNT*100,100)||‚Pâ ó ňˆ@ShowCentiif(ChkCents=0,"00/100",str(ChkCents,2,0)+"/100")|Š‚ZŒą\ óˆ€HDivDescCLOOKUP(P_COMPANY+"L1"+"N"+P_LEVEL1+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|Ş‚ZĚą\ ôˆ€HCustDescCLOOKUP(P_COMPANY+"L2"+"N"+P_LEVEL2+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|s‚Zńt őˆEmpNametrim(P_LNAME)+", "+trim(P_FNAME)+" "+P_MI|m‚Pâ ó öˆ@ShowAmtSTRREP(str(CHKAMOUNT,10,2)," ","*"){C‚ZXO” ÷Š ö|˝‚Pâ ó řˆ@BnkAcctShoLeft(prpaygrp->BANKACCT, 4) + " " + SubStr(prpaygrp->BANKACCT, 5, 2) + " " + SubStr(prpaygrp->BANKACCT, 7, 15){C€dţw ůŠř|i‚Pâ ó úˆ@NameShowUpper(P_FNAME - " " + P_LNAME){C‚ndD( űŠ(ú|o‚Pâ ó üˆ@AddrShowUpper(P_HSTREET1 - "/" + P_HSTREET2){C‚nd4( ýŠ(ü||‚Pâ ó ţˆ@CSZShowEEUpper(P_HCITY - ", " + P_HSTATE - " " + P_HZIP){C‚nd˙$$ ˙Š$ţ|]‚Pâ ó ˆ@ERAddrShoUpper(E_ADDRESS1){C‚ZâÄ Š |‚Pâ ó ˆ@CSZShoERUpper(E_CITY - ", " + E_STATE - " " + Left(E_ZIP, 5)){C‚Z´% Š%|Œ‚Pŕ ó Œ0SplAmtLnthLen(Upper(SpellNum(CHKAMOUNT))+" AND " + ShowCent + " DOLLARS")|Ś‚P&â ó ˆ@ChkAmtREPLICATE("* ", 55 - SplAmtLnth) - Upper(SpellNum(CHKAMOUNT))+" AND " + ShowCent + " DOLLARS"{C‚n&Z't7 Š7|k‚Pâ ó ˆ@BankAddrLk"***" + "BK" + "N" + BANKROUTEGp? BankAddrLkhrtables.dbfhrtables.CDXTABLECODEBankInfozB‚P& €C1zB‚P& €C2zB‚P& €C3zB‚P& €C4zD‚P& €CODEzG‚P& €COMPANYzD‚P& €DESCzF‚P& €GLCOMPzB‚P& €0N1zB‚P& €0N2zB‚P& €0 N3zD‚P& €RULEzE‚P& €TABLEzF‚P& €TCCOMPzC‚Pâ ó @UD1zC‚Pâ ó @UD2zC‚P& €UD3{C‚Pr—Ŕ {C‚Pr—´ |–€d# ˆChkBtchLnkPRCKHIST->EMPNO + PRCKHIST->COMPANY + DtoC(PRCKHIST->CHARGEDATE, 1) + "E"Gp9 ChkBtchLnkprHPost.DBFprHPost.CDXEMPNOBatchInfzH‚d& €0ALLOCCNTzH‚d& €ALLOCINDzH‚d& €0ALLOCORDzH‚d& €0ALLOCSETzF‚d& €0AMOUNTzJ‚d& !€0ARREARSAMTzI‚d& "ATTPOSTEDzH‚d& #€CALCRULEzG‚d& $‚ĄCHADATEzJ‚d& %‚ĄCHARGEDATEzG‚d& &‚ĄCHKDATEzH‚d& '€0CHKGROUPzI‚d& (€CHKNUMBERzG‚d& )€COMPANYzJ‚d& *€0DEDUCTIONSzH‚d& +€DESCRIPTzE‚d& ,€ EMPNOzF‚d& -€0ERLIABzG‚d& .€JOBCODEzI‚d& /€ ORGLEVEL1zI‚d& 0€ ORGLEVEL2zI‚d& 1€ ORGLEVEL3zI‚d& 2€ ORGLEVEL4zI‚d& 3€ ORGLEVEL5zH‚d& 4€PAYGROUPzG‚d& 5€0 PAYRATEzH‚d& 6€POSTCODEzH‚d& 7€POSTTYPEzJ‚d& 8€0 PREVARREARzG‚P[¨ 9PROJECTzH‚d& :€0 QUANTITYzI‚d& ;RETROINCLzE‚d& <€SHIFTzI‚d& =SHIFTINCLzF‚d& >€SOURCEzF‚d& ?€STATUSzG‚d& @€TAXTYPEzD‚d& A€TYPEzH‚d& B€0WAGEBASEzH‚d& C€WORKCODE{C‚P[œ D9|z€d# Eˆ€_JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(BatchInf->COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + BatchInf->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "JC" + "N" +BatchInf->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|u€d# Fˆ€_ORGLEVEL1DivisionIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + BatchInf->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L1" + "N" + BatchInf->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|w€d# Gˆ€_ORGLEVEL2DepartmentIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + BatchInf->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L2" + "N" + BatchInf->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|u€d# Hˆ€_ORGLEVEL3LocationIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + BatchInf->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L3" + "N" + BatchInf->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|x€d# Iˆ€_ORGLEVEL4Not DefinedIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + BatchInf->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L4" + "N" + BatchInf->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|x€d# Jˆ€_ORGLEVEL5Not DefinedIIf(IIf(CLOOKUP(BatchInf->COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + BatchInf->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "L5" + "N" + BatchInf->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ĺ€d# Kˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(BatchInf->COMPANY+BatchInf->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|Ś€d# Lˆ€_POSTTYPEPosting TypeCASE(BatchInf->POSTTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|i€d# Mˆ€_SHIFTWork ShiftIIf(IIf(CLOOKUP(BatchInf->COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +BatchInf->SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "SF" + "N" + BatchInf->SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|¤€d# Nˆ€_TAXTYPETax Table TypeCASE(BatchInf->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "n/a")|˛€d# Oˆ€_TYPECheck TypeCASE(BatchInf->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")|†€d# Pˆ€_WORKCODEWork State For Posting RecordIIf(IIf(CLOOKUP(BatchInf->COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + BatchInf->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(BatchInf->COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = BatchInf->COMPANY, True, False), CLOOKUP(BatchInf->COMPANY + "ST" + "N" +BatchInf->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Š€dQ# Qˆ RprntChkLnkPRCKHIST->COMPANY + PRCKHIST->PAYGROUP + PRCKHIST->CHKNUMBERGpľ RprntChkLnk\Best Software\Abra Suite\Programs\OtherPrg\ChkReprint\reprinttrak.dbf\Best Software\Abra Suite\Programs\OtherPrg\ChkReprint\reprinttrak.CDXCMPGRPCKNOreprintszI‚d& R€ REPRINTIDzJ‚d& S‚ĄREPRINTDTEzJ‚d& T€REPRINTTMEzJ‚d& U€ REPRINTUSRzI‚d& V€ REPRINTPCzJ‚d& W€REPRINTCMPzJ‚d& X€REPRINTPGPzJ‚d& Y€ REPRINTEMPzJ‚d& Z€REPRINTCHKzJ€Px˜ [0REPRINTCNT{C€PxŒ \0[G p2 RegLinkprearn.DBFprearn.CDXEMPNOprearnzF‚Z& ]€0 AMOUNTzG‚Z& ^€0 BALANCEzH‚Z& _€0 BALANCEPzH‚Z& `€CALCRULEzG‚Z& a‚ĄCHADATEzG‚Z& b€COMPANYzI‚Z& c€0 CURAMOUNTzH‚Z& d€0CURHOURSzH‚P2[  eDESCRIPTzH‚Pâ ó f@EARNCODEzE‚Z& g€ EMPNOzD‚Z& h€0 GOALzI‚Z& i€0 MTDAMOUNTzH‚Z& j€0MTDHOURSzH‚Z& k€PAYGROUPzI‚Z& l€0 QTDAMOUNTzJ‚Z& m€0 QTDAMOUNTPzH‚Z& n€0QTDHOURSzI‚Z& o€0QTDHOURSPzI‚Z& p‚ĄSTARTDATEzF‚Z& q€STATUSzH‚Z& r‚ĄSTOPDATEzD‚Pâ ó sTYPEzF‚Z& t€ USERIDzI‚P˘ Kó u0 YTDAMOUNTzJ‚Z& v€0 YTDAMOUNTPzH‚PÄ )ó w2YTDHOURSzI‚Z& x€0YTDHOURSPG p2  RegLinkprdeds.DBFprdeds.CDXEMPNOPRDEDSzF‚Z& y€ACTIVEzF‚Z& z€0 AMOUNTzJ‚Z& {€0 ARREARSAMTzG‚Z& |€0 BALANCEzH‚Z& }€0 BALANCEPzH‚Z& ~€CALCRULEzG‚Z& ‚ĄCHADATEzG‚Z& €€COMPANYzI‚Z& €0 CURAMOUNTzI‚Z& ‚€0 CUREMPLYRzG‚Pâ ó ƒ@DEDCODEzH‚P2[  „DESCRIPTzE‚Z& …€ EMPNOzD‚Z& †€0 GOALzF‚Z& ‡€ MEMBERzI‚Z& ˆ€0 MTDAMOUNTzI‚Z& ‰€0 MTDEMPLYRzH‚Z& Š€PAYGROUPzI‚Z& ‹€0 QTDAMOUNTzJ‚Z& Œ€0 QTDAMOUNTPzI‚Z& €0 QTDEMPLYRzJ‚Z& Ž€0 QTDEMPLYRPzI‚Z& ‚ĄSTARTDATEzH‚Z& ‚ĄSTOPDATEzD‚Pâ ó ‘TYPEzF‚Z& ’€ USERIDzH‚Z& “€0WITHHOLDzI‚P9H  ”0 YTDAMOUNTzJ‚Z& •€0 YTDAMOUNTPzI‚Z& –€0 YTDEMPLYRzJ‚Z& —€0 YTDEMPLYRPG p5  RegLinkprtaxes.DBFprtaxes.CDXEMPNOPRTAXESzG‚Z& ˜‚ĄCHADATEzH‚Z& ™€CODETYPEzG‚Z& š€COMPANYzI‚Z& ›€0CURAMOUNTzH‚Z& œ€0CURWAGESzE‚Z& € EMPNOzF‚Z& ž!EXEMPTzI‚PŹ Aó Ÿ0 EXEMPTCNTzH‚Z&  €0EXTRAAMTzI‚Z& Ą€EXTRATYPEzI‚Pâ ó ˘MARSTATUSzI‚Z& Ł€0MTDAMOUNTzH‚Z& ¤€0MTDWAGESzJ‚Z& Ľ€0 OEXEMPTCNTzH‚Z& Ś€PAYGROUPzI‚Z& §€0QTDAMOUNTzJ‚Z& ¨€0QTDAMOUNTPzH‚Z& Š€0QTDWAGESzI‚Z& Ş€0QTDWAGESPzF‚Z& Ť€STATUSzG‚Pâ ó Ź@TAXCODEzG‚P2ľ  ­TAXDESCzG‚Z& Ž€TAXTYPEzD‚Pâ ó ŻTYPEzF‚Z& °€ USERIDzH‚Z& ą€0WITHHOLDzI‚P9H  ˛2 YTDAMOUNTzJ‚Z& ł€0YTDAMOUNTPzH‚PŐHz ´€0YTDWAGESzI‚Z& ľ€0YTDWAGESP{C‚P2[  śe|Á€d# ˇˆ€_PAYGROUPEmployee Pay GroupCLOOKUP(prearn->COMPANY+prearn->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")}V‚P˝( ¸„2wüCatYTDhrs}V‚PŸHĄ  š„€0 uüChkYTDgrs|W‚Pâ ó şˆ@CodeLink"E"+EARNCODEGp9 CodeLinkprcodes.DBFprcodes.CDXCODETYPEPRCODESzH‚Z& ť!ACCRINCLzI‚Z& ź!ALLCHECKSzH‚Z& ˝€ALLOCINDzJ‚Z& ž!ALWAYSBEERzF‚Z& ż€0 AMOUNTzG‚Z& Ŕ!ARREARSzH‚Z& Á€0ARRPRIORzG‚Z& !AUTOADDzH‚Z& Á!BALRESETzG‚Z& Ä€ BENCODEzH‚Z& Ĺ€CALCRULEzH‚Z& Ć€CATEGORYzH‚Z& Ç€0CHKGROUPzD‚Z& Č€CODEzH‚Z& É€CODETYPEzG‚Z& Ę€COMPANYzH‚Z& Ë€0DEDPRIORzG‚Z& Ě€DEDTYPEzH‚Pâ ó ÍEARNTYPEzI‚Z& ΀EEPAYACCTzJ‚Z& Ď€EEPAYJOBCDzI‚Z& Đ€EEPAYORG1zI‚Z& Ń€EEPAYORG2zI‚Z& Ň€EEPAYORG3zI‚Z& Ó€EEPAYORG4zI‚Z& Ô€EEPAYORG5zI‚Z& Ő€EEPAYPROJzH‚Z& Ö€EMPLYINDzH‚Z& ×€0EMPLYMAXzI‚Z& Ř€0EMPLYPCNTzG‚Z& Ů€EXPACCTzH‚Z& Ú€EXPJOBCDzG‚Z& Ű€EXPORG1zG‚Z& Ü€EXPORG2zG‚Z& Ý€EXPORG3zG‚Z& Ţ€EXPORG4zG‚Z& ߀EXPORG5zG‚Z& ŕ€EXPPROJzG‚Z& á€0FEDPCNTzF‚Z& â!FLSAOTzJ‚Z& ă€GLDISTFLGSzD‚Z& ä€0 GOALzH‚Z& ĺ!OTACCRUEzG‚Z& ć€PAYACCTzH‚Z& ç€PAYCYCLEzE‚Z& č€ PAYEEzH‚Z& é€ PAYJOBCDzG‚Z& ę€ PAYORG1zG‚Z& ë€ PAYORG2zG‚Z& ě€ PAYORG3zG‚Z& í€ PAYORG4zG‚Z& î€ PAYORG5zG‚Z& ď€ PAYPROJzG‚Z& đ€PAYTYPEzJ‚Z& ń€0 RATEFACTORzF‚Z& ň€REASONzI‚Z& ó!RETROINCLzD‚Z& ô€RULEzI‚Z& ő!SHIFTINCLzI‚Z& ö‚ĄSTARTDATEzH‚Z& ÷‚ĄSTOPDATEzH‚Z& ř€STUBDESCzI‚Z& ů€TAKECYCLEzI‚Z& ú€TAXMETHODzF‚Z& ű€TCCOMPzG‚Z& ü€UNITPAYzH‚Z& ý!WCOMPTAX}f‚Pœ Qó ţ„0 uüEARNTYPE <> "T"ChkYTDcash|s€PŒaj ˙ˆ€ ShowReimbiif(EARNTYPE="R"," (Reimbursement)","")}W‚P9H  „0 uüEcatYTDamt}W‚P˝(  „2wüEcatYTDhrs{C‚P2[ „|Á€Z& ˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(PRDEDS->COMPANY+PRDEDS->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")}V‚P˘ Kó „0 ”üChkYTDded}W‚P9H „2 ”üDcatYTDAmt|{‚Pć ó Œ0DetOrdiif(scanning(Prearn),1,iif(scanning(Prtaxes),2,3))|‚P” Yó Œ0ScanYTDcase(DetOrd, 1,PREARN->YTDAMOUNT, 2,PRTAXES->YTDAMOUNT, 3,PRDEDS->YTDAMOUNT, 0)|‘‚Pâ ó ˆscanTypecase(DetOrd, 1,PREARN->TYPE, 2,PRTAXES->TYPE, 3,PRDEDS->TYPE, " "){C‚P2ľ ­{C‚P9H 2 ˛| €Z& ˆ€ _TAXTYPETax Table TypeCASE(PRTAXES->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "")|ž‚Pâ ó ˆ@scanCodecase(DetOrd, 1,PREARN->EARNCODE, 2,PRTAXES->TAXCODE, 3,PRDEDS->DEDCODE, " ")|t‚Pâ ó ˆscanCatcase(DetOrd, 1,"E", 2,"T", 3,"D", " ")|ˇ‚Pâ ó ˆ@DetailLinkprckhist->EMPNO + prckhist->COMPANY + str(prckhist->CHKGROUP,2) + PRCKHIST->CHKNUMBER + scanCat + scanCode}V‚P9H „0 üCatYTDamt}V‚PŐHw „€2 ´üCatYTDwag}g‚P HĄ  „€0 ´üTAXCODE = "FED "ChkYTDfwag}V‚P˘ Kó „2 ˛üChkYTDtaxG”8EMPNO+COMPANY+STR(CHKGROUP,2)+CHKNUMBER+DETAILTYPE+CODEoE DetailLinkprDeHist.DBFC:\Temp\1003268\prDeHist.rrxprDeHistzF‚PH  2 AMOUNTzG‚P& ‚ĄCHADATEzH‚P& €0CHKCOUNTzH‚P& €0CHKGROUPzI‚PČ-  CHKNUMBERzD‚Pâ ó @CODEzG‚Pâ ó @COMPANYzJ‚P& €0DEDUCTIONSzJ‚Pâ ó DETAILTYPEzE‚Pâ ó @EMPNOzF‚P& €0ERLIABzH‚P& €PAYGROUPzD‚P& €TYPEzE‚PO.  2UNITSzH‚PďHj !€2 WAGEBASE{C‚PH  "2 {C‚PH  #2 {C‚PO.  $2 {C‚PH  %2 {C‚PH &2 {C‚PGH '2 |y€d# (ˆ€ _CODEEarning or Deduction DescriptionIIf(IIf(CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"Y"+"_ENT_","COMPANY","PRCODES.DBF","PRCODES.CDX","COMPTYPECD")=prDeHist->COMPANY,.T.,.F.), CLOOKUP("***"+prDeHist->DETAILTYPE+"N"+prDeHist->CODE+"","STUBDESC","PRCODES.DBF","PRCODES.CDX","COMPTYPECD"),IIf(IIf(CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"Y"+"_CO_","COMPANY","PRCODES.DBF","PRCODES.CDX","COMPTYPECD")=prDeHist->COMPANY,.T.,.F.), CLOOKUP(prDeHist->COMPANY+prDeHist->DETAILTYPE+"N"+prDeHist->CODE+"","STUBDESC","PRCODES.DBF","PRCODES.CDX","COMPTYPECD"),""))|¨€d# )ˆ€ _DETAILTYPDetail TypeCASE(prDeHist->DETAILTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|Ĺ€d# *ˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(prDeHist->COMPANY+prDeHist->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|˛€d# +ˆ€ _TYPECheck TypeCASE(prDeHist->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")}V‚PH ,„2 üCatCurAmt}V‚PďHw -„€2 !üCatCurWag}V‚PO. .„2 üCatCurHrs|Ÿ‚Pâ ó /ˆ@ScanDesccase(DetOrd, 1,PREARN->DESCRIPT, 2,PRTAXES->TAXDESC, 3,PRDEDS->DESCRIPT, " ")|¤‚Pd  0ˆ1 ShowWHiif(inlist(TAXCODE,"FED ","NY ","NJ-A","NJ-B"),MARSTATUS+"-"+ltrim(str(EXEMPTCNT,2,0)),""){C‚Pd 1Š10|ˇ‚Pâ ó 2ˆ@PostLinkiif(DETAILTYPE="E",prDeHist->EMPNO+prDeHist->COMPANY+"E"+prDeHist->CODE+str(prckhist->CHKGROUP,2),space(19))G”3EMPNO+COMPANY+POSTTYPE+POSTCODE+ STR(CHKGROUP,2,0)o@ PostLinkprHPost.DBFC:\Temp\1003268\prhpost.rrxprhpostzH‚Z& 3€0ALLOCCNTzH‚Z& 4€ALLOCINDzH‚Z& 5€0ALLOCORDzH‚Z& 6€0ALLOCSETzF‚Z& 7€0AMOUNTzJ‚Z& 8€0ARREARSAMTzI‚Z& 9ATTPOSTEDzH‚Z& :€CALCRULEzG‚Z& ;‚ĄCHADATEzJ‚Z& <‚ĄCHARGEDATEzG‚Z& =‚ĄCHKDATEzH‚Z& >€0CHKGROUPzI‚Z& ?€CHKNUMBERzG‚Pâ ó @@COMPANYzJ‚Z& A€0DEDUCTIONSzH‚Z& B€DESCRIPTzE‚Z& C€ EMPNOzF‚Z& D€0ERLIABzG‚Z& E€JOBCODEzI‚Pâ ó F@ORGLEVEL1zI‚Pâ ó G@ORGLEVEL2zI‚Z& H€ ORGLEVEL3zI‚Z& I€ ORGLEVEL4zI‚Z& J€ ORGLEVEL5zH‚Z& K€PAYGROUPzG‚Z& L€0 PAYRATEzH‚Z& M€POSTCODEzH‚Z& N€POSTTYPEzJ‚Z& O€0 PREVARREARzG‚P[* P€PROJECTzH‚Z& Q€0 QUANTITYzI‚Z& RRETROINCLzE‚Z& S€SHIFTzI‚Z& TSHIFTINCLzF‚Z& U€SOURCEzF‚Z& V€STATUSzG‚Z& W€TAXTYPEzD‚Z& X€TYPEzH‚Z& Y€0WAGEBASEzH‚Z& Z€WORKCODE|s€d# [ˆ€ _JOBCODEJob Code DescriptionIIf(IIf(CLOOKUP(prhpost->COMPANY + "JC" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "JC" + "N" + prhpost->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "JC" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "JC" + "N" +prhpost->JOBCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|n€d# \ˆ€ _ORGLEVEL1DivisionIIf(IIf(CLOOKUP(prhpost->COMPANY + "L1" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L1" + "N" + prhpost->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L1" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L1" + "N" + prhpost->ORGLEVEL1 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|p€d# ]ˆ€ _ORGLEVEL2DepartmentIIf(IIf(CLOOKUP(prhpost->COMPANY + "L2" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L2" + "N" + prhpost->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L2" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L2" + "N" + prhpost->ORGLEVEL2 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|n€d# ^ˆ€ _ORGLEVEL3LocationIIf(IIf(CLOOKUP(prhpost->COMPANY + "L3" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L3" + "N" + prhpost->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L3" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L3" + "N" + prhpost->ORGLEVEL3 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|q€d# _ˆ€ _ORGLEVEL4Not DefinedIIf(IIf(CLOOKUP(prhpost->COMPANY + "L4" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L4" + "N" + prhpost->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L4" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L4" + "N" + prhpost->ORGLEVEL4 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|q€d# `ˆ€ _ORGLEVEL5Not DefinedIIf(IIf(CLOOKUP(prhpost->COMPANY + "L5" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "L5" + "N" + prhpost->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "L5" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "L5" + "N" + prhpost->ORGLEVEL5 + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ă€d# aˆ€ _PAYGROUPEmployee Pay GroupCLOOKUP(prhpost->COMPANY+prhpost->PAYGROUP, "DESCRIPT", "PRPAYGRP.DBF", "PRPAYGRP.CDX", "COMPGROUP")|Ľ€d# bˆ€ _POSTTYPEPosting TypeCASE(prhpost->POSTTYPE, "E", "Earnings", "D", "Deductions", "T", "Taxes", "")|b€d# cˆ€ _SHIFTWork ShiftIIf(IIf(CLOOKUP(prhpost->COMPANY + "SF" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "SF" + "N" +prhpost->SHIFT+ " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "SF" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "SF" + "N" + prhpost->SHIFT + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|Ł€d# dˆ€ _TAXTYPETax Table TypeCASE(prhpost->TAXTYPE, "F", "Federal", "S", "State", "L", "Local", "n/a")|ą€d# eˆ€ _TYPECheck TypeCASE(prhpost->TYPE, "RC", "Regular Check", "RD", "Regular Deposit", "RP", "Regular Pay", "n/a")|€d# fˆ€ _WORKCODEWork State For Posting RecordIIf(IIf(CLOOKUP(prhpost->COMPANY + "ST" + "Y" + "_ENT_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP("***" + "ST" + "N" + prhpost->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), IIf(IIf(CLOOKUP(prhpost->COMPANY + "ST" + "Y" + "_CO_", "COMPANY", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE") = prhpost->COMPANY, True, False), CLOOKUP(prhpost->COMPANY + "ST" + "N" +prhpost->WORKCODE + " ", "DESC", "HRTABLES.DBF", "HRTABLES.CDX", "TABLECODE"), "Unknown"))|ş‚Pâ ó gˆ@ CDivDescCLOOKUP(prhpost->COMPANY+"L1"+"N"+prhpost->ORGLEVEL1+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")|ť‚Pâ ó hˆ@ CCustDescCLOOKUP(prhpost->COMPANY+"L2"+"N"+prhpost->ORGLEVEL2+space(3),"DESC","HRTABLES.DBF","HRTABLES.CDX","TABLECODE")}d‚ZĚąD i€hüCCustDesc<>" "ChkCust}b‚ZŒąD j€güCDivDesc<>" "ChkDiv}k‚PH k„2 üprDeHist->AMOUNT <> 0DedDtlAmt|‹‚P"  lŒ2 PdAtRateIIf(prDeHist->UNITS <> 0, prDeHist->AMOUNT / prDeHist->UNITS, 0)|v‚PŇ“  mˆChkDtlMtchPRCKHIST->CHKNUMBER = prDeHist->CHKNUMBER{C‚P9H n†0 {C‚P9H o†0 {C‚PH p†2 ,{C‚PH q†2 ,{C‚P˝(  r†2{C‚P9H  s†0 |]€Z& tŒˆ0ţPage_rrPage numberPAGENO()|f€Z& uŒ„0ţRecno_rrReport record numberRECNO()|l‚P:H vĚ0 ChkYTDnetChkYTDcash-(ChkYTDtax+ChkYTDded)  <<