Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to Associated_Provider_Roles table |
 ![Foreign Keys FK_Associated_Provider_Roles_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Associated_Provider_Roles_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient Identifier. Link to Person.ID |
| ProviderID | [dbo].[uniqueid] | 9 | NULL 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].RecipientTypeDE Foreign Keys FK_Associated_Provider_Roles_Recipient_Type_DE: [dbo].[Recipient_Type_DE].RecipientTypeDE](../../../../Images/fk.png) | RecipientTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Recipient Type. Link to Recipient_Type_DE.ID |
| IsProviderFLAG | char(1) | 1 | NOT NULL | | | Y/N/E. Indicates the Provider Type |
 | UserID | [dbo].[uniqueid] | 9 | NOT NULL | | | User Identifier. Link to Person.ID |
| LastUpdatedDTTM | datetime | 8 | NULL allowed | | | Last Updated Time |
| ParentID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Added for establishing parent child hierarchy |
![Foreign Keys FK_Associated_Provider_Roles_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE Foreign Keys FK_Associated_Provider_Roles_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE](../../../../Images/fk.png) | RelationshipDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Relationship. Link to Relationship_DE.ID |
| FreeTextRelationship | varchar(50) | 50 | NOT NULL | | ('') | Description of relationship that is not there in the dictionary |
| Comments | varchar(1000) | 1000 | NOT NULL | | ('') | Free text comments |
| RecordedDTTM | datetime | 8 | NOT NULL | | ('01/01/1900') | Record created date time |
![Check Constraints CK_Associated_Provider_Roles_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y') Check Constraints CK_Associated_Provider_Roles_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y')](../../../../Images/c-constraint.png) | IsInactiveFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y' if inactive, 'N' if Active |
![Foreign Keys FK_Associated_Provider_Roles_SiteDE: [dbo].[Site_DE].SiteDE Foreign Keys FK_Associated_Provider_Roles_SiteDE: [dbo].[Site_DE].SiteDE](../../../../Images/fk.png) | SiteDE | [dbo].[dict_id] | 5 | NULL allowed | | | Site. Link to Site_DE.ID |
| MemberLName | varchar(255) | 255 | NOT NULL | | ('') | Free text member's(adhoc entry) Lastname |
| MemberFName | varchar(255) | 255 | NOT NULL | | ('') | Free text member's FirstName |
| MemberMName | varchar(20) | 20 | NOT NULL | | ('') | Free text member's Middle name |
![Foreign Keys FK_Associated_Provider_Roles_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDE Foreign Keys FK_Associated_Provider_Roles_SpecialtyDE: [dbo].[Specialty_DE].SpecialtyDE](../../../../Images/fk.png) | SpecialtyDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Specialty. Link to Specialty_DE.ID |
| AgencyName | varchar(255) | 255 | NOT NULL | | ('') | To save the adhoc agency information |
| Address1 | varchar(255) | 255 | NOT NULL | | ('') | Address info of adhoc PCT (Patient Care Team) member |
| Address2 | varchar(255) | 255 | NOT NULL | | ('') | Address info of adhoc PCT (Patient Care Team) member |
| City | varchar(35) | 35 | NOT NULL | | ('') | Address info of adhoc PCT (Patient Care Team) member |
| State | char(2) | 2 | NOT NULL | | ('') | Address info of adhoc PCT (Patient Care Team) member |
| Zip | char(10) | 10 | NOT NULL | | ('') | Address info of adhoc PCT (Patient Care Team) member |
| Phone | varchar(35) | 35 | NOT NULL | | ('') | Phone Number of adhoc PCT (Patient Care Team) member |
| Phone2 | varchar(35) | 35 | NOT NULL | | ('') | Phone Number of adhoc PCT (Patient Care Team) member |
| Fax | varchar(35) | 35 | NOT NULL | | ('') | Fax Number of adhoc PCT (Patient Care Team) member |
| Email | varchar(255) | 255 | NOT 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].PatientCareTeamDE Foreign Keys FK_Associated_Provider_Roles_PatientCareTeamDE_Patient_Care_Team_DE_ID: [dbo].[Patient_Care_Team_DE].PatientCareTeamDE](../../../../Images/fk.png) | PatientCareTeamDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Patient Care Team. Link to Patient_Care_Team_DE.ID |