Definition of table emp-fringe

No table description available , Table Dump Name emp-frin

Alphabetical Field Summary

annual-obligation: (DECM) (no description available)

comments: (CHAR) Comments about this employee benefit

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

cur-employee-obligation: (DECM) (no description available)

cur-employer-cost: (DECM) (no description available)

deduct-id: (INTG) Deduction Identifier

emp-fringe-seq: (INTG) [DEFINE KEY]

emp-seq: (INTG) Employee's Unique Sequence #

employee-acct-mask[10]: (CHAR) (no description available)

end-date: (DATE) Date this benefit ends

fringe-active: (LOGC) Is this benefit active?

fringe-code-id: (INTG) (no description available)

fringe-covered: (INTG) # of dependents covered by this benefit

fringe-period-id: (INTG) Period this code belongs to

fytd-employee-obligation: (DECM) (no description available)

fytd-employer-cost: (DECM) (no description available)

mtd-employee-obligation: (DECM) (no description available)

mtd-employer-cost: (DECM) (no description available)

payroll-year: (INTG) Payroll year associated with this record

period-obligation: (DECM) (no description available)

primary-key: (INTG) Unique, Primary key for record

proj-employer-cost: (DECM) (no description available)

qtd-employee-obligation: (DECM) (no description available)

qtd-employer-cost: (DECM) (no description available)

start-date: (DATE) Date this benefit starts

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

ytd-employee-obligation: (DECM) (no description available)

ytd-employer-cost: (DECM) (no description available)

Alphabetical Index Summary

emp-year-period: emp-seq, payroll-year, fringe-period-id, emp-fringe-seq

year-period-code: payroll-year, fringe-period-id, fringe-code-id, emp-seq, emp-fringe-seq

year-period-emp: (UNIQUE, PRIMARY) payroll-year, fringe-period-id, emp-seq, emp-fringe-seq

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-efr.p

DELETE: Overridable, Procedure is tr-d-efr.p

REPLICATION-CREATE: Procedure is rp-c-efr.p

REPLICATION-DELETE: Procedure is rp-d-efr.p

REPLICATION-WRITE: Procedure is rp-u-efr.p

WRITE: Overridable, Procedure is tr-u-efr.p

Tables emp-fringe references

emp-accr - Employee Accrual Blocks

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-mpsers - (no description available)

emp-tdp - Employee DTL3 record

fringe-period - Fringe Benefit Period

mpsers-period - (no description available)

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)

comments Data type: CHARACTER
Format: x(128)
Help: Comments about this employee benefit

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

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

cur-employer-cost Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)

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

emp-fringe-seq Data type: INTEGER
Format: ->,>>>,>>9
Description: [DEFINE KEY]
Attributes: Index Component

emp-seq Data type: INTEGER
Format: zzzzzzzz9
Description: Employee's Unique Sequence #
Attributes: Index Component

employee-acct-mask Data type: CHARACTER (Extent: 10)
Format: x(8)

end-date Data type: DATE
Format: 99/99/9999
Help: Date this benefit ends

fringe-active Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this benefit active?

fringe-code-id Data type: INTEGER
Format: 999999999999
Attributes: Index Component

fringe-covered Data type: INTEGER
Format: ->,>>>,>>9
Help: # of dependents covered by this benefit

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

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

fytd-employer-cost Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)

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

mtd-employer-cost Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)

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

proj-employer-cost Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)

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

qtd-employer-cost Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)

start-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Help: Date this benefit starts

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

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

ytd-employer-cost Data type: DECIMAL (Decimals: 2)
Format: ->>,>>9.99 (Initial Value: 0)

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