Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            BNCOMMENTS FILE

                            Benefit Comments

The Benefits Comments file contains comments about benefit plans, flex plans,
employee benefits, COBRA participant benefits, and retiree benefits.

REFERENCED BY

BN08.1    BN215     BN231     BN232     BN233     BN258
HR55.1

UPDATED BY

BN00.1    BN100     BN101     BN102     BN103     BN105
BN15.1    BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN430     BN531     BN71.1    BN72.1    BN90.1    BS32.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BCM-COMPANY          Numeric 4                                   BN90.1
Company              Contains the company number. The number
                     correlates all information about the
                     company.

BCM-CMT-TYPE         Alpha 2                                     BN90.1
Comment Type         Contains the kind of comment.
                     EM = Employee
                     FL = Flex Benefits
                     PL = Plan
                     PT = Participant

BCM-EMPLOYEE         Numeric 9                                   BN90.1
Employee             Contains comments about the employee.
                     This is valid in the Employee file.

BCM-PARTICIPNT       Numeric 9                                   BN90.1
Participant Number   Contains comments about COBRA
                     participants. This is valid in the COBRA
                     Participant Master file.

BCM-PLAN-TYPE        Alpha 2                                     BN90.1
Type                 Contains the benefit type.
                     DB = Defined Benefit
                     DC = Defined Contribution
                     DI = Disability
                     DL = Dependent Life
                     DN = Dental
                     EL = Employee Life
                     HL = Health
                     RS = Spending Account
                     SB = Savings Bond
                     VA = Vacation

BCM-PLAN-CODE        Alpha 4                                     BN90.1
Plan                 Contains the plan code for PL types.
                     For all other types, this field is
                     blank.

BCM-GROUP-NAME       Alpha 10                                    BN90.1
Group Name           Contains the employee group for which
                     the comments apply.

BCM-START-DATE       Numeric 8  (yyyymmdd)                       BN90.1
Start Date           Contains the flex dollar start date for
                     the flex year of the comments.

BCM-SEQ-NBR          Numeric 4                                   BN90.1
Sequence Number      Contains a system-generated number used
                     to track the order in which comment
                     records are related.

BCM-CMT-TEXT         Alpha 60  (Lower Case)                      BN90.1
Comment Text         Contains comment text.

BCM-DATE             Numeric 8  (yyyymmdd)                       BN90.1
Date                 Contains the system date when comments
                     were typed.

                         BNCOMMENTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCMSET1   COMPANY                                                BN00.1  BN08.1
          CMT-TYPE                                               BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PARTICIPNT                                             BN105   BN15.1
          PLAN-TYPE                                              BN215   BN231
          PLAN-CODE                                              BN232   BN233
          GROUP-NAME                                             BN258   BN31.1
          START-DATE                                             BN31.2  BN32.1
          SEQ-NBR                                                BN32.2  BN32.3
                                                                 BN430   BN531
                                                                 BN71.1  BN72.1
                                                                 BN90.1  BS32.1
                                                                 HR55.1

                         BNCOMMENTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BCM-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BCM-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When BCM-EMPLOYEE != Zeroes

                            BCM-COMPANY       -> EMP-COMPANY
                            BCM-EMPLOYEE      -> EMP-EMPLOYEE

Participant    PARTICIPNT   Required
                            When BCM-PARTICIPNT != Zeroes

                            BCM-COMPANY       -> PAR-COMPANY
                            BCM-PARTICIPNT    -> PAR-PARTICIPNT

Plan           PLAN         Required
                            When BCM-PLAN-CODE != Spaces
                            And  BCM-CMT-TYPE  != "FL"

                            BCM-COMPANY       -> PLN-COMPANY
                            BCM-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BCM-PLAN-CODE     -> PLN-PLAN-CODE