Tables [dbo].[Encounter_Employer_Contact]
Employer Contacts for an Occupational Medicine Encounter
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Encounter_Employer_Contact: EncounterEmployerID\EmployerContactTypeDEForeign Keys FK_Encounter_Employer_Contact_EncounterEmployerID: [dbo].[Encounter_Employer].EncounterEmployerIDEncounterEmployerID[dbo].[uniqueid]9NOT NULLEmployer. Link to Encounter_Employer.ID
Cluster Primary Key PK_Encounter_Employer_Contact: EncounterEmployerID\EmployerContactTypeDEForeign Keys FK_Encounter_Employer_Contact_EmployerContactTypeDE: [dbo].[Employer_Contact_Type_DE].EmployerContactTypeDEEmployerContactTypeDE[dbo].[dict_id]5NOT NULL((0))Contact Type. Link to Employer_Contact_Type_DE.ID
ContactNamevarchar(40)40NOT NULLContact full name
ContactPhoneAreasmallint2NOT NULL((0))Contact phone number area code
ContactPhoneExchangesmallint2NOT NULL((0))Contact phone number exchange
ContactPhoneLast4smallint2NOT NULL((0))Contact phone number last 4 digits
ContactPhoneExtensionvarchar(10)10NOT NULL('')Contact phone number extension
ContactFaxAreasmallint2NOT NULL((0))Contact Fax number area code
ContactFaxExchangesmallint2NOT NULL((0))Contact Fax number exchange
ContactFaxLast4smallint2NOT NULL((0))Contact Fax number last 4 digits
ContactEmailvarchar(80)80NOT NULL('')Contact Email address