Definition of table Retirement
Per Payroll Retirement , Table Dump Name res-0019

Alphabetical Field Summary

  • comp-code: (INTG) Employee's assigned company
  • comp-code-description: (CHAR) A brief description of the company's purpose
  • cur-federal-basic: (DECM) Current Federal Basic Retirement amount
  • cur-federal-gross: (DECM) Retirement gross federal basic is calculated on
  • cur-gross: (DECM) Current Retirement Gross
  • cur-retire-hours: (DECM) Total retirement hours for this payroll
  • cur-retire-plan: (DECM) Current retirement plan amount
  • cur-state-basic: (DECM) Current State Basic Retirement amount
  • cur-state-gross: (DECM) Retirement Gross state basic is calculated on
  • 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
  • enable-basic: (LOGC) 'Yes' to enable basic retirement, 'No' to disable it
  • ethnic-code: (CHAR) Employee's ethnicity code
  • fytd-federal-basic: (DECM) FYTD Federal Basic Retirement amount
  • fytd-federal-gross: (DECM) Retirement gross federal basic is calculated on
  • fytd-gross: (DECM) FYTD Retirement Gross
  • fytd-retire-hours: (DECM) FYTD retirement hours
  • fytd-retire-plan: (DECM) FYTD retirement plan amount
  • fytd-state-basic: (DECM) FYTD State Basic Retirement amount
  • fytd-state-gross: (DECM) Retirement Gross state basic is calculated on
  • 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
  • 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) Starting Payroll number.
  • master-stop-pay: (CHAR) Ending Payroll number.
  • mtd-federal-basic: (DECM) MTD Federal Basic Retirement amount
  • mtd-federal-gross: (DECM) Retirement gross federal basic is calculated on
  • mtd-gross: (DECM) MTD Retirement Gross
  • mtd-retire-hours: (DECM) MTD retirement hours
  • mtd-retire-plan: (DECM) MTD retirement plan amount
  • mtd-state-basic: (DECM) MTD State Basic Retirement amount
  • mtd-state-gross: (DECM) Retirement Gross state basic is calculated on
  • payroll-num: (CHAR) Payroll number.
  • payroll-year: (INTG) Payroll year associated with this record
  • pension: (LOGC) Employee on pension?
  • qtd-federal-basic: (DECM) QTD Federal Basic Retirement amount
  • qtd-federal-gross: (DECM) Retirement gross federal basic is calculated on
  • qtd-gross: (DECM) QTD Retirement Gross
  • qtd-retire-hours: (DECM) QTDl retirement hours
  • qtd-retire-plan: (DECM) QTD retirement plan amount
  • qtd-state-basic: (DECM) QTD State Basic Retirement amount
  • qtd-state-gross: (DECM) Retirement Gross state basic is calculated on
  • retiree-num: (INTG) Retiree #
  • status-code: (CHAR) Employee's status code
  • union-member: (LOGC) Does employee belong to a union?
  • ytd-federal-basic: (DECM) YTD Federal Basic Retirement amount
  • ytd-federal-gross: (DECM) Retirement gross federal basic is calculated on
  • ytd-gross: (DECM) YTD Retirement Gross
  • ytd-retire-hours: (DECM) YTD retirement hours
  • ytd-retire-plan: (DECM) YTD retirement plan amount
  • ytd-state-basic: (DECM) YTD State Basic Retirement amount
  • ytd-state-gross: (DECM) Retirement Gross state basic is calculated on

    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 Retirement 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
  • Taxes - Employee Tax Setup (no counters)
  • 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

    cur-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Current Federal Basic Retirement amount

    cur-federal-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement gross federal basic is calculated on

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

    cur-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Total retirement hours for this payroll

    cur-retire-plan Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Current retirement plan amount

    cur-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Current State Basic Retirement amount

    cur-state-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement Gross state basic is calculated on

    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

    enable-basic Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' to enable basic retirement, 'No' to disable it

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

    fytd-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Federal Basic Retirement amount

    fytd-federal-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement gross federal basic is calculated on

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

    fytd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: FYTD retirement hours

    fytd-retire-plan Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: FYTD retirement plan amount

    fytd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: FYTD State Basic Retirement amount

    fytd-state-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement Gross state basic is calculated on

    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-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: MTD Federal Basic Retirement amount

    mtd-federal-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement gross federal basic is calculated on

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

    mtd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: MTD retirement hours

    mtd-retire-plan Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: MTD retirement plan amount

    mtd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: MTD State Basic Retirement amount

    mtd-state-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement Gross state basic is calculated on

    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

    pension Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Employee on pension?

    qtd-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: QTD Federal Basic Retirement amount

    qtd-federal-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement gross federal basic is calculated on

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

    qtd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: QTDl retirement hours

    qtd-retire-plan Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: QTD retirement plan amount

    qtd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: QTD State Basic Retirement amount

    qtd-state-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement Gross state basic is calculated on

    retiree-num Data type: INTEGER
    Format: 999999 (Initial Value: 0)
    Description: Retiree #

    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-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: YTD Federal Basic Retirement amount

    ytd-federal-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement gross federal basic is calculated on

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

    ytd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: YTD retirement hours

    ytd-retire-plan Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: YTD retirement plan amount

    ytd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: YTD State Basic Retirement amount

    ytd-state-gross Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Retirement Gross state basic is calculated on

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