Definition of table W2

Employee W2 information , Table Dump Name res-0021

Alphabetical Field Summary

comp-code: (INTG) Employee's assigned company

comp-code-description: (CHAR) A brief description of the company's purpose

dept-code: (INTG) Employee's assigned department code

dept-code-description: (CHAR) A brief description of the departments purpose

div-code: (INTG) Employee's assigned division

div-code-description: (CHAR) A brief description of the division's purpose

emp-active: (LOGC) Is employee currently active?

emp-fte: (DECM) Employee's Full Time Equivilency (0.00 to 1.00)

emp-group: (CHAR) An employee grouping classification

emp-id: (CHAR) Employee ID (if used)

emp-name: (CHAR) Employee's name in "LAST NAME, FIRST NAME M" order

emp-pic: (CHAR) Employee's PIC (assigned by State)

emp-sex: (LOGC) Employee's sex

emp-ssn: (CHAR) Employee's SSN

ethnic-code: (CHAR) Employee's ethnicity code

is-applicant: (LOGC) Yes if this entry is for an applicant

job-code: (CHAR) Employee's job code

job-code-description: (CHAR) A brief description of the job

loc-code: (CHAR) Employee's Primary Location

loc-code-description: (CHAR) A brief description of the job

marital-code: (CHAR) Employee's Marital status

status-code: (CHAR) Employee's status code

union-member: (LOGC) Does employee belong to a union?

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

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

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

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

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

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

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

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

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

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

w2-fit-extra: (DECM) Additional Federal Wages

w2-fit-total: (DECM) Total Federal Wages

w2-fit-wages: (DECM) FIT Wages

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

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

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

w2-lit-extra: (DECM) Additional LIT Wages

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

w2-lit-total: (DECM) Total LIT Wages

w2-lit-wages: (DECM) LIT Wages

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

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

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

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

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

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

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

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

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

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

w2-oit-extra: (DECM) Additional OIT Wages

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

w2-oit-total: (DECM) Total OIT Wages

w2-oit-wages: (DECM) OIT Wages

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

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

w2-sit-extra: (DECM) Additional SIT Wages

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

w2-sit-total: (DECM) Total SIT Wages

w2-sit-wages: (DECM) SIT Wages

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

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

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

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

Alphabetical Index Summary

comp-code: (PRIMARY) comp-code

dept-code: dept-code

div-code: div-code

emp-group: emp-group

emp-id: emp-id

emp-name: emp-name

emp-ssn: emp-ssn

ethnic-code: ethnic-code

is-applicant: is-applicant

job-code: job-code

loc-code: loc-code

marital-code: marital-code

status-code: status-code

w2-calendar-year: w2-calendar-year

w2-control-num: w2-control-num

w2-w2-printed: w2-w2-printed

Tables W2 references

Contacts - Employee Contacts

Counters - Employee Gross and Tax Counters

Deductions - Employee Deductions

Degree - Employee Degrees

Dependents - Employee Dependents

Distributions - Employee Distributions

Events - Employee Events

Notes - Employee Notes

Payrates - Employee Payrates

Payrate_Distributions - Payrate Related Distributions

Retirement - Per Payroll Retirement

Taxes - Employee Tax Setup (no counters)

Detailed Alphabetical Field Listing
comp-code Data type: INTEGER
Format: 99 (Initial Value: 0)
Description: Employee's assigned company
Attributes: Index Component

comp-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the company's purpose

dept-code Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Employee's assigned department code
Attributes: Index Component

dept-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the departments purpose

div-code Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Employee's assigned division
Attributes: Index Component

div-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the division's purpose

emp-active Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Is employee currently active?

emp-fte Data type: DECIMAL (Decimals: 2)
Format: 9.99 (Initial Value: 0)
Description: Employee's Full Time Equivilency (0.00 to 1.00)

emp-group Data type: CHARACTER
Format: x(8)
Description: An employee grouping classification
Attributes: Index Component

emp-id Data type: CHARACTER
Format: 999999
Description: Employee ID (if used)
Attributes: Index Component

emp-name Data type: CHARACTER
Format: x(30)
Description: Employee's name in "LAST NAME, FIRST NAME M" order
Attributes: Index Component

emp-pic Data type: CHARACTER
Format: x(10)
Description: Employee's PIC (assigned by State)

emp-sex Data type: LOGICAL
Format: Male/Female (Initial Value: no)
Description: Employee's sex

emp-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Description: Employee's SSN
Attributes: Index Component

ethnic-code Data type: CHARACTER
Format: x(8)
Description: Employee's ethnicity code
Attributes: Index Component

is-applicant Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if this entry is for an applicant
Attributes: Index Component

job-code Data type: CHARACTER
Format: x(8)
Description: Employee's job code
Attributes: Index Component

job-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the job

loc-code Data type: CHARACTER
Format: x(8)
Description: Employee's Primary Location
Attributes: Index Component

loc-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the job

marital-code Data type: CHARACTER
Format: x(8)
Description: Employee's Marital status
Attributes: Index Component

status-code Data type: CHARACTER
Format: x(8)
Description: Employee's status code
Attributes: Index Component

union-member Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Does employee belong to a union?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Created on 08/13/2012 by DBHTML V1.2