Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | numeric(8,0) | 5 | NOT NULL | 1 - 1 | | Key to the Business_Entity table. |
 | Code | [dbo].[code] | 10 | NOT NULL | | | Code for the business entity |
 | Name | varchar(60) | 60 | NOT NULL | | | name |
 | AddressLine1 | varchar(35) | 35 | NOT NULL | | | Address line 1 |
 | AddressLine2 | varchar(35) | 35 | NOT NULL | | (' ') | Address Linwe 2 |
 | City | varchar(35) | 35 | NOT NULL | | (' ') | City |
 | State | varchar(15) | 15 | NOT NULL | | (' ') | State |
 | ZipCode | char(10) | 10 | NOT NULL | | (' ') | Zip Code |
 | ZipCodeInternational | varchar(14) | 14 | NOT NULL | | (' ') | International Zip Code |
 | County | varchar(35) | 35 | NOT NULL | | (' ') | County |
 | Country | varchar(35) | 35 | NOT NULL | | (' ') | Country |
 | TaxID | varchar(20) | 20 | NOT NULL | | (' ') | Tax Identification number |
 | PhoneArea | smallint | 2 | NOT NULL | | (0) | Area Code |
 | PhoneExchange | smallint | 2 | NOT NULL | | (0) | Phone Exchange |
 | PhoneLast4 | smallint | 2 | NOT NULL | | (0) | Last 4 digits of the phone number |
 | PhoneExtension | char(5) | 5 | NOT NULL | | (' ') | Phone number extension |
| PhoneInternational | varchar(21) | 21 | NOT NULL | | (' ') | International phone number |
 | FaxArea | smallint | 2 | NOT NULL | | (0) | Fax area code |
 | FaxExchange | smallint | 2 | NOT NULL | | (0) | Fax exchange |
 | FaxLast4 | smallint | 2 | NOT NULL | | (0) | Fax last 4 digits |
 | FaxExtension | char(5) | 5 | NOT NULL | | (' ') | Fax number extension |
| FaxInternational | varchar(21) | 21 | NOT NULL | | (' ') | international fax number |
 | ContactLastName | varchar(35) | 35 | NOT NULL | | (' ') | Contact last name |
 | ContactFirstName | varchar(18) | 18 | NOT NULL | | (' ') | Contact first anme |
 | ContactTitleName | varchar(20) | 20 | NOT NULL | | (' ') | Contact Title |
![Check Constraints CK_Business_Entity_EntityType_Business_Types : ([EntityType]='PA' OR [EntityType]='EM' OR [EntityType]='IN' OR [EntityType]='EX' OR [EntityType]='EN') Check Constraints CK_Business_Entity_EntityType_Business_Types : ([EntityType]='PA' OR [EntityType]='EM' OR [EntityType]='IN' OR [EntityType]='EX' OR [EntityType]='EN')](../../../../Images/c-constraint.png) | EntityType | char(2) | 2 | NOT NULL | | | Entity Type (EN - Enterprise, EX - External Organization, IN - Internal Organization, EM - Employer, PA - Payer) |
| URL | varchar(255) | 255 | NULL allowed | | | URL for the business entity |