Definition of table emp-rate

Employee Payrate records , Table Dump Name emp-rate

Alphabetical Field Summary

adjust-amount: (DECM) Amount of adjustment to apply to payrate for this payroll

adjust-ecc-end-date: (DATE) End date of this adjustment

adjust-ecc-start-date: (DATE) Start date for this adjustment

adjust-pay-cnt: (INTG) Number of payrolls this adjustment has been active on

adjust-pay-max: (INTG) Number of payrolls to apply adjustment

adjust-seq: (INTG) Adjustment Sequence #

adjust-type: (CHAR) Type of adjustment (Normal, Contract, Retro or Backup)

adjust-wage-code-id: (INTG) Internally assigned identifier

assign-id: (INTG) Payrate Assignment identifier

cont-adjust: (DECM) Amount of adjustment applied for this payroll

cont-days: (INTG) Enter number of days to be worked for this Contract

cont-extra-hours: (DECM) Extra hours for this payroll

cont-gross: (DECM) Payrate gross for this payroll

cont-overtime-hours: (DECM) Overtime hours for this payroll

cont-regular-hours: (DECM) Number of regular hours for this payroll

cont-retire-hours: (DECM) Total retirement hours for this payrate and payroll

cont-standard: (LOGC) Yes for Standard Contract with standard # of Contract Days

cur-adjust: (DECM) Amount of adjustment applied for this payroll

cur-adjust-type: (CHAR) Adjustment type as of last calculation

cur-extra-hours: (DECM) Extra hours for this payroll

cur-gross: (DECM) Payrate gross for this payroll

cur-overtime-hours: (DECM) Overtime hours for this payroll

cur-regular-hours: (DECM) Number of regular hours for this payroll

cur-retire-hours: (DECM) Total retirement hours for this payrate and payroll

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

ecc-end-date: (DATE) End date for this employment class

ecc-start-date: (DATE) Start date of this Employement Class Code

eeoc-id: (INTG) EEOC Code ID

emp-seq: (INTG) Employee's Unique Sequence #

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

extra-amount: (DECM) Amount calculated amount for the extra hours on this payroll

extra-hours: (DECM) Extra hours for this payroll

for-regular-pay: (LOGC) 'Reg' to use only for regular pays, 'All' to use for all pay

fytd-adjust: (DECM) Amount of adjustment applied for this payroll

fytd-extra-hours: (DECM) FYTD Extra hours

fytd-gross: (DECM) FYTD Payrate gross

fytd-overtime-hours: (DECM) FYTD Overtime hours

fytd-regular-hours: (DECM) FYTD regular hours

fytd-retire-hours: (DECM) FYTD retirement hours

hit-limit-pay-id: (INTG) Payroll # employee hit payrate limit

hit-limit-pay-seq: (INTG) Employee payroll seq employee hit payrate limit

last-adjust-pay-id: (INTG) Last payroll # record was adjusted on

last-adjust-pay-seq: (INTG) Last employee payroll seq # record was adjusted on

last-used-pay-id: (INTG) Last payroll # record was used on

last-used-pay-seq: (INTG) Last employee payroll seq # record was used on

level-label-id: (INTG) Payrate Schedule Label Identifier for schedule level

mtd-adjust: (DECM) MTD adjustment amount

mtd-extra-hours: (DECM) MTD Extra hours

mtd-gross: (DECM) MTD Payrate gross

mtd-overtime-hours: (DECM) MTD Overtime hours

mtd-regular-hours: (DECM) MTD regular hours

mtd-retire-hours: (DECM) MTD retirement hours

overtime-amount: (DECM) Amount calculated for overtime on this payroll

overtime-hours: (DECM) Overtime hours for this payroll

pay-id: (INTG) Payroll Identifier

pay-over-cnt: (INTG) Number of payrolls to split contract limit over (salaried on

pay-seq: (INTG) Payroll Sequence within a given pay for an employee

primary-key: (INTG) Unique, Primary key for record

qtd-adjust: (DECM) QTD adjustment amount

qtd-extra-hours: (DECM) QTD Extra hours

qtd-gross: (DECM) QTD Payrate gross

qtd-overtime-hours: (DECM) QTD Overtime hours

qtd-regular-hours: (DECM) QTD regular hours

qtd-retire-hours: (DECM) QTDl retirement hours

rate-active: (LOGC) Is this payrate active for this payroll?

rate-amount: (DECM) Hourly wage amount for 'Hourly' rate or per payroll amount f

rate-cycle-id: (INTG) Payroll cycle ID this payrate is active on

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-num: (INTG) Payrate number

rate-primary: (LOGC) 'Yes' if this is considered the 'Primary' payrate

rate-seq: (INTG) Payrate Sequence # (assigned once for the life of the payrat

rate-type: (CHAR) Type of payrate (Normal, Retro or Backup)

regular-amount: (DECM) Amount calculated for regular hours on this payroll

regular-hours: (DECM) Number of regular hours for this payroll

retire-hours: (DECM) Total retirement hours for this payrate and payroll

schd-id: (INTG) Payrate Schedule Identifier

start-date: (DATE) Initial/starting date of employees use of the payrate

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

wage-code-id: (INTG) Internally assigned identifier

ytd-adjust: (DECM) YTD adjustment amounts

ytd-extra-hours: (DECM) YTD Extra hours

ytd-gross: (DECM) YTD Payrate gross

ytd-overtime-hours: (DECM) YTD Overtime hours

ytd-regular-hours: (DECM) YTD regular hours

ytd-retire-hours: (DECM) YTD retirement hours

Alphabetical Index Summary

emp-rate: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq, rate-seq

extern-guid: extern-guid

rate-id: rate-id, pay-id, emp-seq, pay-seq, rate-seq

rate-num: pay-id, emp-seq, pay-seq, rate-num, rate-seq

rate-schd: schd-id, step-label-id, level-label-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ert.p

DELETE: Overridable, Procedure is tr-d-ert.p

REPLICATION-CREATE: Procedure is rp-c-ert.p

REPLICATION-DELETE: Procedure is rp-d-ert.p

REPLICATION-WRITE: Procedure is rp-u-ert.p

WRITE: Overridable, Procedure is tr-u-ert.p

Other tables who reference emp-rate

emp-deduct-rate - Employee Deduction/Payrate linkage

emp-rate-hours - Employee Payrate Hourly detail

emp-rate-loc - Employee Payrate Locations records

emp-rate-savings - Employee payrate savings, typically used for Summer Savings

Tables emp-rate references

ecc-code - ECC Code Definitions

emp-adjust - Employee Adjustments

emp-counter - Employee Counters

emp-dc - (no description available)

emp-deduct-rate - Employee Deduction/Payrate linkage

emp-demo - Employee Demographic Entry

emp-mpsers - (no description available)

emp-pay-master - Employee Payroll Master

emp-payroll - The one per employee, once per payroll control file

emp-quarter - Employee Quarterly Retirement reporting records

emp-rate-savings - Employee payrate savings, typically used for Summer Savings

emp-retire - Employee Retirment Records

emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)

emp-tdp - Employee DTL3 record

emp-unemp - Employee Unemployement counters

pay-assign - Payroll Assignments

pay-check - Payroll Check file, one record per payroll check issued

pay-cycle-schd - Linkage file between cycles and the payroll active for them

pay-rate - Master Payrate definitions

pay-schd - Payroll Schedule for a year One entry per

schd-item - Individual entries for each step/level of each payroll sched

schd-profile - Employee Contract Schedule/Step/Level profile

wage-code - (no description available)

Detailed Alphabetical Field Listing
adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Amount of adjustment to apply to payrate for this payroll

adjust-ecc-end-date Data type: DATE
Format: 99/99/9999
Help: End date of this adjustment

adjust-ecc-start-date Data type: DATE
Format: 99/99/9999
Help: Start date for this adjustment

adjust-pay-cnt Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Number of payrolls this adjustment has been active on

adjust-pay-max Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Number of payrolls to apply adjustment

adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #

adjust-type Data type: CHARACTER
Format: x(8)
Help: Type of adjustment (Normal, Contract, Retro or Backup)

adjust-wage-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned identifier
Help: Wage code associated with this adjustment

assign-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payrate Assignment identifier

cont-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Amount of adjustment applied for this payroll

cont-days Data type: INTEGER
Format: >>9 (Initial Value: 0)
Help: Enter number of days to be worked for this Contract

cont-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Extra hours for this payroll

cont-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Payrate gross for this payroll

cont-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Overtime hours for this payroll

cont-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Number of regular hours for this payroll

cont-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Total retirement hours for this payrate and payroll

cont-standard Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes for Standard Contract with standard # of Contract Days

cur-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Amount of adjustment applied for this payroll

cur-adjust-type Data type: CHARACTER
Format: x(6)
Description: Adjustment type as of last calculation

cur-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Extra hours for this payroll

cur-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: Payrate gross for this payroll

cur-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Overtime hours for this payroll

cur-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Number of regular hours for this payroll

cur-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: Total retirement hours for this payrate and payroll

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

ecc-end-date Data type: DATE
Format: 99/99/9999
Help: End date for this employment class

ecc-start-date Data type: DATE
Format: 99/99/9999
Help: Start date of this Employement Class Code

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

emp-seq Data type: INTEGER
Format: zzzzzzzz9
Description: Employee's Unique Sequence #
Attributes: Index Component

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

extra-amount Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Amount calculated amount for the extra hours on this payroll

extra-hours Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Extra hours for this payroll

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

fytd-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Amount of adjustment applied for this payroll

fytd-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: FYTD Extra hours

fytd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: FYTD Payrate gross

fytd-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: FYTD Overtime hours

fytd-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: FYTD regular hours

fytd-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: FYTD retirement hours

hit-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll # employee hit payrate limit

hit-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Employee payroll seq employee hit payrate limit

last-adjust-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # record was adjusted on

last-adjust-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # record was adjusted on

last-used-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # record was used on

last-used-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # record was used on

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

mtd-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: MTD adjustment amount

mtd-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: MTD Extra hours

mtd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: MTD Payrate gross

mtd-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: MTD Overtime hours

mtd-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: MTD regular hours

mtd-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: MTD retirement hours

overtime-amount Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Amount calculated for overtime on this payroll

overtime-hours Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Overtime hours for this payroll

pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payroll Identifier
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

pay-seq Data type: INTEGER
Format: zzzzzzzzz9
Description: Payroll Sequence within a given pay for an employee
Attributes: Index Component

primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record

qtd-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: QTD adjustment amount

qtd-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: QTD Extra hours

qtd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: QTD Payrate gross

qtd-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: QTD Overtime hours

qtd-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: QTD regular hours

qtd-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: QTDl retirement hours

rate-active Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this payrate active for this payroll?

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: ->,>>>,>>9
Help: Payroll cycle ID this payrate is active on

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
Help: Pay Rate ID for the payrate
Attributes: Index Component

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

rate-num Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Payrate number
Attributes: Index Component

rate-primary Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if this is considered the 'Primary' payrate

rate-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payrate Sequence # (assigned once for the life of the payrat
Attributes: Index Component

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

regular-amount Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Amount calculated for regular hours on this payroll

regular-hours Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Number of regular hours for this payroll

retire-hours Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Total retirement hours for this payrate and payroll

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

start-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Help: Initial/starting date of employees use of the payrate

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

wage-code-id Data type: INTEGER
Format: zzzzzzzzzz9
Description: Internally assigned identifier
Help: Wage code associated with this payrate

ytd-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: YTD adjustment amounts

ytd-extra-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: YTD Extra hours

ytd-gross Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Help: YTD Payrate gross

ytd-overtime-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: YTD Overtime hours

ytd-regular-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: YTD regular hours

ytd-retire-hours Data type: DECIMAL (Decimals: 2)
Format: z,zz9.99 (Initial Value: 0)
Help: YTD retirement hours

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