BNANNENR – No description in the Lawson data dictionary
- System
- Benefits (BN)
- Prefix
BAE- Primary key
COMPANY,PROCESS-LEVEL,RULE-TYPE,GROUP-NAME- Fields
- 22
- Updated by
- 1 program
- Referenced by
- 39 programs
BNANNENR is a Lawson Benefits table (prefix BAE); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, RULE-TYPE, GROUP-NAME (BAESET1). It is related 1:1 to BNCOMPANY, PERSGROUP and PRSYSTEM. It is updated by BS01.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 and 31 more. The table has 22 fields, 1 index and 4 documented relations.
About BNANNENR
No description in the Lawson data dictionary.
Fields (22)
Column = COBOL field name without the BAE- 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 |
|---|---|---|---|
#BAE-COMPANY PKCOMPANY | Numeric 4 | — | BS01.1 |
#BAE-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | BS01.1 |
#BAE-RULE-TYPE PKRULE_TYPE | Alpha 1 | —
| BS01.1 |
#BAE-GROUP-NAME PKGROUP_NAME | Alpha 10 | — | BS01.1 |
#BAE-ENROLL-STARTENROLL_START | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-ENROLL-STOPENROLL_STOP | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-CURRENT-DATECURRENT_DATE | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-NEW-DATENEW_DATE | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-COST-DIVISORCOST_DIVISOR | Alpha 1 | —
| BS01.1 |
#BAE-IMMEDIATEIMMEDIATE | Alpha 1 | —
| BS01.1 |
#BAE-ADD-DEPENDENTSADD_DEPENDENTS | Alpha 1 | —
| BS01.1 |
#BAE-UPDATE-FREQUPDATE_FREQ | Alpha 1 | —
| BS01.1 |
#BAE-DATEDATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | — |
#BAE-MISC-1MISC_1 | Alpha 10 | — | — |
#BAE-MISC-2MISC_2 | Alpha 10 | — | — |
#BAE-FORFEIT-OPTFORFEIT_OPT | Alpha 1 | —
| — |
#BAE-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BS01.1 |
#BAE-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | BS01.1 |
#BAE-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | BS01.1 |
#BAE-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | BS01.1 |
#BAE-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BS01.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 |
|---|---|---|---|---|
BAESET1 |
| Primary | BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source) |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Bncompany | BNCOMPANY | Required |
| |||||||
| Persgroup | PERSGROUP | Required |
| |||||||
| Process Level | PRSYSTEM | Required |
| |||||||
| Prsystem | PRSYSTEM | Required |
|
Programs
Updated by (1)
- BS01.1 Benefits Enrollment Rules
Referenced by (39)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN232 Benefits Statement
- BN245 Benefit Election Form
- BN260 Employee Benefit Extract
- 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
- BN320 Premium Report
- BN331 HIPAA Certification Report
- BN340 ADP and ACP Tests
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BN65.1 Election Simulation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS09.1 Employee Annual Enrollment Rules
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS11.1 Web Enrollment Employee Flex Dollar Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- ZB01.1 Years Of Service Calculation
- ZB10.1 Coverage Options Calculator
- ZB10.2 Get Benefit Eligibility Dates
- 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
- ZB599 Update Enrollment Data Structu