Definition of table emp-counter

Employee Counters , Table Dump Name emp-cnt

Alphabetical Field Summary

cur-fica: (DECM) Current FICA Amount

cur-fica-gross: (DECM) Current FICA Gross

cur-fit: (DECM) Current FIT

cur-fit-gross: (DECM) Taxable gross for FIT

cur-gross: (DECM) Current Gross

cur-lit: (DECM) Current LIT

cur-lit-gross: (DECM) Taxable gross for LIT

cur-medicare: (DECM) Current Medicare

cur-medicare-gross: (DECM) Current Medicare Gross

cur-net: (DECM) Current Net

cur-non-tax-gross: (DECM) Current Non Taxable Gross

cur-oit: (DECM) Current OIT

cur-oit-gross: (DECM) Taxable gross for OIT

cur-sit: (DECM) Current SIT

cur-sit-gross: (DECM) Taxable gross for SIT

cur-taxable-gross: (DECM) Current Taxable Gross

cur-tsa: (DECM) Total of TSA deductions

cur-tvd: (DECM) Current TVD total

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

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

fytd-fica: (DECM) FYTD FICA Amount

fytd-fica-gross: (DECM) FYTD FICA Gross

fytd-fit: (DECM) FYTD FIT

fytd-fit-gross: (DECM) Taxable gross for FIT

fytd-gross: (DECM) FYTD Gross

fytd-lit: (DECM) FYTD LIT

fytd-lit-gross: (DECM) Taxable gross for LIT

fytd-medicare: (DECM) FYTD Medicare

fytd-medicare-gross: (DECM) FYTD Medicare Gross

fytd-net: (DECM) FYTD Net

fytd-non-tax-gross: (DECM) FYTD Non Taxable Gross

fytd-oit: (DECM) FYTD OIT

fytd-oit-gross: (DECM) Taxable gross for OIT

fytd-sit: (DECM) FYTD SIT

fytd-sit-gross: (DECM) Taxable gross for SIT

fytd-taxable-gross: (DECM) FYTD Taxable Gross

fytd-tsa: (DECM) Total of TSA deductions

fytd-tvd: (DECM) FYTD TVD total

mtd-fica: (DECM) MTD FICA Amount

mtd-fica-gross: (DECM) MTD FICA Gross

mtd-fit: (DECM) MTD FIT

mtd-fit-gross: (DECM) Taxable gross for FIT

mtd-gross: (DECM) MTD Gross

mtd-lit: (DECM) MTD LIT

mtd-lit-gross: (DECM) Taxable gross for LIT

mtd-medicare: (DECM) MTD Medicare

mtd-medicare-gross: (DECM) MTD Medicare Gross

mtd-net: (DECM) MTD Net

mtd-non-tax-gross: (DECM) MTD Non Taxable Gross

mtd-oit: (DECM) MTD OIT

mtd-oit-gross: (DECM) Taxable gross for OIT

mtd-sit: (DECM) MTD SIT

mtd-sit-gross: (DECM) Taxable gross for SIT

mtd-taxable-gross: (DECM) MTD Taxable Gross

mtd-tsa: (DECM) Total of TSA deductions

mtd-tvd: (DECM) MTD TVD total

pay-id: (INTG) Payroll Identifier

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

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

qtd-fica: (DECM) QTD FICA Amount

qtd-fica-gross: (DECM) QTD FICA Gross

qtd-fit: (DECM) QTD FIT

qtd-fit-gross: (DECM) Taxable gross for FIT

qtd-gross: (DECM) QTD Gross

qtd-lit: (DECM) QTD LIT

qtd-lit-gross: (DECM) Taxable gross for LIT

qtd-medicare: (DECM) QTD Medicare

qtd-medicare-gross: (DECM) QTD Medicare Gross

qtd-net: (DECM) QTD Net

qtd-non-tax-gross: (DECM) QTD Non Taxable Gross

qtd-oit: (DECM) QTD OIT

qtd-oit-gross: (DECM) Taxable gross for OIT

qtd-sit: (DECM) QTD SIT

qtd-sit-gross: (DECM) Taxable gross for SIT

qtd-taxable-gross: (DECM) QTD Taxable Gross

qtd-tsa: (DECM) Total of TSA deductions

qtd-tvd: (DECM) QTD TVD total

ytd-fica: (DECM) YTD FICA Amount

ytd-fica-gross: (DECM) YTD FICA Gross

ytd-fit: (DECM) YTD FIT

ytd-fit-gross: (DECM) Taxable gross for FIT

ytd-gross: (DECM) YTD Gross

ytd-lit: (DECM) YTD LIT

ytd-lit-gross: (DECM) Taxable gross for LIT

ytd-medicare: (DECM) YTD Medicare

ytd-medicare-gross: (DECM) YTD Medicare Gross

ytd-net: (DECM) YTD Net

ytd-non-tax-gross: (DECM) YTD Non Taxable Gross

ytd-oit: (DECM) YTD OIT

ytd-oit-gross: (DECM) Taxable gross for OIT

ytd-sit: (DECM) YTD SIT

ytd-sit-gross: (DECM) Taxable gross for SIT

ytd-taxable-gross: (DECM) YTD Taxable Gross

ytd-tsa: (DECM) Total of TSA deductions

ytd-tvd: (DECM) YTD TVD total

Alphabetical Index Summary

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

extern-guid: extern-guid

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference emp-counter

emp-adjust - Employee Adjustments

emp-deduct - Employee Deductions file

emp-deduct-rate - Employee Deduction/Payrate linkage

emp-distrib - Employee Distributions

emp-pay-master - Employee Payroll Master

emp-rate - Employee Payrate records

emp-rate-hours - Employee Payrate Hourly detail

emp-rate-loc - Employee Payrate Locations records

emp-rate-savings - Employee payrate savings, typically used for Summer Savings

emp-retire - Employee Retirment Records

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

emp-unemp - Employee Unemployement counters

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

pay-log - Payroll Message log file

Tables emp-counter references

emp-adjust - Employee Adjustments

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

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-check - Payroll Check file, one record per payroll check issued

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

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

Detailed Alphabetical Field Listing
cur-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current FICA Amount

cur-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current FICA Gross

cur-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current FIT

cur-fit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for FIT

cur-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current Gross

cur-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current LIT

cur-lit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for LIT

cur-medicare Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current Medicare

cur-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current Medicare Gross

cur-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current Net

cur-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Current Non Taxable Gross

cur-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current OIT

cur-oit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for OIT

cur-sit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current SIT

cur-sit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for SIT

cur-taxable-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current Taxable Gross

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

cur-tvd Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Current TVD total

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

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

fytd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD FICA Amount

fytd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD FICA Gross

fytd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD FIT

fytd-fit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for FIT

fytd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Gross

fytd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD LIT

fytd-lit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for LIT

fytd-medicare Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Medicare

fytd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Medicare Gross

fytd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Net

fytd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: FYTD Non Taxable Gross

fytd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD OIT

fytd-oit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for OIT

fytd-sit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD SIT

fytd-sit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for SIT

fytd-taxable-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Taxable Gross

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

fytd-tvd Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: FYTD TVD total

mtd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD FICA Amount

mtd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD FICA Gross

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

mtd-fit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for FIT

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

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

mtd-lit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for LIT

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

mtd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD Medicare Gross

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

mtd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: MTD Non Taxable Gross

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

mtd-oit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for OIT

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

mtd-sit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for SIT

mtd-taxable-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD Taxable Gross

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

mtd-tvd Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: MTD TVD total

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

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

qtd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD FICA Amount

qtd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD FICA Gross

qtd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD FIT

qtd-fit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for FIT

qtd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Gross

qtd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD LIT

qtd-lit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for LIT

qtd-medicare Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Medicare

qtd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Medicare Gross

qtd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Net

qtd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: QTD Non Taxable Gross

qtd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD OIT

qtd-oit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for OIT

qtd-sit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD SIT

qtd-sit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for SIT

qtd-taxable-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Taxable Gross

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

qtd-tvd Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: QTD TVD total

ytd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD FICA Amount

ytd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD FICA Gross

ytd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD FIT

ytd-fit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for FIT

ytd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Gross

ytd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD LIT

ytd-lit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for LIT

ytd-medicare Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Medicare

ytd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Medicare Gross

ytd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Net

ytd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: YTD Non Taxable Gross

ytd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD OIT

ytd-oit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for OIT

ytd-sit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD SIT

ytd-sit-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Taxable gross for SIT

ytd-taxable-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Taxable Gross

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

ytd-tvd Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: YTD TVD total

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