BENEFICRY – Beneficiary

System
Benefits (BN)
Prefix
BNF
Primary key
COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, SEQ-NBR
Fields
43
Updated by
3 programs
Referenced by
116 programs

BENEFICRY is the Beneficiary table in Lawson Benefits (prefix BNF). It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, SEQ-NBR (BNFSET1); alternate indexes: BNFSET2. It is related 1:1 to BNCOMPANY, PRSYSTEM, INSTCTRYCD, EMPLOYEE, PAEMPLOYEE, PCODES and PLAN and 1:M to HRCTRYCODE. It is updated by BN430, BN47.1 and BN547 and referenced by BN100, BN101, BN102, BN103, BN105, BN232, BN245, BN247 and 108 more. The table has 43 fields, 2 indexes and 9 documented relations.

About BENEFICRY

The Beneficiary file contains information about the employee's primary and contingent beneficiaries for disability, employee life/AD&D, defined contribution, and defined benefit plans. The employee must have a benefit of the type and plan code to add the beneficiary record. BN47.1 (Beneficiary) is the primary program that updates this file.

Fields (43)

Column = COBOL field name without the BNF- 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
#BNF-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN47.1, BN547
#BNF-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number. The number correlates all information about the employee.BN47.1, BN547
#BNF-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains the kind of plan the beneficiary is associated with.
  • DB Defined Benefit
  • DC Defined Contribution
  • DI Disability
  • EL Employee Life
BN47.1, BN547
#BNF-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the plan code.BN47.1, BN547
#BNF-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the sequence number of the beneficiary. It is auto sequenced based on PEM-LAST-BNF-SEQ.BN47.1, BN547
#BNF-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the beneficiary's last name.BN47.1, BN547
#BNF-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the beneficiary's first name.BN47.1, BN547
#BNF-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the beneficiary's middle initial.BN47.1, BN547
#BNF-PCT-AMT-FLAG
PCT_AMT_FLAG		Alpha 1Indicates whether the payment to the beneficiary is a percent or a flat dollar amount.
  • A Amount
  • P Percent
BN47.1, BN547
#BNF-PMT-AMT
PMT_AMT		Signed 11.2Contains the percent or dollar amount to be paid to the beneficiary.BN47.1, BN547
#BNF-PRIM-CNTGNT SET2
PRIM_CNTGNT		Numeric 1Indicates whether the beneficiary is primary or contingent.
  • 1 Primary
  • 2 Contingent
BN47.1, BN547
#BNF-BENEF-TYPE
BENEF_TYPE		Numeric 1—
  • 0 Individual
  • 1 Trust
BN47.1, BN547
#BNF-TRUST
TRUST		Alpha 60 (Lower Case)—BN47.1, BN547
#BNF-LAST-NAME-PRE
LAST_NAME_PRE		Alpha 30 (Lower Case)—BN47.1, BN547
#BNF-NAME-SUFFIX
NAME_SUFFIX		Alpha 4 (Lower Case)—BN47.1, BN547
#BNF-REL-CODE
REL_CODE		Alpha 10—BN47.1, BN547
#BNF-FICA-NBR
FICA_NBR		Alpha 20—BN47.1, BN547
#BNF-EMP-ADDRESS
EMP_ADDRESS		Alpha 1—
  • H Home Address
  • S Supplemental Address
BN47.1, BN547
#BNF-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.BN47.1, BN547
#BNF-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.BN47.1, BN547
#BNF-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.BN47.1, BN547
#BNF-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.BN47.1, BN547
#BNF-CITY
CITY		Alpha 58 (Lower Case)This field contains the city of the address.BN47.1, BN547
#BNF-STATE
STATE		Alpha 2This field contains the two-character state code of the address.BN47.1, BN547
#BNF-ZIP
ZIP		Alpha 10This field contains the postal code of the address.BN47.1, BN547
#BNF-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN47.1, BN547
#BNF-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)The text associated with the sequence number.BN47.1, BN547
#BNF-LAST-PRE-SUF
LAST_PRE_SUF		Derived——
#BNF-LAST-PRE
LAST_PRE		Derived——
#BNF-LAST-SUF
LAST_SUF		Derived——
#BNF-LAST-NAME-EXP
LAST_NAME_EXP		Derived——
#BNF-FIRST-MI
FIRST_MI		Derived——
#BNF-FIRST-MI-EXP
FIRST_MI_EXP		Derived——
#BNF-FULL-NAME
FULL_NAME		Derived——
#BNF-LABEL-NAME-1
LABEL_NAME_1		Derived——
#BNF-BENEF-NAME-1
BENEF_NAME_1		Derived——
#BNF-BENEF-NAME-2
BENEF_NAME_2		Derived——
#BNF-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN47.1, BN547
#BNF-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN47.1, BN547
#BNF-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN47.1, BN547
#BNF-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN47.1, BN547
#BNF-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN47.1, BN547
#BNF-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN47.1, BN547

Indexes (2)

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
BNFSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN105, BN245, BN247, BN31.1 +22 more (list truncated in source)
BNFSET2
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. PRIM-CNTGNT
  6. SEQ-NBR
KeyChangeBN232, BN47.1

Relations

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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
BNF-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BNF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequired
BNF-COUNTRY-CODE→INT-COUNTRY-CODE
EmployeeEMPLOYEERequired
BNF-COMPANY→EMP-COMPANY
BNF-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
BNF-COMPANY→PEM-COMPANY
BNF-EMPLOYEE→PEM-EMPLOYEE
PcodesPCODESRequired
"DP"→PCO-TYPE
BNF-REL-CODE→PCO-CODE
PlanPLANRequired
BNF-COMPANY→PLN-COMPANY
BNF-PLAN-TYPE→PLN-PLAN-TYPE
BNF-PLAN-CODE→PLN-PLAN-CODE
RelationPCODESRequired
"DP"→PCO-TYPE
BNF-REL-CODE→PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Name SuffixHRCTRYCODE
"SU"→CTC-TYPE
BNF-NAME-SUFFIX→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE

Programs

Updated by (3)

Referenced by (116)