Definition of table pay-rate
Master Payrate definitions , Table Dump Name pay-rate

Alphabetical Field Summary

  • assign-id: (INTG) Payrate Assignment identifier
  • default-regular-hours: (DECM) Default 'regular' hours for this payrate
  • default-retire-hours: (DECM) Default number of retirement hours for this payrate
  • ecc-code-id: (INTG) ECC Code Identifier for this pay rate
  • eeoc-id: (INTG) EEOC Code ID
  • exempt-fica: (LOGC) 'Yes' if payrate is exempt from FICA, otherwise 'No'
  • exempt-fit: (LOGC) 'Yes' if payrate is exempt from FIT, otherwise 'No'
  • exempt-futa: (LOGC) 'Yes' if payrate is exempt from FUTA, otherwise 'No'
  • exempt-lit: (LOGC) 'Yes' if payrate is exempt from LIT, otherwise 'No'
  • exempt-medicare: (LOGC) 'Yes' if payrate is exempt from Medicare, otherwise 'No'
  • exempt-oit: (LOGC) 'Yes' if payrate is exempt from OIT, otherwise 'No'
  • exempt-retire: (LOGC) 'Yes' if payrate is exempt from retirement, 'No' otherwise
  • exempt-sit: (LOGC) 'Yes' if payrate is exempt from SIT, otherwise 'No'
  • exempt-suta: (LOGC) 'Yes' if payrate is exempt from SUTA, otherwise 'No'
  • extern-guid: (CHAR) External Global Unique ID for this record
  • for-regular-pay: (LOGC) 'Reg' to use only for regular pays, 'All' to use for all pay
  • level-label-id: (INTG) Payrate Schedule Label Identifier for schedule level
  • 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
  • rate-active: (LOGC) Should payrate start off as active?
  • rate-amount: (DECM) Hourly wage amount for 'Hourly' rate or per payroll amount f
  • rate-cycle-id: (INTG) Payrate cycle identifier
  • rate-desc: (CHAR) Description of function or purpose of payrate
  • rate-hourly: (LOGC) 'Hourly' for an hourly based payrate or 'Salary' otherwise
  • rate-id: (INTG) Pay Rate Identifier
  • rate-limit: (DECM) Payrate/Contract limit
  • rate-name: (CHAR) Name of payrate
  • rate-type: (CHAR) Type of payrate (Normal, Retro or Backup)
  • schd-id: (INTG) Payrate Schedule Identifier
  • start-pay-id: (INTG) Starting payroll identifier
  • step-label-id: (INTG) Payrate Schedule Label Identifier for schedule step
  • stop-pay-id: (INTG) Ending payroll identifier

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-rate: (UNIQUE, PRIMARY) rate-id
  • rate-desc: payroll-year, rate-desc
  • rate-name: payroll-year, rate-name
  • rate-schd: schd-id, step-label-id, level-label-id

    Alphabetical Trigger Summary

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

    Other tables who reference pay-rate

  • emp-rate - Employee Payrate records

    Tables pay-rate references

  • ecc-code - ECC Code Definitions
  • emp-quarter - Employee Quarterly Retirement reporting records
  • pay-assign - Payroll Assignments
  • pay-year - Payroll Year definitions
  • schd-item - Individual entries for each step/level of each payroll sched
  • schd-profile - Employee Contract Schedule/Step/Level profile


    Detailed Alphabetical Field Listing
    assign-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payrate Assignment identifier

    default-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Help: Default 'regular' hours for this payrate

    default-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Help: Default number of retirement hours for this payrate

    ecc-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: ECC Code Identifier for this pay rate

    eeoc-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: EEOC Code ID

    exempt-fica Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from FICA, otherwise 'No'

    exempt-fit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from FIT, otherwise 'No'

    exempt-futa Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from FUTA, otherwise 'No'

    exempt-lit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from LIT, otherwise 'No'

    exempt-medicare Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from Medicare, otherwise 'No'

    exempt-oit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from OIT, otherwise 'No'

    exempt-retire Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from retirement, 'No' otherwise

    exempt-sit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from SIT, otherwise 'No'

    exempt-suta Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' if payrate is exempt from SUTA, otherwise 'No'

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

    for-regular-pay Data type: LOGICAL
    Format: Reg/All (Initial Value: Reg)
    Help: 'Reg' to use only for regular pays, 'All' to use for all pay

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

    rate-active Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Should payrate start off as active?

    rate-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Hourly wage amount for 'Hourly' rate or per payroll amount f
    Help: Hourly wage/Salary amount

    rate-cycle-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payrate cycle identifier

    rate-desc Data type: CHARACTER
    Format: x(32)
    Help: Description of function or purpose of payrate
    Attributes: Index Component

    rate-hourly Data type: LOGICAL
    Format: Hourly/Salary (Initial Value: Hourly)
    Help: 'Hourly' for an hourly based payrate or 'Salary' otherwise

    rate-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Pay Rate Identifier
    Attributes: Index Component

    rate-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Payrate/Contract limit

    rate-name Data type: CHARACTER
    Format: x(8)
    Help: Name of payrate
    Attributes: Index Component

    rate-type Data type: CHARACTER
    Format: x(8) (Initial Value: Normal)
    Help: Type of payrate (Normal, Retro or Backup)

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

    start-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: -1)
    Description: Starting payroll identifier

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

    stop-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: -1)
    Description: Ending payroll identifier

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