Definition of table fringe-period
Fringe Benefit Period , Table Dump Name fringe-p

Alphabetical Field Summary

  • benefits-calced: (LOGC) Have benefits ever been calculated for this period?
  • benefits-pushed: (LOGC) Hvae benefits ever been pushed for this period?
  • 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 period
  • end-date: (DATE) End date for this benefit period
  • end-pay-id: (INTG) Ending pay identifier
  • fas-gl-journal-code: (CHAR) FAS GL Journal code to use
  • fas-gl-tran-num: (INTG) GL Tran # for this benefit period
  • fringe-period-id: (INTG) [DEFINE KEY]
  • last-calced-by: (CHAR) User who last calculated this benefit period
  • last-calced-on: (DATE) Date this period was last recalculated
  • last-pushed-by: (CHAR) User who last pushed this benefit period to FAS
  • last-pushed-on: (DATE) Date this period was last pushed to FAS
  • last-release-period: (LOGC) Is this the final release period for this cycle?
  • needs-recalc: (LOGC) Does this benefit period need to be recalculated
  • needs-repush: (LOGC) Does this benefit period need to be re-pushed to FAS?
  • note-code: (CHAR) Note that indicates an employee should participate in saving
  • num-release-periods: (INTG) Number of release periods following this savings period
  • payroll-year: (INTG) Payroll year associated with this record
  • period-locked: (LOGC) Has this period been locked for changes
  • primary-key: (INTG) Unique, Primary key for record
  • release-period: (LOGC) Is this a savings release period?
  • savings-acct-num[12]: (CHAR) Account to hold summer savings employer amounts, by fund
  • savings-period: (LOGC) Is this the savings period for this payroll year?
  • start-date: (DATE) Date this benefit period begins
  • start-pay-id: (INTG) Starting payroll identifier
  • 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
  • w2-year: (INTG) Calendar year for W2s for this fringe period

    Alphabetical Index Summary

  • description: payroll-year, description, fringe-period-id
  • year-date: payroll-year, start-date, fringe-period-id
  • year-pay: (PRIMARY) payroll-year, start-pay-id, fringe-period-id

    Alphabetical Trigger Summary

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

    Tables fringe-period references

  • emp-accr - Employee Accrual Blocks
  • mpsers-period - (no description available)
  • note-code - Definition of each of the possible note codes
  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    benefits-calced Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Have benefits ever been calculated for this period?

    benefits-pushed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Hvae benefits ever been pushed for this period?

    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 period
    Attributes: Index Component

    end-date Data type: DATE
    Format: 99/99/9999
    Help: End date for this benefit period

    end-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Ending pay identifier

    fas-gl-journal-code Data type: CHARACTER
    Format: x(8)
    Help: FAS GL Journal code to use

    fas-gl-tran-num Data type: INTEGER
    Format: 999999
    Help: GL Tran # for this benefit period

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

    last-calced-by Data type: CHARACTER
    Format: x(8)
    Help: User who last calculated this benefit period

    last-calced-on Data type: DATE
    Format: 99/99/9999
    Help: Date this period was last recalculated

    last-pushed-by Data type: CHARACTER
    Format: x(8)
    Help: User who last pushed this benefit period to FAS

    last-pushed-on Data type: DATE
    Format: 99/99/9999
    Help: Date this period was last pushed to FAS

    last-release-period Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this the final release period for this cycle?

    needs-recalc Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Does this benefit period need to be recalculated

    needs-repush Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Does this benefit period need to be re-pushed to FAS?

    note-code Data type: CHARACTER
    Format: x(8)
    Help: Note that indicates an employee should participate in saving

    num-release-periods Data type: INTEGER
    Format: zz9
    Help: Number of release periods following this savings period

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

    period-locked Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Has this period been locked for changes

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

    release-period Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this a savings release period?

    savings-acct-num Data type: CHARACTER (Extent: 12)
    Format: x(30)
    Help: Account to hold summer savings employer amounts, by fund

    savings-period Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this the savings period for this payroll year?

    start-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date this benefit period begins
    Attributes: Index Component

    start-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Starting payroll identifier
    Attributes: Index Component

    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

    w2-year Data type: INTEGER
    Format: 99999
    Help: Calendar year for W2s for this fringe period

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