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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| 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 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 |
|---|---|---|---|---|
BTESET1 |
| Primary | BN100, BN101, BN102, BN103, BN105, BN15.1, BN31.1, BN31.2 +13 more | |
BTESET2 |
| HR11.1, HR511, LT101, LT111, LP02.1, LP100, LP101, LP102 +10 more | ||
BTESET3 |
| 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 |
| ||||||||||||||||
| Company | PRSYSTEM | Required |
| ||||||||||||||||
| Employee | EMPLOYEE | Required |
| ||||||||||||||||
| Employee Group | PERSGROUP | Required |
| ||||||||||||||||
| Paemployee | PAEMPLOYEE | Required |
| ||||||||||||||||
| Plan | PLAN | Required |
| ||||||||||||||||
| Ta Master | TAEEMASTER | Required |
| ||||||||||||||||
| Ta Plan | TAPLAN | Required |
|
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Position | PAPOSITION | Valid When BTE-POSITION != Spaces |
| |||||||||||||
| Ta Structure | TASTRUCTUR |
|
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