Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNPOSTCODE


                            BNPOSTCODE FILE

                          Benefit Postal Code

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.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN15.1
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN340     BN345     BN350     BN531     BN65.1    BN71.1
BN72.1    BS10.1    BS12.1    BS32.1

UPDATED BY

BN11.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BPC-POST-CODE-TBL      Alpha 30                                  BN11.1
Element: Post Code Tbl Contains the code descriptions.

BPC-POSTAL-CODE        Alpha 10  (Lower Case)                    BN11.1
Element: Postal Code   This field contains the postal code.

                         BNPOSTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPCSET1   POST-CODE-TBL                                          BN100   BN101
          POSTAL-CODE                                            BN102   BN103
                                                                 BN105   BN11.1
                                                                 BN15.1  BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN340
                                                                 BN345   BN350
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS10.1  BS12.1
                                                                 BS32.1