Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (9) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Referring_Provider_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. |
(12) | EntryName | [dbo].[name] | 255 | NOT NULL | | | EntryName (sometimes firstname + lastname). Some clients do not use the dedicated first and lastname boxes in the app and instead just write them both here. Our code falls back to entryname if first/last fields aren't used. |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
(4)![Check Constraints CK_Referring_Provider_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Referring_Provider_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
![Check Constraints CK_Referring_Provider_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Referring_Provider_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(12)![Check Constraints CK_Referring_Provider_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Referring_Provider_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
| EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
| PhoneArea | smallint | 2 | NOT NULL | | (0) | 3 digit phone area |
| PhoneExchange | smallint | 2 | NOT NULL | | (0) | 3 digit phone exchange |
| PhoneLast4 | smallint | 2 | NOT NULL | | (0) | last 4 digits of phone number |
| PhoneExtension | [dbo].[extension] | 5 | NOT NULL | | ('') | phone extension |
| PhoneInternational | [dbo].[int_phone] | 21 | NOT NULL | | ('') | For international phone numbers |
| AddressLine1 | varchar(255) | 255 | NULL allowed | | ('') | Providers address |
| AddressLine2 | varchar(255) | 255 | NULL allowed | | ('') | Extra address field |
| 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 |
| Country | varchar(30) | 30 | NOT NULL | | ('') | Country |
| County | varchar(35) | 35 | NOT NULL | | ('') | County |
| FaxArea | smallint | 2 | NOT NULL | | (0) | 3 digit Fax Area Code |
| FaxExchange | smallint | 2 | NOT NULL | | (0) | 3 digit Fax Exchange |
| FaxLast4 | smallint | 2 | NOT NULL | | (0) | last 4 digits of fax number |
| FaxExtension | [dbo].[extension] | 5 | NOT NULL | | ('') | fax extension |
| FaxInternational | [dbo].[int_phone] | 21 | NOT NULL | | ('') | international fax number |
 ![Foreign Keys FK_Referring_Provider_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDE Foreign Keys FK_Referring_Provider_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDE](../../../../Images/fk.png) | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Specialty. Key to the Specialty_DE table |
 | LastName | varchar(35) | 35 | NOT NULL | | ('') | Providers last name, not required in app as it will use entryname if this isn't set |
 | FirstName | varchar(35) | 35 | NOT NULL | | ('') | Providres first name, not required in app as it will use entryname if this isn't set. |
 | MiddleName | varchar(35) | 35 | NOT NULL | | ('') | Providers middle name, not required |
| SuffixName | varchar(18) | 18 | NOT NULL | | ('') | name suffex, for example Sr. or Jr. |
| PrefixName | varchar(18) | 18 | NOT NULL | | ('') | name prefix |
| AddressLine3 | varchar(35) | 35 | NOT NULL | | ('') | Another extra address field |
| LinkedProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Link to the corresponding Provider (if there is one). |
 | DistributionTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Distribution Type for print/fax/task CC type. Link to Distribution_Type_DE.ID. |
 | NPI | varchar(10) | 10 | NOT NULL | | ('') | 10 digit NPI number (National Provider Identifier). |
| EmailAddress | varchar(255) | 255 | NOT NULL | | ('') | Email Address |
![Check Constraints CK_Referring_Provider_DE_IsPracticeFLAG_Yes_Or_No : ([IsPracticeFLAG]='N' OR [IsPracticeFLAG]='Y') Check Constraints CK_Referring_Provider_DE_IsPracticeFLAG_Yes_Or_No : ([IsPracticeFLAG]='N' OR [IsPracticeFLAG]='Y')](../../../../Images/c-constraint.png) | IsPracticeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is this an entry for a practice instead of an individual provider? |
![Check Constraints CK_Referring_Provider_DE_IsAgencyFLAG_Yes_Or_No : ([IsAgencyFLAG]='N' OR [IsAgencyFLAG]='Y') Check Constraints CK_Referring_Provider_DE_IsAgencyFLAG_Yes_Or_No : ([IsAgencyFLAG]='N' OR [IsAgencyFLAG]='Y')](../../../../Images/c-constraint.png) | IsAgencyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is this an entry for an agency instead of an individual provider? |
![Foreign Keys FK_Referring_Provider_DE_SexDE: [dbo].[Sex_DE].SexDE Foreign Keys FK_Referring_Provider_DE_SexDE: [dbo].[Sex_DE].SexDE](../../../../Images/fk.png) | SexDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Gender. Key to the Sex_DE table. |
| LanguageDEList | varchar(255) | 255 | NOT NULL | | ('') | Languages spoken. List of Language_DE.ID values. |
| Mobile | varchar(25) | 25 | NOT NULL | | ('') | mobile phone number |
![Foreign Keys FK_Referring_Provider_DE_LinkedUserID: [dbo].[IDX_User].LinkedUserID Foreign Keys FK_Referring_Provider_DE_LinkedUserID: [dbo].[IDX_User].LinkedUserID](../../../../Images/fk.png) | LinkedUserID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Linked User (if there is one). Key to the IDX_User Table |
| CredentialDEList | varchar(255) | 255 | NOT NULL | | ('') | Credentials. Comma separated list of Credential_DE.ID values. |