DEDFREQTBL

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 BS10.1
BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 ZB10.1
ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3 LP138


UPDATED BY
BN00.1 BN04.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DFT-COMPANY
Element: Company Hr
Numeric 4
BN04.1
DFT-TABLE-CODE
Element: Table Code
Alpha 4
Contains the code assigned to the deduction frequency table that identifies it when you define benefit plans.
BN04.1
DFT-DESC
Element: Description
Alpha 30 (Lower Case)
Contains the deduction frequency table description.
BN04.1
DFT-WKLY-DIVI
Element: Wkly Divi
Numeric 2
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.
BN04.1
DFT-BIWK-DIVI
Element: Biwk Divi
Numeric 2
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.
BN04.1
DFT-SEMI-DIVI
Element: Semi Divi
Numeric 2
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.
BN04.1
DFT-MNTH-DIVI
Element: Mnth Divi
Numeric 2
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.
BN04.1
DFT-FRWK-DIVI
Element: Frwk Divi
Numeric 2
BN04.1
DFT-WKLY-CYCLE
Element: Wkly Cycle
Alpha 1 Occurs 9 Times
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
BN04.1
DFT-BIWK-CYCLE
Element: Biwk Cycle
Alpha 1 Occurs 9 Times
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
BN04.1
DFT-SEMI-CYCLE
Element: Semi Cycle
Alpha 1 Occurs 9 Times
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
BN04.1
DFT-MNTH-CYCLE
Element: Mnth Cycle
Alpha 1 Occurs 9 Times
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
BN04.1
DFT-FRWK-CYCLE
Element: Frwk Cycle
Alpha 1 Occurs 9 Times
BN04.1
DFT-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN04.1
DFT-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN04.1
DFT-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN04.1
DFT-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN04.1
DFT-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN04.1
DFT-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN04.1


DEDFREQTBL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DFTSET1 COMPANY
TABLE-CODE
...
BN00.1 BN04.1
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 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1


DEDFREQTBL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
DFT-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
DFT-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


File created: Thu Jun 09 02:30:19 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.