Payroll FAQ

Open as: PDF or Word Document

Data Dictionary

Table of Contents


PR$PST : HOLDS TEMP NAMES FOR INCOMPLETE POSTING

PRAPLK : ACCOUNTS PAYABLE LINK FILE

PRCHCK : CHECK FILE

PRDEDU : EMPLOYEE DEDUCTIONS FILE

PRDEPO : TAX DEPOSITS FILE

PRDEPT : DEPARTMENT FILE

PRDIST : GENERAL LEDGER DISTRIBUTION FILE

PREACC : EMPLOYEE ACCOUNTS FILE

PREMPL : EMPLOYEE FILE

PRLEAV : LEAVE TRACKING FILE

PRPOST : POSTING FILE

PRSTDD : STANDARD DEDUCTION FILE

PRSYST : SYSTEM FILE

PRTAXS : TAX FILE (FWT,SWT,FICA,...)

PRTCHK : TEMPORARY CHECK FILE

PRWITH : TAX TABLE FILE

PRX2AP : TRANSFER TO A/P FILE (APMAST)

PRX2GL : TRANSFER TO G/L FILE (GLTRAX)



PR$PST : HOLDS TEMP NAMES FOR INCOMPLETE POSTING           

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    TEMP_NAME      C      8     0   TEMP_FILE UNCOMPLETED POSTING ARE IN    
   2    H_DELFLAG      C      1     0   '*' IF RECORD WAS DELETED               
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 2 FIELDS = 9




 
PRAPLK : ACCOUNTS PAYABLE LINK FILE                  

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    A_VENDNO       C      9     0   A/P VENDOR NUMBER                       
   2    A_INVNO        C     12     0   A/P INVOICE NUMBER                      
   3    A_ACCT         C     25     0   G/L ACCOUNT                             
   4    A_AMOUNT       N     11     2   AMOUNT TO POST TO A/P                   
   5    A_DATE         D      8     0   CHECK DATE BECOMES AP->PURDATE, 
DUEDATE  
   6    A_BATCH        C      3     0                                           
   7    A_POSTED       C      1     0   "Y" = POSTED TO A/P                     
   8    A_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
   9    A_DELFLAG      C      1     0   "*"=RE-USABLE                           
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 9 FIELDS = 72

                                Related Indexes                                

PRAPLK : A_DELFLAG+A_VENDNO+DTOS(A_DATE)+A_POSTED+A_ACCT                       



 
PRCHCK : CHECK FILE                          

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRCHECK        C      8     0   CHECK NUMBER                            
   2    PRSEQNO        C      5     0   POSTING SEQUENCE NUMBER                 
   3    PREMPL         C      9     0   EMPLOYEE NUMBER (ALIGNMENT= 
"{ALIGNMT}")
   4    PRDATE         D      8     0   CHECK DATE                              
   5    PREND          D      8     0   END DATE OF PAY PERIOD POSTED           
   6    PRDAYS         N      3     0   NUMBER OF DAYS WORKED IN PAY PERIOD     
   7    PRGROSS        N      9     2   GROSS INCOME (TAXABLE+NONTAXABLE)       
   8    C_CONTRACT     N      9     2   AMOUNT OF GROSS THAT WAS CONTRACT       
   9    PRGTW          N      9     2   GROSS TAXABLE WAGES                     
  10    PRGSW          N      9     2   GROSS STATE WAGES                       
  11    PRGFW          N      9     2   GROSS FICA WAGES                        
  12    PRGMW          N      9     2   GROSS MEDI WAGES                        
  13    PRFWT          N      9     2   FEDERAL WITHHELD                        
  14    PRTXFR         N      9     2   TAXABLE FRINGES                         
  15    C_FRINGE       N      9     2   TOTAL FRINGES (INCLUDES NONTAXABLE)     
  16    C_REIMB        N      9     2   TOTAL REIMBURSEMENTS                    
  17    PRNET          N      9     2   AMOUNT OF CHECK                         
  18    PRFICA         N      9     2   FICA WITHHELD                           
  19    PRMEDI         N      9     2   MEDI WITHHELD                           
  20    PRSWT          N      9     2   STATE WITHHELD                          
  21    PRSDI          N      9     2   STATE DISAB. WITHHELD                   
  22    PRLOC          N      9     2   LOCAL TAXES WITHHELD                    
  23    PRFUTA         N      9     2   FUTA WITHHELD                           
  24    PRSUTA         N      9     2   SUTA WITHHELD                           
  25    PRERFI         N      9     2   EMPLOYER FICA                           
  26    PRERME         N      9     2   EMPLOYER MEDI                           
  27    C_DEDU1        N      9     2   DEDUCTION 1 AMOUNT                      
  28    C_DEDU2        N      9     2   DEDUCTION 2 AMOUNT                      
  29    C_DEDU3        N      9     2   DEDUCTION 3 AMOUNT                      
  30    C_DEDU4        N      9     2   DEDUCTION 4 AMOUNT                      
  31    C_DEDU5        N      9     2   DEDUCTION 5 AMOUNT                      
  32    C_DEDU6        N      9     2   DEDUCTION 6 AMOUNT                      
  33    C_DEDU7        N      9     2   DEDUCTION 7 AMOUNT                      
  34    C_DEDU8        N      9     2   DEDUCTION 8 AMOUNT                      
  35    C_DEDU9        N      9     2   DEDUCTION 9 AMOUNT                      
  36    C_DEDUA        N      9     2   DEDUCTION A AMOUNT                      
  37    C_DEDUB        N      9     2   DEDUCTION B AMOUNT                      
  38    C_DEDUC        N      9     2   DEDUCTION C AMOUNT                      
  39    C_DEDUD        N      9     2   DEDUCTION D AMOUNT                      
  40    C_DEDUE        N      9     2   DEDUCTION E AMOUNT                      
  41    C_DEDUF        N      9     2   DEDUCTION F AMOUNT                      
  42    C_DEDUG        N      9     2   DEDUCTION G AMOUNT                      
  43    C_DEDUH        N      9     2   DEDUCTION H AMOUNT                      
  44    C_DEDUI        N      9     2   DEDUCTION I AMOUNT                      
  45    C_DEDUJ        N      9     2   DEDUCTION J AMOUNT                      
  46    C_DEDUK        N      9     2   DEDUCTION K AMOUNT                      
  47    C_DEDUL        N      9     2   DEDUCTION L AMOUNT                      
  48    C_DEDUM        N      9     2   DEDUCTION M AMOUNT                      
  49    C_DEDUN        N      9     2   DEDUCTION N AMOUNT                      
  50    C_DEDUO        N      9     2   DEDUCTION O AMOUNT                      
  51    C_DEDUP        N      9     2   DEDUCTION P AMOUNT                      
  52    C_DEDUQ        N      9     2   DEDUCTION Q AMOUNT                      
  53    C_DEDUR        N      9     2   DEDUCTION R AMOUNT                      
  54    C_DEDUS        N      9     2   DEDUCTION S AMOUNT                      
  55    C_DEDUU        N      9     2   DEDUCTION U AMOUNT                      
  56    C_DEDUV        N      9     2   DEDUCTION V AMOUNT                      
  57    C_DEDUW        N      9     2   DEDUCTION W AMOUNT                      
  58    C_DEDUX        N      9     2   DEDUCTION X AMOUNT                      
  59    C_DEDUY        N      9     2   DEDUCTION Y AMOUNT                      
  60    C_DEDUZ        N      9     2   DEDUCTION Z AMOUNT                      
  61    PR401K         N      9     2   401K DEDUCTIONS                         
  62    PRVDATE        D      8     0   VOIDED DATE (BLANK IF NOT VOIDED)       
  63    C_NETACNT      C     25     0   NET G/L ACCOUNT                         
  64    C_RETURN       C      1     0   CKREC RETURNED? (YN)  RECONCILED = 
'C'  
  65    C_POSTAMT      N     11     2   CKREC AMOUNT                            
  66    C_STDATE       D      8     0   CHECK RECONCILIATION STATEMENT DATE     
  67    C_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  68    C_DELFLAG      C      1     0   DELETE FLAG (*)                         
  69    C_ECHKSTAT     C      1     0   CHECK OUTPUT TO ASCII FILE (Y,N)        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 69 FIELDS = 593

                                Related Indexes                                

PRCHCK : PREMPL+PRCHECK+DTOS(PREND)                                            
PRCKDT : DTOS(PRDATE)+PRCHECK                                                  
PRCKNO : PRCHECK+DTOS(PRDATE)                                                  



 
PRDEDU : EMPLOYEE DEDUCTIONS FILE                   

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PREMPL         C      9     0   EMPLOYEE NUMBER                         
   2    PRDESC         C     15     0   DEDUCTION DESCRIPTION                   
   3    PRSEQ          C      1     0   DEDUCTION SEQUENCE NUMBER (1-9)(A-J)    
   4    PRCODE         C      4     0   STANDARD DEDUCTION CODE                 
   5    PRDSTATUS      C      1     0   DEDUCTION STATUS CODE                   
   6    PRFREQ         C      1     0   ONETIME,PAYPERIOD,MONTHLY,NEVER         
   7    PRRATE         C      1     0   RATE OR FIXED                           
   8    PRTYPE         C      1     0   GROSS,NET,GROSS-WH,NET-DEDU             
   9    PRTAXAB        C      8     0   (SEE BELOW)                             
  10    PRPER          C      1     0   HOURLY,PAYPERIOD                        
  11    PRPERIODS      C      5     0   PAYPERIODS TO TAKE DEDUCTION 1-5        
  12    PRAMOUNT       N     10     4   RATE OR FIXED AMOUNT TO DEDUCT          
  13    PRMAX          N      9     2   MAX AMOUNT TO DEDUCT (0.00=NO MAX)      
  14    PRMAXBASE      C      1     0   (Y)EAR-TO-DATE OR (F)ISCAL YEAR  
MAXIMUM 
  15    PRSTAT         C      6     0   Y/N IN PR PERIODS TAKEN                 
  16    PRMTDD         N      9     2   MTD DEDUCTED                            
  17    PRQTDD         N      9     2   QTD DEDUCTED                            
  18    PRYTDD         N      9     2   YTD DEDUCTED                            
  19    PRFTDD         N      9     2   FISCAL DEDUCTED                         
  20    PRLTDD         N      9     2   LAST YEAR DEDUCTED                      
  21    PRACNT         C     25     0   G/L ACCOUNT                             
  22    D_DIRECT       C      1     0   'Y'ES IF DIRECT DEPOSIT                 
  23    D_EMPLACCT     C     20     0   EMPLOYEE'S DIRECT DEPOSIT ACCOUNT #     
  24    D_EMPLBANK     C     20     0   EMPLOYEE'S DIRECT DEPOSIT BANK ROUTER 
# 
  25    D_PRENOTE      C      1     0   (Y)ES IF PRENOTE NEEDS TO BE SENT.      
  26    D_APXFER       C      1     0   TRANSFER TO A/P? (Y/N)                  
  27    D_APVEND       C      9     0   ACCOUNTS PAYABLE VENDOR                 
  28    PRCPRT         N      3     0   CURRENT # OF CHECKS TO BE PRINTED       
  29    D_PRPLAN       C      1     0   PLAN LETTER FROM THE FPRPLAN STM        
  30    D_MISC         C     30     0   DESCRIPTION FIELD                       
  31    D_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  32    D_DELFLAG      C      1     0   "*" = REUSABLE                          
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 32 FIELDS =  232

                                Related Indexes                                

PRDEDU : D_DELFLAG+PREMPL+PRSEQ                                                



 
PRDEPO : TAX DEPOSITS FILE                      

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRTAX          C      6     0   TAX CODE                                
   2    PRDATE         D      8     0   DATE OF DEPOSIT                         
   3    PRAMNT         N     10     2   AMOUNT DEPOSITED                        
   4    O_DELFLAG      C      1     0   "*" = REUSABLE                          
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 4 FIELDS = 25




 
RDEPT : DEPARTMENT FILE                       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    D_CODE         C      3     0   DEPARTMENT CODE                         
   2    D_NAME         C     40     0   DEPARTMENT NAME                         
   3    D_COMPCODE     C      5     0   WORKMANS COMP CODE                      
   4    D_DELFLAG      C      1     0   DELETE FLAG                             
   5    D_NETSTAMP     N      2     0   NETWORK STAMP                           
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 5 FIELDS = 51

                                Related Indexes                                

PRDEPT : D_DELFLAG+D_CODE                                                      



 
PRDIST : GENERAL LEDGER DISTRIBUTION FILE               

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    D_ACCT         C     25     0   G/L ACCOUNT                             
   2    D_DATE         D      8     0   TRANSACTION DATE (CHECK DATE)           
   3    D_BATCH        C      3     0                                           
   4    D_AMT          N     11     2   ACTUAL AMOUNT                           
   5    D_ENCAMT       N     11     2   ENCUMBRANCE AMOUNT                      
   6    D_POSTED       C      1     0   POSTED TO G/L ? (Y/N)                   
   7    D_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
   8    D_DELFLAG      C      1     0   DELETE FLAG (*)                         
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 8 FIELDS = 62

                                Related Indexes                                

PRDIST : D_DELFLAG+D_ACCT+DTOS(D_DATE)+D_POSTED                                
PRDBAT : D_DELFLAG+D_BATCH+D_ACCT+DTOS(D_DATE)                                 



 
PREACC : EMPLOYEE ACCOUNTS FILE                  

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    A_EMPL         C      9     0   EMPLOYEE NUMBER                         
   2    A_TYPE         C      2     0   PAY TYPE (G1, OT, ...)                  
   3    A_DESC         C     12     0   DESCRIPTION                             
   4    A_TAX          C      8     0   (SEE BELOW)                             
   5    A_AUTO         C      1     0   AUTOPOST? : "Y"ES / "N"O                
   6    A_AUTOQTY      N      3     0   NUMBER OF AUTO POST PAYROLLS TIL NO 
AUTO
   7    A_BASIS        C      1     0   AUTO BASIS : "G"ROSS / "H"OURS          
   8    A_METHOD       C      1     0   AUTO METHOD : "R"ATE / "F"LAT           
   9    A_CONTRACT     C      1     0   'Y'ES IF THIS AMOUNT IS PART OF 
CONTRACT
  10    A_AMOUNT       N     11     4   AUTOAMOUNT : (EX."R"ATE 
TYPES=2.00=2%)  
  11    A_DISENCUF     C      1     0   DISENCUMBER FICA EXPENSE                
  12    A_DISENCUM     C      1     0   DISENCUMBER MEDI EXPENSE                
  13    A_DISENCUE     C      1     0   DISENCUMBER EXPENSE                     
  14    A_ACNT         C     25     0   GROSS ACCOUNT                           
  15    A_FICA         C     25     0   ERFICA ACCOUNT                          
  16    A_FRINGE       C     25     0   ON FRINGE TYPES: FRINGE LIABILITY 
ACCT  
  17    A_JOB          C      6     0   JOB CODE (ON FRINGES: AP VENDOR)        
  18    A_WORK         C      4     0   WORK CODE (ON FRINGES: 1,2,3 = AP 
VENDOR
  19    A_MTD          N     10     2   MONTH-TO-DATE FOR THIS PAY TYPE         
  20    A_QTD          N     10     2   QUARTER                                 
  21    A_YTD          N     10     2   YEAR                                    
  22    A_FTD          N     10     2   FISCAL                                  
  23    A_LTD          N     10     2   LAST YEAR                               
  24    A_PERIODS      C      5     0   PERIODS TO TAKE FRINGE AUTO POST        
  25    A_TAKEN        C      5     0   PERIODS TAKEN RESPECTIVE TO PERIOD      
  26    A_I_FRINGE     C     13     0   INCLUDE THIS PAYTYPE IN BASE OF 
FRINGES 
  27    A_I_DEDUCT     C     34     0   INCLUDE THIS PAYTYPE IN BASE OF 
DEDUCTS?
  28    A_RATE         N     11     4   HOURLY RATE FOR PAY TYPE "HOURLY"       
  29    A_MEDI         C     25     0   ERMEDI ACCOUNT                          
  30    A_PLAN         C      1     0   FRINGE DEDUCTION PLAN LETTER IF ANY.    
  31    A_HOBATCH      C      4     0   HO BATCH WHICH LAST UPDATED EMPLOYEE    
  32    A_COMPCODE     C      5     0   WORKERS COMP CODE                       
  33    A_PERDIEMF     N      6     2   PER DIEM FACTOR (1 UNIT PAID = X 
HOURS) 
  34    A_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  35    A_DELFLAG      C      1     0   "*" = REUSABLE                          
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 35 FIELDS = 299

                                Related Indexes                                

PREACC  : A_DELFLAG+A_EMPL+FPRLINE(A_TYPE)                                      



 
PREMPL : EMPLOYEE FILE                        

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PREMPL         C      9     0   EMPLOYEE NUMBER                         
   2    PRFIRST        C     15     0   FIRST NAME                              
   3    PRMIDDLE       C      1     0   MIDDLE INITIAL                          
   4    PRLAST         C     25     0   LAST NAME                               
   5    PREXT          C      4     0   EXTENSION NAME                          
   6    E_TITLE        C     35     0   JOB TITLE                               
   7    PRADDR         C     70     0   ADDRESS 1,35 & 36,35                    
   8    PRCITY         C     25     0   CITY                                    
   9    E_STATE        C     10     0   STATE                                   
  10    E_ZIP          C     10     0   ZIP                                     
  11    PRPHONE        C     13     0   PHONE #                                 
  12    PRSSNUM        C     11     0   SOCIAL SECURITY NUMBER                  
  13    PRDEPT         C      3     0   DEPARTMENT                              
  14    PRSTAT         C      3     0   1=ACT,INACT,TERM/2=SEX,3=ETHNIC         
  15    PRCYCLE        C      5     0   1=WK, BI, SMO, MO, QTR, YR 
2=HR, SAL, TIMECARD 
  16    E_CYCLES       N      2     0   PAY CYCLES PER YEAR                     
  17    PRPAYR         N     11     3   HOURLY OR SALARY RATE                   
  18    PRREGU         N      6     2   REGULAR HOURS                           
  19    PRCONTRCT      N      9     2   CONTRACT AMOUNT                         
  20    E_HRRATE       C     80     0   TIME CARD RATES 999.9999                
  21    PRDATE         C     24     0   1=HIRE,9=BIRTH,17=TERMINATION           
  22    E_HIRE         D      8     0   HIRE DATE (REPLACES PRDATE)             
  23    E_BIRTH        D      8     0   BIRTH DATE (REPLACES PRDATE)            
  24    E_TERM         D      8     0   TERMINATION DATE (REPLACES PRDATE)      
  25    E_MISC         C    200     0   MISC. FIELD USED FOR NOTES OR CUSTOM    
  26    PRFLAG         C      4     0   "NEW" IF NEW EMPLOYEE/"POST" IF 
POSTED  
  27    PRFWT          C      7     0   1=S/M/H FILING STAT,2-3=#EXMPT,4-
6=SUPP 
  28    PRSWT          C      7     0   1=S/M/H FILING STAT,2-3=#EXMPT,4-
6=SUPP 
  29    PRSTATUS       C      8     0   STATUS FIELD FOR STATE TAX ROUTINES     
  30    PREXEMPT       C     14     0   SEE BELOW                               
  31    PRSTLOC        C      8     0   1-2=STATE TAX AREA,3-5=LOCAL TAX AREA   
  32    E_CODE         C      6     0   USER DEFINED CODE FOR WAGE SUMMARY 
REPO.
  33    E_HRCODE       C     50     0   TIME CARD RATE CODES AAAA|              
  34    E_FICATYPE     C      1     0   FICA TYPE: "F"ICA OR "M"QGE             
  35    E_DECEASED     C      1     0   DECEASED FLAG FOR W2                    
  36    E_PENSION      C      1     0   PENSION FLAG FOR W2                     
  37    E_LEGALREP     C      1     0   LEGAL REP FLAG FOR W2                   
  38    E_DEFCOMP      C      1     0   BOX 16 FOR W2                           
  39    E_STATUTOR     C      1     0   STATUTORY EMPLOYEE (W2)                 
  40    E_VTDET        C      1     0   (H)OURLY OR (S)ALARY FOR VT (ONLY) 
DET  
  41    PRLIFE         N      4     0   1000S $ LIFE INSURANCE                  
  42    E_FTE          N      4     2   FTE VALUE 1 FTE = 520 HRS WORKED        
  43    E_UNINSURE     C      1     0   UNINSURED FLAG                          
  44    PRPDATE        D      8     0   LAST POSTING DATE                       
  45    PRCDATE        D      8     0   LAST CHECK DATE                         
  46    PRENDD         C    112     0   ENDING DATE OF LAST 14 PAY PERIODS      
  47    PRMGROSS       N     10     2   MTD GROSS                               
  48    E_ECHECK       C      1     0   ELECTRONIC CHECKS (Y/N)                 
  49    E_NETACNT      C     25     0   NET ACCOUNT                             
  50    E_TAXACNT      C     25     0   TAX EXPENSE (FUTA / SUTA) ACCOUNT       
  51    PRQGROSS       N     10     2   QTD GROSS                               
  52    PRYGROSS       N     10     2   YTD GROSS                               
  53    PRFGROSS       N     10     2   FTD GROSS                               
  54    PRLGROSS       N     10     2   LAST YEAR GROSS                         
  55    PRMGTW         N     10     2   MTD GROSS TAXABLE WAGES                 
  56    PRQGTW         N     10     2   QTD GROSS TAXABLE WAGES                 
  57    PRYGTW         N     10     2   YTD GROSS TAXABLE WAGES                 
  58    PRFGTW         N     10     2   FTD GROSS TAXABLE WAGES                 
  59    PRLGTW         N     10     2   LAST YEAR GROSS TAXABLE WAGES           
  60    PRMGSW         N     10     2   MTD GROSS STATE WAGES                   
  61    PRQGSW         N     10     2   QTD GROSS STATE WAGES                   
  62    PRYGSW         N     10     2   YTD GROSS STATE WAGES                   
  63    PRFGSW         N     10     2   FTD GROSS STATE WAGES                   
  64    PRLGSW         N     10     2   LAST YEAR GROSS STATE WAGES             
  65    PRMGFW         N      8     2   MTD GROSS FICA WAGES                    
  66    PRQGFW         N      8     2   QTD GROSS FICA WAGES                    
  67    PRYGFW         N      9     2   YTD GROSS FICA WAGES                    
  68    PRFGFW         N      9     2   FTD GROSS FICA WAGES                    
  69    PRLGFW         N      9     2   LAST YEARS GROSS FICA WAGES              
  70    PRMGMW         N      8     2   MONTH TO DATE GROSS MEDI WAGES          
  71    PRQGMW         N      8     2   QUARTER TO DATE GROSS MEDI WAGES        
  72    PRYGMW         N      9     2   YEAR TO DATE GROSS MEDI WAGES           
  73    PRFGMW         N      9     2   FISCAL TO DATE GROSS MEDI WAGES         
  74    PRLGMW         N      9     2   LAST YEARS GROSS MEDI WAGES             
  75    PRLGLW         N      9     2   LAST YEARS GROSS LOCAL WAGES             
  76    PRLMOVE        N      9     2   LAST YEARS MOVING EXPENSES (P) BOX 12    
  77    PRLHSA         N      9     2   LAST YEARS EMPLOYER HSA (W) BOX 12       
  78    E_FTDCONTR     N      9     2   CONTRACT AMOUNT PAID FTD                
  79    PRCONLBAL      N      9     2   BALANCE OF CONTRACT FROM LAST YEAR 
FTD  
  80    PRMTXFR        N      8     2   MTD TAXABLE FRINGE                      
  81    PRQTXFR        N      8     2   QTD TAXABLE FRINGE                      
  82    PRYTXFR        N      9     2   YTD TAXABLE FRINGE                      
  83    PRFTXFR        N      9     2   FTD TAXABLE FRINGE                      
  84    PRLTXFR        N      9     2   LAST YEAR TAXABLE FRINGE                
  85    PRM401K        N      8     2   MTD 401K DEDUCTED                       
  86    PRQ401K        N      8     2   QTD 401K DEDUCTED                       
  87    PRY401K        N      9     2   YTD 401K DEDUCTED                       
  88    PRF401K        N      9     2   FTD 401K DEDUCTED                       
  89    PRL401K        N      9     2   LAST YEAR 401K DEDUCTED                 
  90    PRMNET         N     10     2   MTD NET                                 
  91    PRQNET         N     10     2   QTD NET                                 
  92    PRYNET         N     10     2   YTD NET                                 
  93    PRFNET         N     10     2   FTD NET                                 
  94    PRLNET         N     10     2   LAST YEAR NET                           
  95    PRMHOUR        N      8     2   MTD HOUR                                
  96    PRQHOUR        N      8     2   QTD HOUR                                
  97    PRYHOUR        N      8     2   YTD HOUR                                
  98    PRFHOUR        N      8     2   FTD HOUR                                
  99    PRLHOUR        N      8     2   LAST YEAR HOUR                          
 100    PRMFWT         N      8     2   MTD FWT                                 
 101    PRQFWT         N      8     2   QTD FWT                                 
 102    PRYFWT         N      9     2   YTD FWT                                 
 103    PRFFWT         N      9     2   FTD FWT                                 
 104    PRLFWT         N      9     2   LAST YEAR FWT                           
 105    PRMSWT         N      8     2   MTD SWT                                 
 106    PRQSWT         N      8     2   QTD SWT                                 
 107    PRYSWT         N      9     2   YTD SWT                                 
 108    PRFSWT         N      9     2   FTD SWT                                 
 109    PRLSWT         N      9     2   LAST YEAR SWT                           
 110    PRMFICA        N      8     2   MTD FICA                                
 111    PRQFICA        N      8     2   QTD FICA                                
 112    PRYFICA        N      9     2   YTD FICA                                
 113    PRFFICA        N      9     2   FTD FICA                                
 114    PRLFICA        N      9     2   LAST YEAR FICA                          
 115    PRMERFI        N      8     2   MTD EMPLOYER FICA                       
 116    PRQERFI        N      8     2   QTD EMPLOYER FICA                       
 117    PRYERFI        N      9     2   YTD EMPLOYER FICA                       
 118    PRFERFI        N      9     2   FTD EMPLOYER FICA                       
 119    PRLERFI        N      9     2   LAST YEAR EMPLOYER FICA                 
 120    PRMMEDI        N      8     2   MONTH TO DATE MEDI                      
 121    PRQMEDI        N      8     2   QUARTER TO DATE MEDI                    
 122    PRYMEDI        N      9     2   YEAR TO DATE MEDI                       
 123    PRFMEDI        N      9     2   FISCAL TO DATE MEDI                     
 124    PRLMEDI        N      9     2   LAST YEARS MEDI                         
 125    PRMERME        N      8     2   MONTH TO DATE EMPLOYERS MEDI            
 126    PRQERME        N      8     2   QUARTER TO DATE EMPLOYERS MEDI          
 127    PRYERME        N      9     2   YEAR TO DATE EMPLOYERS MEDI             
 128    PRFERME        N      9     2   FISCAL TO DATE EMPLOYERS MEDI           
 129    PRLERME        N      9     2   LAST YEARS EMPLOYER MEDI                
 130    PRMLOC         N      8     2   MTD LOCAL TAX                           
 131    PRQLOC         N      8     2   QTD LOCAL TAX                           
 132    PRYLOC         N      9     2   YTD LOCAL TAX                           
 133    PRFLOC         N      9     2   FTD LOCAL TAX                           
 134    PRLLOC         N      9     2   LAST YEAR LOCAL TAX                     
 135    PRMSDI         N      8     2   MTD SDI                                 
 136    PRQSDI         N      8     2   QTD SDI                                 
 137    PRYSDI         N      9     2   YTD SDI                                 
 138    PRFSDI         N      9     2   FTD SDI                                 
 139    PRLSDI         N      9     2   LAST YEAR SDI                           
 140    PRMFUTA        N      8     2   MTD FUTA                                
 141    PRQFUTA        N      8     2   QTD FUTA                                
 142    PRYFUTA        N      9     2   YTD FUTA                                
 143    PRFFUTA        N      9     2   FTD FUTA                                
 144    PRLFUTA        N      9     2   LAST YEAR FUTA                          
 145    PRMSUTA        N      8     2   MTD SUTA                                
 146    PRQSUTA        N      8     2   QTD SUTA                                
 147    PRYSUTA        N      9     2   YTD SUTA                                
 148    PRFSUTA        N      9     2   FTD SUTA                                
 149    PRLSUTA        N      9     2   LAST YEAR SUTA                          
 150    PRSICK         C     38     0   SICK ACCRUAL (SEE BELOW)                
 151    PRPERS         C     38     0   PERSONAL     (SEE BELOW)                      
 152    PRVACA         C     38     0   VACATION     (SEE BELOW)                      
 153    PRLV1          C     38     0   LEAVE 1      (SEE BELOW)                       
 154    PRLV2          C     38     0   LEAVE 2      (SEE BELOW)                      
 155    PRLV3          C     38     0   LEAVE 3      (SEE BELOW)                      
 156    PRLV4          C     38     0   LEAVE 4      (SEE BELOW)	       
 157    PRLV5          C     38     0   LEAVE 5      (SEE BELOW)         
 158    PRLV6          C     38     0   LEAVE 6      (SEE BELOW)         
 159    PRLEIC         N      9     2   LAST YEARS EIC PAYMENTS                  
 160    PRLDCB         N      9     2   LAST YEARS DBC PAYMENTS                  
 161    PRLSST         N      9     2   LAST YEARS SOCIAL SECURITY TIPS          
 162    PRLALL         N      9     2   LAST YEARS ALLOCATED TIPS                
 163    PRLNON         N      9     2   LAST YEARS (DISBURSEMENTS FROM NON 
PLANS)
 164    PRL3GW         N      9     2   LAST YEARS GROSS FROM 3RD PARTY PAYER  
 165    PRL3TW         N      9     2   LAST YEARS TAXABLE WAGES FROM 3RD 
PARTY  
 166    PRL3FW         N      9     2   LAST YEARS FWT FROM 3RD PARTY PAYERS     
 167    PRL3FICA       N      9     2   LAST YEARS EMPLOYEE FICA ON 3RD PARTY 
PAY
 168    PRL3MEDI       N      9     2   LAST YEARS EMPLOYEE MEDI ON 3RD PARTY 
PAY
 169    E_HOBATCH      C      4     0   HO BATCH WHICH LAST UPDATED EMPLOYEE    
 170    E_COMPCODE     C      5     0   WORKERS COMP CODE DEFAULT               
 171    E_NETSTAMP     N      2     0   NETWORK STAMP                           
 172    E_DELFLAG      C      1     0   DELETE FLAG (*)                         
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 172 FIELDS = 2225

                                Related Indexes                                

PREDEP : PRDEPT+PREMPL                                                         
PRELAS : UPPE(PRLAST)                                                          
PREMPL : PREMPL                                                                



 
PRLEAV : LEAVE TRACKING FILE                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PREMPL         C      9     0   EMPLOYEE NUMBER                         
   2    L_DATE         D      8     0   DATE LEAVE WAS TAKEN                    
   3    L_UNITS        N      6     2   THE AMOUNT OF TIME TAKEN                
   4    L_MISC         C     30     0   USER DEFINED NOTES                      
   5    L_TYPE         C      2     0   TYPE OF LEAVE - HP,SP,PP,VP,L1-L6       
   6    L_NETSTAMP     N      2     0   NETWORK STAMP                           
   7    L_DELFLAG      C      1     0   "*" IF DELETED                          
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 7 FIELDS = 58

                                Related Indexes                                

PRLEAV : L_DELFLAG+PREMPL+DTOS(L_DATE)+L_TYPE                                  



 
PRPOST : POSTING FILE                         

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRSEQNO        C      5     0   POSTING SEQUENCE NUMBER                 
   2    PREMPL         C      9     0   EMPLOYEE NUMBER                         
   3    PREND          D      8     0   END DATE OF PAY PERIOD                  
   4    PRTYPE         C      2     0   SEE BELOW                               
   5    PRQTY          N      9     2   HOURS/DAYS,MAX DEDU,GROSS WAGES FOR 
TAX 
   6    PRRATE         N     10     4   PAYRATE OR RATE(%,$) OF DEDUCTION       
   7    PRAMOUNT       N     10     2   PAY,AMT OF DEDU,AMT OF TAX              
   8    PRCHECK        C      8     0   CHECK NUMBER                            
   9    PRSTATUS       C      1     0   SEE BELOW                               
  10    PRLINE         C      3     0   LINE NUMBER IN THIS POSTING (SEE 
BELOW) 
  11    P_DIRECT       L      1     0   IF A DEDUCTION, IS IT DIRECT DEPOSIT?   
  12    P_TAX          C      8     0   SEE BELOW                               
  13    P_DISENCUM     C      1     0   DISENCUMBER?                            
  14    PRACNT         C     25     0   G/L ACCOUNT                             
  15    PRDESC         C     15     0   SEE BELOW                               
  16    PRFLAG         C     27     0   SEE BELOW                               
  17    P_I_FRINGE     C     13     0   INCLUDE THIS POSTING IN FRINGES?        
  18    P_I_DEDUCT     C     34     0   INCLUDE THIS POSTING IN DEDUCTS?        
  19    P_CONTRACT     C      1     0   'Y' THIS AMOUNT IS INCLUDED IN 
CONTRACT 
  20    P_COMPCODE     C      5     0   WORKERS COMP CODE                       
  21    P_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  22    P_DELFLAG      C      1     0   DELETE FLAG (*)                         
  23    PRDEPT         C      3     0                                           
  24    PRSTDD         D      8     0   BANK STATEMENT DATE CLEARED ON          
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 24 FIELDS = 209

                                Related Indexes                                

PRPLKP : PRSEQNO                                                               
PRPOST : P_DELFLAG+PREMPL+PRSEQNO+PRLINE                                       
PRPWRK : P_DELFLAG+UPPE(PRSTATUS)+PREMPL+PRSEQNO+PRLINE+PRACNT                 
PRWKDP : P_Delflag+UPPE(Prstatus)+Prdept+Prempl+Prseqno+Prline+Pracnt          


 
PRSTDD : STANDARD DEDUCTION FILE                   

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRDESC         C     15     0   DEDUCTION DESCRIPTION                   
   2    PRSEQ          C      4     0   DEDUCTION SEQUENCE NUMBER (1-9)(A-J)    
   3    PRFREQ         C      1     0   ONETIME,PAYPERIOD,MONTHLY,NEVER         
   4    PRRATE         C      1     0   RATE OR FIXED                           
   5    PRTYPE         C      1     0   GROSS,NET,GROSS-WH,NET-DEDU             
   6    PRTAXAB        C      8     0   (SEE BELOW)                             
   7    PRPER          C      1     0   HOURLY,PAYPERIOD                        
   8    PRPERIODS      C      5     0   PAYPERIODS TO TAKE DEDUCTION 1-5        
   9    PRAMOUNT       N     10     4   RATE OR FIXED AMOUNT TO DEDUCT          
  10    PRMAX          N      9     2   MAX AMOUNT TO DEDUCT (0.00=NO MAX)      
  11    PRMAXBASE      C      1     0   'Y'EAR TO DATE, 'F'ISCAL YEAR  
MAXIMUM  
  12    PRACNT         C     25     0   G/L ACCOUNT                             
  13    D_DIRECT       C      1     0   'Y'ES IF DIRECT DEPOSIT                 
  14    D_APXFER       C      1     0   'Y'ES IF TRANSFER TO A/P                
  15    D_APVEND       C      9     0   ACCOUNTS PAYABLE VENDOR                 
  16    D_PRPLAN       C      1     0   PLAN LETTER FROM THE PRPLAN DBF         
  17    D_OLDCODE      C      4     0   MISC. DESCRIPTION FIELD                 
  18    D_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  19    D_DELFLAG      C      1     0   DELETE FLAG (*)                         
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 19 FIELDS = 100

                                Related Indexes                                

PRSTDD : D_delflag+Prseq                                                       



 
PRSYST : SYSTEM FILE                       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    S_GLLINK       C      1     0   LINK TO GENERAL LEDGER? (Y/N)           
   2    S_GLCOMP       C      2     0   GENERAL LEDGER ENTITY TO LINK TO        
   3    S_GLNXTBAT     N      3     0                                           
   4    S_APLINK       C      1     0   LINK TO ACCOUNTS PAYABLE? (Y/N)         
   5    S_APCOMP       C      2     0   ACCOUNTS PAYABLE ENTITY TO LINK TO      
   6    S_APNXTBAT     N      3     0                                           
   7    S_TRACKJC      C      1     0   TRACK JOB COSTING? (Y/N)                
   8    S_ADDEMPL      C      1     0   ADD NEW EMPLOYEES DURING HR 
TRANSFER?Y/N
   9    S_NET          C     25     0   G/L NET (CASH) ACCOUNT (DEFAULT)        
  10    S_DUETO        C     25     0   G/L DUE TO ACCOUNT                      
  11    S_DUEFROM      C     25     0   G/L DUE FROM ACCOUNT                    
  12    S_ENCACCT      C     25     0   G/L ENCUMBRANCE ACCOUNT                 
  13    S_TAXACCT      C     25     0   G/L TAX EXPENSE ACCOUNT (DEFAULT)       
  14    S_ERFICA       C     25     0   G/L EMPLOYER FICA ACCOUNT (DEFAULT)     
  15    S_ERMEDI       C     25     0   G/L EMPLOYER MEDI ACCOUNT (DEFAULT)     
  16    S_ENCUM        C      1     0   DISENCUMBER ? (YN)                      
  17    S_ONEENC       C      1     0   1 ENCUM ACCOUNT("Y") OR 1 PER 
FUND("N") 
  18    S_ONEWH        C      1     0   1 W/H ACCOUNT("Y") OR 1 PER FUND("N")   
  19    S_VOIDATE      C      1     0   (A)CTUAL  OR (V)OID DATE                
  20    S_FEDID        C     10     0   FEDERAL TAX ID                          
  21    S_FEDPIN       C      4     0   FEDERAL PIN NUMBER                      
  22    S_STATEID      C     15     0   STATE TAX ID                            
  23    S_69NUM        C     10     0   "69" NUMBER                             
  24    S_FEDWH        N     11     2   AMOUNT OF ONE FED. WITHHOLDING 
ALLOWANC 
  25    S_FICAMAX      N     11     2   MAXIMUM YEARLY WAGES SUBJECT TO 
FICA/MED
  26    S_W2MAX        N     11     2   MAXIMUM LAST YEAR FICA MAX (FOR W-2)    
  27    S_EICMAX       N     11     2   MAXIMUM YEARLY ADVANCE EIC PAID         
  28    S_WARRTTL      C     30     0   TITLE TO APPEAR ON CHECK WARRANT 
REPORT 
  29    S_CKFORM       C      2     0   CHECK FORM (00,01,...)                  
  30    S_W2FORM       C      2     0   W2 FORM (00,01,...)                     
  31    S_TFFORM       C      2     0   PREPRINTED TAX FORM (00,01,...)         
  32    S_LASTEND      D      8     0   LAST PAYROLL ENDING DATE USED           
  33    S_QTRDT        D      8     0   DATE OF LAST QUARTER CLOSE              
  34    S_QTRNUM       C      1     0   CURRENT QUARTER NUMBER                  
  35    S_FISCYR       D      8     0   DATE OF LAST FISCAL YEAR CLOSE          
  36    S_YEAR         N      4     0   CURRENT YEAR                            
  37    S_PERIOD       N      2     0   CURRENT PERIOD                          
  38    S_W2YEAR       N      4     0   YEAR FOR W-2 REPORTING                  
  39    S_NXTPOST      C      5     0   NEXT POSTING SEQUENCE NUMBER            
  40    S_LSTCHCK      N      8     0   LAST PRINTED CHECK NUMBER               
  41    S_PRENUMB      C      1     0   PRENUMBERED CHECKS? (Y/N)               
  42    S_LSTECHK      N      7     0   LAST E-CHECK NUMBER USED                
  43    S_ENET         C      1     0   SHOW NET AMT OF E-CHECK ON 
STUB+REPORTS 
  44    S_ORDER        C      1     0   DEFAULT ORDER (LAST ONE USED)           
  45    S_ER_HC        C      1     0   EMPLOYER PROVIDED HEALTH CARE           
  46    S_WEEKLY       N      5     2   WEEKLY       ANNUALIZING FACTOR FOR 
CALC
  47    S_BIWEEK       N      5     2   BI-WEEKLY    "                          
  48    S_SEMIMO       N      5     2   SEMI-MONTHLY "                          
  49    S_MONTHY       N      5     2   MONTHLY      "                          
  50    S_QTERLY       N      5     2   QUARTERLY    "                          
  51    S_YEARLY       N      5     2   YEARLY       "                          
  52    S_MTDGROS      N     11     2   MONTH-TO-DATE GROSS                     
  53    S_QTDGROS      N     11     2   QUARTER-TO-DATE GROSS                   
  54    S_YTDGROS      N     11     2   YEAR-TO-DATE GROSS                      
  55    S_FTDGROS      N     11     2   FISCAL-TO-DATE GROSS                    
  56    S_MTDNET       N     11     2   MTD NET                                 
  57    S_QTDNET       N     11     2   QTD NET                                 
  58    S_YTDNET       N     11     2   YTD NET                                 
  59    S_FTDNET       N     11     2   FTD NET                                 
  60    S_QTDFDEP      N     11     2   QTD FEDERAL DEPOSITS                    
  61    S_QTDSDEP      N     11     2   QTD STATE DEPOSITS                      
  62    S_MTDFDED      N     11     2   MTD FEDERAL TAXES DEDUCTED              
  63    S_QTDFDED      N     11     2   QTD FEDERAL TAXES DEDUCTED              
  64    S_YTDFDED      N     11     2   YTD FEDERAL TAXES DEDUCTED              
  65    S_FTDFDED      N     11     2   FTD FEDERAL TAXES DEDUCTED              
  66    S_MTDSDED      N     11     2   MTD STATE TAXES DEDUCTED                
  67    S_QTDSDED      N     11     2   QTD STATE TAXES DEDUCTED                
  68    S_YTDSDED      N     11     2   YTD STATE TAXES DEDUCTED                
  69    S_FTDSDED      N     11     2   FTD STATE TAXES DEDUCTED                
  70    S_DESCL1       C      8     0   LEAVE 1 DESCRIPTION                     
  71    S_DESCL2       C      8     0   LEAVE 2 DESCRIPTION              
  72    S_DESCL3       C      8     0   LEAVE 3 DESCRIPTION              
  73    S_DESCL4       C      8     0   LEAVE 4 DESCRIPTION              
  74    S_DESCL5       C      8     0   LEAVE 5 DESCRIPTION              
  75    S_DESCL6       C      8     0   LEAVE 6 DESCRIPTION              
  76    S_DEFLPAY      C      1     0   DEFAULT 0.00 AS THE LEAVE PAY RATE?     
  77    S_MISCFELD     C    100     0   MISC FIELD DESCRIPTIONS IN EMPL MAINT   
  78    S_WARRBOT      M      0     0   WARRANT BOTTOM MEMO                     
  79    S_INC_REIM     C      1     0   INCLUDE REIMBURSMENTS IN NET 
DEDUCTIONS 
  80    S_PRWAIT       N      5     1   SECONDS OF DELAY DURING CHECK UPDATES   
  81    S_F05          C     30     0   FUNCTION KEY F5                         
  82    S_F06          C     30     0   FUNCTION KEY F6                         
  83    S_F07          C     30     0   FUNCTION KEY F7                         
  84    S_F08          C     30     0   FUNCTION KEY F8                         
  85    S_F09          C     30     0   FUNCTION KEY F9                         
  86    S_F10          C     30     0   FUNCTION KEY F10                        
  87    S_F11          C     30     0   FUNCTION KEY F11                        
  88    S_F12          C     30     0   FUNCTION KEY F12                        
  89    S_BAKDATE      D      8     0   LAST TEMPORARY BACKUP DATE              
  90    S_BAKTIME      C      8     0   LAST TEMPORARY BACKUP TIME              
  91    S_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  92    S_JANUARY      N      2     0   JAN IS WHAT PERIOD FOR UPPER LEFT 
CORNER
  93    S_VERSION      C      4     0   NEMRC EXECUTABLE THAT MATCHES THIS 
DATA 
  94    S_OLDVER       C      4     0   PREVIOUS INSTALLED VERSION OF THE 
MODULE
  95    S_UPVER        D      8     0   DATE THE NEW VERSION WAS INSTALLED      
  96    S_DIDMI        C      1     0   MIDDLE INITIAL CONVERSION (F/C/N)       
  97    S_BANK1        C     40     0   BANK NAME 1                             
  98    S_BANK2        C     40     0   BANK NAME 2                             
  99    S_BANK3        C     40     0   BANK NAME 3                             
 100    S_BANK4        C     40     0   BANK NAME 4                             
 101    S_ABA          C      9     0   ABA NUMBER                              
 102    S_BANKACCT     C     15     0   BANK ACCOUNT NUMBER                     
 103    S_BANKCODE     C      4     0   BANK CODE                               
 104    S_FEDCODE      C      6     0   FED CODE                                
 105    S_ACCT1        C     40     0   ACCOUNT OWNER NAME 1                    
 106    S_ACCT2        C     40     0   ACCOUNT OWNER NAME 2                    
 107    S_ACCT3        C     40     0   ACCOUNT OWNER NAME 3                    
 108    S_ACCT4        C     40     0   ACCOUNT OWNER NAME 4                    
 109    S_USECALF      C      1     0   USE THE FRINGE BENEFIT SPREAD DEPT 
ROUTI
 110    S_CALF_NUM     C     13     0   FRINGES TO USE THE ROUTINE ON           
 111    S_CALF_MAX     N     12     2   MAXIMUM AMOUNT FOR 1ST FRING ON LIST    
 112    S_CALF_ST      N      2     0   REPLACEMENT STARTS AT                   
 113    S_CALF_LN      N      2     0   REPLACEMENT CONTINUES FOR               
 114    S_NEWSCR       C      1     0   USE NEW POSTING SCREEN                  
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 114 FIELDS = 1416




 
PRTAXS : TAX FILE (FWT,SWT,FICA,...)                 

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRTAX          C      6     0   TAX CODE (SEE BELOW)                    
   2    PRDESC         C     15     0   DESCRIPTION OF TAX                      
   3    PRTABL         C      1     0   Y=USE MPRWITH# FILE AS TABLE            
   4    PRRATE         N      7     5   RATE TO DEDUCT IN DECIMAL (NOT %)       
   5    PRBASE         N      9     2   MAX EMPL TAXABLE GROSS (0.00=NO MAX)    
   6    PRMAX          N      9     2   MAX AMT THAT CAN BE TAKEN (0=NO MAX)    
   7    PRACNT         C     25     0   G/L ACCOUNT                             
   8    PRSUTATYP      C      1     0   SUTA PAID BY EMPLOYER OR EMPLOYEE 
(R/E) 
   9    X_APVEND       C      9     0   ACCOUNTS PAYABLE VENDOR                 
  10    PRWITH1        N     10     2   QTD WITHHELD IN QUARTER 1               
  11    PRWITH2        N     10     2   QTD WITHHELD IN QUARTER 2               
  12    PRWITH3        N     10     2   QTD WITHHELD IN QUARTER 3               
  13    PRWITH4        N     10     2   QTD WITHHELD IN QUARTER 4               
  14    PRDEP1         N     10     2   QTD DEPOSITED IN QUARTER 1              
  15    PRDEP2         N     10     2   QTD DEPOSITED IN QUARTER 2              
  16    PRDEP3         N     10     2   QTD DEPOSITED IN QUARTER 3              
  17    PRDEP4         N     10     2   QTD DEPOSITED IN QUARTER 4              
  18    X_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  19    PRSTATE        C      1     0   ACCUMULATE GSW FOR STATE EXEMPT 
EMPLOYEE
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 19 FIELDS = 165

                                Related Indexes                                

PRTAXS : PRTAX                                                                 



 
PRTCHK : TEMPORARY CHECK FILE                     

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRCHECK        C      8     0                                           
   2    PRSEQNO        C      5     0                                           
   3    PREMPL         C      9     0                                           
   4    PRLAST         C     25     0   LAST NAME: SAME AS PREMPL->PRLAST       
   5    PRFIRST        C     15     0   FIRST NAME: SAME AS PREMPL->PRFIRST     
   6    PRDATE         D      8     0                                           
   7    PREND          D      8     0                                           
   8    PRDAYS         N      3     0                                           
   9    PRGROSS        N      9     2                                           
  10    C_CONTRACT     N      9     2   AMOUNT OF GROSS THAT IS CONTRACT        
  11    PRGTW          N      9     2                                           
  12    PRGSW          N      9     2                                           
  13    PRGFW          N      9     2                                           
  14    PRGMW          N      9     2   GROSS MEDI WAGES                        
  15    PRFWT          N      9     2                                           
  16    PRTXFR         N      9     2                                           
  17    C_FRINGE       N      9     2                                           
  18    C_REIMB        N      9     2                                           
  19    PRNET          N      9     2                                           
  20    PRDNET         N      9     2   NET DIRECT DEPOSITS                     
  21    PRFICA         N      9     2                                           
  22    PRMEDI         N      9     2   MEDI WITHHELD                           
  23    PRSWT          N      9     2                                           
  24    PRSDI          N      9     2                                           
  25    PRLOC          N      9     2                                           
  26    PRFUTA         N      9     2   FEDERAL UNEMPLOYMENT TAX                
  27    PRSUTA         N      9     2   STATE UNEMPLOYMENT TAX                  
  28    PRERFI         N      9     2   EMPLOYER FICA                           
  29    PRERME         N      9     2   EMPLOYER MEDI                           
  30    PR401K         N      9     2                                           
  31    PRVDATE        D      8     0                                           
  32    C_NETACNT      C     25     0                                           
  33    C_RETURN       C      1     0                                           
  34    C_POSTAMT      N     11     2                                           
  35    C_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  36    C_DELFLAG      C      1     0                                           
  37    TT_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  38    DT_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  39    OT_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  40    R9_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  41    R8_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  42    R7_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  43    R6_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  44    R5_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  45    R4_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  46    R3_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  47    R2_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  48    R1_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  49    FD_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  50    FC_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  51    FB_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  52    FA_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  53    F9_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  54    F8_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  55    F7_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  56    F6_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  57    F5_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  58    F4_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  59    F3_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  60    F2_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  61    F1_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  62    O9_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  63    O8_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  64    O7_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  65    O6_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  66    O5_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  67    O4_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  68    O3_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  69    O2_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  70    O1_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  71    H9_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  72    H8_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  73    H7_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  74    H6_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  75    H5_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  76    H4_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  77    H3_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  78    H2_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  79    H1_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  80    HA_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  81    HB_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  82    HC_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  83    HD_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  84    HE_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  85    HF_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  86    HG_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  87    HH_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  88    HI_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  89    HJ_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  90    HK_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  91    HL_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  92    HM_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  93    HN_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  94    HO_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  95    HQ_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  96    HR_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  97    HS_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  98    HT_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
  99    HU_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 100    HV_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 101    HW_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 102    HX_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 103    HY_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 104    HZ_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 105    G9_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 106    G8_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 107    G7_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 108    G6_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 109    G5_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 110    G4_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 111    G3_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 112    G2_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 113    G1_INFO        M      0     0   PAY TYPE (MEMORY VARIABLES)             
 114    GR_AMT         N     10     2                                           
 115    HR_AMT         N     10     2                                           
 116    OT_AMT         N     10     2                                           
 117    DT_AMT         N     10     2                                           
 118    TT_AMT         N     10     2                                           
 119    TO_AMT         N     10     2                                           
 120    SP_AMT         N     10     2                                           
 121    VP_AMT         N     10     2                                           
 122    HP_AMT         N     10     2                                           
 123    PP_AMT         N     10     2                                           
 124    L1_AMT         N     10     2                                           
 125    L2_AMT         N     10     2                                           
 126    L3_AMT         N     10     2                                           
 127    L4_AMT         N     10     2                                           
 128    L5_AMT         N     10     2                                           
 129    L6_AMT         N     10     2                                           
 130    F1_AMT         N     10     2                                           
 131    F2_AMT         N     10     2                                           
 132    F3_AMT         N     10     2                                           
 133    F4_AMT         N     10     2                                           
 134    F5_AMT         N     10     2                                           
 135    F6_AMT         N     10     2                                           
 136    F7_AMT         N     10     2                                           
 137    F8_AMT         N     10     2                                           
 138    F9_AMT         N     10     2                                           
 139    FA_AMT         N     10     2                                           
 140    FB_AMT         N     10     2                                           
 141    FC_AMT         N     10     2                                           
 142    FD_AMT         N     10     2                                           
 143    R1_AMT         N     10     2                                           
 144    R2_AMT         N     10     2                                           
 145    R3_AMT         N     10     2                                           
 146    R4_AMT         N     10     2                                           
 147    R5_AMT         N     10     2                                           
 148    R6_AMT         N     10     2                                           
 149    R7_AMT         N     10     2                                           
 150    R8_AMT         N     10     2                                           
 151    R9_AMT         N     10     2                                           
 152    HR_HRS         N     10     2                                           
 153    OT_HRS         N     10     2                                           
 154    DT_HRS         N     10     2                                           
 155    TT_HRS         N     10     2                                           
 156    SP_HRS         N     10     2                                           
 157    VP_HRS         N     10     2                                           
 158    HP_HRS         N     10     2                                           
 159    PP_HRS         N     10     2                                           
 160    L1_HRS         N     10     2                                           
 161    L2_HRS         N     10     2                                           
 162    L3_HRS         N     10     2                                           
 163    L4_HRS         N     10     2                                           
 164    L5_HRS         N     10     2                                           
 165    L6_HRS         N     10     2                                           
 166    SP_RATE        N     11     4                                           
 167    VP_RATE        N     11     4                                           
 168    HP_RATE        N     11     4                                           
 169    PP_RATE        N     11     4                                           
 170    L1_RATE        N     11     4                                           
 171    L2_RATE        N     11     4                                           
 172    L3_RATE        N     11     4                                           
 173    L4_RATE        N     11     4                                           
 174    L5_RATE        N     11     4                                           
 175    L6_RATE        N     11     4                                           
 176    GR_YTD         N     10     4                                           
 177    GR_FTD         N     10     2                                           
 178    NT_YTD         N     10     2                                           
 179    FW_YTD         N     10     2                                           
 180    SW_YTD         N     10     2                                           
 181    FI_YTD         N     10     2                                           
 182    ME_YTD         N     10     2   YEAR TO DATE MEDI WITHHELD              
 183    SD_YTD         N     10     2                                           
 184    SU_YTD         N     10     2   YTD SUTA TAX                            
 185    LT_YTD         N     10     2                                           
 186    D_INFO_1       M     10     2   HOLDS C_DEDU? VARIABLES                 
 187    D_INFO_2       M     10     2   HOLDS D?_DES VARIABLES                  
 188    D_INFO_3       M     10     2   HOLDS D?_YTD VARIABLES                  
 189    P00_YTD        N     10     2                                           
 190    P02_YTD        N     10     2                                           
 191    P04_YTD        N     10     2                                           
 192    P06_YTD        N     10     2                                           
 193    P08_YTD        N     10     2                                           
 194    P20_YTD        N     10     2                                           
 195    P40_YTD        N     10     2                                           
 196    PRDEPT         C      3     0                                           
 197    PRSTATUS       C      1     0                                           
 198    P080_YTD       N     10     2   SICK PAY YTD                            
 199    P081_YTD       N     10     2   VACTION PAY YTD                         
 200    P082_YTD       N     10     2   HOLIDAY PAY YTD                         
 201    P083_YTD       N     10     2   PERSONAL PAY YTD                        
 202    P084_YTD       N     10     2   LEAVE 1 PAY YTD                         
 203    P085_YTD       N     10     2   LEAVE 2 PAY YTD                         
 204    P086_YTD       N     10     2   LEAVE 3 PAY YTD                         
 205    P087_YTD       N     10     2   LEAVE 4 PAY YTD                         
 206    P088_YTD       N     10     2   LEAVE 5 PAY YTD                         
 207    P089_YTD       N     10     2   LEAVE 6 PAY YTD                         
 208    SP_ACC         N      8     3   YTD SICK HOURS ACCRUED                  
 209    VP_ACC         N      8     3   YTD VACA HOURS ACCRUED                  
 210    PP_ACC         N      8     3   YTD PERSONAL HOURS ACCRUED              
 211    L1_ACC         N      8     3   YTD LEAVE 1 HOURS ACCRUED               
 212    L2_ACC         N      8     3   ETC                                     
 213    L3_ACC         N      8     3   ETC                                     
 214    L4_ACC         N      8     3   ETC                                     
 215    L5_ACC         N      8     3   ETC                                     
 216    L6_ACC         N      8     3   ETC                                     
 217    SP_TAK         N      8     3   YTD SICK HOURS TAKEN                    
 218    VP_TAK         N      8     3   ETC                                     
 219    PP_TAK         N      8     3   ETC                                     
 220    L1_TAK         N      8     3   ETC                                     
 221    L2_TAK         N      8     3   ETC                                     
 222    L3_TAK         N      8     3   ETC                                     
 223    L4_TAK         N      8     3   ETC                                     
 224    L5_TAK         N      8     3   ETC                                     
 225    L6_TAK         N      8     3   ETC                                     
 226    SP_EARN        N      8     3   SICK HOURS EARNED THIS PERIOD           
 227    VP_EARN        N      8     3   ETC                                     
 228    PP_EARN        N      8     3   ETC                                     
 229    L1_EARN        N      8     3   ETC                                     
 230    L2_EARN        N      8     3   ETC                                     
 231    L3_EARN        N      8     3   ETC                                     
 232    L4_EARN        N      8     3   ETC                                     
 233    L5_EARN        N      8     3   ETC                                     
 234    L6_EARN        N      8     3   ETC                                     
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 234 FIELDS = 1477




 
PRWITH : TAX TABLE FILE                       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PRTAX          C      6     0   TAX CODE (FWT,SWT+STATE,LOC+CODE)       
   2    PRTSTAT        C      1     0   MARITAL STATUS                          
   3    PRMINW         N      9     2   MINIMUM WAGE FOR THIS TAX AND RATE      
   4    PRMINT         N      8     2   MINIMUM TAX FOR THIS CATEGORY           
   5    PRRATE         N      5     3   ADDITIONAL TAX RATE                     
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 5 FIELDS = 29

                                Related Indexes                                

PRWITH : PRTAX+PRTSTAT+STR(INT(PRMINW))                                        



 
PRX2AP : TRANSFER TO A/P FILE (APMAST)                

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    PVENDNO        C      9     0   VENDOR NUMBER                           
   2    PINVNO         C     12     0   INVOICE NUMBER                          
   3    REF            C      8     0   PURCHASE ORDER NUMBER                   
   4    CHECKNO        C      8     0   CHECK NUMBER                            
   5    POSTAT         C      1     0   U=UNPAID,P=PAID,V=VOID                  
   6    PCOMPANY       C     35     0   VENDOR COMPANY NAME                     
   7    PADDRESS1      C     35     0   VENDOR ADDRESS 1                        
   8    PADDRESS2      C     35     0   VENDOR ADDRESS 2                        
   9    PCITY          C     25     0   VENDOR CITY                             
  10    PSTATE         C     10     0   VENDOR STATE                            
  11    PZIP           C     10     0   VENDOR ZIP                              
  12    PPRIORITY      C      2     0   CHECKING ACCOUNT CODE (MN=MANUAL)       
  13    PURDATE        D      8     0   DATE OF PURCHASE (INVOICE DATE)         
  14    DUEDATE        D      8     0   DATE PAYMENT DUE                        
  15    CHECKDATE      D      8     0   DATE OF CHECK                           
  16    PURAMT         N     11     2   FULL AMOUNT OF PURCHASE                 
  17    DISAMT         N     11     2   DISCOUNT AMOUNT                         
  18    PAIDAMT        N     11     2   AMOUNT PAID                             
  19    CHECKACC       C     25     0   G/L NET ACCOUNT NUMBER                  
  20    M_FUNDESC      C     15     0   FUND DESCRIPTION                        
  21    M_FISCYR       C      9     0   FISCAL YEAR (1234-1234)                 
  22    M_INVDESC      C     25     0   INVOICE DESCRIPTION                     
  23    M_DISPERC      N      5     2   DISCOUNT PERCENTAGE                     
  24    M_DISDAY       N      2     0   # DAYS TO CALC DISCOUNT DUE DATE        
  25    M_DUEDAY       N      2     0   # DAYS TO CALC FINAL DUE DATE           
  26    M_VOUCHER      C      8     0   VOUCHER NUMBER                          
  27    M_FROMPO       C      1     0   "Y"=INVOICE STARTED AS A PO             
  28    M_1099         C      1     0   "Y"=INVOICE IS A 1099 PAYMENT           
  29    M_MISCFLG      C      1     0   USED DURING:REPRINT & WARRANT REPO      
  30    M_GL_POST      C      1     0   "Y"=POSTED TO G/L " " = NOT POSTED      
  31    M_GL_INV       C      1     0   "Y"=INVOICE HAS BEEN POSTED             
  32    M_GL_CHK       C      1     0   "Y"=CHECK HAS BEEN POSTED               
  33    M_GL_BAT       C      3     0   GL BATCH NUMBER                         
  34    M_MANUAL       C      1     0   'Y' OR 'N' IF MANUAL                    
  35    M_NETSTAMP     N      2     0   NETWORK SIGNATURE                       
  36    M_DELFLAG      C      1     0   "*" FOR RE-USABLE RECORD                
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 36 FIELDS = 351




 
PRX2GL : TRANSFER TO G/L FILE (GLTRAX)                

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    TRSACT         C     25     0   ACCOUNT NUMBER                          
   2    TRSDES         C     25     0   TRANSACTION DESCRIPTION                 
   3    TRSREF         C     12     0   REFERENCE NUMBER                        
   4    TRSDATE        D      8     0   TRANSACTION DATE                        
   5    TRSAMT         N     15     2   AMOUNT                                  
   6    TRSID          C      1     0   0=SPECIAL,1=POSTING,2=REFERENCE         
   7    TRSMODU        C      2     0   MODULE THAT GENERATED THIS POSTING      
   8    TRSCOMPID      C      2     0   COMPANY ID THAT GENERATED THIS 
POSTING  
   9    TRSTYPE        C      1     0   TRANSACTION TYPE (SEE BELOW)            
  10    TRSPD          C      2     0   G/L PERIOD OF POSTING                   
  11    TRSDELFLAG     C      1     0                                           
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 11 FIELDS = 94

© NEMRC 2010-2021 | Privacy Policy