BNLIMITS – Benefit Limits

System
Human Resources (HR)
Prefix
BNL
Primary key
YEAR
Fields
9
Updated by
1 program
Referenced by
14 programs

BNLIMITS is the Benefit Limits table in Lawson Human Resources (prefix BNL). It is indexed by YEAR (BNLSET1). It is updated by BN12.1 and referenced by BN200, BN236, BN335, BN340, BN56.1, BN66.1, PR140, PR189 and 6 more. The table has 9 fields, 1 index and 0 documented relations.

About BNLIMITS

Contains the government-set benefit limits.

Fields (9)

Column = COBOL field name without the BNL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BNL-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.BN12.1
BNL-MAX-COMP
MAX_COMP		Signed 11.2Contains the maximum compensation allowed for contributing to a defined contribution plan.BN12.1
BNL-MAX-ANN-ADD
MAX_ANN_ADD		Signed 11.2Contains the maximum amount an employee can contribute to a defined contribution plan. This includes employee pre-tax, after tax, and company match.BN12.1
BNL-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN12.1
BNL-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN12.1
BNL-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN12.1
BNL-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN12.1
BNL-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN12.1
BNL-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN12.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BNLSET1YEARPrimaryBN12.1, BN200, BN236, BN335, BN340, BN56.1, BN66.1, PR140 +7 more

Programs

Updated by (1)

Referenced by (14)