NAVIGATE – Benefit Process Order
- System
- Benefits (BN)
- Prefix
NAV- Primary key
COMPANY,PROCESS-LEVEL,EMPLOYEE- Fields
- 4
- Updated by
- 2 programs
- Referenced by
- 21 programs
NAVIGATE is the Benefit Process Order table in Lawson Benefits (prefix NAV). It is indexed by COMPANY, PROCESS-LEVEL, EMPLOYEE (NAVSET1). It is related 1:1 to BNCOMPANY, EMPLOYEE and PRSYSTEM. It is updated by BN00.1 and BN30.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN231, BN31.1, BN31.2 and 13 more. The table has 4 fields, 1 index and 4 documented relations.
About NAVIGATE
The Benefit Entry Navigation file contains the navigation sequence for a company, process level, or employee. It determines the order in which plans display and benefits are updated.
Fields (4)
Column = COBOL field name without the NAV- 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 |
|---|---|---|---|
#NAV-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established company and is entered on all function codes. | BN30.1 |
#NAV-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | The process level is the reporting hierarchy below the company. This must be a valid PRS-PROCESS-LEVEL. This navigation sequence is used for all employees where the EMP-PROCESS-LEVEL is equal to the value in this field. | BN30.1 |
#NAV-EMPLOYEE PKEMPLOYEE | Numeric 9 | This field is to establish a unique navigation sequence for an employee. This employee must be valid in the EMPLOYEE file. | BN30.1 |
#NAV-PLAN-TYPEPLAN_TYPE | Alpha 2 Occurs 11 Times ×11 | Contains the 11 benefit types in the sequence. These types are defined in BN30.1 (Benefit Process Order). | BN102, BN105, BN30.1 |
Indexes (1)
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 |
|---|---|---|---|---|
NAVSET1 |
| Primary | BN00.1, BN100, BN101, BN102, BN103, BN105, BN231, BN30.1 +15 more |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Bn Company | BNCOMPANY | Required |
| |||||||
| Employee | EMPLOYEE | Required | When NAV-EMPLOYEE != Zeroes |
| ||||||
| Pr Company | PRSYSTEM | Required |
| |||||||
| Process Level | PRSYSTEM | Required | When NAV-PROCESS-LEVEL != Spaces |
|
Programs
Updated by (2)
Referenced by (21)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN231 Employee Benefit Report
- 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
- BS531 Web Pending Employee Benefit Extract
- 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
- ZS531 Web Pending Employee Benefit Extract