Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              PARTBEN FILE

                       COBRA Participant Benefit

The COBRA Participant Benefit file contains benefit records for COBRA
participants and retirees.

REFERENCED BY

BN00.1    BN100     BN101     BN102     BN103     BN230
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN321
BN531     BN532     BN80.1    BS32.1    HR13.2    HR13.3
HR13.4    BN02.1    BN02.2    BN02.3    BN02.4    BN02.5
BN15.1    BN17.1    BN17.2    BN17.3    BN18.1    BN18.2
BN18.3    BN18.4    BN18.5    BN18.6    BN18.7    BN19.1
BN19.2    BN19.3    BN19.4    BN331     BN233     BN180
BN70.1    BN77.1    BN90.1

UPDATED BY

BN105     BN175     BN430     BN71.1    BN72.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PTB-COMPANY          Numeric 4                                   BN105   BN71.1
Company              Contains the company number.                BN72.1

PTB-PLAN-TYPE        Alpha 2                                     BN105   BN71.1
Type                 This field contains the code that           BN72.1
                     identifies the type of benefit plan.
                     DB = Defined Benefit
                     DC = Defined Contribution
                     DI = Disability
                     DL = Dependent Life
                     DN = Dental
                     EL = Employee Life
                     HL = Health
                     RS = Reserve Account
                     SB = Savings Bond
                     SP = Stock Purchase
                     VA = Vacation

PTB-PLAN-CODE        Alpha 4                                     BN105   BN71.1
Plan                 The user-defined code used to represent     BN72.1
                     a specific benefit plan.

PTB-PARTICIPNT       Numeric 9                                   BN105   BN331
Participant Number   This is the COBRA participant's number.     BN71.1  BN72.1
                     This is not the same as the employee
                     number.  If this record is for a
                     retiree, this field is blank.

PTB-EMPLOYEE         Numeric 9                                   BN105   BN71.1
Employee             Contains the employee number.               BN72.1

                     This field only has a value in it if
                     this record is for a retiree. If the
                     record is for a COBRA participant, this
                     field is blank.

PTB-START-DATE       Numeric 8  (yyyymmdd)                       BN105   BN71.1
Start Date           This is the benefit start date.             BN72.1
                     It determines when premium/invoicing
                     begins for the participant/employee.

PTB-STOP-DATE        Numeric 8  (yyyymmdd)                       BN105   BN175
Stop Date            This field indicates when the               BN71.1  BN72.1
                     participant/retiree terminates or
                     switches coverage.  This field also is
                     used to terminate premium invoicing.

PTB-COV-OPTION       Numeric 2                                   BN105   BN71.1
Coverage Option      This field selects the plan and             BN72.1
                     coverage type desired by the
                     participant/retiree.

PTB-COVER-AMT        Signed 11.2                                 BN105   BN71.1
Flat Amount          This field specifies the coverage           BN72.1
                     amount. The system uses this field to
                     calculate the premium for the desired
                     coverage amount.  The user enters the
                     coverage amount.

PTB-DEP-COVER-AMT    Signed 11.2
Dep Cover Amt

PTB-COMP-CONT        Signed 7.2                                  BN105   BN71.1
Company Contribution This is the company contribution for        BN72.1
                     retiree premiums.

PTB-EMP-AFT-CONT     Signed 7.2                                  BN105   BN71.1
Employee After Tax   This is the Retiree or COBRA                BN72.1
Contrib              contribution amount.

PTB-EXC-PREM-AMT     Signed 7.2
Excess Premium       This is the excess premium amount for
Amount               COBRA participants (holds the surcharge
                     for administrative costs).

PTB-PAY-PER-AMT      Signed 7.2                                  BN105   BN71.1
Pay Per Amt          Contains the monthly contribution           BN72.1
                     amount for spending accounts. This field
                     is used only for COBRA participants.

PTB-ANNUAL-AMT       Signed 9.2                                  BN105   BN71.1
Annual Amt           Contains the annual contribution for        BN72.1
                     spending accounts. This field is used
                     only for COBRA participants.

PTB-SMOKER           Alpha 1                                     BN105   BN71.1
Smoker               Indicates if the participant is a           BN72.1
                     smoker.

PTB-PREM-UPD-DT      Numeric 8  (yyyymmdd)                       BN105   BN71.1
Premium Update Date  Contains the most recent start date.        BN72.1

PTB-PREM-GROUP       Alpha 10                                    BN105   BN71.1
Prem Group           Contains the employee group name of the     BN72.1
                     contribution record for retiree or COBRA
                     benefits.

PTB-COV-UPD-DT       Numeric 8  (yyyymmdd)                       BN105   BN71.1
Cov Upd Dt           Contains the start date of the coverage     BN72.1
                     record used for this benefit.

PTB-CNT-AGE-DATE     Numeric 8  (yyyymmdd)
Cnt Age Date

PTB-COV-GROUP        Alpha 10                                    BN105   BN71.1
Cov Group            Contains the employee group name of the     BN72.1
                     coverage record for retiree and COBRA
                     benefits.

PTB-CREATION-DATE    Numeric 8  (yyyymmdd)                       BN105   BN71.1
Creation Date        This is the date that this line was         BN72.1
                     added to the requisition.

PTB-UPD-DATE         Numeric 8  (yyyymmdd)                       BN105   BN71.1
Upd Date             Contains the date the retiree or COBRA      BN72.1
                     benefits were updated.

PTB-MO-COMP-CONT     Derived
Mo Comp Cont

PTB-MO-EMP-AFT       Derived
Mo Emp Aft

PTB-MO-EXC-PREM      Derived
Mo Exc Prem

PTB-MO-TOT-EMP       Derived
Mo Tot Emp

PTB-TOT-EMP-PREM     Derived
Tot Emp Prem

PTB-PLAN-TYPE-2      Derived
Plan Type 2

PTB-USER-ID          Alpha 10  (Lower Case)                      BN105   BN71.1
User ID Name         Contains the user ID of the person who      BN72.1
                     last changed this record.

PTB-TIME-STAMP       Numeric 6  (hhmmss)                         BN105   BN71.1
Time Stamp           Contains the server time (hour, minute,     BN72.1
                     and second) when the record was last
                     changed.

                         PARTBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTBSET1   COMPANY                                                BN00.1  BN100
          PLAN-TYPE                                              BN101   BN102
          PARTICIPNT                                             BN103   BN105
          EMPLOYEE                                               BN175   BN230
          START-DATE                                             BN31.1  BN31.2
          PLAN-CODE                                              BN32.1  BN32.2
                                                                 BN32.3  BN321
                                                                 BN430   BN531
                                                                 BN532   BN71.1
                                                                 BN72.1  BN80.1
                                                                 BS32.1  HR13.2
                                                                 HR13.3  HR13.4

PTBSET2   COMPANY                                                BN02.1  BN02.2
          PLAN-TYPE                                              BN02.3  BN02.4
          PLAN-CODE                                              BN02.5  BN105
          PARTICIPNT                                             BN15.1  BN17.1
          EMPLOYEE                                               BN17.2  BN17.3
          START-DATE*                                            BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  BN19.1
                                                                 BN19.2  BN19.3
                                                                 BN19.4  BN331

PTBSET3   COMPANY       KeyChange                                BN15.1  BN18.1
          PLAN-TYPE                                              BN18.2  BN18.3
          PLAN-CODE                                              BN18.4  BN18.5
          PREM-UPD-DT                                            BN18.6  BN18.7
          PREM-GROUP                                             BN19.1  BN19.2
          EMPLOYEE                                               BN19.3  BN19.4
          PARTICIPNT
          START-DATE

PTBSET4   COMPANY       KeyChange                                BN105   BN233
          PARTICIPNT                                             BN331   BN71.1
          EMPLOYEE                                               BN72.1
          PLAN-TYPE
          PLAN-CODE
          START-DATE*

PTBSET5   COMPANY       KeyChange                                BN105   BN180
          EMPLOYEE                                               BN70.1  BN71.1
          PARTICIPNT                                             BN72.1  BN77.1
          PLAN-TYPE                                              BN90.1  HR13.4
          PLAN-CODE
          START-DATE

                         PARTBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncovopt       BNCOVOPT     Not Required

                            PTB-COMPANY       -> COP-COMPANY
                            PTB-PLAN-TYPE     -> COP-PLAN-TYPE
                            PTB-PLAN-CODE     -> COP-PLAN-CODE
                            PTB-COV-OPTION    -> COP-COVERAGE-OPT

Company        BNCOMPANY    Required

                            PTB-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            PTB-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Contrib Group  PERSGROUP    Not Required

                            PTB-COMPANY       -> PRG-COMPANY
                            PTB-PREM-GROUP    -> PRG-GROUP-NAME

Coverage Group PERSGROUP    Not Required

                            PTB-COMPANY       -> PRG-COMPANY
                            PTB-COV-GROUP     -> PRG-GROUP-NAME

Employee       EMPLOYEE     Required
                            When PTB-EMPLOYEE   != Zeroes
                            And  PTB-PARTICIPNT =  Zeroes

                            PTB-COMPANY       -> EMP-COMPANY
                            PTB-EMPLOYEE      -> EMP-EMPLOYEE

Participant    PARTICIPNT   Required
                            When PTB-PARTICIPNT != Zeroes

                            PTB-COMPANY       -> PAR-COMPANY
                            PTB-PARTICIPNT    -> PAR-PARTICIPNT

Plan           PLAN         Required

                            PTB-COMPANY       -> PLN-COMPANY
                            PTB-PLAN-TYPE     -> PLN-PLAN-TYPE
                            PTB-PLAN-CODE     -> PLN-PLAN-CODE

Ret Cont Group PREMIUM      Not Required

                            PTB-COMPANY       -> PRE-COMPANY
                            PTB-PLAN-TYPE     -> PRE-PLAN-TYPE
                            PTB-PLAN-CODE     -> PRE-PLAN-CODE
                            "R"               -> PRE-COVER-TYPE
                            PTB-START-DATE    -> PRE-START-DATE
                            PTB-PREM-GROUP    -> PRE-GROUP-NAME

Ret Cov Group  BNCOVERAGE   Not Required

                            PTB-COMPANY       -> CVR-COMPANY
                            PTB-PLAN-TYPE     -> CVR-PLAN-TYPE
                            PTB-PLAN-CODE     -> CVR-PLAN-CODE
                            "R"               -> CVR-COVER-TYPE
                            PTB-START-DATE    -> CVR-START-DATE
                            PTB-COV-GROUP     -> CVR-GROUP-NAME

                         PARTBEN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hrdepben       HRDEPBEN

                            PTB-COMPANY       -> HDB-COMPANY
                            PTB-EMPLOYEE      -> HDB-EMPLOYEE
                            PTB-PLAN-TYPE     -> HDB-PLAN-TYPE
                            PTB-PLAN-CODE     -> HDB-PLAN-CODE
                            PTB-START-DATE    -> HDB-EMP-START
                                                 HDB-DEPENDENT
                                                 HDB-START-DATE