Tables [dbo].[Associated_Provider_Roles]
Roles a provider plays in a patients care. Used to define a Patient Care Team.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Associated_Provider_Roles_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to Associated_Provider_Roles table
Cluster Key CIX_Associated_Provider_Roles_PatientID_UserID: PatientID\UserIDForeign Keys FK_Associated_Provider_Roles_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Identifier. Link to Person.ID
ProviderID[dbo].[uniqueid]9NULL allowed((0))Provider Identifier.
When IsProviderFLAG= 'Y', Link to Person.ID                      
When IsProviderFLAG= 'N', Link to Referring_Provider_DE.ID                      
When IsProviderFLAG= 'E', Free Text members
Foreign Keys FK_Associated_Provider_Roles_Recipient_Type_DE: [dbo].[Recipient_Type_DE].RecipientTypeDERecipientTypeDE[dbo].[dict_id]5NOT NULLRecipient Type. Link to Recipient_Type_DE.ID
IsProviderFLAGchar(1)1NOT NULLY/N/E. Indicates the Provider Type
Cluster Key CIX_Associated_Provider_Roles_PatientID_UserID: PatientID\UserIDUserID[dbo].[uniqueid]9NOT NULLUser Identifier. Link to Person.ID
LastUpdatedDTTMdatetime8NULL allowedLast Updated Time
ParentID[dbo].[uniqueid]9NOT NULL((0))Added for establishing parent child hierarchy
Foreign Keys FK_Associated_Provider_Roles_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDERelationshipDE[dbo].[dict_id]5NOT NULL((0))Relationship. Link to Relationship_DE.ID
FreeTextRelationshipvarchar(50)50NOT NULL('')Description of relationship that is not there in the dictionary
Commentsvarchar(1000)1000NOT NULL('')Free text comments
RecordedDTTMdatetime8NOT NULL('01/01/1900')Record created date time
Check Constraints CK_Associated_Provider_Roles_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y')IsInactiveFlag[dbo].[BOOL]1NOT NULL('N')Y' if inactive, 'N' if Active
Foreign Keys FK_Associated_Provider_Roles_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NULL allowedSite. Link to Site_DE.ID
MemberLNamevarchar(255)255NOT NULL('')Free text member's(adhoc entry) Lastname
MemberFNamevarchar(255)255NOT NULL('')Free text member's FirstName
MemberMNamevarchar(20)20NOT NULL('')Free text member's Middle name
Foreign Keys FK_Associated_Provider_Roles_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULL((0))Specialty. Link to Specialty_DE.ID
AgencyNamevarchar(255)255NOT NULL('')To save the adhoc agency information
Address1varchar(255)255NOT NULL('')Address info of adhoc PCT (Patient Care Team) member
Address2varchar(255)255NOT NULL('')Address info of adhoc PCT (Patient Care Team) member
Cityvarchar(35)35NOT NULL('')Address info of adhoc PCT (Patient Care Team) member
Statechar(2)2NOT NULL('')Address info of adhoc PCT (Patient Care Team) member
Zipchar(10)10NOT NULL('')Address info of adhoc PCT (Patient Care Team) member
Phonevarchar(35)35NOT NULL('')Phone Number of adhoc PCT (Patient Care Team) member
Phone2varchar(35)35NOT NULL('')Phone Number of adhoc PCT (Patient Care Team) member
Faxvarchar(35)35NOT NULL('')Fax Number of adhoc PCT (Patient Care Team) member
Emailvarchar(255)255NOT NULL('')Email of adhoc PCT (Patient Care Team) member
Foreign Keys FK_Associated_Provider_Roles_PatientCareTeamDE_Patient_Care_Team_DE_ID: [dbo].[Patient_Care_Team_DE].PatientCareTeamDEPatientCareTeamDE[dbo].[dict_id]5NOT NULL('0')Patient Care Team. Link to Patient_Care_Team_DE.ID