Definition of table emp-unemp

Employee Unemployement counters , Table Dump Name emp-unem

Alphabetical Field Summary

cur-futa-excess: (DECM) Current FUTA Excess Wages

cur-futa-gross: (DECM) Current FUTA Gross

cur-futa-tax: (DECM) Current FUTA Tax

cur-futa-taxable: (DECM) Current FUTA Taxable Wages

cur-suta-excess: (DECM) Current SUTA Excess Wages

cur-suta-gross: (DECM) Current SUTA Gross

cur-suta-tax: (DECM) Current SUTA Tax

cur-suta-taxable: (DECM) Current SUTA Taxable Wages

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

enable-futa: (LOGC) 'Yes' to enable FUTA calculations, 'No' to disable them

enable-suta: (LOGC) 'Yes' to enable calculation of SUTA, 'No' to disabled it

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

futa-acct-num: (CHAR) Account used to create disbursement

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

futa-distributed: (LOGC) True if FUTA was distributed during last calculations

futa-ent-id: (CHAR) Vendor # used for producing this disbursement

futa-excess[4]: (DECM) FUTA Excess wages for quarter

futa-gross[4]: (DECM) FUTA Gross for quarter

futa-tax[4]: (DECM) FUTA Tax for quarter

futa-taxable[4]: (DECM) FUTA Taxable Gross for quarter

fytd-futa-excess: (DECM) FYTD FUTA Excess Wages

fytd-futa-gross: (DECM) FYTD FUTA Gross

fytd-futa-tax: (DECM) FYTD FUTA Tax

fytd-futa-taxable: (DECM) FYTD FUTA Taxable Wages

fytd-suta-excess: (DECM) FYTD SUTA Excess Wages

fytd-suta-gross: (DECM) FYTD SUTA Gross

fytd-suta-tax: (DECM) FYTD SUTA Tax

fytd-suta-taxable: (DECM) FYTD SUTA Taxable Wages

hit-futa-limit-pay-id: (INTG) Pay # of payroll meeting FUTA wage limit

hit-futa-limit-pay-seq: (INTG) Pay Seq# of payroll meeting FUTA wage limit

hit-suta-limit-pay-id: (INTG) Pay # of payroll meeting SUTA wage limit

hit-suta-limit-pay-seq: (INTG) Pay Seq# of payroll meeting SUTA wage limit

mtd-futa-excess: (DECM) MTD FUTA Excess Wages

mtd-futa-gross: (DECM) MTD FUTA Gross

mtd-futa-tax: (DECM) MTD FUTA Tax

mtd-futa-taxable: (DECM) MTD FUTA Taxable Wages

mtd-suta-excess: (DECM) MTD SUTA Excess Wages

mtd-suta-gross: (DECM) MTD SUTA Gross

mtd-suta-tax: (DECM) MTD SUTA Tax

mtd-suta-taxable: (DECM) MTD SUTA Taxable Wages

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-futa-excess: (DECM) QTD FUTA Excess Wages

qtd-futa-gross: (DECM) QTD FUTA Gross

qtd-futa-tax: (DECM) QTD FUTA Tax

qtd-futa-taxable: (DECM) QTD FUTA Taxable Wages

qtd-suta-excess: (DECM) QTD SUTA Excess Wages

qtd-suta-gross: (DECM) QTD SUTA Gross

qtd-suta-tax: (DECM) QTD SUTA Tax

qtd-suta-taxable: (DECM) QTD SUTA Taxable Wages

suta-acct-num: (CHAR) Account used to create disbursement

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

suta-distributed: (LOGC) True if SUTA was distributed during last calculations

suta-ent-id: (CHAR) Vendor # used for producing this disbursement

suta-excess[4]: (DECM) SUTA Excess wages for quarter

suta-gross[4]: (DECM) SUTA Gross for quarter

suta-tax[4]: (DECM) SUTA Tax for quarter

suta-taxable[4]: (DECM) SUTA Taxable Gross for quarter

ytd-futa-excess: (DECM) YTD FUTA Excess Wages

ytd-futa-gross: (DECM) YTD FUTA Gross

ytd-futa-tax: (DECM) YTD FUTA Tax

ytd-futa-taxable: (DECM) YTD FUTA Taxable Wages

ytd-suta-excess: (DECM) YTD SUTA Excess Wages

ytd-suta-gross: (DECM) YTD SUTA Gross

ytd-suta-tax: (DECM) YTD SUTA Tax

ytd-suta-taxable: (DECM) YTD SUTA Taxable Wages

Alphabetical Index Summary

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

extern-guid: extern-guid

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference emp-unemp

emp-adjust - Employee Adjustments

emp-counter - Employee Counters

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)

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

pay-log - Payroll Message log file

Tables emp-unemp references

emp-adjust - Employee Adjustments

emp-counter - Employee Counters

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

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-futa-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current FUTA Excess Wages

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

cur-futa-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current FUTA Tax

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

cur-suta-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current SUTA Excess Wages

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

cur-suta-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Current SUTA Tax

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

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

enable-futa Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: 'Yes' to enable FUTA calculations, 'No' to disable them

enable-suta Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: 'Yes' to enable calculation of SUTA, 'No' to disabled it

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

futa-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement

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

futa-distributed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: True if FUTA was distributed during last calculations

futa-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement

futa-excess Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FUTA Excess wages for quarter

futa-gross Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FUTA Gross for quarter

futa-tax Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FUTA Tax for quarter

futa-taxable Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FUTA Taxable Gross for quarter

fytd-futa-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD FUTA Excess Wages

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

fytd-futa-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD FUTA Tax

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

fytd-suta-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD SUTA Excess Wages

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

fytd-suta-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD SUTA Tax

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

hit-futa-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Pay # of payroll meeting FUTA wage limit

hit-futa-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Pay Seq# of payroll meeting FUTA wage limit

hit-suta-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Pay # of payroll meeting SUTA wage limit

hit-suta-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Pay Seq# of payroll meeting SUTA wage limit

mtd-futa-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD FUTA Excess Wages

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

mtd-futa-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD FUTA Tax

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

mtd-suta-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD SUTA Excess Wages

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

mtd-suta-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD SUTA Tax

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

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-futa-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD FUTA Excess Wages

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

qtd-futa-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD FUTA Tax

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

qtd-suta-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD SUTA Excess Wages

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

qtd-suta-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD SUTA Tax

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

suta-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement

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

suta-distributed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: True if SUTA was distributed during last calculations

suta-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement

suta-excess Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: SUTA Excess wages for quarter

suta-gross Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: SUTA Gross for quarter

suta-tax Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: SUTA Tax for quarter

suta-taxable Data type: DECIMAL (Extent: 4, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: SUTA Taxable Gross for quarter

ytd-futa-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD FUTA Excess Wages

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

ytd-futa-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD FUTA Tax

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

ytd-suta-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD SUTA Excess Wages

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

ytd-suta-tax Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD SUTA Tax

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

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