PRU    P/R Tax Table Master File (PRU_TaxTableMasterFile)                       Level: 4.40
        Record Type: 1    P/R Tax Table Master File                              08/28/2009
 
 File Type: Direct   Key Size: 6    Rec Len: 184     Min Len: 110    Define: N

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 State Code (Spaces For Federal) . . . . StateCodeSpacesForFederal . . String      *(1,3)
 Local Code (Spaces For State And FederalLocalCodeSpacesForStateAndFed String      *(4,3)
 Description . . . . . . . . . . . . . . Description . . . . . . . . . String      (7,25)
 Company Tax Id Number . . . . . . . . . CompanyTaxIdNumber. . . . . . String      (32,15)
 Accrual G/L Acct-Withholding. . . . . . AccrualGLAcctWithholding. . . G/L Account (47,9)
 Accrual G/L Acct-Worker'S Comp. . . . . AccrualGLAcctWorkersComp. . . G/L Account (56,9)
 Accrual G/L Acct-Empl Fica/Sdi/Ldi. . . AccrualGLAcctEmplFicaSdiLdi . G/L Account (65,9)
 Accr G/L Acct-Empr Fica/Empl Sui/Ol . . AccrGLAcctEmprFicaEmplSui . . G/L Account (74,9)
 Accrual G/L Acct-Unemployment . . . . . AccrualGLAcctUnemployment . . G/L Account (83,9)
 Tax Limit Type (A/Q/W/D). . . . . . . . TaxLimitTypeEmplFicaSdiLdi. . String      (92,1)
   Employee FICA/SDI/LDI (Fed/State/Local. . . . . . . . . . . . . . . Memo
   Annually, Quarterly, Weekly, Daily. . . . . . . . . . . . . . . . . Memo
 Tax Limit Type (A/Q/W/D). . . . . . . . TaxLimTypEmprFicaEmplSui. . . String      (93,1)
   Emplr FICA/Emple SUI/Other Local Tax. . . . . . . . . . . . . . . . Memo
 Tax Limit Type - Unemployment . . . . . TaxLimitTypeUnemployment. . . String      (94,1)
   Annually, Quarterly, Weekly, Daily. . . . . . . . . . . . . . . . . Memo
 Tax Calculation Steps . . . . . . . . . TaxCalculationSteps . . . . . String      (95,9)
 Personal Exemptions Exist?. . . . . . . PersonalExemptionsExist . . . Yes/No      (104,1)
 Personal Exemptions Exceeed Dep Exemps. PersonalExemptionsExceeedDep. Yes/No      (105,1)
 Exclude Table From Tax Update (Y/N) . . ExcludeTableFromTaxUpdate . . Yes/No      (106,1)
 Round Withholding Tax Amount? . . . . . RoundWithholdingTaxAmount . . Yes/No      (107,1)
 W2 Locality Tax Type. . . . . . . . . . W2LocalityTaxType . . . . . . Uppercase   (108,1)
   space = none. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
   C = City Income Tax . . . . . . . . . . . . . . . . . . . . . . . . Memo
   D = County Income Tax . . . . . . . . . . . . . . . . . . . . . . . Memo
   E = School District Income Tax. . . . . . . . . . . . . . . . . . . Memo
   F = Other Income Tax. . . . . . . . . . . . . . . . . . . . . . . . Memo
 Tax Type. . . . . . . . . . . . . . . . TaxType . . . . . . . . . . . Zero-Filled (109,2)
   Aatrix ELI Tax Type (last 2 digits) . . . . . . . . . . . . . . . . Memo
 Employee Fica/Sdi/Ldi Rate. . . . . . . EmployeeFicaSdiLdiRate. . . . Number      [0]       3.5
 Empl Fica Rate/Empl Sui/Other Local . . EmplFicaRateEmplSuiOtherLocal Number      [1]       3.5
 Unemployment Tax Rate . . . . . . . . . UnemploymentTaxRate . . . . . Number      [2]       3.5
 Employee Fica/Sdi/Ldi Limit . . . . . . EmployeeFicaSdiLdiLimit . . . Number      [3]       7.2
 Empl Fica Lim/Empl Sui/Other Local. . . EmplFicaLimEmplSuiOtherLoc. . Number      [4]       7.2
 Unemployment Tax Limit. . . . . . . . . UnemploymentTaxLimit. . . . . Number      [5]       7.2
                                                                                   ________
                                                                      Total Bytes  181