DEDFREQTBL – Frequency Table

System: Payroll (PR)
Prefix: DFT
Primary key: COMPANY, TABLE-CODE
Fields: 19
Updated by: 2 programs
Referenced by: 36 programs

DEDFREQTBL is the Frequency Table table in Lawson Payroll (prefix DFT). It is indexed by COMPANY, TABLE-CODE (DFTSET1). It is related 1:1 to BNCOMPANY and PRSYSTEM. It is updated by BN00.1 and BN04.1 and referenced by BN06.1, BN100, BN101, BN102, BN103, BN104, BN105, BN145 and 28 more. The table has 19 fields, 1 index and 2 documented relations.

About DEDFREQTBL

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.

Fields (19)

Column = COBOL field name without the DFT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`DFT-COMPANY` PK COMPANY	Numeric 4	—	BN04.1
`DFT-TABLE-CODE` PK 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` DESC	Alpha 30 (Lower Case)	Contains the deduction frequency table description.	BN04.1
`DFT-WKLY-DIVI` 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` 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` 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` 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` FRWK_DIVI	Numeric 2	—	BN04.1
`DFT-WKLY-CYCLE` WKLY_CYCLE	Alpha 1 Occurs 9 Times ×9	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` BIWK_CYCLE	Alpha 1 Occurs 9 Times ×9	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` SEMI_CYCLE	Alpha 1 Occurs 9 Times ×9	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` MNTH_CYCLE	Alpha 1 Occurs 9 Times ×9	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` FRWK_CYCLE	Alpha 1 Occurs 9 Times ×9	—	BN04.1
`DFT-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN04.1
`DFT-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN04.1
`DFT-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN04.1
`DFT-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN04.1
`DFT-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN04.1
`DFT-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN04.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`DFTSET1`	`COMPANY`, `TABLE-CODE`	Primary		BN00.1, BN04.1, BN06.1, BN100, BN101, BN102, BN103, BN104 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	BNCOMPANY	Required		`DFT-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required		`DFT-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

Programs

Updated by (2)

BN00.1 Benefits Company
BN04.1 Frequency Table

Referenced by (36)

BN06.1 Flex Plan
BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN145 Flex Dollars Calculation
BN15.1 Benefit Plan
BN204 Frequency Table Listing
BN206 Flex Plan Listing
BN215 Plan Parameter Listing
BN245 Benefit Election Form
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
LP138 Absence Plan Hours Update
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add