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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCTSET1PLAN-TYPE, PLAN-OPTIONPrimaryBN13.1, BN15.1, BN215

Programs

Updated by (1)

Referenced by (2)