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.

Field / columnTypeDescription & valuesUpdated by
BAE-COMPANY PK
COMPANY
Numeric 4BS01.1
BAE-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5BS01.1
BAE-RULE-TYPE PK
RULE_TYPE
Alpha 1
  • A Annual Enrollment Rules
  • F Family Status Change Rules
  • N New Hire Rules
  • C Current Benefits
BS01.1
BAE-GROUP-NAME PK
GROUP_NAME
Alpha 10BS01.1
BAE-ENROLL-START
ENROLL_START
Numeric 8 (yyyymmdd)BS01.1
BAE-ENROLL-STOP
ENROLL_STOP
Numeric 8 (yyyymmdd)BS01.1
BAE-CURRENT-DATE
CURRENT_DATE
Numeric 8 (yyyymmdd)BS01.1
BAE-NEW-DATE
NEW_DATE
Numeric 8 (yyyymmdd)BS01.1
BAE-COST-DIVISOR
COST_DIVISOR
Alpha 1
  • A Annual
  • S Semi-Monthly
  • M Monthly
  • P Pay Frequency
BS01.1
BAE-IMMEDIATE
IMMEDIATE
Alpha 1
  • Y Yes
  • N No
  • T Test
BS01.1
BAE-ADD-DEPENDENTS
ADD_DEPENDENTS
Alpha 1
  • Y Yes
  • N No
BS01.1
BAE-UPDATE-FREQ
UPDATE_FREQ
Alpha 1
  • H Hourly
  • D Daily
  • W Weekly
  • M Monthly
  • E End of Enrollment
BS01.1
BAE-DATE
DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.
BAE-MISC-1
MISC_1
Alpha 10
BAE-MISC-2
MISC_2
Alpha 10
BAE-FORFEIT-OPT
FORFEIT_OPT
Alpha 1
  • N No
  • Y Yes
BAE-CREATE-DATE
CREATE_DATE
Numeric 8 (yyyymmdd)BS01.1
BAE-CREATE-TIME
CREATE_TIME
Numeric 6 (hhmmss)BS01.1
BAE-CREATE-USER-ID
CREATE_USER_ID
Alpha 10 (Lower Case)BS01.1
BAE-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)BS01.1
BAE-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)BS01.1
BAE-USER-ID
USER_ID
Alpha 10 (Lower Case)BS01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BAESET1COMPANY, PROCESS-LEVEL, RULE-TYPE, GROUP-NAMEPrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
BncompanyBNCOMPANYRequiredBAE-COMPANYBNC-COMPANY
PersgroupPERSGROUPRequiredBAE-COMPANYPRG-COMPANY, BAE-GROUP-NAMEPRG-GROUP-NAME
Process LevelPRSYSTEMRequiredBAE-COMPANYPRS-COMPANY, BAE-PROCESS-LEVELPRS-PROCESS-LEVEL
PrsystemPRSYSTEMRequiredBAE-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (39)