Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PARTBEN


                              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     BN106
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN320
BN321     BN53.1    BN531     BN532     BN80.1    BS32.1
HR13.1    HR13.2    HR13.3    HR13.4    HR513     PA218
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    BN230     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
Element: Company Hr    Contains the company number.              BN72.1

PTB-PLAN-TYPE          Alpha 2                                   BN105   BN71.1
Element: Plan 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
Element: Plan Code     The user-defined code used to represent   BN72.1
                       a specific benefit plan.

PTB-PARTICIPNT         Numeric 9                                 BN105   BN331
Element: Participnt    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
Element: 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
Element: 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
Element: 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
Element: Cov 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
Element: Cover Amt     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
Element: Dep Cover Amt

PTB-COMP-CONT          Signed 11.2                               BN105   BN71.1
Element: Comp Cont     This is the company contribution for      BN72.1
                       retiree premiums.

PTB-EMP-AFT-CONT       Signed 11.2                               BN105   BN71.1
Element: Emp Aft Cont  This is the Retiree or COBRA              BN72.1
                       contribution amount.

PTB-EXC-PREM-AMT       Signed 7.2
Element: Exc Prem Amt  This is the excess premium amount for
                       COBRA participants (holds the surcharge
                       for administrative costs).

PTB-PAY-PER-AMT        Signed 7.2                                BN105   BN71.1
Element: 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
Element: 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
Element: Smoker        Indicates if the participant is a         BN72.1
                       smoker.

PTB-PREM-UPD-DT        Numeric 8  (yyyymmdd)                     BN105   BN71.1
Element: Prem Upd Dt   Contains the most recent start date.      BN72.1

PTB-PREM-GROUP         Alpha 10                                  BN105   BN71.1
Element: 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
Element: Cov Upd Dt    Contains the start date of the coverage   BN72.1
                       record used for this benefit.

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

PTB-COV-GROUP          Alpha 10                                  BN105   BN71.1
Element: 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
Element: 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
Element: Upd Date      Contains the date the retiree or COBRA    BN72.1
                       benefits were updated.

PTB-MO-COMP-CONT       Derived
Element: Mo Comp Cont

PTB-MO-EMP-AFT         Derived
Element: Mo Emp Aft

PTB-MO-EXC-PREM        Derived
Element: Mo Exc Prem

PTB-MO-TOT-EMP         Derived
Element: Mo Tot Emp

PTB-TOT-EMP-PREM       Derived
Element: Tot Emp Prem

PTB-PLAN-TYPE-2        Derived
Element: Plan Type 2

PTB-USER-ID            Alpha 10  (Lower Case)                    BN105   BN71.1
Element: User                                                    BN72.1

PTB-TIME-STAMP         Numeric 6  (hhmmss)                       BN105   BN71.1
Element: 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                                               BN106   BN175
          START-DATE                                             BN31.1  BN31.2
          PLAN-CODE                                              BN32.1  BN32.2
                                                                 BN32.3  BN320
                                                                 BN321   BN430
                                                                 BN53.1  BN531
                                                                 BN532   BN71.1
                                                                 BN72.1  BN80.1
                                                                 BS32.1  HR13.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

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

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                                             BN320
          START-DATE

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

PTBSET5   COMPANY       KeyChange                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PARTICIPNT                                             BN105   BN180
          PLAN-TYPE                                              BN31.1  BN31.2
          PLAN-CODE                                              BN32.1  BN32.2
          START-DATE                                             BN32.3  BN531
                                                                 BN532   BN70.1
                                                                 BN71.1  BN72.1
                                                                 BN77.1  BN90.1
                                                                 BS32.1  HR13.1
                                                                 HR13.2  HR13.3
                                                                 HR13.4  HR513
                                                                 PA218

                         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