Alphabetical Field Summary
Alphabetical Index Summary
Tables Counters references
comp-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the company's purpose
cur-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Current FICA Amount
cur-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Current FICA Gross
cur-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: Current Gross
cur-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: Current Medicare
cur-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Current Medicare Gross
cur-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Current Net
cur-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Current Non Taxable Gross
cur-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: 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)
Description: 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)
Description: Current TVD total
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
fytd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: FYTD FICA Amount
fytd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: FYTD FICA Gross
fytd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: FYTD Gross
fytd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: FYTD Medicare
fytd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: FYTD Medicare Gross
fytd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: FYTD Net
fytd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: FYTD Non Taxable Gross
fytd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: 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)
Description: 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)
Description: FYTD TVD total
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
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: Starting Payroll number.
Attributes: Index Component
master-stop-pay Data type: CHARACTER
Format: x(4) (Initial Value: Last)
Description: Ending Payroll number.
Attributes: Index Component
mtd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: MTD FICA Amount
mtd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: MTD FICA Gross
mtd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: MTD Gross
mtd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: MTD Medicare
mtd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: MTD Medicare Gross
mtd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: MTD Net
mtd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: MTD Non Taxable Gross
mtd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: 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)
Description: 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)
Description: MTD TVD total
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
qtd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: QTD FICA Amount
qtd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: QTD FICA Gross
qtd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: QTD Gross
qtd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: QTD Medicare
qtd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: QTD Medicare Gross
qtd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: QTD Net
qtd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: QTD Non Taxable Gross
qtd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: 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)
Description: 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)
Description: QTD TVD total
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?
ytd-fica Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: YTD FICA Amount
ytd-fica-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: YTD FICA Gross
ytd-fit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: YTD Gross
ytd-lit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: YTD Medicare
ytd-medicare-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: YTD Medicare Gross
ytd-net Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: YTD Net
ytd-non-tax-gross Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: YTD Non Taxable Gross
ytd-oit Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: 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)
Description: 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)
Description: 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)
Description: YTD TVD total
Created on 08/13/2012 by DBHTML V1.2