BNFAMSTS – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: BFS
Primary key: COMPANY, PROCESS-LEVEL, FAMILY-STATUS, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE
Fields: 30
Updated by: 2 programs
Referenced by: 39 programs

BNFAMSTS is a Lawson Benefits table (prefix BFS); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, FAMILY-STATUS, GROUP-NAME, PLAN-GROUP, PLAN-TYPE, PLAN-CODE (BFSSET1); alternate indexes: BFSSET2, BFSSET3, BFSSET4 and BFSSET5. It is related 1:1 to BNPLNGROUP, PERSGROUP, PLAN, PRSYSTEM and PCODES. It is updated by BS02.1 and BS03.2 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN232 and 31 more. The table has 30 fields, 5 indexes and 6 documented relations.

About BNFAMSTS

No description in the Lawson data dictionary.

Fields (30)

Column = COBOL field name without the BFS- 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 / column	Type	Description & values	Updated by
#`BFS-COMPANY` PK COMPANY	Numeric 4	—	BS03.2
#`BFS-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	—	BS03.2
#`BFS-FAMILY-STATUS` PK FAMILY_STATUS	Alpha 10	— `ADOPTION` Adoption `BIRTH` Birth `DEATH` Death `DIVORCE` Divorce `LEGAL SEP` Legal Separation `LOA` Leave of Absence `MARRIAGE` Marriage `MOVE` Address Change `RETIREMENT` Retirement `SPS CHANGE` Spouse Coverage Change\ `STUDENT` Student	BS03.2
#`BFS-GROUP-NAME` PK GROUP_NAME	Alpha 10	—	BS03.2
#`BFS-PLAN-GROUP` PK PLAN_GROUP	Alpha 20	—	BS03.2
#`BFS-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	— `HL` Health `DN` Dental `DI` Disability `EL` Employee Life `DL` Dependent Life `DC` Defined Contribution `DB` Defined Benefit `VA` Vacation `RS` Spending Account `SB` Savings Bond `SP` Stock Purchase	BS03.2
#`BFS-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BS03.2
#`BFS-PROCESS-ORDER` SET2 PROCESS_ORDER	Numeric 2	—	BS02.1, BS03.2
#`BFS-INQUIRE-ONLY` INQUIRE_ONLY	Alpha 1	— `Y` Yes `N` No	—
#`BFS-ADD-ALLOWED` ADD_ALLOWED	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-ADD-DATE` ADD_DATE	Alpha 2	— `FS` Family Status Change Date `CM` First of Current Month `NM` First of Next Month `CP` First of Current Pay Period `NP` First of Next Pay Period `CW` First of Current Work Period `NW` First of Next Work Period	BS03.2
#`BFS-CHANGE-ALLOWED` CHANGE_ALLOWED	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-CHANGE-DATE` CHANGE_DATE	Alpha 2	— `FS` Family Status Change Date `CM` First of Current Month `NM` First of Next Month `CP` First of Current Work Period `NP` First of Next Pay Period `CW` First of Current Work Period `NW` First of Next Work Period	BS03.2
#`BFS-STOP-ALLOWED` STOP_ALLOWED	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-STOPPED-DATE` STOPPED_DATE	Alpha 2	— `FS` Family Status Change Date `CM` First of Current Month `NM` First of Next Month `CP` First of Current Pay Period `NP` First of Next Pay Period `CW` First of Current Work Period `NW` First of Next Work Period	BS03.2
#`BFS-EOI-DAYS` EOI_DAYS	Numeric 3	—	BS03.2
#`BFS-EMPLOYEE-COST` EMPLOYEE_COST	Alpha 1	— `E` Employee Only `F` Flex Only `B` Employee And Flex Both `T` Total of Employee And Flex	BS03.2
#`BFS-COMPANY-COST` COMPANY_COST	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-DEP-BENEFITS` DEP_BENEFITS	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-BENEFICIARY` BENEFICIARY	Alpha 1	— `Y` Yes `N` No	—
#`BFS-CO-PROVIDED` CO_PROVIDED	Alpha 1	— `Y` Yes `N` No	—
#`BFS-CREATE-TRANS` CREATE_TRANS	Alpha 1	— `Y` Yes `N` No	BS03.2
#`BFS-DEFAULT-REASON` DEFAULT_REASON	Alpha 10 Occurs 3 Times ×3	—	BS03.2
#`BFS-REASON-1` REASON_1	Derived	—	—
#`BFS-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BS03.2
#`BFS-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BS03.2
#`BFS-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BS03.2
#`BFS-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BS02.1, BS03.2
#`BFS-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BS02.1, BS03.2
#`BFS-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BS02.1, BS03.2

Indexes (5)

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.

Index	Keys	Flags	Used in
`BFSSET1`	`COMPANY` `PROCESS-LEVEL` `FAMILY-STATUS` `GROUP-NAME` `PLAN-GROUP` `PLAN-TYPE` `PLAN-CODE`	Primary	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`BFSSET2`	`COMPANY` `PROCESS-LEVEL` `FAMILY-STATUS` `GROUP-NAME` `PROCESS-ORDER` `PLAN-TYPE` `PLAN-CODE`		BS10.1, BS12.1
`BFSSET3`	`COMPANY` `PROCESS-LEVEL` `FAMILY-STATUS` `GROUP-NAME` `PLAN-TYPE` `PLAN-CODE`		BS03.2, BS13.1, BS14.1, BS15.1
`BFSSET4`	`COMPANY` `PROCESS-LEVEL` `PLAN-GROUP` `FAMILY-STATUS` `GROUP-NAME` `PLAN-TYPE` `PLAN-CODE`		BS02.1
`BFSSET5`	`COMPANY` `PLAN-TYPE` `PLAN-CODE` `PROCESS-LEVEL` `FAMILY-STATUS` `GROUP-NAME` `PLAN-GROUP`		BN15.1

Relations

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

One to one (6) — lookups and parents

Relation Table Rules Condition Field map

Bnplngroup

BNPLNGROUP

Required

`BFS-COMPANY`	→	`BPG-COMPANY`
`BFS-PLAN-GROUP`	→	`BPG-PLAN-GROUP`

Employee Group

PERSGROUP

Required

`BFS-COMPANY`	→	`PRG-COMPANY`
`BFS-GROUP-NAME`	→	`PRG-GROUP-NAME`

Plan

PLAN

Required

`BFS-COMPANY`	→	`PLN-COMPANY`
`BFS-PLAN-TYPE`	→	`PLN-PLAN-TYPE`
`BFS-PLAN-CODE`	→	`PLN-PLAN-CODE`

Process Level

PRSYSTEM

Required

`BFS-COMPANY`	→	`PRS-COMPANY`
`BFS-PROCESS-LEVEL`	→	`PRS-PROCESS-LEVEL`

Prsystem

PRSYSTEM

Required

`BFS-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Reason Code

PCODES

Required

When BFS-REASON-1 != Zeroes

`"BT"`	→	`PCO-TYPE`
`BFS-DEFAULT-REASON`	→	`PCO-CODE`

Programs

Updated by (2)

BS02.1 Benefits Plan Groups
BS03.2 Benefits Life Event Plan Rules

Referenced by (39)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN15.1 Benefit Plan
BN232 Benefits Statement
BN245 Benefit Election Form
BN260 Employee Benefit Extract
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
BN320 Premium Report
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS09.1 Employee Annual Enrollment Rules
BS10.1 Web Enrollment Current Benefit Inquiry
BS11.1 Web Enrollment Employee Flex Dollar Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
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

BNFAMSTS – No description in the Lawson data dictionary

About BNFAMSTS

Fields (30) Copy as SQL

Indexes (5)

Relations

One to one (6) — lookups and parents

Programs

Updated by (2)

Referenced by (39)

Fields (30)