Definition of table pay-deduct

Payroll Master Deductions definition , Table Dump Name pay-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

create-disbursement: (LOGC) 'Yes' to auto-create disbursements for this provider

deduct-active: (LOGC) Deduction Active?

deduct-amount: (DECM) Amount to deduct

deduct-by: (CHAR) Deduct funds using an Amount, Percent, Scale or Expression

deduct-cycle-id: (INTG) Deduction Payroll Cycle Identifier

deduct-desc: (CHAR) Description, if any, of this deduction

deduct-expr: (CHAR) Deduction Expression

deduct-group-id: (INTG) Deduction Group identifier

deduct-id: (INTG) Deduction Identifier

deduct-limit: (DECM) Default deduction limit for employee deductions (0 if no lim

deduct-name: (CHAR) Name of this deduction

deduct-percent: (DECM) Percentage to deduct

deduct-type: (CHAR) Type of deduction (TSA or TVD)

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

irs-class-id: (INTG) IRS Class Identifier

last-used-pay-id: (INTG) Last Payroll this deduction was used on

net-as-gross: (LOGC) 'Yes' to base deduction on Net, 'No' for running/payrate gro

payroll-year: (INTG) Payroll year associated with this record

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

print-on-check: (LOGC) 'Yes' if deduction should appear on check stub, 'No' otherwi

scale-counter-deduct: (LOGC) Use employee's deduction accrual in determining the percenta

scale-counter-fytd: (LOGC) Use employee's FYTD figures for determining percentage?

scale-counter-qtd: (LOGC) Use employee's QTD figures for determining percentage?

scale-counter-ytd: (LOGC) Use employee's YTD figures for determining percentage?

scale-from[5]: (DECM) Lower limit for this range

scale-on-gross: (LOGC) Yes to use accrued deduction gross for scale, No for accrual

scale-percent[5]: (DECM) Percentage to use for this range

scale-to[5]: (DECM) Upper limit for the range

start-pay-id: (INTG) Starting payroll identifier

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

use-all-rates: (LOGC) 'Yes' to consider all Payrates for deduction, 'No' to select

Alphabetical Index Summary

deduct-desc: payroll-year, deduct-desc

deduct-name: payroll-year, deduct-name

deduct-type: payroll-year, deduct-type, deduct-name

extern-guid: extern-guid

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

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference pay-deduct

emp-deduct - Employee Deductions file

emp-fringe - (no description available)

fringe-code - (no description available)

Tables pay-deduct references

deduct-group - Deduction Group definitions

emp-distrib - Employee Distributions

irs-class - IRS Deduction Classification codes

pay-acct - Payroll Distribution Account List

pay-disburse - Record of per-payroll vendor disburements

pay-distrib - Payroll DIstributions file

pay-year - Payroll Year definitions

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

create-disbursement Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: 'Yes' to auto-create disbursements for this provider

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

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

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

deduct-cycle-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Deduction Payroll Cycle Identifier

deduct-desc Data type: CHARACTER
Format: x(32)
Help: Description, if any, of this deduction
Attributes: Index Component

deduct-expr Data type: CHARACTER
Format: x(38)
Help: Deduction Expression

deduct-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Deduction Group identifier
Help: Deductions group, if any (such as RETIRE)

deduct-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Deduction Identifier
Attributes: Index Component

deduct-limit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Default deduction limit for employee deductions (0 if no lim

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

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

deduct-type Data type: CHARACTER
Format: x(4) (Initial Value: TVD)
Help: Type of deduction (TSA or TVD)
Attributes: Index Component

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

irs-class-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: IRS Class Identifier
Help: Deductions IRS Classification, if any

last-used-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last Payroll this deduction was used on

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

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

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

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

scale-counter-deduct Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Use employee's deduction accrual in determining the percenta

scale-counter-fytd Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Use employee's FYTD figures for determining percentage?

scale-counter-qtd Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Use employee's QTD figures for determining percentage?

scale-counter-ytd Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Use employee's YTD figures for determining percentage?

scale-from Data type: DECIMAL (Extent: 5, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Lower limit for this range

scale-on-gross Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to use accrued deduction gross for scale, No for accrual

scale-percent Data type: DECIMAL (Extent: 5, Decimals: 2)
Format: zz9.99% (Initial Value: 0)
Help: Percentage to use for this range

scale-to Data type: DECIMAL (Extent: 5, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Upper limit for the range

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

use-all-rates Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: 'Yes' to consider all Payrates for deduction, 'No' to select

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