Definition of table pay-check
Payroll Check file, one record per payroll check issued , Table Dump Name pay-chk

Alphabetical Field Summary

  • check-amount: (DECM) Amount check was drafted for
  • check-date: (DATE) Date appearing on the check
  • check-desc: (CHAR) Description/Comment about this check
  • check-name: (CHAR) Name appearing on the check
  • check-num: (INTG) Check number
  • check-status: (CHAR) Status of check (Open/Void/Scratch/Cleared)
  • closed-date: (DATE) Date check was cleared/voided/scratched
  • emp-seq: (INTG) Unique Sequence # of employee associated with this check
  • extern-guid: (CHAR) External Global Unique ID for this record
  • 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

    Alphabetical Index Summary

  • check-name: check-name, check-num
  • check-num: check-num
  • check-status: check-status, check-num
  • emp-check: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq
  • extern-guid: extern-guid
  • pay-check: pay-id, check-num

    Alphabetical Trigger Summary

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

    Other tables who reference pay-check

  • 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-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-log - Payroll Message log file

    Tables pay-check 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-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
    check-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Amount check was drafted for

    check-date Data type: DATE
    Format: 99/99/9999
    Help: Date appearing on the check

    check-desc Data type: CHARACTER
    Format: x(32)
    Help: Description/Comment about this check

    check-name Data type: CHARACTER
    Format: x(40)
    Help: Name appearing on the check
    Attributes: Index Component

    check-num Data type: INTEGER
    Format: 999999 (Initial Value: 0)
    Help: Check number
    Attributes: Index Component

    check-status Data type: CHARACTER
    Format: x(8) (Initial Value: Open)
    Help: Status of check (Open/Void/Scratch/Cleared)
    Attributes: Index Component

    closed-date Data type: DATE
    Format: 99/99/9999
    Description: Date check was cleared/voided/scratched

    emp-seq Data type: INTEGER
    Format: zzzzzzzz9
    Description: Unique Sequence # of employee associated with this check
    Attributes: Index Component

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

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