Definition of table Taxes

Employee Tax Setup (no counters) , Table Dump Name res-0020

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

fica-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

fica-adjust-amount: (DECM) FICA Adjustment amount

fica-adjust-applied: (DECM) Adjustment applied for this pay

fica-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

fica-adjust-percent: (DECM) FICA Adjustment Percentage

fica-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

fica-pay-cnt: (INTG) Number of pays adjustment has been applied to

fica-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

fica-status: (CHAR) FICA Tax Active (Yes, No or 'Adj' for Adjustments Only)

figure-on-pay-cnt: (INTG) Number of payrolls to figure taxes over (for annualizing)

figure-taxes-by: (CHAR) Figure taxes by Annualize, Tax Bracket or Past Pays

fit-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

fit-adjust-amount: (DECM) FIT Adjustment amount

fit-adjust-applied: (DECM) Adjustment applied for this pay

fit-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

fit-adjust-percent: (DECM) FIT Adjustment Percentage

fit-exempt-cnt: (INTG) Number of exemptions

fit-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

fit-name: (CHAR) Name of tax table to use for federal taxes

fit-pay-cnt: (INTG) Number of pays adjustment has been applied to

fit-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

fit-status: (CHAR) FIT Tax Active (Yes, No or 'Adj' for Adjusments Only)

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

lit-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

lit-adjust-amount: (DECM) LIT Adjustment amount

lit-adjust-applied: (DECM) Adjustment applied for this pay

lit-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

lit-adjust-percent: (DECM) LIT Adjustment Percentage

lit-exempt-cnt: (INTG) Number of exemptions

lit-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

lit-name: (CHAR) Name of tax table to use for 'local' taxes

lit-pay-cnt: (INTG) Number of pays adjustment has been applied to

lit-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

lit-status: (CHAR) LIT Tax Active (Yes, No or 'Adj' for Adjustments Only)

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

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

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

master-check-num: (INTG) Check number

master-cycle-code: (CHAR) Name of this payroll cycle

master-ecc-code: (CHAR) ECC Code

master-pay-active: (LOGC) Is this employee active for this payroll?

master-pay-group: (CHAR) Name of this employee payroll group

master-pay-regular: (LOGC) 'Regular' or 'Supplemental' payroll

master-retire-code: (CHAR) Retirement code name

master-start-pay: (CHAR) Start Payroll number.

master-stop-pay: (CHAR) Last Payroll number.

medicare-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

medicare-adjust-amount: (DECM) Medicare Adjustment amount

medicare-adjust-applied: (DECM) Adjustment applied for this pay

medicare-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

medicare-adjust-percent: (DECM) Medicare Adjustment Percentage

medicare-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

medicare-pay-cnt: (INTG) Number of pays adjustment has been applied to

medicare-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

medicare-status: (CHAR) Medicare Tax Active (Yes, No or 'Adj' for Adjustments Only)

oit-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

oit-adjust-amount: (DECM) OIT Adjustment amount

oit-adjust-applied: (DECM) Adjustment applied for this pay

oit-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

oit-adjust-percent: (DECM) OIT Adjustment Percentage

oit-exempt-cnt: (INTG) Number of exemptions

oit-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

oit-name: (CHAR) Name of tax table to use for this tax

oit-pay-cnt: (INTG) Number of pays adjustment has been applied to

oit-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

oit-status: (CHAR) OIT Tax Active (Yes, No, 'Adj' for Adjustments Only)

payroll-num: (CHAR) Payroll number.

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

sit-adjust-accrued: (DECM) Amount accrued toward this adjustments limit

sit-adjust-amount: (DECM) SIT Adjustment amount

sit-adjust-applied: (DECM) Adjustment applied for this pay

sit-adjust-limit: (DECM) Limit for adjustment, 0 for no limit

sit-adjust-percent: (DECM) SIT Adjustment Percentage

sit-exempt-cnt: (INTG) Number of exemptions

sit-for-regular-pay: (LOGC) 'Reg' to enable for regular pays only, 'All' for all pays

sit-name: (CHAR) Name of tax table to use for state tax

sit-pay-cnt: (INTG) Number of pays adjustment has been applied to

sit-pay-max: (CHAR) Number of pays to apply adjustment or 'ALL'

sit-status: (CHAR) SIT Tax Active (Yes, No or 'Adj' for Adjustments Only)

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

tax-bracket: (INTG) Tax Bracket (1 - 5)

tax-pay-cnt: (INTG) Number of payrolls thus far in taxing year

taxing-marital-code: (CHAR) Martial status as used for taxing purposes

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

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

master-check-num: master-check-num

master-cycle-code: master-cycle-code

master-ecc-code: master-ecc-code

master-pay-group: master-pay-group

master-retire-code: master-retire-code

master-start-pay: master-start-pay

master-stop-pay: master-stop-pay

payroll-num: payroll-num

payroll-year: payroll-year

status-code: status-code

Tables Taxes 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

W2 - Employee W2 information

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

fica-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

fica-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: FICA Adjustment amount

fica-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

fica-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

fica-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: FICA Adjustment Percentage

fica-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

fica-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

fica-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

fica-status Data type: CHARACTER
Format: x(3)
Description: FICA Tax Active (Yes, No or 'Adj' for Adjustments Only)

figure-on-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of payrolls to figure taxes over (for annualizing)

figure-taxes-by Data type: CHARACTER
Format: x(11)
Description: Figure taxes by Annualize, Tax Bracket or Past Pays

fit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

fit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: FIT Adjustment amount

fit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

fit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

fit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: FIT Adjustment Percentage

fit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Description: Number of exemptions

fit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

fit-name Data type: CHARACTER
Format: x(8)
Description: Name of tax table to use for federal taxes

fit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

fit-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

fit-status Data type: CHARACTER
Format: x(3)
Description: FIT Tax Active (Yes, No or 'Adj' for Adjusments Only)

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

lit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

lit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: LIT Adjustment amount

lit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

lit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

lit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: LIT Adjustment Percentage

lit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Description: Number of exemptions

lit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

lit-name Data type: CHARACTER
Format: x(8)
Description: Name of tax table to use for 'local' taxes

lit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

lit-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

lit-status Data type: CHARACTER
Format: x(3)
Description: LIT Tax Active (Yes, No or 'Adj' for Adjustments Only)

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

master-check-num Data type: INTEGER
Format: 999999 (Initial Value: 0)
Description: Check number
Attributes: Index Component

master-cycle-code Data type: CHARACTER
Format: x(8)
Description: Name of this payroll cycle
Attributes: Index Component

master-ecc-code Data type: CHARACTER
Format: x(8)
Description: ECC Code
Attributes: Index Component

master-pay-active Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Is this employee active for this payroll?

master-pay-group Data type: CHARACTER
Format: x(8)
Description: Name of this employee payroll group
Attributes: Index Component

master-pay-regular Data type: LOGICAL
Format: Regular/Supplemental (Initial Value: no)
Description: 'Regular' or 'Supplemental' payroll

master-retire-code Data type: CHARACTER
Format: x(8)
Description: Retirement code name
Attributes: Index Component

master-start-pay Data type: CHARACTER
Format: x(5) (Initial Value: First)
Description: Start Payroll number.
Attributes: Index Component

master-stop-pay Data type: CHARACTER
Format: x(4) (Initial Value: Last)
Description: Last Payroll number.
Attributes: Index Component

medicare-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

medicare-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Medicare Adjustment amount

medicare-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

medicare-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

medicare-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: Medicare Adjustment Percentage

medicare-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

medicare-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

medicare-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

medicare-status Data type: CHARACTER
Format: x(3)
Description: Medicare Tax Active (Yes, No or 'Adj' for Adjustments Only)

oit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

oit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: OIT Adjustment amount

oit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

oit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

oit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: OIT Adjustment Percentage

oit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Description: Number of exemptions

oit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

oit-name Data type: CHARACTER
Format: x(8)
Description: Name of tax table to use for this tax

oit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

oit-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

oit-status Data type: CHARACTER
Format: x(3)
Description: OIT Tax Active (Yes, No, 'Adj' for Adjustments Only)

payroll-num Data type: CHARACTER
Format: x(4)
Description: Payroll number.
Attributes: Index Component

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

sit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit

sit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: SIT Adjustment amount

sit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay

sit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Limit for adjustment, 0 for no limit

sit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Description: SIT Adjustment Percentage

sit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Description: Number of exemptions

sit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: no)
Description: 'Reg' to enable for regular pays only, 'All' for all pays

sit-name Data type: CHARACTER
Format: x(8)
Description: Name of tax table to use for state tax

sit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of pays adjustment has been applied to

sit-pay-max Data type: CHARACTER
Format: x(3)
Description: Number of pays to apply adjustment or 'ALL'

sit-status Data type: CHARACTER
Format: x(3)
Description: SIT Tax Active (Yes, No or 'Adj' for Adjustments Only)

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

tax-bracket Data type: INTEGER
Format: 9 (Initial Value: 0)
Description: Tax Bracket (1 - 5)

tax-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Description: Number of payrolls thus far in taxing year

taxing-marital-code Data type: CHARACTER
Format: x(8)
Description: Martial status as used for taxing purposes

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

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