Definition of table pay-log
Payroll Message log file , Table Dump Name pay-log

Alphabetical Field Summary

  • emp-seq: (INTG) Employee's Unique Sequence #
  • extern-guid: (CHAR) External Global Unique ID for this record
  • log-class: (CHAR) Log entry class (FICA, RATE, DEDUCT, etc)
  • log-ident: (CHAR) Identification (i.e. payrate #/name, deduction #/name, etc)
  • log-level: (CHAR) Log entry level (INFO, WARN, ERROR).
  • log-message: (CHAR) Logged message text
  • log-obj-seq: (INTG) Logged object Seq # (i.e. rate-seq, deduct-seq)
  • log-seq: (INTG) Log Seq# for this entry
  • pay-id: (INTG) Payroll Identifier
  • pay-seq: (INTG) Payroll Sequence within a given pay for an employee
  • primary-key: (INTG) Unique, Primary key for record
  • program-trace: (CHAR) Program calling trace

    Alphabetical Index Summary

  • class-log: pay-id, log-class, log-seq
  • extern-guid: extern-guid
  • level-log: pay-id, log-level, log-seq
  • pay-log: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq, log-seq

    Alphabetical Trigger Summary

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

    Other tables who reference pay-log

  • emp-pay-master - Employee Payroll Master

    Tables pay-log 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-pay-master - Employee Payroll Master
  • 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-schd - Payroll Schedule for a year One entry per

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

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

    log-class Data type: CHARACTER
    Format: x(6)
    Help: Log entry class (FICA, RATE, DEDUCT, etc)
    Attributes: Index Component

    log-ident Data type: CHARACTER
    Format: x(80)
    Help: Identification (i.e. payrate #/name, deduction #/name, etc)

    log-level Data type: CHARACTER
    Format: x(6)
    Help: Log entry level (INFO, WARN, ERROR).
    Attributes: Index Component

    log-message Data type: CHARACTER
    Format: x(80)
    Help: Logged message text

    log-obj-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Logged object Seq # (i.e. rate-seq, deduct-seq)

    log-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Log Seq# for this entry
    Attributes: Index Component

    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

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

    program-trace Data type: CHARACTER
    Format: x(70)
    Description: Program calling trace

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