Definition of table emp-rate-hours
Employee Payrate Hourly detail
, Table Dump Name emp-rhrs
Alphabetical Field Summary
acct-num: (CHAR) Expense account to distribute to
emp-seq: (INTG) Employee's Unique Sequence #
extern-guid: (CHAR) External Global Unique ID for this record
extra-hours: (DECM) Extra hours for this payroll
line-note: (CHAR) Any notes on this detail line/payrate
line-num: (INTG) Line # of this hourly detail
overtime-hours: (DECM) Overtime hours for this payroll
pay-id: (INTG) Payroll Identifier
pay-seq: (INTG) Payroll Sequence within a given pay for an employee
primary-key: (INTG) Unique, Primary key for record
rate-seq: (INTG) Payrate Sequence # (assigned once for the life of the payrat
regular-hours: (DECM) Number of regular hours for this payroll
retire-hours: (DECM) Total retirement hours for this payrate and payroll
Alphabetical Index Summary
emp-rate-hours: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq, rate-seq, line-num
extern-guid: extern-guid
Alphabetical Trigger Summary
CREATE: Overridable, Procedure is tr-c-erh.p
DELETE: Overridable, Procedure is tr-d-erh.p
REPLICATION-CREATE: Procedure is rp-c-erh.p
REPLICATION-DELETE: Procedure is rp-d-erh.p
REPLICATION-WRITE: Procedure is rp-u-erh.p
WRITE: Overridable, Procedure is tr-u-erh.p
Tables emp-rate-hours references
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-distrib - Employee Distributions
emp-mpsers - (no description available)
emp-pay-master - Employee Payroll Master
emp-payroll - The one per employee, once per payroll control file
emp-rate - Employee Payrate 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-acct - Payroll Distribution Account List
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-disburse - Record of per-payroll vendor disburements
pay-distrib - Payroll DIstributions file
pay-schd - Payroll Schedule for a year One entry per
Detailed Alphabetical Field Listing
acct-num Data type: CHARACTER
Format: x(30)
Help: Expense account to distribute to
emp-seq Data type: INTEGER
Format: zzzzzzzz9
Description: Employee's Unique Sequence #
Attributes: Index Component
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
extra-hours Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Extra hours for this payroll
line-note Data type: CHARACTER
Format: x(17)
Help: Any notes on this detail line/payrate
line-num Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Line # of this hourly detail
Attributes: Index Component
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-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
rate-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payrate Sequence # (assigned once for the life of the payrat
Attributes: Index Component
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
Created on 12/28/2020 by DBHTML V1.2