Definition of table emp-retire
Employee Retirment Records , Table Dump Name emp-ret

Alphabetical Field Summary

  • 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-gross-retire-adjust: (DECM) (no description available)
  • cur-retire-adjust: (DECM) (no description available)
  • 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
  • ecc-code-id: (INTG) ECC Code Identifier for this payroll
  • emp-seq: (INTG) Employee's Unique Sequence #
  • enable-basic: (LOGC) 'Yes' to enable basic retirement, 'No' to disable it
  • extern-guid: (CHAR) External Global Unique ID for this record
  • federal-retire-acct-num: (CHAR) Account used to create disbursement
  • federal-retire-check-run: (INTG) Check run # used for producing this disbursement
  • federal-retire-ent-id: (CHAR) Vendor # used for producing this disbursement
  • 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
  • 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
  • pay-id: (INTG) Payroll Identifier
  • pay-seq: (INTG) Payroll Sequence within a given pay for an employee
  • pension: (LOGC) Employee on pension?
  • primary-key: (INTG) Unique, Primary key for record
  • 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
  • retire-adjustment: (DECM) (no description available)
  • retire-code-id: (INTG) Retirement Code Identifier
  • retire-distributed: (LOGC) True if retirement was distributed with the last calculation
  • retire-gross-adjust: (DECM) (no description available)
  • retiree-num: (INTG) Retiree #
  • state-retire-acct-num: (CHAR) Account used to create disbursement
  • state-retire-check-run: (INTG) Check run # used for producing this disbursement
  • state-retire-ent-id: (CHAR) Vendor # used for producing this disbursement
  • 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

  • emp-retire: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-err.p
  • DELETE: Overridable, Procedure is tr-d-err.p
  • REPLICATION-CREATE: Procedure is rp-c-err.p
  • REPLICATION-DELETE: Procedure is rp-d-err.p
  • REPLICATION-WRITE: Procedure is rp-u-err.p
  • WRITE: Overridable, Procedure is tr-u-err.p

    Other tables who reference emp-retire

  • emp-adjust - Employee Adjustments
  • emp-counter - Employee Counters
  • emp-deduct - Employee Deductions file
  • emp-deduct-rate - Employee Deduction/Payrate linkage
  • emp-distrib - Employee Distributions
  • emp-pay-master - Employee Payroll Master
  • emp-rate - Employee Payrate records
  • emp-rate-hours - Employee Payrate Hourly detail
  • emp-rate-loc - Employee Payrate Locations records
  • emp-rate-savings - Employee payrate savings, typically used for Summer Savings
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-unemp - Employee Unemployement counters
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-log - Payroll Message log file

    Tables emp-retire references

  • ecc-code - ECC Code Definitions
  • emp-adjust - Employee Adjustments
  • emp-counter - Employee Counters
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-pay-master - Employee Payroll Master
  • emp-payroll - The one per employee, once per payroll control file
  • emp-quarter - Employee Quarterly Retirement reporting records
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-tdp - Employee DTL3 record
  • emp-unemp - Employee Unemployement counters
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-cycle-schd - Linkage file between cycles and the payroll active for them
  • pay-schd - Payroll Schedule for a year One entry per
  • retire-code - Retirement code definitions

    Detailed Alphabetical Field Listing
    cur-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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)
    Help: Current Retirement Gross

    cur-gross-retire-adjust Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99

    cur-retire-adjust Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99

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

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

    cur-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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

    ecc-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: ECC Code Identifier for this payroll

    emp-seq Data type: INTEGER
    Format: zzzzzzzz9
    Description: Employee's Unique Sequence #
    Attributes: Index Component

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

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    federal-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Description: Account used to create disbursement

    federal-retire-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run # used for producing this disbursement

    federal-retire-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor # used for producing this disbursement

    fytd-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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)
    Help: FYTD Retirement Gross

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

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

    fytd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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

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

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

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

    mtd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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

    pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payroll Identifier
    Attributes: Index Component

    pay-seq Data type: INTEGER
    Format: zzzzzzzzz9
    Description: Payroll Sequence within a given pay for an employee
    Attributes: Index Component

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

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

    qtd-federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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)
    Help: QTD Retirement Gross

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

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

    qtd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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

    retire-adjustment Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99

    retire-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Retirement Code Identifier

    retire-distributed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: True if retirement was distributed with the last calculation

    retire-gross-adjust Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99

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

    state-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Description: Account used to create disbursement

    state-retire-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run # used for producing this disbursement

    state-retire-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor # used for producing this disbursement

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

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

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

    ytd-state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: 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 12/28/2020 by DBHTML V1.2