ZBNUXLOG – No description in the Lawson data dictionary

System: Benefits (BN)
Prefix: ZBL
Primary key: COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE-457, START-DATE-457, PLAN-CODE-MAT, START-DATE-MAT, SEQ-NBR
Fields: 26
Updated by: 36 programs
Referenced by: 0 programs

ZBNUXLOG is a Lawson Benefits table (prefix ZBL); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE-457, START-DATE-457, PLAN-CODE-MAT, START-DATE-MAT, SEQ-NBR (ZBLSET1); alternate indexes: ZBLSET2, ZBLSET3 and ZBLSET4. It is updated by BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 and 28 more. The table has 26 fields, 4 indexes and 0 documented relations.

About ZBNUXLOG

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the ZBL- 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
#`ZBL-COMPANY` PK COMPANY	Numeric 4	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-PLAN-CODE-457` PK PLAN_CODE_457	Alpha 4	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-START-DATE-457` PK START_DATE_457	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-PLAN-CODE-MAT` PK PLAN_CODE_MAT	Alpha 4	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-START-DATE-MAT` PK START_DATE_MAT	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-SEQ-NBR` PK SEQ_NBR	Numeric 4	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-LOG-TYPE` SET3 LOG_TYPE	Numeric 1	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-IN-ELIG-GROUP` IN_ELIG_GROUP	Alpha 1	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-PLAN-CODE-PEN` PLAN_CODE_PEN	Alpha 4	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-START-DATE-PEN` START_DATE_PEN	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-BEN-DATE-3` BEN_DATE_3	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-YEARS-OF-SVC` YEARS_OF_SVC	Numeric 2	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-CONTRIB-457` CONTRIB_457	Signed 7.2	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-CONTRIB-MAT` CONTRIB_MAT	Signed 7.2	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-MATCH-PCT` MATCH_PCT	Signed 5.2	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-INVOKE` INVOKE	Alpha 6	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-FC` FC	Alpha 1	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-ERROR-CAT` ERROR_CAT	Alpha 5	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-ERROR-NBR` ERROR_NBR	Numeric 3	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-MESSAGE` MESSAGE	Alpha 60 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-PROGRAM-CODE` PROGRAM_CODE	Alpha 5	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#`ZBL-USER-NAME` USER_NAME	Alpha 10 (Lower Case)	—	BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more

Indexes (4)

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	Used in
`ZBLSET1`	`COMPANY` `EMPLOYEE` `PLAN-TYPE` `PLAN-CODE-457` `START-DATE-457` `PLAN-CODE-MAT` `START-DATE-MAT` `SEQ-NBR`	Primary	—
`ZBLSET2`	`COMPANY` `EMPLOYEE` `SEQ-NBR` ↓		BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
`ZBLSET3`	`COMPANY` `LOG-TYPE` `EMPLOYEE` `SEQ-NBR`		—
`ZBLSET4`	`COMPANY` `START-DATE-457` `EMPLOYEE` `SEQ-NBR`		—

Programs

Updated by (36)

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
BS10.1 Web Enrollment Current Benefit 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

ZBNUXLOG – No description in the Lawson data dictionary

About ZBNUXLOG

Fields (26) Copy as SQL

Indexes (4)

Programs

Updated by (36)

Fields (26)