Definition of table fringe-class
Fringe benefit classes , Table Dump Name fringe-c

Alphabetical Field Summary

  • cost-acct-num[12]: (CHAR) Cost Account for this benefit class, by fund
  • 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
  • description: (CHAR) Description of this benefit class
  • distrib-method: (CHAR) (no description available)
  • employee-acct-mask[10]: (CHAR) Account mask to use with employee's portion of benefit cost
  • employer-acct-mask[10]: (CHAR) Account translation mask for employer acct
  • ent-id: (CHAR) Vendor # used for this fringe benefit class
  • fringe-class-code: (CHAR) Code for this benefit class
  • fringe-class-id: (INTG) [DEFINE KEY]
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • push-to-fas: (LOGC) Yes to push this class to FAS, no for HRS/W2s only
  • 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

    Alphabetical Index Summary

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

    Alphabetical Trigger Summary

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

    Other tables who reference fringe-class

  • fringe-code - (no description available)

    Tables fringe-class references

  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    cost-acct-num Data type: CHARACTER (Extent: 12)
    Format: x(30)
    Help: Cost Account for this benefit class, by fund

    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

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

    distrib-method Data type: CHARACTER
    Format: x(16)

    employee-acct-mask Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Account mask to use with employee's portion of benefit cost

    employer-acct-mask Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Description: Account translation mask for employer acct

    ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor # used for this fringe benefit class

    fringe-class-code Data type: CHARACTER
    Format: x(8)
    Help: Code for this benefit class
    Attributes: Index Component

    fringe-class-id Data type: INTEGER
    Format: 999999999999
    Description: [DEFINE KEY]
    Attributes: Index Component

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

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

    push-to-fas Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to push this class to FAS, no for HRS/W2s only

    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

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