BNTRANS – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: BNT
Primary key: COMPANY, PLAN-TYPE, PLAN-CODE, EMPLOYEE, PARTICIPNT, DEPENDENT, START-DATE, TRAN-SEQ-NBR
Fields: 22
Updated by: 32 programs
Referenced by: 1 program

BNTRANS is a Lawson Benefits table (prefix BNT); no description in the lawson data dictionary. It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE, EMPLOYEE, PARTICIPNT, DEPENDENT, START-DATE, TRAN-SEQ-NBR (BNTSET1); alternate indexes: BNTSET2 and BNTSET3. It is related 1:1 to PRSYSTEM, EMDEPEND, EMPLOYEE, PARTICIPNT, PLAN and PCODES. It is updated by BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 and 24 more and referenced by BN70.1. The table has 22 fields, 3 indexes and 6 documented relations.

About BNTRANS

No description in the Lawson data dictionary.

Fields (22)

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

Field / column	Type	Description & values	Updated by
`BNT-COMPANY` PK COMPANY	Numeric 4	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-PARTICIPNT` PK PARTICIPNT	Numeric 9	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-DEPENDENT` PK DEPENDENT	Numeric 4	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-START-DATE` PK START_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-TRAN-SEQ-NBR` PK TRAN_SEQ_NBR	Numeric 4	An automatically assigned sequence number.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-EMP-START` EMP_START	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`BNT-EVENT-CODE` EVENT_CODE	Numeric 1	— `1` Termination of Employment `2` Reduction of Work Hours `3` Medicare `4` Death `5` Divorce `6` Separation `7` Ineligible Child `8` Bankruptcy or Retiree	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`BNT-COVER-TYPE` COVER_TYPE	Alpha 1	— `E` Employee `R` Retiree `C` COBRA Participant	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-TRAN-STATUS` TRAN_STATUS	Numeric 1	This field displays the status of the transaction. `1` Active `2` Transmitted `3` On Hold	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +21 more
`BNT-TRAN-ACTION` TRAN_ACTION	Alpha 1	— `A` Add `C` Change `D` Delete `S` Stop	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +21 more
`BNT-TRAN-REASON` TRAN_REASON	Alpha 10	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-MEMBER-ID` MEMBER_ID	Numeric 1	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-STOP-DATE` STOP_DATE	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +20 more
`BNT-HIPAA-FILE-NBR` HIPAA_FILE_NBR	Alpha 30 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +20 more
`BNT-FILE-DATE` FILE_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +19 more
`BNT-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +20 more
`BNT-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +20 more
`BNT-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +20 more

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
`BNTSET1`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `EMPLOYEE`, `PARTICIPNT`, `DEPENDENT`, `START-DATE`, `TRAN-SEQ-NBR`	Primary	BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +22 more
`BNTSET2`	`COMPANY`, `EMPLOYEE`, `PARTICIPNT`, `DEPENDENT`, `PLAN-TYPE`, `PLAN-CODE`, `EFFECT-DATE`, `TRAN-SEQ-NBR`		BN100, BN101, BN102, BN103, BN105, BN106, BN31.1, BN31.2 +22 more (list truncated in source)
`BNTSET3`	`COMPANY`, `DATE-STAMP*`, `PLAN-TYPE`, `PLAN-CODE`, `EMPLOYEE`, `PARTICIPNT`, `DEPENDENT`, `START-DATE`, `TRAN-SEQ-NBR`	KeyChange	—

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`BNT-COMPANY` → `PRS-COMPANY (PRSSET1)`, `Spaces` → `PRS-PROCESS-LEVEL`
Dependent	EMDEPEND	Required	When BNT-DEPENDENT != Zeroes	`BNT-COMPANY` → `EMD-COMPANY`, `BNT-EMPLOYEE` → `EMD-EMPLOYEE`, `BNT-DEPENDENT` → `EMD-SEQ-NBR`
Employee	EMPLOYEE	Required	When BNT-EMPLOYEE != Zeroes	`BNT-COMPANY` → `EMP-COMPANY`, `BNT-EMPLOYEE` → `EMP-EMPLOYEE`
Participant	PARTICIPNT	Required	When BNT-PARTICIPNT != Zeroes	`BNT-COMPANY` → `PAR-COMPANY`, `BNT-PARTICIPNT` → `PAR-PARTICIPNT`
Plan	PLAN	Required		`BNT-COMPANY` → `PLN-COMPANY`, `BNT-PLAN-TYPE` → `PLN-PLAN-TYPE`, `BNT-PLAN-CODE` → `PLN-PLAN-CODE`
Reason Code	PCODES	Required		`"BT"` → `PCO-TYPE`, `BNT-TRAN-REASON` → `PCO-CODE`

Programs

Updated by (32)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN106 Benefit Transaction Export
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
BN430 Benefit Purge
BN53.1 Benefit Transactions
BN531 Batch Benefit Enrollment
BN532 Batch Dependent Benefit Enrollment
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS32.1 Web Enrollment Stop Benefits Update
HR11.1 Employee
HR13.1 Dependent
HR13.2 Dependent Benefits
HR13.3 Dependent Benefits
HR13.4 Dependent Benefits
HR513 Dependent Conversion
PA115 Employee Purge
PA218 Travel Listing
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

Referenced by (1)

BN70.1 COBRA Participant