Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DEDFREQTBL


                            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

UPDATED BY

BN00.1    BN04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DFT-COMPANY            Numeric 4                                 BN04.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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
Weekly Premium         Contains the weekly premium divisor.
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
Bi-Weekly Premium      Contains the biweekly premium divisor.
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
Semi-monthly           Contains the semimonthly premium
Premium Divisor        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
Monthly Premium        Contains the monthly premium divisor.
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
Weekly Deduction       Contains the value that indicates the
Cycles                 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
Bi-Weekly Deduction    Contains the value that Indicates the
Cycle                  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-monthly CContains 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
Monthly Deduction      Contains the value that indicates the
Cycles                 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

                         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