BNCOMMENTS – Benefit Comments

System
Benefits (BN)
Prefix
BCM
Primary key
COMPANY, CMT-TYPE, EMPLOYEE, PARTICIPNT, PLAN-TYPE, PLAN-CODE, GROUP-NAME, START-DATE, SEQ-NBR
Fields
11
Updated by
24 programs
Referenced by
7 programs

BNCOMMENTS is the Benefit Comments table in Lawson Benefits (prefix BCM). It is indexed by COMPANY, CMT-TYPE, EMPLOYEE, PARTICIPNT, PLAN-TYPE, PLAN-CODE, GROUP-NAME, START-DATE, SEQ-NBR (BCMSET1). It is related 1:1 to BNCOMPANY, PRSYSTEM, EMPLOYEE, PARTICIPNT and PLAN. It is updated by BN00.1, BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1 and 16 more and referenced by BN08.1, BN215, BN231, BN232, BN233, BN258 and HR55.1. The table has 11 fields, 1 index and 5 documented relations.

About BNCOMMENTS

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

Fields (11)

Column = COBOL field name without the BCM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BCM-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN90.1
BCM-CMT-TYPE PK
CMT_TYPE		Alpha 2Contains the kind of comment.
  • EM Employee
  • FL Flex Benefits
  • PL Plan
  • PT Participant
BN90.1
BCM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains comments about the employee. This is valid in the Employee file.BN90.1
BCM-PARTICIPNT PK
PARTICIPNT		Numeric 9Contains comments about COBRA participants. This is valid in the COBRA Participant Master file.BN90.1
BCM-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains 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
BN90.1
BCM-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the plan code for PL types. For all other types, this field is blank.BN90.1
BCM-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains the employee group for which the comments apply.BN90.1
BCM-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the flex dollar start date for the flex year of the comments.BN90.1
BCM-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains a system-generated number used to track the order in which comment records are related.BN90.1
BCM-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)Contains comment text.BN90.1
BCM-DATE
DATE		Numeric 8 (yyyymmdd)Contains the system date when comments were typed.BN90.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCMSET1COMPANY, CMT-TYPE, EMPLOYEE, PARTICIPNT, PLAN-TYPE, PLAN-CODE, GROUP-NAME, START-DATE, SEQ-NBRPrimaryBN00.1, BN08.1, BN100, BN101, BN102, BN103, BN105, BN15.1 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequiredBCM-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredBCM-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen BCM-EMPLOYEE != ZeroesBCM-COMPANY → EMP-COMPANY, BCM-EMPLOYEE → EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen BCM-PARTICIPNT != ZeroesBCM-COMPANY → PAR-COMPANY, BCM-PARTICIPNT → PAR-PARTICIPNT
PlanPLANRequiredWhen 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

Programs

Updated by (24)

Referenced by (7)