BNACCOUNTS – Benefit Accounts

System: Benefits (BN)
Prefix: BNA
Primary key: COMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, DED-CODE
Fields: 21
Updated by: 40 programs
Referenced by: 4 programs

BNACCOUNTS is the Benefit Accounts table in Lawson Benefits (prefix BNA). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, START-DATE, GROUP-NAME, DED-CODE (BNASET1); alternate indexes: BNASET2 and BNASET3. It is related 1:1 to GLMASTER, PRSYSTEM and PLAN. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN20.1 and 32 more and referenced by BN215, BN220, HR55.1 and PRBN.1. The table has 21 fields, 3 indexes and 4 documented relations.

About BNACCOUNTS

Contains general ledger accounts to be used on employee deduction master override of accounts for a deduction code or a pay code.

Fields (21)

Column = COBOL field name without the BNA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`BNA-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN20.1
`BNA-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the plan type.	BN20.1
`BNA-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN20.1
`BNA-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	Contains the date the general ledger overrides take effect.	BN20.1
`BNA-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains the employee group name.	BN20.1
`BNA-DED-CODE` PK DED_CODE	Alpha 4	Contains the deduction code or pay code.	BN20.1
`BNA-EXP-DIST-CO` EXP_DIST_CO	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BN20.1
`BNA-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	BN20.1
`BNA-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BN20.1
`BNA-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	BN20.1
`BNA-ACR-DIST-CO` ACR_DIST_CO	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BN20.1
`BNA-ACR-ACCT-UNIT` ACR_ACCT_UNIT	Alpha 15	Contains the accrual accounting unit for the deduction code or pay code.	BN20.1
`BNA-ACR-ACCOUNT` ACR_ACCOUNT	Numeric 6	Contains the accrual account number for the deduction code or pay code.	BN20.1
`BNA-ACR-SUB-ACCT` ACR_SUB_ACCT	Numeric 4	Contains the accrual subaccount number for the deduction code or pay code.	BN20.1
`BNA-STATUS` STATUS	Numeric 1	Contains the account's status. `0` New Group New Date `1` Existing Group New Date `2` Change Existing Record `3` Updated	BN105, BN20.1
`BNA-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN20.1
`BNA-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN20.1
`BNA-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN20.1
`BNA-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN20.1
`BNA-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN20.1
`BNA-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN20.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`BNASET1`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE`, `GROUP-NAME`, `DED-CODE`	Primary	BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN20.1 +22 more (list truncated in source)
`BNASET2`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `START-DATE*`, `GROUP-NAME`, `DED-CODE`		BN100, BN101, BN102, BN103, BN105, BN145, BN215, BN232 +22 more (list truncated in source)
`BNASET3`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `GROUP-NAME`, `START-DATE`, `DED-CODE`		BN20.1

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Acr Acct Desc	GLMASTER	Not Required	`BNA-COMPANY` → `GLM-COMPANY`, `BNA-ACR-ACCT-UNIT` → `GLM-ACCT-UNIT`, `BNA-ACR-ACCOUNT` → `GLM-ACCOUNT`, `BNA-ACR-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Company	PRSYSTEM	Required	`BNA-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Exp Acct Desc	GLMASTER	Not Required	`BNA-COMPANY` → `GLM-COMPANY`, `BNA-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `BNA-EXP-ACCOUNT` → `GLM-ACCOUNT`, `BNA-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Plan	PLAN	Not Required	`BNA-COMPANY` → `PLN-COMPANY`, `BNA-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BNA-PLAN-CODE` → `PLN-PLAN-CODE`

Programs

Updated by (40)

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
BN20.1 General Ledger Overrides
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

Referenced by (4)

BN215 Plan Parameter Listing
BN220 Benefit Plan Status Report
HR55.1 Employee Group Definition
PRBN.1 Payroll Cycle Benefit Edit