Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCOMMENTS


                            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
Element: Company       Contains the company number. The number
                       correlates all information about the
                       company.

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

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

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

BCM-PLAN-TYPE          Alpha 2                                   BN90.1
Element: 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
Element: Plan          Contains the plan code for PL types.
                       For all other types, this field is
                       blank.

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

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

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

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

BCM-DATE               Numeric 8  (yyyymmdd)                     BN90.1
Element: 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