Definition of table pay-cycle-schd
Linkage file between cycles and the payroll active for them , Table Dump Name pay-cysc

Alphabetical Field Summary

  • cycle-id: (INTG) Cycle Identification
  • extern-guid: (CHAR) External Global Unique ID for this record
  • last-pay: (LOGC) Yes if this is the last payroll (for accruals/contracts)
  • pay-id: (INTG) Unique identifier for this particular payroll
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • reset-pay: (LOGC) Yes if this payroll will reset accruals/counters

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-cycle-schd: (UNIQUE, PRIMARY) cycle-id, pay-id
  • pay-schd-cycle: pay-id, cycle-id

    Alphabetical Trigger Summary

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

    Other tables who reference pay-cycle-schd

  • 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-pay-master - Employee Payroll Master
  • emp-payroll - The one per employee, once per payroll control file
  • 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
  • fringe-period - Fringe Benefit Period
  • mpsers-period - (no description available)
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-deduct - Payroll Master Deductions definition
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-distrib - Payroll DIstributions file
  • pay-log - Payroll Message log file
  • pay-rate - Master Payrate definitions
  • pay-schd - Payroll Schedule for a year One entry per

    Tables pay-cycle-schd references

  • emp-payroll - The one per employee, once per payroll control file
  • pay-cycle - Payroll Cycle Definitions
  • pay-schd - Payroll Schedule for a year One entry per
  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    cycle-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Cycle Identification
    Attributes: Index Component

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

    last-pay Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if this is the last payroll (for accruals/contracts)

    pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Unique identifier for this particular payroll
    Attributes: Index Component

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

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

    reset-pay Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Yes if this payroll will reset accruals/counters

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