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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BTG-COMPANY PKCOMPANY | Numeric 4 | — | BN15.1, LP02.1 |
#BTG-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code that represents a benefit plan. | BN15.1, LP02.1 |
#BTG-TA-PLAN PKTA_PLAN | Alpha 10 | — | BN15.1, LP02.1 |
#BTG-EMPLOYEE-GROUP PKEMPLOYEE_GROUP | Alpha 10 | — | BN15.1, LP02.1 |
#BTG-EMP-GRP-STATUSEMP_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.
| BN15.1, LP02.1, LP15.1 |
#BTG-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | BN15.1, LP02.1 |
#BTG-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN15.1, LP02.1 |
Indexes (2)
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 | Condition | Used in |
|---|---|---|---|---|
BTGSET1 |
| Primary | BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1, BN31.2 +12 more | |
BTGSET2 |
| LP02.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bn Plan | PLAN | Required |
| ||||||||||
| Company | PRSYSTEM | Required |
| ||||||||||
| Employee Group | PERSGROUP | Required |
| ||||||||||
| Ta Plan | TAPLAN | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ta Structure | TASTRUCTUR |
|
Programs
Updated by (3)
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