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
BN230     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN320     BN321     BN53.1    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
Element: Company Hr    Contains the company number.              BN72.1

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

PTB-PARTICIPNT         Numeric 9                                 BN105   BN331
Element: Participant NuThis 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: Coverage OptioThis field selects the plan and           BN72.1
                       coverage type desired by the
                       participant/retiree.

PTB-COVER-AMT          Signed 11.2                               BN105   BN71.1
Element: 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
Element: Dep Cover Amt

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

PTB-EMP-AFT-CONT       Signed 11.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
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: Premium UpdateContains 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          Contains the user ID of the person who    BN72.1
                       last changed this record.

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                                             BN230   BN31.1
          PLAN-CODE                                              BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN320   BN321
                                                                 BN430   BN53.1
                                                                 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                                             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
                                                                 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                                             BN320
          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