Tables [dbo].[Business_Entity]
Business Entities. these include organizations, employers, and payers.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Business_Entity_ID: IDIDnumeric(8,0)5NOT NULL1 - 1Key to the Business_Entity table.
Indexes XAK2Business_EntityCode[dbo].[code]10NOT NULLCode for the business entity
Indexes XAK1Business_EntityNamevarchar(60)60NOT NULLname
Indexes TWstat_Business_Entity_AddressLine1AddressLine1varchar(35)35NOT NULLAddress line 1
Indexes TWstat_Business_Entity_AddressLine2AddressLine2varchar(35)35NOT NULL(' ')Address Linwe 2
Indexes TWstat_Business_Entity_CityCityvarchar(35)35NOT NULL(' ')City
Indexes TWstat_Business_Entity_StateStatevarchar(15)15NOT NULL(' ')State
Indexes TWstat_Business_Entity_ZipCodeZipCodechar(10)10NOT NULL(' ')Zip Code
Indexes TWstat_Business_Entity_ZipCodeInternationalZipCodeInternationalvarchar(14)14NOT NULL(' ')International Zip Code
Indexes TWstat_Business_Entity_CountyCountyvarchar(35)35NOT NULL(' ')County
Indexes TWstat_Business_Entity_CountryCountryvarchar(35)35NOT NULL(' ')Country
Indexes TWstat_Business_Entity_TaxIDTaxIDvarchar(20)20NOT NULL(' ')Tax Identification number
Indexes TWstat_Business_Entity_PhoneAreaPhoneAreasmallint2NOT NULL(0)Area Code
Indexes TWstat_Business_Entity_PhoneExchangePhoneExchangesmallint2NOT NULL(0)Phone Exchange
Indexes TWstat_Business_Entity_PhoneLast4PhoneLast4smallint2NOT NULL(0)Last 4 digits of the phone number
Indexes TWstat_Business_Entity_PhoneExtensionPhoneExtensionchar(5)5NOT NULL(' ')Phone number extension
PhoneInternationalvarchar(21)21NOT NULL(' ')International phone number
Indexes TWstat_Business_Entity_FaxAreaFaxAreasmallint2NOT NULL(0)Fax area code
Indexes TWstat_Business_Entity_FaxExchangeFaxExchangesmallint2NOT NULL(0)Fax exchange
Indexes TWstat_Business_Entity_FaxLast4FaxLast4smallint2NOT NULL(0)Fax last 4 digits
Indexes TWstat_Business_Entity_FaxExtensionFaxExtensionchar(5)5NOT NULL(' ')Fax number extension
FaxInternationalvarchar(21)21NOT NULL(' ')international fax number
Indexes TWstat_Business_Entity_ContactLastNameContactLastNamevarchar(35)35NOT NULL(' ')Contact last name
Indexes TWstat_Business_Entity_ContactFirstNameContactFirstNamevarchar(18)18NOT NULL(' ')Contact first anme
Indexes TWstat_Business_Entity_ContactTitleNameContactTitleNamevarchar(20)20NOT 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')EntityTypechar(2)2NOT NULLEntity Type (EN - Enterprise, EX - External Organization, IN - Internal Organization, EM - Employer, PA - Payer)
URLvarchar(255)255NULL allowedURL for the business entity