Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              BNWAIT FILE

                         Benefit Waiting Period

Contains all plan eligibility rules for employees. It includes all initial
and re-enrollment rules used for benefit entry and all add, change, and
termination rules used by BN100 (Employee Change Benefit Update).

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN216     BN245     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN331     BN340     BN345     BN45.1    BN531
BN65.1    BN71.1    BN72.1    BS09.1    BS10.1    BS11.1
BS12.1    BS13.1    BS14.1    BS15.1    BS32.1    HR55.1
BN500

UPDATED BY

BN15.1    BN16.1    BN16.2    BN16.3    BN16.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BWT-COMPANY          Numeric 4                                   BN16.1  BN16.2
Company              Contains the company number.                BN16.3  BN16.4

BWT-RULE-TYPE        Alpha 1                                     BN16.1  BN16.2
Rule Type            Contains waiting period rules used at       BN16.3  BN16.4
                     benefit entry. Add, change, and
                     termination rules are used by BN100
                     (Employee Change Benefit Update).
                     " " = Waiting Periods
                     A = Add Rules
                     C = Change Rules
                     T = Termination Rules

BWT-PLAN-TYPE        Alpha 2                                     BN16.1  BN16.2
Type                 Contains the benefit plan type.             BN16.3  BN16.4
                     HL = Health
                     DN = Dental
                     DI = Disability
                     EL = Life
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase
                     FL = Flex

BWT-PLAN-CODE        Alpha 4                                     BN16.1  BN16.2
Plan                 Contains the user-defined code that         BN16.3  BN16.4
                     represents a benefit plan.

BWT-START-DATE       Numeric 8  (yyyymmdd)                       BN16.1  BN16.2
Start Date           Contains the start date for the rule.       BN16.3  BN16.4

BWT-GROUP-NAME       Alpha 10                                    BN16.1  BN16.2
Group Name           Contains the employee group for which       BN16.3  BN16.4
                     the rule applies. If the group is blank,
                     the system will use this rule for all
                     employees.

BWT-ACTION-CODE      Alpha 10                                    BN16.1  BN16.2
Action Code          This field contains the personnel           BN16.3  BN16.4
                     action code for add, change, and
                     termination rules.

BWT-ENTRY-AGE        Numeric 2                                   BN16.1  BN16.2
Entry Age            Contains the entry age if eligibility       BN16.3  BN16.4
                     rules require a minimum age for entry
                     into the plan.

BWT-FROM-DATE        Alpha 2                                     BN16.1  BN16.2
From Date            Indicates the date from which the           BN16.3  BN16.4
                     waiting period is calculated.
                     HI = Hire Date
                     AJ = Adjusted Hire Date
                     AN = Anniversary Date
                     PA = Personnel Action Eff Date
                     SN = Seniority Date
                     WP = Work Period Begin Date
                     B1 = Benefit Date 1
                     B2 = Benefit Date 2
                     B3 = Benefit Date 3
                     B4 = Benefit Date 4
                     B5 = Benefit Date 5
                     X = Custom Calculation

BWT-MNTHS-SERV       Numeric 2                                   BN16.1  BN16.2
Months               Indicates the number of months of           BN16.3  BN16.4
                     service used to determine the initial
                     eligibility date.

BWT-HOURS-SERV       Signed 7.2                                  BN16.1  BN16.2
Hours                Indicates the hours of service used to      BN16.3  BN16.4
                     determine the initial eligibility date.

BWT-QUAL-PERIOD      Numeric 3                                   BN16.1  BN16.2
Qual Period          Contains the number of days used to         BN16.3  BN16.4
                     determine the initial eligibility date.

BWT-PAY-CLASS        Alpha 3                                     BN16.1  BN16.2
Payment Class        If hours are used to determine              BN16.3  BN16.4
                     eligibility, this field contains the pay
                     class used to determine which hours are
                     used to determine eligibility.

BWT-INIT-ENT-POINT   Alpha 1                                     BN16.1  BN16.2
Init Ent Point       Indicates the initial entry point at        BN16.3  BN16.4
                     which employees begin to receive
                     benefits.
                     0 = No Entry Points
                     1 = Prior Entry Point
                     2 = Next Entry Point
                     3 = Prior Pay Period
                     4 = Next Pay Period
                     5 = Prior Work Period
                     6 = Next Work Period

BWT-ENTRY-MMDD       Numeric 4 Occurs 12 Times                   BN16.1  BN16.2
Entry Month Day      If entry points are used, this field        BN16.3  BN16.4
                     contains the specific month and day
                     initial eligibility date.

BWT-SUB-FROM         Alpha 2                                     BN16.1  BN16.2
Sub From             If re-enrollment rules are used, this       BN16.3  BN16.4
                     field contains the beginning date used
                     calculate re-enrollment eligibility.
                     HI = Hire Date
                     AJ = Adjusted Hire Date
                     AN = Anniversary Date
                     SN = Seniority Date
                     B1 = Benefit Date 1
                     B2 = Benefit Date 2
                     B3 = Benefit Date 3
                     B4 = Benefit Date 4
                     B5 = Benefit Date 5
                     X = Custom Calculation

BWT-SUB-MOS          Numeric 2                                   BN16.1  BN16.2
Sub Mos              If re-enrollment rules are used, this       BN16.3  BN16.4
                     field contains the number of months from
                     the beginning date used to calculate
                     re-enrollment eligibility.

BWT-SUB-DAYS         Numeric 3                                   BN16.1  BN16.2
Sub Days             If re-enrollment rules are used, this       BN16.3  BN16.4
                     field contains
                     the number of days from the beginning
                     date used to calculate re-enrollment
                     eligibility.

BWT-SUB-CLASS        Alpha 3                                     BN16.1  BN16.2
Sub Class            If re-enrollment rules are used, this       BN16.3  BN16.4
                     field contains the pay class used to
                     determine which hours are used for
                     re-enrollment.

BWT-SUB-HOURS        Signed 7.2                                  BN16.1  BN16.2
Sub Hours            If re-enrollment rules are used, this       BN16.3  BN16.4
                     field contains the number of hours from
                     the subsequent enrollment date used to
                     calculate re-enrollment eligibility.

BWT-SUB-ENT-POINT    Alpha 1                                     BN16.1  BN16.2
Sub Ent Point        If re-enrollment rules are used, this       BN16.3  BN16.4
                     field determines if the re-enrollment
                     point has specific entry points.
                     0 = No Entry Points
                     1 = Prior Entry Point
                     2 = Next Entry Point
                     3 = Prior Pay Period
                     4 = Next Pay Period
                     5 = Prior Work Period
                     6 = Next Work Period

BWT-SUB-POINTS       Numeric 4 Occurs 12 Times                   BN16.1  BN16.2
Sub Points           If re-enrollment rules are used with        BN16.3  BN16.4
                     entry points, this field contains the
                     months and days used as entry points.

BWT-TERM-STOP-DATE   Alpha 2                                     BN16.1  BN16.2
Term Stop Date       If termination rules are used, this         BN16.3  BN16.4
                     field contains the beginning date used
                     to calculate the benefit termination
                     date.
                     TM = Termination Date
                     PA = Personnel Action Date
                     WP = Work Period End Date
                     PP = Pay Period End Date
                     ME = End of Month
                     UE = Custom Calculation

BWT-TERM-MOS         Numeric 2                                   BN16.1  BN16.2
Term Mos             If termination rules are used, this         BN16.3  BN16.4
                     field contains the number of months used
                     to calculate the benefit termination
                     date.

BWT-TERM-DAYS        Numeric 3                                   BN16.1  BN16.2
Term Days            If termination rules are used, this         BN16.3  BN16.4
                     field contains the number of days from
                     the termination stop date that benefits
                     will terminate.

BWT-CHG-WAIT         Alpha 1                                     BN16.1  BN16.2
Chg Wait             This field is not used.                     BN16.3  BN16.4
                     0 = Not Updated
                     1 = Updated

BWT-COBRA-OCC        Alpha 1                                     BN16.1  BN16.2
Cobra Occ            If termination rules are used, this         BN16.3  BN16.4
                     field defines whether this benefit
                     termination is a COBRA occurrence.
                     Y = Yes
                     N = No

BWT-COBRA-TYPE       Alpha 2                                     BN16.1  BN16.2
Cobra Type           If this benefit termination is a COBRA      BN16.3  BN16.4
                     occurrence, this field defines the of
                     occurrence.

BWT-RE-ENROLL-DATE   Alpha 2
Re Enroll Date       If the rule type is " " for the waiting
                     period, this field contains the
                     beginning date used to calculate the
                     re-enrollment date.
                     HI = Hire Date
                     AJ = Adjusted Hire Date
                     AN = Anniversary Date
                     PA = Personnel Action Eff Date
                     SN = Seniority Date
                     WP = Work Period Begin Date
                     B1 = Benefit Date 1
                     B2 = Benefit Date 2
                     B3 = Benefit Date 3
                     B4 = Benefit Date 4
                     B5 = Benefit Date 5
                     X = Custom Calculation

BWT-CHANGE-EFFECT    Alpha 2                                     BN16.1  BN16.2
Change Effect        If change rules are used, this field        BN16.3  BN16.4
                     contains the date the change is
                     effective.
                     PA = Personnel Action Eff Date
                     NM = First of Next Month
                     PM = First of Prior Month
                     DC = Date of Change
                     PP = Prior Pay Period
                     NP = Next Pay Period
                     PW = Prior Work Period
                     NW = Next Work Period

                         BNWAIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BWTSET1   COMPANY                                                BN100   BN101
          RULE-TYPE                                              BN102   BN103
          PLAN-TYPE                                              BN105   BN145
          PLAN-CODE                                              BN15.1  BN16.1
          START-DATE                                             BN16.2  BN16.3
          GROUP-NAME                                             BN16.4  BN16.5
          ACTION-CODE                                            BN16.6  BN216
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN331   BN340
                                                                 BN345   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 ...

BWTSET2   COMPANY                                                BN100   BN101
          RULE-TYPE                                              BN102   BN103
          PLAN-TYPE                                              BN105   BN145
          PLAN-CODE                                              BN245   BN31.1
          START-DATE*                                            BN31.2  BN32.1
          GROUP-NAME                                             BN32.2  BN32.3
          ACTION-CODE                                            BN331   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1

BWTSET3   COMPANY                                                BN100   BN101
          RULE-TYPE                                              BN102   BN103
          PLAN-TYPE                                              BN105   BN145
          PLAN-CODE                                              BN245   BN31.1
          ACTION-CODE                                            BN31.2  BN32.1
          START-DATE*                                            BN32.2  BN32.3
          GROUP-NAME                                             BN331   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1

BWTSET4   COMPANY                                                BN15.1  BN216
          PLAN-TYPE                                              BN500
          PLAN-CODE
          RULE-TYPE
          START-DATE
          GROUP-NAME
          ACTION-CODE

                         BNWAIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Add Rules      PLAN         Required
                            When BWT-RULE-TYPE = "A"

                            BWT-COMPANY       -> PLN-COMPANY
                            BWT-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BWT-PLAN-CODE     -> PLN-PLAN-CODE

Change Rules   PLAN         Required
                            When BWT-RULE-TYPE = "C"

                            BWT-COMPANY       -> PLN-COMPANY
                            BWT-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BWT-PLAN-CODE     -> PLN-PLAN-CODE

Cobra Occur    OCCURTYPE    Required

                            BWT-COMPANY       -> OCC-COMPANY
                            BWT-COBRA-TYPE    -> OCC-OCCUR-TYPE

Payclass       PAYCLASS     Required

                            BWT-COMPANY       -> PCL-COMPANY
                            BWT-PAY-CLASS     -> PCL-PAY-CLASS

Persgroup      PERSGROUP    Not Required

                            BWT-COMPANY       -> PRG-COMPANY
                            BWT-GROUP-NAME    -> PRG-GROUP-NAME

Plan           PLAN         Required

                            BWT-COMPANY       -> PLN-COMPANY
                            BWT-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BWT-PLAN-CODE     -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            BWT-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Term Rules     PLAN         Required
                            When BWT-RULE-TYPE = "T"

                            BWT-COMPANY       -> PLN-COMPANY
                            BWT-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BWT-PLAN-CODE     -> PLN-PLAN-CODE

Wait Rules     PLAN         Required
                            When BWT-RULE-TYPE = Spaces

                            BWT-COMPANY       -> PLN-COMPANY
                            BWT-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BWT-PLAN-CODE     -> PLN-PLAN-CODE