Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference pay-rate
Tables pay-rate references
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