BNCATEGORY – Benefit Categories

System
Benefits (BN)
Prefix
BCT
Primary key
PLAN-TYPE, PLAN-OPTION
Fields
3
Updated by
1 program
Referenced by
2 programs

BNCATEGORY is the Benefit Categories table in Lawson Benefits (prefix BCT). It is indexed by PLAN-TYPE, PLAN-OPTION (BCTSET1). It is updated by BN13.1 and referenced by BN15.1 and BN215. The table has 3 fields, 1 index and 0 documented relations.

About BNCATEGORY

The Benefit Categories file the user-defined subset of benefit plan types. This file can be used to create default benefits.

Fields (3)

Column = COBOL field name without the BCT- 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
#BCT-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains the plan 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
  • SP Stock Purchase
  • VA Vacation
BN13.1
#BCT-PLAN-OPTION PK
PLAN_OPTION		Numeric 2Contains the user-defined plan category.BN13.1
#BCT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the category description.BN13.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
BCTSET1
  1. PLAN-TYPE
  2. PLAN-OPTION
PrimaryBN13.1, BN15.1, BN215

Programs

Updated by (1)

Referenced by (2)