Definition of table emp-mpsers
No table description available , Table Dump Name emp-mpse

Alphabetical Field Summary

  • begin-date: (DATE) Begin date of this MPSERS record (usually MPSERS period begi
  • comment: (CHAR) Comments about this MPSERS entry
  • cont-end-date: (DATE) Contract end date for this ECC Code, Wage Code
  • cont-start-date: (DATE) Contract start date for this ECC code, Wage Code
  • cre-date: (DATE) Date this record was created
  • cre-time: (CHAR) Creation time of this record
  • cre-user-name: (CHAR) Name of user who created this record
  • ecc-code-id: (INTG) ECC Code Identifier for this MPSERS record
  • emp-mpsers-id: (INTG) Unique ID for this record [DEFINE KEY]
  • emp-seq: (INTG) Employee's Unique Sequence #
  • employer-contribution: (DECM) Total employer contribution for this MPSERS record
  • end-date: (DATE) End date for this MPSERS record (usually MPSERS period end)
  • exception-amount: (DECM) Total exceptions amount for this MPSERS record (if any)
  • gross-amount: (DECM) Total Gross for employee for this MPSERS record
  • is-adjust: (LOGC) Is this record for a wage adjustment?
  • is-hourly: (LOGC) Is this record hourly?
  • is-primary: (LOGC) Is this the primary record?
  • manual-record: (LOGC) Was this record created manually, or can the builder purge i
  • member-contributions: (DECM) Total Member contributions for this MPSERS record
  • mpsers-period-id: (INTG) Internally assigned identifier
  • pay-over-cnt: (INTG) Number of payrolls to split contract limit over (salaried on
  • pay-rate: (DECM) Employees hourly rate or salary
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • retire-hours: (DECM) Total retirement hours for this MPSERS record
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time of last update to this record
  • upd-user-name: (CHAR) Name of user who last updated this record
  • wage-code-id: (INTG) Internally assigned identifier

    Alphabetical Index Summary

  • by-period: mpsers-period-id, emp-seq
  • emp-mpsers: emp-seq, payroll-year, mpsers-period-id
  • temp: (PRIMARY) emp-seq

    Alphabetical Trigger Summary

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

    Tables emp-mpsers references

  • ecc-code - ECC Code Definitions
  • emp-accr - Employee Accrual Blocks
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-quarter - Employee Quarterly Retirement reporting records
  • emp-tdp - Employee DTL3 record
  • mpsers-period - (no description available)
  • pay-year - Payroll Year definitions
  • wage-code - (no description available)

    Detailed Alphabetical Field Listing
    begin-date Data type: DATE
    Format: 99/99/9999
    Help: Begin date of this MPSERS record (usually MPSERS period begi

    comment Data type: CHARACTER
    Format: x(60)
    Help: Comments about this MPSERS entry

    cont-end-date Data type: DATE
    Format: 99/99/9999
    Help: Contract end date for this ECC Code, Wage Code

    cont-start-date Data type: DATE
    Format: 99/99/9999
    Help: Contract start date for this ECC code, Wage Code

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Creation time of this record

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who created this record
    Attributes: Mandatory

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

    emp-mpsers-id Data type: INTEGER
    Format: zzzzzzzzz9
    Description: Unique ID for this record [DEFINE KEY]
    Help: Internally Assigned Identifier

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

    employer-contribution Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99 (Initial Value: 0)
    Help: Total employer contribution for this MPSERS record

    end-date Data type: DATE
    Format: 99/99/9999
    Help: End date for this MPSERS record (usually MPSERS period end)

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

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

    is-adjust Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this record for a wage adjustment?

    is-hourly Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this record hourly?

    is-primary Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Is this the primary record?

    manual-record Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Was this record created manually, or can the builder purge i

    member-contributions Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99 (Initial Value: 0)
    Help: Total Member contributions for this MPSERS record

    mpsers-period-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally assigned identifier
    Help: MPSERS period this employee record is associated with
    Attributes: Index Component

    pay-over-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Number of payrolls to split contract limit over (salaried on

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

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

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

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

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time of last update to this record

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who last updated this record

    wage-code-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Internally assigned identifier
    Help: Wage code associated with this MPSERS record

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