BNPOSTCODE – Benefit Postal Code

System
Benefits (BN)
Prefix
BPC
Primary key
POST-CODE-TBL, POSTAL-CODE
Fields
2
Updated by
1 program
Referenced by
29 programs

BNPOSTCODE is the Benefit Postal Code table in Lawson Benefits (prefix BPC). It is indexed by POST-CODE-TBL, POSTAL-CODE (BPCSET1). It is updated by BN11.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN15.1, BN245, BN260 and 21 more. The table has 2 fields, 1 index and 0 documented relations.

About BNPOSTCODE

Contains postal code tables that can be used can use as criteria for benefit eligibility. East postal code for a table is one record in this file. A table is composed of all records with the same postal code table description. Postal codes can be assigned to a plan, which limits the plan's eligibility to employees with benefit postal codes assigned to the table.

Fields (2)

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

Field / columnTypeDescription & valuesUpdated by
BPC-POST-CODE-TBL PK
POST_CODE_TBL
Alpha 30Contains the code descriptions.BN11.1
BPC-POSTAL-CODE PK
POSTAL_CODE
Alpha 10 (Lower Case)This field contains the postal code.BN11.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BPCSET1POST-CODE-TBL, POSTAL-CODEPrimaryBN100, BN101, BN102, BN103, BN105, BN11.1, BN15.1, BN245 +22 more

Programs

Updated by (1)

Referenced by (29)