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
BN15.1 BN201 BN215 BN331
UPDATED BY
BN01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCR-INS-CARRIER Alpha 4 BN01.1
Insurance Carrier Contains 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
Ins. Carrier Name Contains the insurer's name.
BCR-ADDR1 Alpha 30 (Lower Case) BN01.1
Address 1 Contains the first line of the
insurer's address.
BCR-ADDR2 Alpha 30 (Lower Case) BN01.1
Address 2 Contains the second line of the
insurer's address.
BCR-ADDR3 Alpha 30 (Lower Case) BN01.1
Address 3 Contains the third line of the
insurer's address.
BCR-ADDR4 Alpha 30 (Lower Case) BN01.1
Address 4 Contains the fourth line of the
insurer's address.
BCR-CITY Alpha 18 (Lower Case) BN01.1
City Contains the city of the insurer's
address.
BCR-STATE Alpha 2 BN01.1
State or Province Contains the state of the insurer's
address.
BCR-POSTAL-CODE Alpha 10 (Lower Case) BN01.1
Postal Code Contains the postal code of the
insurer's address.
BCR-LAST-NAME Alpha 30 (Lower Case) BN01.1
Last Name Contains the last name of the person to
contact at the insurer.
BCR-FIRST-NAME Alpha 15 (Lower Case) BN01.1
First Name Contains the first name of the person
to contact at the insurer.
BCR-MIDDLE-INIT Alpha 1 BN01.1
Middle Initial Contains 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
Telephone Number Contains the insurer's telephone number.
BCR-PHONE-EXT Alpha 5
Telephone Extension Contains the extension of the insurer's
telephone number.
BCR-FAX-COUNTRY Alpha 6 BN01.1
Fax Country Contains the prefix of the insurer's
fax number.
BCR-FAX-NUMBER Alpha 15 BN01.1
Fax Number Contains the insurer's fax number.
BCR-FAX-EXT Alpha 5
Fax Extension Contains the extension of the insurer's
fax number.
BCR-TELEX-NUMBER Alpha 15 BN01.1
Telex Number Contains the insurer's telex number.
BCR-CMT-TEXT Alpha 60 (Lower Case) BN01.1
Comment Text Contains comment text about the insurer.
BCR-COUNTRY-CODE Alpha 2 BN01.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BNCARRIER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCRSET1 INS-CARRIER BN01.1 BN15.1
BN201 BN215
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
|
