Definition of table pay-cycle
Payroll Cycle Definitions , Table Dump Name pay-cyc

Alphabetical Field Summary

  • cycle-active: (LOGC) 'Yes' for an active cycle, 'No' to disable/deactivate the cy
  • cycle-comment: (CHAR) Any comments regarding this cycle you care to make
  • cycle-desc: (CHAR) Description of this payroll cycle
  • cycle-id: (INTG) Payroll Cycle Identifier
  • cycle-name: (CHAR) Name of this payroll cycle
  • cycle-pay-cnt: (INTG) Number of payrolls associated with this cycle
  • extern-guid: (CHAR) External Global Unique ID for this record
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record

    Alphabetical Index Summary

  • cycle-id: (UNIQUE, PRIMARY) cycle-id
  • cycle-name: payroll-year, cycle-name
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Other tables who reference pay-cycle

  • emp-deduct - Employee Deductions file
  • emp-pay-master - Employee Payroll Master
  • emp-rate - Employee Payrate records
  • emp-rate-savings - Employee payrate savings, typically used for Summer Savings
  • pay-cycle-schd - Linkage file between cycles and the payroll active for them
  • pay-deduct - Payroll Master Deductions definition
  • pay-rate - Master Payrate definitions

    Tables pay-cycle references

  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    cycle-active Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: 'Yes' for an active cycle, 'No' to disable/deactivate the cy

    cycle-comment Data type: CHARACTER
    Format: x(48)
    Help: Any comments regarding this cycle you care to make

    cycle-desc Data type: CHARACTER
    Format: x(32)
    Help: Description of this payroll cycle

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

    cycle-name Data type: CHARACTER
    Format: x(8)
    Help: Name of this payroll cycle
    Attributes: Index Component

    cycle-pay-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Number of payrolls associated with this cycle

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    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

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