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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCMSET1
  1. COMPANY
  2. CMT-TYPE
  3. EMPLOYEE
  4. PARTICIPNT
  5. PLAN-TYPE
  6. PLAN-CODE
  7. GROUP-NAME
  8. START-DATE
  9. SEQ-NBR
PrimaryBN00.1, BN08.1, BN100, BN101, BN102, BN103, BN105, BN15.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNCOMPANYPRSYSTEMEMPLOYEEPARTICIPNTPLANBNCOMMENTS

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
BCM-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BCM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen BCM-EMPLOYEE != Zeroes
BCM-COMPANY→EMP-COMPANY
BCM-EMPLOYEE→EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen BCM-PARTICIPNT != Zeroes
BCM-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)