Definition of table schd-label
Labels or the Step/Level of the Payroll Schedule , Table Dump Name schd-lbl

Alphabetical Field Summary

  • extern-guid: (CHAR) External Global Unique ID for this record
  • label-id: (INTG) Pay Schedule Label Identifier
  • label-is-step: (LOGC) True if label is for a step, False if for a label
  • label-name: (CHAR) Name or label for this step/level
  • label-num: (INTG) Number indicating labels position within a step or level
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • schd-id: (INTG) Payroll Schedule Identifier

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • schd-label-id: (UNIQUE, PRIMARY) schd-id, label-is-step, label-id
  • schd-label-name: payroll-year, schd-id, label-is-step, label-name
  • schd-label-num: schd-id, label-is-step, label-num

    Alphabetical Trigger Summary

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

    Other tables who reference schd-label

  • emp-rate - Employee Payrate records
  • pay-rate - Master Payrate definitions
  • schd-item - Individual entries for each step/level of each payroll sched

    Tables schd-label references

  • pay-year - Payroll Year definitions
  • schd-profile - Employee Contract Schedule/Step/Level profile

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

    label-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Pay Schedule Label Identifier
    Attributes: Index Component

    label-is-step Data type: LOGICAL
    Format: Step/Level (Initial Value: Step)
    Help: True if label is for a step, False if for a label
    Attributes: Index Component

    label-name Data type: CHARACTER
    Format: x(8)
    Help: Name or label for this step/level
    Attributes: Index Component

    label-num Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Description: Number indicating labels position within a step or level
    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

    schd-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payroll Schedule Identifier
    Attributes: Index Component

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