BNCARRIER FILE
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 BN201 BN215 BN320 BN331
UPDATED BY
BN01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCR-INS-CARRIER Alpha 4 BN01.1
Element: Insurance CarrContains the code that represents the
insurer.
BCR-CARRIER-ID Alpha 30 (Lower Case) BN01.1
Ins. Carrier Contains the insurer's identification
Identification number.
BCR-NAME Alpha 30 (Lower Case) BN01.1
Element: Ins. Carrier NContains the insurer's name.
BCR-ADDR1 Alpha 30 (Lower Case) BN01.1
Element: Address 1 Contains the first line of the
insurer's address.
BCR-ADDR2 Alpha 30 (Lower Case) BN01.1
Element: Address 2 Contains the second line of the
insurer's address.
BCR-ADDR3 Alpha 30 (Lower Case) BN01.1
Element: Address 3 Contains the third line of the
insurer's address.
BCR-ADDR4 Alpha 30 (Lower Case) BN01.1
Element: Address 4 Contains the fourth line of the
insurer's address.
BCR-CITY Alpha 18 (Lower Case) BN01.1
Element: City Contains the city of the insurer's
address.
BCR-STATE Alpha 2 BN01.1
Element: State or ProviContains the state of the insurer's
address.
BCR-POSTAL-CODE Alpha 10 (Lower Case) BN01.1
Element: Postal Code Contains the postal code of the
insurer's address.
BCR-LAST-NAME Alpha 30 (Lower Case) BN01.1
Element: Last Name Contains the last name of the person to
contact at the insurer.
BCR-FIRST-NAME Alpha 15 (Lower Case) BN01.1
Element: First Name Contains the first name of the person
to contact at the insurer.
BCR-MIDDLE-INIT Alpha 1 BN01.1
Element: Middle InitialContains the middle initial of the
person to contact at the insurer.
BCR-PHONE-COUNTRY Alpha 6 BN01.1
Telephone Country Contains the prefix of the insurer's
Code telephone number.
BCR-PHONE-NUMBER Alpha 15 BN01.1
Element: Telephone NumbContains the insurer's telephone number.
BCR-PHONE-EXT Alpha 5
Element: Telephone ExteContains the extension of the insurer's
telephone number.
BCR-FAX-COUNTRY Alpha 6 BN01.1
Telephone Country Contains the prefix of the insurer's
Code fax number.
BCR-FAX-NUMBER Alpha 15 BN01.1
Element: Telephone NumbContains the insurer's fax number.
BCR-FAX-EXT Alpha 5
Element: Telephone ExteContains the extension of the insurer's
fax number.
BCR-TELEX-NUMBER Alpha 15 BN01.1
Element: Telephone NumbContains the insurer's telex number.
BCR-CMT-TEXT Alpha 60 (Lower Case) BN01.1
Element: Comment Text Contains comment text about the insurer.
BCR-COUNTRY-CODE Alpha 2 BN01.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BCR-ENTITY-TYPE Numeric 1 BN01.1
Element: Entity Type Bn1 = Carrier
2 = Broker or Sales Office
3 = Third Party Admin
BCR-HIPAA-ID-TYPE Numeric 1 BN01.1
Element: Hipaa Id Type 1 = Federal ID
2 = HIPAA ID
3 = Other
BCR-CONTRACT-NMBR Alpha 30 BN01.1
Element: Contract
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Country INSTCTRYCD Required
When (BCR-COUNTRY-CODE != Spaces )
BCR-COUNTRY-CODE -> INT-COUNTRY-CODE
|
