Definition of table schd-profile
Employee Contract Schedule/Step/Level profile , Table Dump Name schd-prf

Alphabetical Field Summary

  • base-salary: (DECM) Base salary for this payroll schedule
  • cont-days-max: (INTG) Enter maximum number of work days in this Contract Schedule
  • cont-days-min: (INTG) Enter minimum number of work days in this Contract Schedule
  • extern-guid: (CHAR) External Global Unique ID for this record
  • pay-over-cnt: (INTG) Number of payrolls to split contract limit over (salaried on
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • round-dollars: (LOGC) 'Yes' to have schedule calculations round to nearest dollar
  • schd-desc: (CHAR) Description, if any, of the payroll contract schedule
  • schd-from: (DATE) Date schedule is valid from
  • schd-hourly: (LOGC) 'Hourly' for an hourly schedule or 'Salary' for a salaried o
  • schd-id: (INTG) Payroll Schedule Identifier
  • schd-name: (CHAR) Name of this payroll contract schedule
  • schd-statutory: (LOGC) Yes to indicate this Schedule contains a Statutory Minimum S
  • schd-to: (DATE) Date schedule is valid to
  • x-axis-multiplier: (DECM) Multiply successive horizontal items by this
  • x-axis-step: (LOGC) 'Step' if horizontal axis is step or 'Level' if it's not
  • y-axis-multiplier: (DECM) Multiply successive vertical items by this
  • y-axis-step: (LOGC) 'Level' if vertical axis is level, 'Step' it is not

    Alphabetical Index Summary

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

    Alphabetical Trigger Summary

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

    Other tables who reference schd-profile

  • emp-rate - Employee Payrate records
  • pay-rate - Master Payrate definitions
  • schd-item - Individual entries for each step/level of each payroll sched
  • schd-label - Labels or the Step/Level of the Payroll Schedule

    Tables schd-profile references

  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    base-salary Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Base salary for this payroll schedule

    cont-days-max Data type: INTEGER
    Format: >>9 (Initial Value: 0)
    Help: Enter maximum number of work days in this Contract Schedule

    cont-days-min Data type: INTEGER
    Format: >>9 (Initial Value: 0)
    Help: Enter minimum number of work days in this Contract Schedule

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

    pay-over-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Number of payrolls to split contract limit over (salaried on

    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

    round-dollars Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: 'Yes' to have schedule calculations round to nearest dollar

    schd-desc Data type: CHARACTER
    Format: x(32)
    Help: Description, if any, of the payroll contract schedule

    schd-from Data type: DATE
    Format: 99/99/9999
    Help: Date schedule is valid from

    schd-hourly Data type: LOGICAL
    Format: Hourly/Salary (Initial Value: Salary)
    Help: 'Hourly' for an hourly schedule or 'Salary' for a salaried o

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

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

    schd-statutory Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to indicate this Schedule contains a Statutory Minimum S

    schd-to Data type: DATE
    Format: 99/99/9999
    Help: Date schedule is valid to

    x-axis-multiplier Data type: DECIMAL (Decimals: 2)
    Format: -zz9.99% (Initial Value: 1)
    Help: Multiply successive horizontal items by this

    x-axis-step Data type: LOGICAL
    Format: Step/Level (Initial Value: Step)
    Help: 'Step' if horizontal axis is step or 'Level' if it's not

    y-axis-multiplier Data type: DECIMAL (Decimals: 2)
    Format: -zz9.99% (Initial Value: 1)
    Help: Multiply successive vertical items by this

    y-axis-step Data type: LOGICAL
    Format: Step/Level (Initial Value: Level)
    Help: 'Level' if vertical axis is level, 'Step' it is not

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