BNTAEMPBAL – Emp Vacation Buy/Sell Balance
- System
- Absence Management (LP)
- Prefix
BTE- Primary key
COMPANY,PLAN-CODE,EMPLOYEE,TA-PLAN,EMPLOYEE-GROUP,POSITION,START-DATE- Fields
- 17
- Updated by
- 36 programs
- Referenced by
- 3 programs
BNTAEMPBAL is the Emp Vacation Buy/Sell Balance table in Lawson Absence Management (prefix BTE). It is indexed by COMPANY, PLAN-CODE, EMPLOYEE, TA-PLAN, EMPLOYEE-GROUP, POSITION, START-DATE (BTESET1); alternate indexes: BTESET2 and BTESET3. It is related 1:1 to BENEFIT, PRSYSTEM, EMPLOYEE, PERSGROUP, PAEMPLOYEE, PLAN, TAEEMASTER and TAPLAN and 1:M to PAPOSITION and TASTRUCTUR. It is updated by BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 and 28 more and referenced by BN15.1, LP02.1 and LP331. The table has 17 fields, 3 indexes and 10 documented relations.
About BNTAEMPBAL
No description in the Lawson data dictionary.
Fields (17)
Column = COBOL field name without the BTE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
BTE-COMPANY PKCOMPANY | Numeric 4 | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code that represents a benefit plan. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-EMPLOYEE PKEMPLOYEE | 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 +11 more |
BTE-TA-PLAN PKTA_PLAN | Alpha 10 | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-EMPLOYEE-GROUP PKEMPLOYEE_GROUP | Alpha 10 | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-POSITION PKPOSITION | Alpha 12 | Contains the user-defined code that represents a position in the company. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-STOP-DATESTOP_DATE | Numeric 8 (yyyymmdd) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-TA-OBJ-IDTA_OBJ_ID | Numeric 12 | Ties the record to teh associated BENEFIT record. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-TOTAL-HOURSTOTAL_HOURS | Signed 8.4 | Store the total elected number of hours from the benefit. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-PERCENTPERCENT | Signed 7.3 | Stores the percent of the total hours that apply to this group or position. Used only when there are multiple master records for a TA plan. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more |
BTE-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 more |
BTE-UPDATED-HOURSUPDATED_HOURS | Signed 8.4 | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 more |
BTE-UPD-THRU-DATEUPD_THRU_DATE | Numeric 8 (yyyymmdd) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 more |
BTE-DATE-STAMPDATE_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, BN31.1, BN31.2, BN32.1 +12 more |
BTE-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 more |
BTE-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 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 | Condition | Used in |
|---|---|---|---|---|
BTESET1 | COMPANY, PLAN-CODE, EMPLOYEE, TA-PLAN, EMPLOYEE-GROUP, POSITION, START-DATE | Primary | BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1, BN31.2 +13 more | |
BTESET2 | COMPANY, TA-PLAN, EMPLOYEE-GROUP, EMPLOYEE, POSITION, PLAN-CODE, START-DATE | HR11.1, HR511, LT101, LT111, LP02.1, LP100, LP101, LP102 +10 more | ||
BTESET3 | COMPANY, PLAN-CODE, EMPLOYEE, START-DATE*, EMPLOYEE-GROUP, POSITION | BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +12 more |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Benefit | BENEFIT | Required | BTE-COMPANY → BEN-COMPANY, "VA" → BEN-PLAN-TYPE, BTE-EMPLOYEE → BEN-EMPLOYEE, BTE-START-DATE → BEN-START-DATE, BTE-PLAN-CODE → BEN-PLAN-CODE | |
| Company | PRSYSTEM | Required | BTE-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | BTE-COMPANY → EMP-COMPANY, BTE-EMPLOYEE → EMP-EMPLOYEE | |
| Employee Group | PERSGROUP | Required | BTE-COMPANY → PRG-COMPANY, BTE-EMPLOYEE-GROUP → PRG-GROUP-NAME | |
| Paemployee | PAEMPLOYEE | Required | BTE-COMPANY → PEM-COMPANY, BTE-EMPLOYEE → PEM-EMPLOYEE | |
| Plan | PLAN | Required | BTE-COMPANY → PLN-COMPANY, "VA" → PLN-PLAN-TYPE, BTE-PLAN-CODE → PLN-PLAN-CODE | |
| Ta Master | TAEEMASTER | Required | BTE-COMPANY → TEM-COMPANY, BTE-EMPLOYEE → TEM-EMPLOYEE, BTE-TA-PLAN → TEM-PLAN, BTE-EMPLOYEE-GROUP → TEM-EMPLOYEE-GROUP, BTE-POSITION → TEM-POSITION | |
| Ta Plan | TAPLAN | Required | BTE-COMPANY → TAP-COMPANY, BTE-TA-PLAN → TAP-PLAN |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Position | PAPOSITION | Valid When BTE-POSITION != Spaces | BTE-COMPANY → POS-COMPANY, BTE-POSITION → POS-POSITION, POS-EFFECT-DATE | |
| Ta Structure | TASTRUCTUR | BTE-COMPANY → TST-COMPANY, BTE-TA-PLAN → TST-PLAN, BTE-EMPLOYEE-GROUP → TST-EMPLOYEE-GROUP, TST-BEGIN-DATE |
Programs
Updated by (36)
- 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
- HR11.1 Employee
- HR511 Employee Conversion
- LP100 Employee Absence Plan Update
- LP101 Mass Absence Plan Add
- LP102 Employee Master Update
- LP103 Mass Absence Plan Termination
- LP131 Zero Balance Update
- LP138 Absence Plan Hours Update
- LP151 FMLA Rolling 12 Month Update
- LP180 Mass Absence Plan Transfer
- LP197 Absence Plan Close
- LP31.1 Employee Absence Plan Master
- LP34.1 Absence Plan Hours Allocation
- LP80.1 Employee Absence Plan Transfer
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA100 Action Update
- PA52.4 Hire an Applicant
- 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