Definition of table emp-pay-master
Employee Payroll Master , Table Dump Name ep-mast

Alphabetical Field Summary

  • cash-acct-num: (CHAR) Account used to create disbursement
  • cash-check-run: (INTG) Check run # used for producing this disbursement
  • cash-ent-id: (CHAR) Vendor # used for producing this disbursement
  • check-printed: (LOGC) 'Yes' if a check has been printed for employee
  • detail-exceptions: (LOGC) 'Detail' to allow hourly detail, 'Summary' for summary payra
  • emp-seq: (INTG) Employee's Unique Sequence #
  • exception-comment: (CHAR) Comment, if any, regard this payroll for employee
  • exceptions-posted: (LOGC) 'Yes' if the employee has had some exceptions posted
  • extern-guid: (CHAR) External Global Unique ID for this record
  • last-used-pay-id: (INTG) Last payroll # record was used on
  • last-used-pay-seq: (INTG) Last employee payroll seq # record was used on
  • locked-pay: (LOGC) Set if payroll is locked off from changes
  • log-seq: (INTG) Last assigned Log Seq#
  • pay-accr-used[5]: (DECM) Amount used for this payroll
  • pay-active: (LOGC) Is this employee active for this payroll?
  • pay-being-recalced: (LOGC) Set if record in recalculation process
  • pay-calculated: (LOGC) 'Yes' if payroll has been calculated for employee
  • pay-comment[3]: (CHAR) Any comments regarding this payroll
  • pay-cycle-id: (INTG) Payroll cycle ID this employee is active on
  • pay-group-id: (INTG) Employee's Payroll Group
  • pay-id: (INTG) Payroll Identifier
  • pay-multiplier: (INTG) # or payrolls to calculate for for this one payroll
  • pay-needs-calc: (LOGC) 'Yes' if employee needs to be (re) calculated
  • pay-regular: (LOGC) 'Regular' or 'Supplemental' payroll
  • pay-seq: (INTG) Payroll Sequence within a given pay for an employee
  • post-payroll: (LOGC) 'Yes' if employee has been through post payroll processing
  • pre-payroll: (LOGC) 'Yes' if employee has had pre-payroll processing performed
  • primary-key: (INTG) Unique, Primary key for record
  • start-pay-id: (INTG) Starting payroll identifier for this employee
  • stop-pay-id: (INTG) Ending payroll identifier
  • zombie-payroll: (LOGC) Set if the payroll didn't have a gross/do anything

    Alphabetical Index Summary

  • emp-pay-master: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq
  • emp-seq: emp-seq, pay-id, pay-seq
  • emp-stat: pre-payroll, pay-calculated, check-printed, post-payroll, pay-id, emp-seq, pay-seq
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Other tables who reference emp-pay-master

  • 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-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-retire - Employee Retirment Records
  • 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-pay-master references

  • emp-adjust - Employee Adjustments
  • emp-counter - Employee Counters
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-payroll - The one per employee, once per payroll control file
  • emp-retire - Employee Retirment 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-group - Payroll employee group definitions
  • pay-log - Payroll Message log file
  • pay-schd - Payroll Schedule for a year One entry per

    Detailed Alphabetical Field Listing
    cash-acct-num Data type: CHARACTER
    Format: x(30)
    Description: Account used to create disbursement

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

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

    check-printed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if a check has been printed for employee
    Attributes: Index Component

    detail-exceptions Data type: LOGICAL
    Format: Detail/Summary (Initial Value: No)
    Help: 'Detail' to allow hourly detail, 'Summary' for summary payra

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

    exception-comment Data type: CHARACTER
    Format: x(54)
    Help: Comment, if any, regard this payroll for employee

    exceptions-posted Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if the employee has had some exceptions posted

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

    last-used-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Last payroll # record was used on

    last-used-pay-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Last employee payroll seq # record was used on

    locked-pay Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Set if payroll is locked off from changes

    log-seq Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: 0)
    Help: Last assigned Log Seq#

    pay-accr-used Data type: DECIMAL (Extent: 5, Decimals: 3)
    Format: -z,zz9.999 (Initial Value: 0)
    Help: Amount used for this payroll

    pay-active Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this employee active for this payroll?

    pay-being-recalced Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Set if record in recalculation process

    pay-calculated Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if payroll has been calculated for employee
    Attributes: Index Component

    pay-comment Data type: CHARACTER (Extent: 3)
    Format: x(40)
    Help: Any comments regarding this payroll

    pay-cycle-id Data type: INTEGER
    Format: ->,>>>,>>9
    Help: Payroll cycle ID this employee is active on

    pay-group-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Employee's Payroll Group

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

    pay-multiplier Data type: INTEGER
    Format: zz9 (Initial Value: 1)
    Help: # or payrolls to calculate for for this one payroll

    pay-needs-calc Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if employee needs to be (re) calculated

    pay-regular Data type: LOGICAL
    Format: Regular/Supplemental (Initial Value: Regular)
    Help: 'Regular' or 'Supplemental' payroll

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

    post-payroll Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if employee has been through post payroll processing
    Attributes: Index Component

    pre-payroll Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' if employee has had pre-payroll processing performed
    Attributes: Index Component

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

    start-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: -1)
    Description: Starting payroll identifier for this employee

    stop-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: -1)
    Description: Ending payroll identifier

    zombie-payroll Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Set if the payroll didn't have a gross/do anything

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