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.

Field / columnTypeDescription & valuesUpdated by
NAV-COMPANY PK
COMPANY
Numeric 4The company number represents an established company and is entered on all function codes.BN30.1
NAV-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5The 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 PK
EMPLOYEE
Numeric 9This field is to establish a unique navigation sequence for an employee. This employee must be valid in the EMPLOYEE file.BN30.1
NAV-PLAN-TYPE
PLAN_TYPE
Alpha 2 Occurs 11 Times ×11Contains the 11 benefit types in the sequence. These types are defined in BN30.1 (Benefit Process Order).BN102, BN105, BN30.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
NAVSET1COMPANY, PROCESS-LEVEL, EMPLOYEEPrimaryBN00.1, BN100, BN101, BN102, BN103, BN105, BN231, BN30.1 +15 more

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Bn CompanyBNCOMPANYRequiredNAV-COMPANYBNC-COMPANY
EmployeeEMPLOYEERequiredWhen NAV-EMPLOYEE != ZeroesNAV-COMPANYEMP-COMPANY, NAV-EMPLOYEEEMP-EMPLOYEE
Pr CompanyPRSYSTEMRequiredNAV-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequiredWhen NAV-PROCESS-LEVEL != SpacesNAV-COMPANYPRS-COMPANY, NAV-PROCESS-LEVELPRS-PROCESS-LEVEL

Programs

Updated by (2)

Referenced by (21)