Definition of table Deductions
Employee Deductions , Table Dump Name res-0006

Alphabetical Field Summary

  • all-or-nothing: (LOGC) 'Yes' to drop deductions exceeding gross, 'No' to reduce the
  • cap-tsa-as-tvd: (LOGC) 'Yes' to have excess TSA (over class limit) become TVD
  • comp-code: (INTG) Employee's assigned company
  • comp-code-description: (CHAR) A brief description of the company's purpose
  • cur-amount: (DECM) Current deduction amount for this payroll
  • cur-gross: (DECM) Gross deduction was calculated on
  • cur-tsa-amount: (DECM) TSA portion of deduction amount
  • cur-tvd-amount: (DECM) TVD portion of deduction amount
  • deduct-accrual: (DECM) Total Deduction accrual since last reset
  • deduct-active: (LOGC) Is this deduction active for this payroll?
  • deduct-amount: (DECM) Amount to deduct for this payroll
  • deduct-by: (CHAR) Deduct funds using an Amount, Percent or Master
  • deduct-cycle-code: (CHAR) Name of this payroll cycle
  • deduct-gross: (DECM) Total Gross deduction was calculated on since last reset
  • deduct-group: (CHAR) Name of the deduction group
  • deduct-limit: (DECM) Deduction limit (or 0 if there is no limit)
  • deduct-master-active: (LOGC) Deduction Active?
  • deduct-master-cycle-code: (CHAR) Name of this payroll cycle
  • deduct-master-print-on-check: (LOGC) 'Yes' if deduction should appear on check stub, 'No' otherwi
  • deduct-master-start-pay: (CHAR) Payroll number.
  • deduct-master-stop-pay: (CHAR) Payroll number.
  • deduct-name: (CHAR) Name of this deduction
  • deduct-num: (INTG) Deduction number
  • deduct-percent: (DECM) Percentage to deduct
  • deduct-tsa-accrual: (DECM) TSA portion of deduction amount
  • deduct-tvd-accrual: (DECM) TVD portion of deduction amount
  • deduct-user-info: (CHAR) User data; can be used for classification, notes, etc
  • deposit-acct-type: (CHAR) Direct deposit type is 'None', 'Checking' or 'Savings'
  • deposit-num: (CHAR) Direct Deposit # (if any) for this deduction
  • deposit-route-num: (CHAR) Routing number for direct depositing
  • dept-code: (INTG) Employee's assigned department code
  • dept-code-description: (CHAR) A brief description of the departments purpose
  • div-code: (INTG) Employee's assigned division
  • div-code-description: (CHAR) A brief description of the division's purpose
  • emp-active: (LOGC) Is employee currently active?
  • emp-fte: (DECM) Employee's Full Time Equivilency (0.00 to 1.00)
  • emp-group: (CHAR) An employee grouping classification
  • emp-id: (CHAR) Employee ID (if used)
  • emp-name: (CHAR) Employee's name in "LAST NAME, FIRST NAME M" order
  • emp-pic: (CHAR) Employee's PIC (assigned by State)
  • emp-sex: (LOGC) Employee's sex
  • emp-ssn: (CHAR) Employee's SSN
  • ethnic-code: (CHAR) Employee's ethnicity code
  • for-regular-pay: (LOGC) 'Reg' to use only for regular pays, 'All' to use for all pay
  • fytd-amount: (DECM) FYTD Amount for this deduction
  • fytd-gross: (DECM) FYTD total Gross deduction was calculated on
  • fytd-tsa-amount: (DECM) TSA portion of deduction amount
  • fytd-tvd-amount: (DECM) TVD portion of deduction amount
  • irs-class: (CHAR) Name of IRS deduction classification (i.e. 401k, 403b, etc)
  • is-applicant: (LOGC) Yes if this entry is for an applicant
  • job-code: (CHAR) Employee's job code
  • job-code-description: (CHAR) A brief description of the job
  • last-deposited: (DECM) Amount last deposited for a ACH and/or direct deposit deduct
  • loc-code: (CHAR) Employee's Primary Location
  • loc-code-description: (CHAR) A brief description of the job
  • marital-code: (CHAR) Employee's Marital status
  • master-check-num: (INTG) Check number
  • master-cycle-code: (CHAR) Name of this payroll cycle
  • master-ecc-code: (CHAR) ECC Code
  • master-pay-active: (LOGC) Is this employee active for this payroll?
  • master-pay-group: (CHAR) Name of this employee payroll group
  • master-pay-regular: (LOGC) 'Regular' or 'Supplemental' payroll
  • master-retire-code: (CHAR) Retirement code name
  • master-start-pay: (CHAR) Starting Payroll number.
  • master-stop-pay: (CHAR) Ending Payroll number.
  • mtd-amount: (DECM) MTD amount for deduction
  • mtd-gross: (DECM) MTD Total gross deduction was calculated on
  • mtd-tsa-amount: (DECM) TSA portion of deduction amount
  • mtd-tvd-amount: (DECM) TVD portion of deduction amount
  • net-as-gross: (LOGC) 'Yes' to base deduction on Net, 'No' for running/payrate gro
  • override-irs-class: (LOGC) Yes to allow overriding IRS Class limits for the TSA
  • payroll-num: (CHAR) Payroll number.
  • payroll-year: (INTG) Payroll year associated with this record
  • qtd-amount: (DECM) QTD Amount for this deduction
  • qtd-gross: (DECM) QTD Total gross deduction was calculated on
  • qtd-tsa-amount: (DECM) TSA portion of deduction amount
  • qtd-tvd-amount: (DECM) TVD portion of deduction amount
  • start-date: (DATE) Initial/starting date of employees use of the deduction
  • start-pay-num: (CHAR) Payroll number.
  • status-code: (CHAR) Employee's status code
  • stop-pay-num: (CHAR) Payroll number.
  • union-member: (LOGC) Does employee belong to a union?
  • use-all-rates: (LOGC) 'All' for all payrates or 'Some' to select only a few payrat
  • ytd-amount: (DECM) YTD Amount for this deduction
  • ytd-gross: (DECM) YTD Total gross deduction was calculated on
  • ytd-tsa-amount: (DECM) TSA portion of deduction amount
  • ytd-tvd-amount: (DECM) TVD portion of deduction amount

    Alphabetical Index Summary

  • comp-code: (PRIMARY) comp-code
  • deduct-cycle-code: deduct-cycle-code
  • deduct-group: deduct-group
  • deduct-master-cycle-code: deduct-master-cycle-code
  • deduct-master-start-pay: deduct-master-start-pay
  • deduct-master-stop-pay: deduct-master-stop-pay
  • deduct-name: deduct-name
  • deduct-num: deduct-num
  • dept-code: dept-code
  • div-code: div-code
  • emp-group: emp-group
  • emp-id: emp-id
  • emp-name: emp-name
  • emp-ssn: emp-ssn
  • ethnic-code: ethnic-code
  • irs-class: irs-class
  • is-applicant: is-applicant
  • job-code: job-code
  • loc-code: loc-code
  • marital-code: marital-code
  • master-check-num: master-check-num
  • master-cycle-code: master-cycle-code
  • master-ecc-code: master-ecc-code
  • master-pay-group: master-pay-group
  • master-retire-code: master-retire-code
  • master-start-pay: master-start-pay
  • master-stop-pay: master-stop-pay
  • payroll-num: payroll-num
  • payroll-year: payroll-year
  • start-pay-num: start-pay-num
  • status-code: status-code
  • stop-pay-num: stop-pay-num

    Tables Deductions references

  • Contacts - Employee Contacts
  • Counters - Employee Gross and Tax Counters
  • Degree - Employee Degrees
  • Dependents - Employee Dependents
  • Distributions - Employee Distributions
  • Events - Employee Events
  • Notes - Employee Notes
  • Payrates - Employee Payrates
  • Payrate_Distributions - Payrate Related Distributions
  • Retirement - Per Payroll Retirement
  • Taxes - Employee Tax Setup (no counters)
  • W2 - Employee W2 information

    Detailed Alphabetical Field Listing
    all-or-nothing Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' to drop deductions exceeding gross, 'No' to reduce the

    cap-tsa-as-tvd Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' to have excess TSA (over class limit) become TVD

    comp-code Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Description: Employee's assigned company
    Attributes: Index Component

    comp-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the company's purpose

    cur-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Current deduction amount for this payroll

    cur-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Gross deduction was calculated on

    cur-tsa-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    cur-tvd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    deduct-accrual Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Total Deduction accrual since last reset

    deduct-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this deduction active for this payroll?

    deduct-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount to deduct for this payroll

    deduct-by Data type: CHARACTER
    Format: x(8)
    Description: Deduct funds using an Amount, Percent or Master

    deduct-cycle-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this payroll cycle
    Attributes: Index Component

    deduct-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Total Gross deduction was calculated on since last reset

    deduct-group Data type: CHARACTER
    Format: x(8)
    Description: Name of the deduction group
    Attributes: Index Component

    deduct-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Deduction limit (or 0 if there is no limit)

    deduct-master-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Deduction Active?

    deduct-master-cycle-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this payroll cycle
    Attributes: Index Component

    deduct-master-print-on-check Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if deduction should appear on check stub, 'No' otherwi

    deduct-master-start-pay Data type: CHARACTER
    Format: x(5) (Initial Value: First)
    Description: Payroll number.
    Attributes: Index Component

    deduct-master-stop-pay Data type: CHARACTER
    Format: x(4) (Initial Value: Last)
    Description: Payroll number.
    Attributes: Index Component

    deduct-name Data type: CHARACTER
    Format: x(8)
    Description: Name of this deduction
    Attributes: Index Component

    deduct-num Data type: INTEGER
    Format: zzz9 (Initial Value: 0)
    Description: Deduction number
    Attributes: Index Component

    deduct-percent Data type: DECIMAL (Decimals: 2)
    Format: -zz9.99% (Initial Value: 0)
    Description: Percentage to deduct

    deduct-tsa-accrual Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    deduct-tvd-accrual Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    deduct-user-info Data type: CHARACTER
    Format: x(12)
    Description: User data; can be used for classification, notes, etc

    deposit-acct-type Data type: CHARACTER
    Format: x(8)
    Description: Direct deposit type is 'None', 'Checking' or 'Savings'

    deposit-num Data type: CHARACTER
    Format: x(20)
    Description: Direct Deposit # (if any) for this deduction

    deposit-route-num Data type: CHARACTER
    Format: x(16)
    Description: Routing number for direct depositing

    dept-code Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Employee's assigned department code
    Attributes: Index Component

    dept-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the departments purpose

    div-code Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Employee's assigned division
    Attributes: Index Component

    div-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the division's purpose

    emp-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is employee currently active?

    emp-fte Data type: DECIMAL (Decimals: 2)
    Format: 9.99 (Initial Value: 0)
    Description: Employee's Full Time Equivilency (0.00 to 1.00)

    emp-group Data type: CHARACTER
    Format: x(8)
    Description: An employee grouping classification
    Attributes: Index Component

    emp-id Data type: CHARACTER
    Format: 999999
    Description: Employee ID (if used)
    Attributes: Index Component

    emp-name Data type: CHARACTER
    Format: x(30)
    Description: Employee's name in "LAST NAME, FIRST NAME M" order
    Attributes: Index Component

    emp-pic Data type: CHARACTER
    Format: x(10)
    Description: Employee's PIC (assigned by State)

    emp-sex Data type: LOGICAL
    Format: Male/Female (Initial Value: no)
    Description: Employee's sex

    emp-ssn Data type: CHARACTER
    Format: xxx-xx-xxxx
    Description: Employee's SSN
    Attributes: Index Component

    ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's ethnicity code
    Attributes: Index Component

    for-regular-pay Data type: LOGICAL
    Format: Reg/All (Initial Value: no)
    Description: 'Reg' to use only for regular pays, 'All' to use for all pay

    fytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Amount for this deduction

    fytd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: FYTD total Gross deduction was calculated on

    fytd-tsa-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    fytd-tvd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    irs-class Data type: CHARACTER
    Format: x(8)
    Description: Name of IRS deduction classification (i.e. 401k, 403b, etc)
    Attributes: Index Component

    is-applicant Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this entry is for an applicant
    Attributes: Index Component

    job-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's job code
    Attributes: Index Component

    job-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

    last-deposited Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount last deposited for a ACH and/or direct deposit deduct

    loc-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's Primary Location
    Attributes: Index Component

    loc-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

    marital-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's Marital status
    Attributes: Index Component

    master-check-num Data type: INTEGER
    Format: 999999 (Initial Value: 0)
    Description: Check number
    Attributes: Index Component

    master-cycle-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this payroll cycle
    Attributes: Index Component

    master-ecc-code Data type: CHARACTER
    Format: x(8)
    Description: ECC Code
    Attributes: Index Component

    master-pay-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this employee active for this payroll?

    master-pay-group Data type: CHARACTER
    Format: x(8)
    Description: Name of this employee payroll group
    Attributes: Index Component

    master-pay-regular Data type: LOGICAL
    Format: Regular/Supplemental (Initial Value: no)
    Description: 'Regular' or 'Supplemental' payroll

    master-retire-code Data type: CHARACTER
    Format: x(8)
    Description: Retirement code name
    Attributes: Index Component

    master-start-pay Data type: CHARACTER
    Format: x(5) (Initial Value: First)
    Description: Starting Payroll number.
    Attributes: Index Component

    master-stop-pay Data type: CHARACTER
    Format: x(4) (Initial Value: Last)
    Description: Ending Payroll number.
    Attributes: Index Component

    mtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD amount for deduction

    mtd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: MTD Total gross deduction was calculated on

    mtd-tsa-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    mtd-tvd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    net-as-gross Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' to base deduction on Net, 'No' for running/payrate gro

    override-irs-class Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes to allow overriding IRS Class limits for the TSA

    payroll-num Data type: CHARACTER
    Format: x(4)
    Description: Payroll number.
    Attributes: Index Component

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

    qtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Amount for this deduction

    qtd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: QTD Total gross deduction was calculated on

    qtd-tsa-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    qtd-tvd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    start-date Data type: DATE
    Format: 99/99/9999
    Description: Initial/starting date of employees use of the deduction

    start-pay-num Data type: CHARACTER
    Format: x(5) (Initial Value: First)
    Description: Payroll number.
    Attributes: Index Component

    status-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's status code
    Attributes: Index Component

    stop-pay-num Data type: CHARACTER
    Format: x(4) (Initial Value: Last)
    Description: Payroll number.
    Attributes: Index Component

    union-member Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Does employee belong to a union?

    use-all-rates Data type: LOGICAL
    Format: All/Some (Initial Value: no)
    Description: 'All' for all payrates or 'Some' to select only a few payrat

    ytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Amount for this deduction

    ytd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: YTD Total gross deduction was calculated on

    ytd-tsa-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TSA portion of deduction amount

    ytd-tvd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: TVD portion of deduction amount

    Created on 08/13/2012 by DBHTML V1.2