Definition of table emp-w2

Employee W2 Info , Table Dump Name emp-w2

Alphabetical Field Summary

advance-eic: (DECM) Amount paid to employee as advance EIC

calendar-year: (INTG) Calendar year associated with this record

control-num: (INTG) W2's Control # (assigned at printing)

deceased: (LOGC) Yes if employee was deceased during the calendar year

deferred-comp: (LOGC) Yes if employee contributed to a deferred compensation plan

dependent-care: (DECM) Amount of section 129 dependent care paid to employee

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

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

fica-excess: (DECM) Amount of FICA Wages in excess of the wage limit

fica-extra: (DECM) Any additional FICA Wages to have reported

fica-total: (DECM) Total FICA Wages to be reported (capped to FICA wage limit)

fica-wages: (DECM) FICA Wages, capped at the FICA wage limit

fica-withheld: (DECM) FICA Tax withheld from employee's earnings

fit-extra: (DECM) Additional Federal Wages

fit-third: (DECM) FIT withheld by a third party

fit-total: (DECM) Total Federal Wages

fit-wages: (DECM) FIT Wages

fit-withheld: (DECM) FIT Withheld from employee from employees earnings

irs-box-amount[10]: (DECM) Miscellaneous IRS related/reported amounts

irs-box-code[10]: (CHAR) Miscellaneous IRS related/reported codes (A-N)

lit-extra: (DECM) Additional LIT Wages

lit-name: (CHAR) Name of locality for tax (i.e. city, county, etc)

lit-total: (DECM) Total LIT Wages

lit-wages: (DECM) LIT Wages

lit-withheld: (DECM) LIT Withheld from employee from employees earnings

medicare-excess: (DECM) Amount of Medicare wage in excess of the wage limit

medicare-extra: (DECM) Any additional Medicare wages to have reported

medicare-total: (DECM) Total Medicare wages (capped to Medicare Wage limit)

medicare-wages: (DECM) Medicare wages capped at the Medicare wage limit

medicare-withheld: (DECM) Medicare Tax withheld from employee's earnings

misc-box-amount[10]: (DECM) District selected items to report (not reported to IRS)

misc-box-deduct-group-id[10]: (INTG) Related Group ID (for identifying the deduction group)

misc-box-desc[10]: (CHAR) Descriptions for district selected items to report

non-qualified: (DECM) Amount paid to employee via non-qualified plans

non-qualified-flag: (CHAR) Set to 'G' if non-qualified payment is from 457 plan

oit-extra: (DECM) Additional OIT Wages

oit-name: (CHAR) Name of locality (i.e. city, county, etc)

oit-total: (DECM) Total OIT Wages

oit-wages: (DECM) OIT Wages

oit-withheld: (DECM) OIT Withheld from employee from employees earnings

pension-plan: (LOGC) Yes if employee contributed to an approved pension plan

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

sit-extra: (DECM) Additional SIT Wages

sit-name: (CHAR) Name of state for tax (i.e. MI, OH, CT, etc)

sit-total: (DECM) Total SIT Wages

sit-wages: (DECM) SIT Wages

sit-withheld: (DECM) SIT Withheld from employee from employees earnings

statutory-emp: (LOGC) Statutory employee

taxable-benefits: (DECM) Taxable Portion of employee fringe benefits

w2-changed: (LOGC) Yes if the W2 has been modified since being created

w2-printed: (LOGC) Has the W2 been printed yet?

Alphabetical Index Summary

emp-w2: (UNIQUE, PRIMARY) emp-seq, calendar-year

extern-guid: extern-guid

w2-control: calendar-year, control-num

w2-print: calendar-year, w2-printed, control-num

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference emp-w2

aca-benefit-plan - ACA Benefit Plan codes

aca-category-code - (no description available)

aca-coverage-code - ACA Coverage Codes

aca-safe-harbor-code - (no description available)

district-1094c - (no description available)

emp-1095c - Employee 1095c filing record

emp-aca - (no description available)

emp-quarter - Employee Quarterly Retirement reporting records

pay-profile - Payroll System Profile

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

tax-table - Federal, State and Local tax tables

Tables emp-w2 references

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-mpsers - (no description available)

emp-tdp - Employee DTL3 record

pay-profile - Payroll System Profile

Detailed Alphabetical Field Listing
advance-eic Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Amount paid to employee as advance EIC

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

control-num Data type: INTEGER
Format: 999999 (Initial Value: 0)
Help: W2's Control # (assigned at printing)
Attributes: Index Component

deceased Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if employee was deceased during the calendar year

deferred-comp Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if employee contributed to a deferred compensation plan

dependent-care Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Amount of section 129 dependent care paid to employee

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

fica-excess Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Amount of FICA Wages in excess of the wage limit

fica-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Any additional FICA Wages to have reported

fica-total Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Total FICA Wages to be reported (capped to FICA wage limit)

fica-wages Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FICA Wages, capped at the FICA wage limit

fica-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FICA Tax withheld from employee's earnings

fit-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Additional Federal Wages

fit-third Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)
Description: FIT withheld by a third party
Help: Amount of FIT withheld by a 3rd party

fit-total Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Total Federal Wages

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

fit-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FIT Withheld from employee from employees earnings

irs-box-amount Data type: DECIMAL (Extent: 10, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Miscellaneous IRS related/reported amounts

irs-box-code Data type: CHARACTER (Extent: 10)
Format: x
Help: Miscellaneous IRS related/reported codes (A-N)

lit-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Additional LIT Wages

lit-name Data type: CHARACTER
Format: x(8)
Help: Name of locality for tax (i.e. city, county, etc)

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

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

lit-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: LIT Withheld from employee from employees earnings

medicare-excess Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Amount of Medicare wage in excess of the wage limit

medicare-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Any additional Medicare wages to have reported

medicare-total Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Total Medicare wages (capped to Medicare Wage limit)

medicare-wages Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Medicare wages capped at the Medicare wage limit

medicare-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Medicare Tax withheld from employee's earnings

misc-box-amount Data type: DECIMAL (Extent: 10, Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: District selected items to report (not reported to IRS)

misc-box-deduct-group-id Data type: INTEGER (Extent: 10)
Format: zzzzzzzzzzzzz9
Description: Related Group ID (for identifying the deduction group)

misc-box-desc Data type: CHARACTER (Extent: 10)
Format: x(8)
Help: Descriptions for district selected items to report

non-qualified Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Amount paid to employee via non-qualified plans

non-qualified-flag Data type: CHARACTER
Format: x
Help: Set to 'G' if non-qualified payment is from 457 plan

oit-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Additional OIT Wages

oit-name Data type: CHARACTER
Format: x(8)
Help: Name of locality (i.e. city, county, etc)

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

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

oit-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: OIT Withheld from employee from employees earnings

pension-plan Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if employee contributed to an approved pension plan

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

sit-extra Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Additional SIT Wages

sit-name Data type: CHARACTER
Format: x(8)
Help: Name of state for tax (i.e. MI, OH, CT, etc)

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

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

sit-withheld Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: SIT Withheld from employee from employees earnings

statutory-emp Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Statutory employee

taxable-benefits Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Taxable Portion of employee fringe benefits

w2-changed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if the W2 has been modified since being created

w2-printed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Has the W2 been printed yet?
Attributes: Index Component

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