Definition of table pay-year
Payroll Year definitions , Table Dump Name pay-year

Alphabetical Field Summary

  • comment: (CHAR) Any comments regarding this payroll year
  • extern-guid: (CHAR) External Global Unique ID for this record
  • pay-end: (DATE) Date payroll year ends on
  • pay-start: (DATE) Date payroll year starts on
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-date: pay-start, pay-end
  • pay-year: (UNIQUE, PRIMARY) payroll-year

    Alphabetical Trigger Summary

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

    Other tables who reference pay-year

  • emp-dc - (no description available)
  • emp-fringe - (no description available)
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • fringe-class - Fringe benefit classes
  • fringe-code - (no description available)
  • fringe-period - Fringe Benefit Period
  • mpsers-period - (no description available)
  • pay-acct - Payroll Distribution Account List
  • pay-cycle - Payroll Cycle Definitions
  • pay-cycle-schd - Linkage file between cycles and the payroll active for them
  • pay-deduct - Payroll Master Deductions definition
  • pay-rate - Master Payrate definitions
  • pay-schd - Payroll Schedule for a year One entry per
  • schd-item - Individual entries for each step/level of each payroll sched
  • schd-label - Labels or the Step/Level of the Payroll Schedule
  • schd-profile - Employee Contract Schedule/Step/Level profile

    Detailed Alphabetical Field Listing
    comment Data type: CHARACTER
    Format: x(60)
    Help: Any comments regarding this payroll year

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

    pay-end Data type: DATE
    Format: 99/99/9999
    Help: Date payroll year ends on
    Attributes: Index Component

    pay-start Data type: DATE
    Format: 99/99/9999
    Help: Date payroll year starts on
    Attributes: Index Component

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

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

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