Definition of table tax-table
Federal, State and Local tax tables , Table Dump Name tax-tbl

Alphabetical Field Summary

  • acct-num: (CHAR) Liability account for tax table
  • backup-rate: (DECM) Backup/Bonus pay taxing rate
  • calendar-year: (INTG) Calendar year associated with this record
  • check-run: (INTG) Check for for tax table
  • disburse-enabled: (LOGC) Enable automatic FAS disbursements for this tax
  • ent-id: (CHAR) Entity ID for tax table
  • exempt-amount: (DECM) Annual amount of 1 exemption
  • exempt2-amount: (DECM) Annual Secondary exemption amount (if any) for this tax tabl
  • extern-guid: (CHAR) External Global Unique ID for this record
  • hoh-excess[10]: (DECM) HOH Excess
  • hoh-over[10]: (DECM) HOH Over
  • hoh-percent[10]: (DECM) HOH Percent
  • hoh-under[10]: (DECM) HOH Under
  • hoh-withhold[10]: (DECM) hoh withhold
  • married-excess[10]: (DECM) Excess wages for this tax bracket
  • married-over[10]: (DECM) Low income range for this tax bracket (annually)
  • married-percent[10]: (DECM) Additional percentage to withhold at this tax bracket
  • married-under[10]: (DECM) High income range (annually) for this tax bracket
  • married-withhold[10]: (DECM) Base amount to withhold for this tax bracket (annually)
  • primary-key: (INTG) Unique, Primary key for record
  • single-excess[10]: (DECM) Excess wages for this tax bracket
  • single-over[10]: (DECM) Low income range for this tax bracket (annually)
  • single-percent[10]: (DECM) Additional percentage to withhold at this tax bracket
  • single-under[10]: (DECM) High income range (annually) for this tax bracket
  • single-withhold[10]: (DECM) Base amount to withhold for this tax bracket (annually)
  • tax-enabled: (LOGC) Is tax table enabled?
  • tax-name: (CHAR) Tax Table name (Federal, State or Local)
  • tax-reporting-id: (CHAR) Reporting ID for this tax (blank to use districts FEIN)

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • tax-table: (UNIQUE, PRIMARY) calendar-year, tax-name

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-txt.p
  • DELETE: Overridable, Procedure is tr-d-txt.p
  • REPLICATION-CREATE: Procedure is rp-c-txt.p
  • REPLICATION-DELETE: Procedure is rp-d-txt.p
  • REPLICATION-WRITE: Procedure is rp-u-txt.p
  • WRITE: Overridable, Procedure is tr-u-txt.p

    Tables tax-table references

  • emp-distrib - Employee Distributions
  • emp-w2 - Employee W2 Info
  • pay-acct - Payroll Distribution Account List
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-distrib - Payroll DIstributions file
  • pay-profile - Payroll System Profile

    Detailed Alphabetical Field Listing
    acct-num Data type: CHARACTER
    Format: x(30)
    Description: Liability account for tax table
    Help: Liability account for this tax table

    backup-rate Data type: DECIMAL (Decimals: 2)
    Format: zz9.99% (Initial Value: 0)
    Help: Backup/Bonus pay taxing rate

    calendar-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Calendar year associated with this record
    Attributes: Index Component

    check-run Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Description: Check for for tax table
    Help: Check run used for disbursements created for this tax table

    disburse-enabled Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Enable automatic FAS disbursements for this tax
    Help: Yes to enable automatic disbursements for this tax table

    ent-id Data type: CHARACTER
    Format: x(6)
    Description: Entity ID for tax table
    Help: Entity ID for disbursements from this tax table

    exempt-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Annual amount of 1 exemption

    exempt2-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Annual Secondary exemption amount (if any) for this tax tabl

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    hoh-excess Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: HOH Excess

    hoh-over Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: HOH Over

    hoh-percent Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zz9.999% (Initial Value: 0)
    Help: HOH Percent

    hoh-under Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: HOH Under

    hoh-withhold Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: hoh withhold

    married-excess Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Excess wages for this tax bracket

    married-over Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Low income range for this tax bracket (annually)

    married-percent Data type: DECIMAL (Extent: 10, Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: Additional percentage to withhold at this tax bracket

    married-under Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: High income range (annually) for this tax bracket

    married-withhold Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Base amount to withhold for this tax bracket (annually)

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for record

    single-excess Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Excess wages for this tax bracket

    single-over Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Low income range for this tax bracket (annually)

    single-percent Data type: DECIMAL (Extent: 10, Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: Additional percentage to withhold at this tax bracket

    single-under Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: High income range (annually) for this tax bracket

    single-withhold Data type: DECIMAL (Extent: 10, Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Base amount to withhold for this tax bracket (annually)

    tax-enabled Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Description: Is tax table enabled?
    Help: No to disable this table and related taxes for anyone using

    tax-name Data type: CHARACTER
    Format: x(8)
    Help: Tax Table name (Federal, State or Local)
    Attributes: Index Component

    tax-reporting-id Data type: CHARACTER
    Format: x(12)
    Help: Reporting ID for this tax (blank to use districts FEIN)

    Created on 12/28/2020 by DBHTML V1.2