Definition of table emp-rate-savings
Employee payrate savings, typically used for Summer Savings , Table Dump Name emp-rats

Alphabetical Field Summary

  • accrued-dc-released: (DECM) (no description available)
  • accrued-dc-saved: (DECM) (no description available)
  • accrued-fica-released: (DECM) FICA Amount Released
  • accrued-fica-saved: (DECM) FICA Amount Saved
  • accrued-rate-released: (DECM) Accrued released
  • accrued-rate-saved: (DECM) Accrued Savings
  • accrued-retire-released: (DECM) Amount released from retirement
  • accrued-retire-saved: (DECM) Amount saved toward retirement
  • cur-dc-released: (DECM) (no description available)
  • cur-dc-saved: (DECM) (no description available)
  • cur-fica-released: (DECM) FICA Amount Released
  • cur-fica-saved: (DECM) FICA Amount Saved
  • cur-rate-released: (DECM) Cur Released
  • cur-rate-saved: (DECM) Cur Amount saved
  • cur-retire-released: (DECM) Amount released from retirement
  • cur-retire-saved: (DECM) Amount saved toward retirement
  • cycle-id: (INTG) Cycle code used for accruing savings
  • emp-seq: (INTG) Employee Seq#
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fytd-dc-released: (DECM) (no description available)
  • fytd-dc-saved: (DECM) (no description available)
  • fytd-fica-released: (DECM) FICA Amount Released
  • fytd-fica-saved: (DECM) FICA Amount Saved
  • fytd-rate-released: (DECM) FYTD Released
  • fytd-rate-saved: (DECM) FYTD Saved
  • fytd-retire-released: (DECM) Amount released from retirement
  • fytd-retire-saved: (DECM) Amount saved toward retirement
  • mtd-dc-released: (DECM) (no description available)
  • mtd-dc-saved: (DECM) (no description available)
  • mtd-fica-released: (DECM) FICA Amount Released
  • mtd-fica-saved: (DECM) FICA Amount Saved
  • mtd-rate-released: (DECM) MTD Released
  • mtd-rate-saved: (DECM) MTD Saved
  • mtd-retire-released: (DECM) Amount released from retirement
  • mtd-retire-saved: (DECM) Amount saved toward retirement
  • pay-id: (INTG) Payroll ID
  • pay-seq: (INTG) Internally assigned payroll seq#
  • per-payroll-amount: (DECM) Amount to accrue toward savings each payroll
  • primary-key: (INTG) Unique, Primary key for record
  • qtd-dc-released: (DECM) (no description available)
  • qtd-dc-saved: (DECM) (no description available)
  • qtd-fica-released: (DECM) FICA Amount Released
  • qtd-fica-saved: (DECM) FICA Amount Saved
  • qtd-rate-released: (DECM) QTD Released
  • qtd-rate-saved: (DECM) QTD Saved
  • qtd-retire-released: (DECM) Amount released from retirement
  • qtd-retire-saved: (DECM) Amount saved toward retirement
  • rate-seq: (INTG) Rate Seq #
  • release-accrual: (LOGC) Yes to release entire savings accrual this pay
  • savings-active: (LOGC) Yes if savings (either saved or released) are active
  • ytd-dc-released: (DECM) (no description available)
  • ytd-dc-saved: (DECM) (no description available)
  • ytd-fica-released: (DECM) FICA Amount Released
  • ytd-fica-saved: (DECM) FICA Amount Saved
  • ytd-rate-released: (DECM) YTD Released
  • ytd-rate-saved: (DECM) YTD Saved
  • ytd-retire-released: (DECM) Amount released from retirement
  • ytd-retire-saved: (DECM) Amount saved toward retirement

    Alphabetical Index Summary

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

    Alphabetical Trigger Summary

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

    Other tables who reference emp-rate-savings

  • emp-deduct-rate - Employee Deduction/Payrate linkage
  • emp-rate - Employee Payrate records
  • emp-rate-hours - Employee Payrate Hourly detail
  • emp-rate-loc - Employee Payrate Locations records

    Tables emp-rate-savings 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-retire - Employee Retirment Records
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-tdp - Employee DTL3 record
  • emp-unemp - Employee Unemployement counters
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-cycle - Payroll Cycle Definitions
  • 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
    accrued-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    accrued-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    accrued-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    accrued-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    accrued-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Accrued released

    accrued-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Accrued Savings

    accrued-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    accrued-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    cur-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    cur-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    cur-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    cur-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    cur-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Cur Released

    cur-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Cur Amount saved

    cur-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    cur-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    cycle-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Cycle code used for accruing savings

    emp-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Employee Seq#
    Attributes: Index Component

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

    fytd-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    fytd-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    fytd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    fytd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    fytd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Released

    fytd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Saved

    fytd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    fytd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    mtd-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    mtd-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    mtd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    mtd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    mtd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD Released

    mtd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD Saved

    mtd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    mtd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payroll ID
    Attributes: Index Component

    pay-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally assigned payroll seq#
    Attributes: Index Component

    per-payroll-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Amount to accrue toward savings each payroll

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

    qtd-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    qtd-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    qtd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    qtd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    qtd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Released

    qtd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Saved

    qtd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    qtd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    rate-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Rate Seq #
    Attributes: Index Component

    release-accrual Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to release entire savings accrual this pay

    savings-active Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if savings (either saved or released) are active

    ytd-dc-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    ytd-dc-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)

    ytd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Released

    ytd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FICA Amount Saved

    ytd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Released

    ytd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Saved

    ytd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    ytd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

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