BNCARRIER

Insurance Carrier

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

REFERENCED BY
BN106 BN15.1 BN215 BN320 BN331 BN201


UPDATED BY
BN01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCR-INS-CARRIER
Element: Insurance Carrier
Alpha 4
Contains the code that represents the insurer.
BN01.1
BCR-CARRIER-ID
Ins. Carrier
Identification
Alpha 30 (Lower Case)
Contains the insurer's identification number.
BN01.1
BCR-NAME
Element: Ins. Carrier Name
Alpha 30 (Lower Case)
Contains the insurer's name.
BN01.1
BCR-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
Contains the first line of the insurer's address.
BN01.1
BCR-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
Contains the second line of the insurer's address.
BN01.1
BCR-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
Contains the third line of the insurer's address.
BN01.1
BCR-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
Contains the fourth line of the insurer's address.
BN01.1
BCR-CITY
Element: City
Alpha 18 (Lower Case)
Contains the city of the insurer's address.
BN01.1
BCR-STATE
Element: State
Alpha 2
Contains the state of the insurer's address.
BN01.1
BCR-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
Contains the postal code of the insurer's address.
BN01.1
BCR-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the last name of the person to contact at the insurer.
BN01.1
BCR-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the first name of the person to contact at the insurer.
BN01.1
BCR-MIDDLE-INIT
Element: Middle Initial
Alpha 1
Contains the middle initial of the person to contact at the insurer.
BN01.1
BCR-PHONE-COUNTRY
Element: Phone Country
Alpha 6
Contains the prefix of the insurer's telephone number.
BN01.1
BCR-PHONE-NUMBER
Element: Phone
Alpha 15
Contains the insurer's telephone number.
BN01.1
BCR-PHONE-EXT
Element: Phone Ext
Alpha 5
Contains the extension of the insurer's telephone number.
BCR-FAX-COUNTRY
Element: Phone Country
Alpha 6
Contains the prefix of the insurer's fax number.
BN01.1
BCR-FAX-NUMBER
Element: Phone
Alpha 15
Contains the insurer's fax number.
BN01.1
BCR-FAX-EXT
Element: Phone Ext
Alpha 5
Contains the extension of the insurer's fax number.
BCR-TELEX-NUMBER
Element: Phone
Alpha 15
Contains the insurer's telex number.
BN01.1
BCR-CMT-TEXT
Element: Comment Text
Alpha 60 (Lower Case)
Contains comment text about the insurer.
BN01.1
BCR-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN01.1
BCR-ENTITY-TYPE
Element: Entity Type Bn
Numeric 1

1 = Carrier
2 = Broker or Sales Office
3 = Third Party Admin
BN01.1
BCR-HIPAA-ID-TYPE
Element: Hipaa Id Type
Numeric 1

1 = Federal ID
2 = HIPAA ID
3 = Other
BN01.1
BCR-CONTRACT-NMBR
Element: Contract Nmbr
Alpha 30
BN01.1


BNCARRIER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCRSET1 INS-CARRIER
BN01.1 BN106
BN15.1 BN201
BN215 BN320
BN331


BNCARRIER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Country INSTCTRYCD Required
When (BCR-COUNTRY-CODE !=Spaces )
BCR-COUNTRY-CODE->INT-COUNTRY-CODE


File created: Thu Jun 09 11:09:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.