Definition of table schd-item
Individual entries for each step/level of each payroll schedule , Table Dump Name schd-itm

Alphabetical Field Summary

  • amount: (DECM) Amount for this step/level of the schedule
  • extern-guid: (CHAR) External Global Unique ID for this record
  • level-label-id: (INTG) Pay Schedule Label Identifier for schedule level
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • schd-id: (INTG) Payroll Schedule Identifier
  • statutory-item: (LOGC) Yes to indicate this item belongs to the Statutory Minimum S
  • step-label-id: (INTG) Pay Schedule Label Identifier for schedule step

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • schd-item: (UNIQUE, PRIMARY) schd-id, step-label-id, level-label-id

    Alphabetical Trigger Summary

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

    Other tables who reference schd-item

  • emp-rate - Employee Payrate records
  • pay-rate - Master Payrate definitions

    Tables schd-item references

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

    Detailed Alphabetical Field Listing
    amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Amount for this step/level of the schedule

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

    level-label-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Pay Schedule Label Identifier for schedule level
    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

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

    statutory-item Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to indicate this item belongs to the Statutory Minimum S

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

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