Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNWAIT


                              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    BN320     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
Element: Company       Contains the company number.              BN16.3  BN16.4

BWT-RULE-TYPE          Alpha 1                                   BN16.1  BN16.2
Element: 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
Element: 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
Element: 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
Element: Date          Contains the start date for the rule.     BN16.3  BN16.4

BWT-GROUP-NAME         Alpha 10                                  BN16.1  BN16.2
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Init Ent PointIndicates 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
Element: Entry Month DaIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Term Stop DateIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Re Enroll DateIf 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
Element: 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
                                                                 BN320   BN331
                                                                 BN340   BN345
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS09.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                                            BN320   BN331
                                                                 BN340   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                                             BN320   BN331
                                                                 BN340   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