BNTAGROUP – Vacation Buy/Sell Emp Groups

System: Absence Management (LP)
Prefix: BTG
Primary key: COMPANY, PLAN-CODE, TA-PLAN, EMPLOYEE-GROUP
Fields: 8
Updated by: 3 programs
Referenced by: 18 programs

BNTAGROUP is the Vacation Buy/Sell Emp Groups table in Lawson Absence Management (prefix BTG). It is indexed by COMPANY, PLAN-CODE, TA-PLAN, EMPLOYEE-GROUP (BTGSET1); alternate indexes: BTGSET2. It is related 1:1 to PLAN, PRSYSTEM, PERSGROUP and TAPLAN and 1:M to TASTRUCTUR. It is updated by BN15.1, LP02.1 and LP15.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 and 10 more. The table has 8 fields, 2 indexes and 5 documented relations.

About BNTAGROUP

Holds records identifying which employee groups within a plan will allow hours to be bought or sold. When an employee enrolls in a vacation buy/sell benefit plan, the TA master records will be checked to ensure that a valid plan-group combination exists for the employee.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`BTG-COMPANY` PK COMPANY	Numeric 4	—	BN15.1, LP02.1
`BTG-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a benefit plan.	BN15.1, LP02.1
`BTG-TA-PLAN` PK TA_PLAN	Alpha 10	—	BN15.1, LP02.1
`BTG-EMPLOYEE-GROUP` PK EMPLOYEE_GROUP	Alpha 10	—	BN15.1, LP02.1
`BTG-EMP-GRP-STATUS` EMP_GRP_STATUS	Numeric 1	Allows user to set up a benefit plan and identify which groups within the TAplan structure are allowed to buy or sell hours. `1` Active `2` Inactive	BN15.1, LP02.1, LP15.1
`BTG-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN15.1, LP02.1
`BTG-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN15.1, LP02.1
`BTG-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN15.1, LP02.1

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
`BTGSET1`	`COMPANY`, `PLAN-CODE`, `TA-PLAN`, `EMPLOYEE-GROUP`	Primary		BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1, BN31.2 +12 more
`BTGSET2`	`COMPANY`, `TA-PLAN`, `EMPLOYEE-GROUP`, `PLAN-CODE`			LP02.1

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Bn Plan	PLAN	Required	`BTG-COMPANY` → `PLN-COMPANY`, `"VA"` → `PLN-PLAN-TYPE`, `BTG-PLAN-CODE` → `PLN-PLAN-CODE`
Company	PRSYSTEM	Required	`BTG-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee Group	PERSGROUP	Required	`BTG-COMPANY` → `PRG-COMPANY`, `BTG-EMPLOYEE-GROUP` → `PRG-GROUP-NAME`
Ta Plan	TAPLAN	Required	`BTG-COMPANY` → `TAP-COMPANY`, `BTG-TA-PLAN` → `TAP-PLAN`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Ta Structure	TASTRUCTUR			`BTG-COMPANY` → `TST-COMPANY`, `BTG-TA-PLAN` → `TST-PLAN`, `BTG-EMPLOYEE-GROUP` → `TST-EMPLOYEE-GROUP`, → `TST-BEGIN-DATE`

Programs

Updated by (3)

BN15.1 Benefit Plan
LP02.1 Plan Structure
LP15.1 Absence Plan Benefit Groups

Referenced by (18)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
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
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