Definition of table fringe-code
No table description available , Table Dump Name frin-cd

Alphabetical Field Summary

  • annual-obligation: (DECM) (no description available)
  • cap-amount: (DECM) (no description available)
  • copy-forward: (LOGC) (no description available)
  • cost-basis: (DECM) (no description available)
  • cre-date: (DATE) Date this record was created
  • cre-time: (CHAR) Creation time of this record
  • cre-user-name: (CHAR) Name of user who created this record
  • deduct-id: (INTG) Deduction Identifier
  • description: (CHAR) Description of this benefit code
  • employer-cost: (DECM) Employers Benefit Cost
  • fringe-class-id: (INTG) Fringe class this code belongs to
  • fringe-code: (CHAR) Benefit code
  • fringe-code-id: (INTG) [DEFINE KEY]
  • fringe-period-id: (INTG) Period this code belongs to
  • payroll-year: (INTG) Payroll year associated with this record
  • period-obligation: (DECM) (no description available)
  • primary-key: (INTG) Unique, Primary key for record
  • report-on-w2: (LOGC) Include this benefit on employee's W2
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time of last update to this record
  • upd-user-name: (CHAR) Name of user who last updated this record
  • use-covered: (LOGC) Should the # of dependents covered matter for this benefit?
  • use-deduct: (LOGC) (no description available)
  • w2-box-code: (CHAR) Box code for this benefit, if using box 12
  • w2-box-num: (CHAR) Box # to report this on the W2

    Alphabetical Index Summary

  • description: payroll-year, fringe-period-id, description
  • year-period-code: payroll-year, fringe-period-id, fringe-code
  • year-period-id: (UNIQUE, PRIMARY) payroll-year, fringe-period-id, fringe-code

    Alphabetical Trigger Summary

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

    Tables fringe-code references

  • fringe-class - Fringe benefit classes
  • fringe-period - Fringe Benefit Period
  • pay-deduct - Payroll Master Deductions definition
  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    annual-obligation Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99 (Initial Value: 0)

    cap-amount Data type: DECIMAL (Decimals: 2)
    Format: >>>,>>9.99 (Initial Value: 0)

    copy-forward Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)

    cost-basis Data type: DECIMAL (Decimals: 5)
    Format: zzz,zz9.99999 (Initial Value: 0)

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Creation time of this record

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who created this record
    Attributes: Mandatory

    deduct-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Deduction Identifier

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this benefit code
    Attributes: Index Component

    employer-cost Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99 (Initial Value: 0)
    Help: Employers Benefit Cost

    fringe-class-id Data type: INTEGER
    Format: 999999999999
    Help: Fringe class this code belongs to

    fringe-code Data type: CHARACTER
    Format: x(8)
    Help: Benefit code
    Attributes: Index Component

    fringe-code-id Data type: INTEGER
    Format: 999999999999
    Description: [DEFINE KEY]

    fringe-period-id Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Period this code belongs to
    Attributes: Index Component

    payroll-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Payroll year associated with this record
    Attributes: Index Component

    period-obligation Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>9.99 (Initial Value: 0)

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

    report-on-w2 Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Include this benefit on employee's W2

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time of last update to this record

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who last updated this record

    use-covered Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Should the # of dependents covered matter for this benefit?

    use-deduct Data type: LOGICAL
    Format: Yes/No (Initial Value: No)

    w2-box-code Data type: CHARACTER
    Format: x(2)
    Help: Box code for this benefit, if using box 12

    w2-box-num Data type: CHARACTER
    Format: x(4)
    Help: Box # to report this on the W2

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