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.

Field / column	Type	Description & values	Updated by
`BNF-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN47.1, BN547
`BNF-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee's number. The number correlates all information about the employee.	BN47.1, BN547
`BNF-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains 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 4	Contains the plan code.	BN47.1, BN547
`BNF-SEQ-NBR` PK SEQ_NBR	Numeric 4	Contains 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 1	Contains the beneficiary's middle initial.	BN47.1, BN547
`BNF-PCT-AMT-FLAG` PCT_AMT_FLAG	Alpha 1	Indicates 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.2	Contains the percent or dollar amount to be paid to the beneficiary.	BN47.1, BN547
`BNF-PRIM-CNTGNT` PRIM_CNTGNT	Numeric 1	Indicates 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 2	This field contains the two-character state code of the address.	BN47.1, BN547
`BNF-ZIP` ZIP	Alpha 10	This field contains the postal code of the address.	BN47.1, BN547
`BNF-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`BNFSET1`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `SEQ-NBR`	Primary		BN100, BN101, BN102, BN103, BN105, BN245, BN247, BN31.1 +22 more (list truncated in source)
`BNFSET2`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `PRIM-CNTGNT`, `SEQ-NBR`	KeyChange		BN232, BN47.1

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Field map
Company	BNCOMPANY	Required	`BNF-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required	`BNF-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Country	INSTCTRYCD	Required	`BNF-COUNTRY-CODE` → `INT-COUNTRY-CODE`
Employee	EMPLOYEE	Required	`BNF-COMPANY` → `EMP-COMPANY`, `BNF-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required	`BNF-COMPANY` → `PEM-COMPANY`, `BNF-EMPLOYEE` → `PEM-EMPLOYEE`
Pcodes	PCODES	Required	`"DP"` → `PCO-TYPE`, `BNF-REL-CODE` → `PCO-CODE`
Plan	PLAN	Required	`BNF-COMPANY` → `PLN-COMPANY`, `BNF-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BNF-PLAN-CODE` → `PLN-PLAN-CODE`
Relation	PCODES	Required	`"DP"` → `PCO-TYPE`, `BNF-REL-CODE` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Name Suffix	HRCTRYCODE			`"SU"` → `CTC-TYPE`, `BNF-NAME-SUFFIX` → `CTC-HRCTRY-CODE`, → `CTC-COUNTRY-CODE`

Programs

Updated by (3)

BN430 Benefit Purge
BN47.1 Beneficiaries
BN547 Beneficiaries Conversion

Referenced by (116)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN232 Benefits Statement
BN245 Benefit Election Form
BN247 Beneficiary Listing
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN531 Batch Benefit Enrollment
BS32.1 Web Enrollment Stop Benefits Update
HR04.2 Human Resource Codes
HR04.3 Human Resource Codes
HR04.7 User Fields Value List
HR04.8 Human Resource Codes
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add