|
|
DEDFREQTBL FILE
Frequency Table
Contains annual premium divisors and payroll deduction cycles that are
assigned to employee deductions created by the Benefits system based on an
employee's pay frequency.
REFERENCED BY
BN06.1 BN100 BN101 BN102 BN103 BN104
BN105 BN145 BN15.1 BN204 BN206 BN215
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS13.1
BS14.1 BS15.1 BS32.1 LP138
UPDATED BY
BN00.1 BN04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DFT-COMPANY Numeric 4 BN04.1
Element: Company Hr
DFT-TABLE-CODE Alpha 4 BN04.1
Element: Table Code Contains the code assigned to the
deduction frequency table that
identifies it when you define benefit
plans.
DFT-DESC Alpha 30 (Lower Case) BN04.1
Element: Description Contains the deduction frequency table
description.
DFT-WKLY-DIVI Numeric 2 BN04.1
Element: Wkly Divi Contains the weekly premium divisor.
The weekly premium divisor default value
is 52. All pay frequencies require a
premium divisor. The system divides the
annual premium or contribution amount
indicated on each employee benefit by
the premium divisor indicated by the pay
frequency, to determine the "next
amount" of the employee's deduction.
DFT-BIWK-DIVI Numeric 2 BN04.1
Element: Biwk Divi Contains the biweekly premium divisor.
The biweekly premium divisor default
value is 26. All pay frequencies require
a premium divisor. The system divides
the annual premium or contribution
amount indicated on each employee
benefit by the premium divisor indicated
by the pay frequency, to determine the
"next amount" of the employee's
deduction.
DFT-SEMI-DIVI Numeric 2 BN04.1
Element: Semi Divi Contains the semimonthly premium
divisor. The semimonthly premium divisor
default value is 24. All pay frequencies
require a premium divisor. The system
divides the annual premium or
contribution amount indicated on each
employee benefit by the premium divisor
indicated by the pay frequency, to
determine the "next amount" of the
employee's deduction.
DFT-MNTH-DIVI Numeric 2 BN04.1
Element: Mnth Divi Contains the monthly premium divisor.
The monthly premium divisor default
value is 12. All pay frequencies require
a premium divisor. The system divides
the annual premium or contribution
amount indicated on each employee
benefit by the premium divisor indicated
by the pay frequency, to determine the
"next amount" of the employee's
deduction.
DFT-FRWK-DIVI Numeric 2 BN04.1
Element: Frwk Divi
DFT-WKLY-CYCLE Alpha 1 Occurs 9 Times BN04.1
Element: Wkly Cycle Contains the value that indicates the
cycle in which the system takes the
deduction for a weekly frequency table.
The system uses the Deduction Cycle
fields when creating the Employee
Deduction file record.
X
DFT-BIWK-CYCLE Alpha 1 Occurs 9 Times BN04.1
Element: Biwk Cycle Contains the value that Indicates the
cycle in which the system takes the
deduction for a biweekly frequency
table. The system uses the Deduction
Cycle fields when creating the Employee
Deduction file record.
X
DFT-SEMI-CYCLE Alpha 1 Occurs 9 Times BN04.1
Element: Semi Cycle Contains the value that indicates the
cycle in which the system takes the
deduction for a semimonthly frequency
table. The system uses the Deduction
Cycle fields when creating the Employee
Deduction file record.
X
DFT-MNTH-CYCLE Alpha 1 Occurs 9 Times BN04.1
Element: Mnth Cycle Contains the value that indicates the
cycle in which the system takes the
deduction for a monthly frequency table.
The system uses the Deduction Cycle
fields when creating the Employee
Deduction file record.
X
DFT-FRWK-CYCLE Alpha 1 Occurs 9 Times BN04.1
Element: Frwk Cycle
DEDFREQTBL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DFTSET1 COMPANY BN00.1 BN04.1
TABLE-CODE BN06.1 BN100
BN101 BN102
BN103 BN104
BN105 BN145
BN15.1 BN204
BN206 BN215
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 LP138
DEDFREQTBL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
DFT-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
DFT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
