Navigate to the Canadian Institute for Health Information home page

Logical Data Model

Logical Data Model (LDM) / Entity / Health Care Provider Organization Affiliation

Project:

Health Care Provider Organization Affiliation
Appears In: Care Team LDM Subject Area, Provider LDM Subject Area, CACDI LDM View, Provider Health Human Resource LDM Subject Area
The organizations for which a provider is affiliated with and the details pertaining to each affiliation.<br/>
  • Attributes
  • Associations To
  • Associations From
  • Constraints
Attribute Type
Health Care Provider Organization Affiliation Employee Identifier Identifier
Notes: The employee number or identifier assigned to a provider when affiliated with an organization.<br/>
Health Care Provider Organization Affiliation Type Code Codeable Concept
Notes: Specifies the type of affiliation for a health care provider (e.g. Network, Hospital, Practice).<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Status Code Codeable Concept
Notes: Indicates the current status of the affiliation with an organization (e.g. Active, Inactive, Suspended).<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Effective Date Date
Notes: The date when the affiliation of a health care provider with an organization started.<br/>
Health Care Provider Organization Affiliation Expiry Date Date
Notes: The date when the affiliation of a health care provider with an organization ended.<br/>
Health Care Provider Organization Affiliation Employment Category Code Codeable Concept
Notes: The category of employment of a health care provider with a specific organization (e.g. Permanent employee, Temporary employee, Self-employed, Provisional employment, etc.).<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Employment Funding Source Code Codeable Concept
Notes: The main funding source for each employment at the time of registration or renewal (e.g. Public, Private, Mix of public and private, etc.)<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Employment Agency Indicator Indicator
Notes: Indicates whether a health care provider is employed by a staffing agency at the time of registration or renewal.<br/>
Health Care Provider Organization Affiliation Employment Full Time Status Code Codeable Concept
Notes: The full time employment status of a health care provider at the time of data collection (e.g. Full time, Part time, Casual work).<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Employment Annual Earned Hours Integer
Notes: The total annual earned hours of work for each of the health care provider’s employments.<br/>Earned hours include worked and benefit hours for which the provider has received or will receive salaries.<br/>
Health Care Provider Organization Affiliation Employment Multiple Site Indicator Indicator
Notes: Indicates whether a health care provider works at more than one site for a single employer in a given employment.<br/>
Health Care Provider Organization Affiliation Employment Primary Virtual Care Proportion Code Codeable Concept
Notes: A coded concept that specifies the proportion of virtual care used to provide direct care at a provider’s primary site of practice. (e.g. More than 50% of the time, 10% to 49% of the time, Less than 10% of the time, Never, etc).<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Employment Primary Site Postal Code String
Notes: The 6-digit postal code assigned by Canada Post to the provider’s primary site of practice at the time of registration or renewal.<br/>
Health Care Provider Organization Affiliation Employment Site of Practice Indicator for Postal Code Indicator
Notes: Indicates whether the Primary Site Postal Code provided reflects the primary site of practice at the time of registration or renewal.<br/>
Health Care Provider Organization Affiliation Employment Primary Site Province or Territory Code Codeable Concept
Notes: The Canadian province or territory of the provider’s primary site of practice at the time of registration or renewal.<br/><br/>Value Set:<br/>To be developed.<br/>
Health Care Provider Organization Affiliation Employment Primary Site Country Code Codeable Concept
Notes: The country of the provider’s primary site of practice at the time of registration or renewal. <br/><br/>Value Set:<br/>To be developed.<br/>
Constraint
Unique Key: Health Care Provider, Organization, Health Care Provider Organization Affiliation Effective Date