Definition of table emp-deduct

Employee Deductions file , Table Dump Name emp-ded

Alphabetical Field Summary

acct-num: (CHAR) Liability account used for recording this deduction

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

check-run: (INTG) Check run # used for producing this disbursement

cur-amount: (DECM) Current deduction amount for this payroll

cur-employer-contrib: (DECM) Current employer contribution for this deduction

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

dc-end-date: (DATE) DC End Date

dc-flag: (LOGC) Does this deduction represent a defined contribution

dc-record-id: (INTG) DC Record Type

dc-start-date: (DATE) DC Start Date

dc-status-date: (DATE) Date of DC status change

dc-status-id: (INTG) DC Status Change Reason Code

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-id: (INTG) Payroll cycle ID this deduction is active on

deduct-employer-contrib: (DECM) Employer contribution since last reset

deduct-gross: (DECM) Total Gross deduction was calculated on since last reset

deduct-id: (INTG) Deduction ID for the deduction

deduct-info: (CHAR) User data; can be used for classification, notes, etc

deduct-limit: (DECM) Deduction limit (or 0 if there is no limit)

deduct-num: (INTG) Deduction number

deduct-percent: (DECM) Percentage to deduct

deduct-seq: (INTG) Deduction Seq# (assigned once for the life of the deduction)

deduct-tsa-accrual: (DECM) TSA portion of deduction amount

deduct-tvd-accrual: (DECM) TVD portion of deduction amount

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

emp-seq: (INTG) Employee's Unique Sequence #

employer-amount: (DECM) Employer Amount

ent-id: (CHAR) Vendor # used for this deductions provider

extern-guid: (CHAR) External Global Unique ID for this record

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-employer-contrib: (DECM) FYTD employer contribution 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

hit-limit-pay-id: (INTG) Payroll # employee hit deduction limit

hit-limit-pay-seq: (INTG) Employee payroll seq employee hit deduction limit

last-deposit-num: (CHAR) Direct Deposit # (if any) for this deduction of Last deposit

last-deposit-route-num: (CHAR) Routing number for direct depositing of last Direct Deposit

last-deposited: (DECM) Amount last deposited for a ACH and/or direct deposit deduct

last-used-pay-id: (INTG) Last payroll # record was used on

last-used-pay-seq: (INTG) Last employee payroll seq # record was used on

mtd-amount: (DECM) MTD amount for deduction

mtd-employer-contrib: (DECM) MTD Employer Contribution for this 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

pay-id: (INTG) Payroll Identifier

pay-seq: (INTG) Payroll Sequence within a given pay for an employee

pre-note-flag: (LOGC) Yes to generate ACH pre-note (deduction disable for that pay

primary-key: (INTG) Unique, Primary key for record

qtd-amount: (DECM) QTD Amount for this deduction

qtd-employer-contrib: (DECM) QTD employer contribution 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-id: (INTG) Starting payroll identifier

stop-pay-id: (INTG) Ending payroll identifier

tdp-adjustment-id: (INTG) TDP Adjustment to record with this record

tdp-agreement-num: (INTG) TDP Agreement Number (from Payroll Authorization Form)

tdp-deduct-reason-id: (INTG) TDP Deduction Reason Code

tdp-flag: (LOGC) 'Yes' if this is a TDP deduction, otherwise 'No'

tdp-invoice-num: (INTG) Invoice # from service purchase bill

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-employer-contrib: (DECM) YTD Employer contribution 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

deduct-id: deduct-id, pay-id, emp-seq, pay-seq, deduct-seq

deduct-num: pay-id, emp-seq, pay-seq, deduct-num, deduct-seq

emp-deduct: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq, deduct-seq

extern-guid: extern-guid

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ede.p

DELETE: Overridable, Procedure is tr-d-ede.p

REPLICATION-CREATE: Procedure is rp-c-ede.p

REPLICATION-DELETE: Procedure is rp-d-ede.p

REPLICATION-WRITE: Procedure is rp-u-ede.p

WRITE: Overridable, Procedure is tr-u-ede.p

Other tables who reference emp-deduct

emp-deduct-rate - Employee Deduction/Payrate linkage

Tables emp-deduct references

dc-record-type - (no description available)

dc-status-reason - (no description available)

emp-adjust - Employee Adjustments

emp-counter - Employee Counters

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-distrib - Employee Distributions

emp-mpsers - (no description available)

emp-pay-master - Employee Payroll Master

emp-payroll - The one per employee, once per payroll control file

emp-retire - Employee Retirment Records

emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)

emp-tdp - Employee DTL3 record

emp-unemp - Employee Unemployement counters

pay-acct - Payroll Distribution Account List

pay-check - Payroll Check file, one record per payroll check issued

pay-cycle-schd - Linkage file between cycles and the payroll active for them

pay-deduct - Payroll Master Deductions definition

pay-disburse - Record of per-payroll vendor disburements

pay-distrib - Payroll DIstributions file

pay-schd - Payroll Schedule for a year One entry per

tdp-adjustment-type - TDP Adjustment type codes for MPSERS

tdp-deduct-reason - (no description available)

Detailed Alphabetical Field Listing
acct-num Data type: CHARACTER
Format: x(30)
Help: Liability account used for recording this deduction

all-or-nothing Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: 'Yes' to drop deductions exceeding gross, 'No' to reduce the

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

check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement

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

cur-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99
Help: Current employer contribution for this deduction

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

dc-end-date Data type: DATE
Format: 99/99/9999
Help: DC End Date

dc-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Does this deduction represent a defined contribution

dc-record-id Data type: INTEGER
Format: 9999999999999
Help: DC Record Type

dc-start-date Data type: DATE
Format: 99/99/9999
Help: DC Start Date

dc-status-date Data type: DATE
Format: 99/99/9999
Help: Date of DC status change

dc-status-id Data type: INTEGER
Format: 999999999999999
Help: DC Status Change Reason Code

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

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

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

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

deduct-cycle-id Data type: INTEGER
Format: ->,>>>,>>9
Help: Payroll cycle ID this deduction is active on

deduct-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)
Help: Employer contribution since last reset

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-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Deduction ID for the deduction
Attributes: Index Component

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

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

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

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

deduct-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Deduction Seq# (assigned once for the life of the deduction)
Attributes: Index Component

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

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

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

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

emp-seq Data type: INTEGER
Format: zzzzzzzz9
Description: Employee's Unique Sequence #
Attributes: Index Component

employer-amount Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99
Help: Employer Amount

ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for this deductions provider

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

for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Reg)
Help: '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)
Help: FYTD Amount for this deduction

fytd-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99
Help: FYTD employer contribution 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

hit-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll # employee hit deduction limit

hit-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Employee payroll seq employee hit deduction limit

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

last-deposit-route-num Data type: CHARACTER
Format: x(8)
Help: Routing number for direct depositing of last Direct Deposit

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

last-used-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # record was used on

last-used-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # record was used on

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

mtd-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99
Help: MTD Employer Contribution for this 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)
Help: 'Yes' to base deduction on Net, 'No' for running/payrate gro

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

pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payroll Identifier
Attributes: Index Component

pay-seq Data type: INTEGER
Format: zzzzzzzzz9
Description: Payroll Sequence within a given pay for an employee
Attributes: Index Component

pre-note-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to generate ACH pre-note (deduction disable for that pay

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

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

qtd-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99
Help: QTD employer contribution 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 (Initial Value: TODAY)
Help: Initial/starting date of employees use of the deduction

start-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: -1)
Description: Starting payroll identifier

stop-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: -1)
Description: Ending payroll identifier

tdp-adjustment-id Data type: INTEGER
Format: zzzzzzzzzz9
Description: TDP Adjustment to record with this record

tdp-agreement-num Data type: INTEGER
Format: zzzzzzzz9 (Initial Value: 0)
Help: TDP Agreement Number (from Payroll Authorization Form)

tdp-deduct-reason-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: TDP Deduction Reason Code

tdp-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: 'Yes' if this is a TDP deduction, otherwise 'No'

tdp-invoice-num Data type: INTEGER
Format: zzzzzzz9 (Initial Value: 0)
Help: Invoice # from service purchase bill

use-all-rates Data type: LOGICAL
Format: All/Some (Initial Value: Yes)
Help: '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)
Help: YTD Amount for this deduction

ytd-employer-contrib Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99
Help: YTD Employer contribution 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 12/28/2020 by DBHTML V1.2