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

Alphabetical Field Summary

  • begin-date: (DATE) Begin date of this MPSERS record (usually MPSERS period begi
  • change-date: (DATE) Status Change Date
  • 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
  • dc-record-id: (INTG) define key
  • dc-status-id: (INTG) DC Status Change Reason Code
  • emp-seq: (INTG) Employee's Unique Sequence #
  • employer-contribution: (DECM) Total employer contribution for this MPSERS record
  • employer-dc-percent: (DECM) Employer DC Percent
  • employer-phf-contribution: (DECM) Employer PHF Contribution
  • employer-phf-percent: (DECM) Employer PHF Percent
  • end-date: (DATE) End date for this MPSERS record (usually MPSERS period end)
  • gross-amount: (DECM) Total Gross for employee for this MPSERS 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
  • member-dc-percent: (DECM) Member DC Percent
  • member-phf-contribution: (DECM) Member PHF Contribution
  • member-phf-percent: (DECM) Member PHF Percent
  • mpsers-period-id: (INTG) Internally assigned identifier
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for 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

    Alphabetical Index Summary

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

    Alphabetical Trigger Summary

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

    Tables emp-dc references

  • dc-record-type - (no description available)
  • dc-status-reason - (no description available)
  • emp-accr - Employee Accrual Blocks
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • mpsers-period - (no description available)
  • pay-year - Payroll Year definitions

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

    change-date Data type: DATE
    Format: 99/99/9999
    Help: Status Change Date

    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

    dc-record-id Data type: INTEGER
    Format: 999999999999999999
    Help: define key

    dc-status-id Data type: INTEGER
    Format: 999999999999999
    Help: DC Status Change Reason Code

    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

    employer-dc-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99
    Help: Employer DC Percent

    employer-phf-contribution Data type: DECIMAL (Decimals: 2)
    Format: -zzzz,zzz,zz9.99 (Initial Value: 0)
    Help: Employer PHF Contribution

    employer-phf-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99
    Help: Employer PHF Percent

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

    gross-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Total Gross for employee for this MPSERS 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

    member-dc-percent Data type: DECIMAL (Decimals: 2)
    Format: <<9.99
    Help: Member DC Percent

    member-phf-contribution Data type: DECIMAL (Decimals: 2)
    Format: -zzzz,zzz,zz9.99 (Initial Value: 0)
    Help: Member PHF Contribution

    member-phf-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99
    Help: Member PHF Percent

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

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

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for 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

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