Definition of table emp-quarter
Employee Quarterly Retirement reporting records , Table Dump Name emp-qtr

Alphabetical Field Summary

  • calendar-year: (INTG) Calendar year associated with this record
  • comment: (CHAR) Any comments regarding this quarter (this is not reported)
  • ecc-code-id: (INTG) ECC Code Identifier for this quarter record
  • emp-seq: (INTG) Employee's Unique Sequence #
  • exception-amount: (DECM) Total exceptions amount for this quarter (if any)
  • extern-guid: (CHAR) External Global Unique ID for this record
  • federal-basic: (DECM) Federal Basic Retirement amount for this quarter
  • federal-gross: (DECM) Retirement gross federal basic is calculated on
  • gross-amount: (DECM) Total Gross for employee for this quarter
  • hire-date: (DATE) Date employee hired (blank if not reporting this quarter)
  • pay-rate: (DECM) Employees hourly rate or salary
  • primary-key: (INTG) Unique, Primary key for record
  • prior-period: (LOGC) 'Yes' if quarterly info includes prior quarter figures
  • qtr-num: (INTG) Quarter of calendar year this record records
  • retire-amount: (DECM) Retirement Plan (MIP) Amount for this quarter
  • retire-code-id: (INTG) Retirement Code Identifier
  • retire-hours: (DECM) Total retirement hours for this quarter
  • state-basic: (DECM) State Basic Retirement amount for this quarter
  • state-gross: (DECM) Retirement Gross state basic is calculated on
  • term-code: (INTG) Termination code, if terminated this quarter
  • term-date: (DATE) Date employee terminated employment (if in this quarter)

    Alphabetical Index Summary

  • emp-quarter: (PRIMARY) emp-seq, calendar-year, qtr-num, ecc-code-id
  • extern-guid: extern-guid
  • quarter-info: calendar-year, qtr-num, emp-seq, ecc-code-id
  • retire-order: calendar-year, qtr-num, emp-seq, retire-code-id, ecc-code-id

    Alphabetical Trigger Summary

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

    Tables emp-quarter references

  • ecc-code - ECC Code Definitions
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • emp-w2 - Employee W2 Info
  • pay-profile - Payroll System Profile
  • retire-code - Retirement code definitions

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

    comment Data type: CHARACTER
    Format: x(40)
    Help: Any comments regarding this quarter (this is not reported)

    ecc-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: ECC Code Identifier for this quarter record
    Attributes: Index Component

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

    exception-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Total exceptions amount for this quarter (if any)

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

    federal-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Federal Basic Retirement amount for this quarter

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

    gross-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Total Gross for employee for this quarter

    hire-date Data type: DATE
    Format: 99/99/9999
    Help: Date employee hired (blank if not reporting this quarter)

    pay-rate Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Employees hourly rate or salary

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

    prior-period Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if quarterly info includes prior quarter figures

    qtr-num Data type: INTEGER
    Format: 9 (Initial Value: 0)
    Help: Quarter of calendar year this record records
    Attributes: Index Component

    retire-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Retirement Plan (MIP) Amount for this quarter

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

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

    state-basic Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: State Basic Retirement amount for this quarter

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

    term-code Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Help: Termination code, if terminated this quarter

    term-date Data type: DATE
    Format: 99/99/9999
    Help: Date employee terminated employment (if in this quarter)

    Created on 12/28/2020 by DBHTML V1.2