BNCARRIER – Insurance Carrier

System
Benefits (BN)
Prefix
BCR
Primary key
INS-CARRIER
Fields
25
Updated by
1 program
Referenced by
6 programs

BNCARRIER is the Insurance Carrier table in Lawson Benefits (prefix BCR). It is indexed by INS-CARRIER (BCRSET1). It is related 1:1 to INSTCTRYCD. It is updated by BN01.1 and referenced by BN106, BN15.1, BN201, BN215, BN320 and BN331. The table has 25 fields, 1 index and 1 documented relation.

About BNCARRIER

The Insurance Carrier file contains information about insurance carriers. The Benefits system tracks insurance carriers for all benefit plans.

Fields (25)

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

Field / columnTypeDescription & valuesUpdated by
BCR-INS-CARRIER PK
INS_CARRIER		Alpha 4Contains the code that represents the insurer.BN01.1
BCR-CARRIER-ID
CARRIER_ID		Alpha 30 (Lower Case)Contains the insurer's identification number.BN01.1
BCR-NAME
NAME		Alpha 30 (Lower Case)Contains the insurer's name.BN01.1
BCR-ADDR1
ADDR1		Alpha 30 (Lower Case)Contains the first line of the insurer's address.BN01.1
BCR-ADDR2
ADDR2		Alpha 30 (Lower Case)Contains the second line of the insurer's address.BN01.1
BCR-ADDR3
ADDR3		Alpha 30 (Lower Case)Contains the third line of the insurer's address.BN01.1
BCR-ADDR4
ADDR4		Alpha 30 (Lower Case)Contains the fourth line of the insurer's address.BN01.1
BCR-CITY
CITY		Alpha 58 (Lower Case)Contains the city of the insurer's address.BN01.1
BCR-STATE
STATE		Alpha 2Contains the state of the insurer's address.BN01.1
BCR-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)Contains the postal code of the insurer's address.BN01.1
BCR-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the last name of the person to contact at the insurer.BN01.1
BCR-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the first name of the person to contact at the insurer.BN01.1
BCR-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the middle initial of the person to contact at the insurer.BN01.1
BCR-PHONE-COUNTRY
PHONE_COUNTRY		Alpha 6Contains the prefix of the insurer's telephone number.BN01.1
BCR-PHONE-NUMBER
PHONE_NUMBER		Alpha 15Contains the insurer's telephone number.BN01.1
BCR-PHONE-EXT
PHONE_EXT		Alpha 5Contains the extension of the insurer's telephone number.—
BCR-FAX-COUNTRY
FAX_COUNTRY		Alpha 6Contains the prefix of the insurer's fax number.BN01.1
BCR-FAX-NUMBER
FAX_NUMBER		Alpha 15Contains the insurer's fax number.BN01.1
BCR-FAX-EXT
FAX_EXT		Alpha 5Contains the extension of the insurer's fax number.—
BCR-TELEX-NUMBER
TELEX_NUMBER		Alpha 15Contains the insurer's telex number.BN01.1
BCR-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)Contains comment text about the insurer.BN01.1
BCR-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN01.1
BCR-ENTITY-TYPE
ENTITY_TYPE		Numeric 1—
  • 1 Carrier
  • 2 Broker or Sales Office
  • 3 Third Party Admin
BN01.1
BCR-HIPAA-ID-TYPE
HIPAA_ID_TYPE		Numeric 1—
  • 1 Federal ID
  • 2 HIPAA ID
  • 3 Other
BN01.1
BCR-CONTRACT-NMBR
CONTRACT_NMBR		Alpha 30—BN01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BCRSET1INS-CARRIERPrimaryBN01.1, BN106, BN15.1, BN201, BN215, BN320, BN331

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CountryINSTCTRYCDRequiredWhen (BCR-COUNTRY-CODE != Spaces)BCR-COUNTRY-CODE → INT-COUNTRY-CODE

Programs

Updated by (1)

Referenced by (6)