BNESSPLNR – Employee Self-Service Plan Rule.

System
Benefits (BN)
Prefix
RUP
Primary key
COMPANY, GROUP-NAME, PLAN-TYPE, PLAN-CODE
Fields
5
Updated by
1 program
Referenced by
1 program

BNESSPLNR is the Employee Self-Service Plan Rule. table in Lawson Benefits (prefix RUP). It is indexed by COMPANY, GROUP-NAME, PLAN-TYPE, PLAN-CODE (RUPSET1). It is related 1:1 to PRSYSTEM, PERSGROUP and PLAN. It is updated by BS03.4 and referenced by BS10.1. The table has 5 fields, 1 index and 3 documented relations.

About BNESSPLNR

Employee Self-Service Plan Rule. Used to hide entire benefit plan or just company cost during EMSS benefit enrollment process.

Fields (5)

Column = COBOL field name without the RUP- 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
#RUP-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.BS03.4
#RUP-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains the employee group name.BS03.4
#RUP-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains the type of benefit plan.
  • HL Health
  • DN Dental
  • DI Disability
  • EL Employee Life
  • DL Dependent Life
  • DC Defined Contribution
  • DB Defined Benefit
  • VA Vacation
  • RS Spending Account
  • SB Savings Bond
  • SP Stock Purcahse
BS03.4
#RUP-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined code that represents a benefit plan. The plan code is unique within a plan type.BS03.4
#RUP-OPTION
OPTION		Alpha 1Customize display of plan during EMSS benefit enrollment process.
  • C Hide Company Cost
  • P Hide Plan
BS03.4

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
RUPSET1
  1. COMPANY
  2. GROUP-NAME
  3. PLAN-TYPE
  4. PLAN-CODE
PrimaryBS03.4, BS10.1

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
RUP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Emp GroupPERSGROUPRequired
RUP-COMPANY→PRG-COMPANY
RUP-GROUP-NAME→PRG-GROUP-NAME
PlanPLANRequired
RUP-COMPANY→PLN-COMPANY
RUP-PLAN-TYPE→PLN-PLAN-TYPE
RUP-PLAN-CODE→PLN-PLAN-CODE

Programs

Updated by (1)

Referenced by (1)