Definition of table emp-rate-loc
Employee Payrate Locations records , Table Dump Name emp-rloc

Alphabetical Field Summary

  • adjust-dist-code: (CHAR) Distribution code for Adjustment amounts
  • emp-seq: (INTG) Employee's Unique Sequence #
  • extern-guid: (CHAR) External Global Unique ID for this record
  • extra-dist-code: (CHAR) Distribution code for Extra amount
  • loc-code: (CHAR) Location code for this distribution
  • loc-fte: (DECM) FTE for this location
  • loc-seq: (INTG) Location Sequence # (oridinal purposes only)
  • overtime-dist-code: (CHAR) Distribution code for Overtime
  • 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-dist-code: (CHAR) Distribution code for Regular/Salary amount

    Alphabetical Index Summary

  • emp-rate-loc: (UNIQUE, PRIMARY) pay-id, emp-seq, pay-seq, rate-seq, loc-seq
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Tables emp-rate-loc 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-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
  • loc-code - Location Codes
  • 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-schd - Payroll Schedule for a year One entry per

    Detailed Alphabetical Field Listing
    adjust-dist-code Data type: CHARACTER
    Format: x
    Help: Distribution code for Adjustment amounts

    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-dist-code Data type: CHARACTER
    Format: x
    Help: Distribution code for Extra amount

    loc-code Data type: CHARACTER
    Format: x(8)
    Help: Location code for this distribution

    loc-fte Data type: DECIMAL (Decimals: 2)
    Format: zz9.99% (Initial Value: 0)
    Help: FTE for this location

    loc-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Location Sequence # (oridinal purposes only)
    Attributes: Index Component

    overtime-dist-code Data type: CHARACTER
    Format: x
    Help: Distribution code for Overtime

    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-dist-code Data type: CHARACTER
    Format: x
    Help: Distribution code for Regular/Salary amount

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