BNBEN – No description in the Lawson data dictionary

System
Benefits (BN)
Prefix
BNB
Primary key
COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE
Fields
45
Updated by
6 programs
Referenced by
28 programs

BNBEN is a Lawson Benefits table (prefix BNB); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE (BNBSET1). It is related 1:1 to BNCOMPANY, CUCODES, EMPLOYEE, PLAN and PCODES and 1:M to DEPBEN. It is updated by BS31.1, BS531, HR11.1, PA115, ZB10.3 and ZS531 and referenced by BN305, HR28.1, HR511, LT101, LT111, PA02.1, PA100, PA102 and 20 more. The table has 45 fields, 1 index and 6 documented relations.

About BNBEN

No description in the Lawson data dictionary.

Fields (45)

Column = COBOL field name without the BNB- 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
#BNB-COMPANY PK
COMPANY		Numeric 4—BS31.1, ZS531
#BNB-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BS31.1
#BNB-PLAN-TYPE PK
PLAN_TYPE		Alpha 2—BS31.1
#BNB-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined code that represents a benefit plan.BS31.1
#BNB-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)—BS31.1
#BNB-FC
FC		Alpha 1—BS31.1
#BNB-ENROLL-DATE
ENROLL_DATE		Numeric 8 (yyyymmdd)——
#BNB-COVER-OPT
COVER_OPT		Numeric 2—BS31.1
#BNB-MULT-SALARY
MULT_SALARY		Signed 6.3—BS31.1
#BNB-COVER-AMT
COVER_AMT		Signed 13.4—BS31.1
#BNB-PAY-RATE
PAY_RATE		Signed 13.4—BS31.1
#BNB-PCT-AMT-FLAG
PCT_AMT_FLAG		Alpha 1—BS31.1
#BNB-PRE-AFT-FLAG
PRE_AFT_FLAG		Alpha 1—BS31.1
#BNB-SMOKER-FLAG
SMOKER_FLAG		Alpha 1—BS31.1
#BNB-EMP-PRE-CONT
EMP_PRE_CONT		Signed 13.4—BS31.1
#BNB-EMP-AFT-CONT
EMP_AFT_CONT		Signed 13.4—BS31.1
#BNB-STOP-DATE
STOP_DATE		Numeric 8 (yyyymmdd)—BS31.1
#BNB-PEND-EVIDENCE
PEND_EVIDENCE		Alpha 1——
#BNB-YTD-CONT
YTD_CONT		Signed 13.4——
#BNB-RCD-TYPE
RCD_TYPE		Numeric 2—BS31.1
#BNB-PLAN-GROUP
PLAN_GROUP		Alpha 20—BS31.1
#BNB-COP-COV-DESC
COP_COV_DESC		Alpha 30—BS31.1
#BNB-DEP-COVER-AMT
DEP_COVER_AMT		Signed 11.2—BS31.1
#BNB-COV-PCT
COV_PCT		Signed 5.2—BS31.1
#BNB-FLEX-COST
FLEX_COST		Signed 9.2—BS31.1
#BNB-EMP-COST
EMP_COST		Signed 9.2—BS31.1
#BNB-COMP-COST
COMP_COST		Signed 9.2—BS31.1
#BNB-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.BS31.1
#BNB-ALPHADATA1
ALPHADATA1		Alpha 1——
#BNB-NUMERIC1
NUMERIC1		Signed 15.4——
#BNB-DATE1
DATE1		Numeric 8 (yyyymmdd)——
#BNB-PLAN-DESC
PLAN_DESC		Alpha 30—BS31.1
#BNB-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BS31.1
#BNB-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BS31.1
#BNB-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.BS31.1
#BNB-UPD-DATE
UPD_DATE		Numeric 8 (yyyymmdd)—BS31.1
#BNB-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BS31.1
#BNB-USER-ID
USER_ID		Alpha 10 (Lower Case)—BS31.1
#BNB-CREATE-TRANS
CREATE_TRANS		Alpha 1—
  • Y Yes
  • N No
BS31.1
#BNB-TRAN-REASON
TRAN_REASON		Alpha 10—BS31.1
#BNB-MEMBER-ID
MEMBER_ID		Numeric 1—BS31.1
#BNB-BN-TYPE
BN_TYPE		Alpha 1Load pending employee actions by specific Benefit Types of 1) New Hire, 2) Open Enrollment, 3) Life Event.
  • 1 Annual
  • 2 Life Event
  • 3 New Hire
BS31.1
#BNB-HOLD-FLAG
HOLD_FLAG		Alpha 1—
  • N No
  • Y Yes
BS31.1
#BNB-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BS31.1
#BNB-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BS31.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
BNBSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. START-DATE
PrimaryBN305, BS31.1, BS531, ZB10.3, ZS531, HR11.1, HR11.2, HR11.4 +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)
BNCOMPANYCUCODESEMPLOYEEPLANPCODESDEPBENBNBEN

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
BNB-COMPANY→BNC-COMPANY
CurrencyCUCODESRequired
BNB-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
BNB-COMPANY→EMP-COMPANY
BNB-EMPLOYEE→EMP-EMPLOYEE
PlanPLANRequired
BNB-COMPANY→PLN-COMPANY
BNB-PLAN-TYPE→PLN-PLAN-TYPE
BNB-PLAN-CODE→PLN-PLAN-CODE
Reason CodePCODESRequiredWhen BNB-TRAN-REASON != Spaces
"BT"→PCO-TYPE
BNB-TRAN-REASON→PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
DepbenDEPBENDelete Restricted
BNB-COMPANY→DEP-COMPANY
BNB-EMPLOYEE→DEP-EMPLOYEE
BNB-PLAN-TYPE→DEP-PLAN-TYPE
BNB-PLAN-CODE→DEP-PLAN-CODE
BNB-START-DATE→DEP-EMP-START
—→DEP-DEPENDENT
—→DEP-START-DATE

Programs

Updated by (6)

Referenced by (28)