Board Approval IndCore Competency IndSpecialtySpecialty Priority SeqSpecialty Type
| Business Data Model Data Model |
| Description | An association between a role player, a specialty, and a specialty type. It is used to indicate the specialties that a party may have. While this does not apply to all parties, it does pertain to many role player types. |
| Attributes | |
| Board Approval Ind |
|
| Core Competency Ind |
|
| Specialty |
|
| Specialty Priority Seq |
|
| Specialty Type |
|
| Relationship | |
 Practitioner has Specialty |
|
| Party Specialty Specialty Type FK |
|
| Party Specialty Specialty FK |
|
| Party Specialty_Role Player_FK |
|
| Role Player Specialty_Role Player_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Board Approval Ind
| Description | Indicates whether this practice specialty requires a board approval. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Core Competency Ind
| Description | Indicates whether or not this particular Specialty is considered to be a core competency for the party. For example: Many hospitals offer a wide range of services, but may consider Oncology to be a core competency, while Obstetrics, which they offer, is not. Many hospitals offer varying levels of Trauma care, but a Level 1 Trauma Care Facility considers that to be a core competency. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Specialty
| Description | Indicates the provider or practitioner's specialty. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Specialty Priority Seq
| Description | Indicates the relative significance or priority of the Practitioner's Specialty Code. A value of 1 indicates Primary. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Specialty Type
| Description | Indicates the type or rank of a practitioner's specialty. For example: Primary Secondary |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Practitioner has Specialty
| Is Identifying Relationship | false |
| Child Table | Party Specialty |
| Child Role Name | is specialty for |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Practitioner |
| Parent Role Name | has specialty |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Party Specialty Specialty Type FK
| Is Identifying Relationship | false |
| Child Table | Party Specialty |
| Child Role Name | has type |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Specialty Type |
| Parent Role Name | is type for |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Party Specialty Specialty FK
| Is Identifying Relationship | false |
| Child Table | Party Specialty |
| Child Role Name | has speciality |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Specialty |
| Parent Role Name | is speciality for |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Party Specialty_Role Player_FK
| Is Identifying Relationship | true |
| Child Table | Party Specialty |
| Child Role Name | is specialty |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Role Player |
| Parent Role Name | has sSpecialty |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Role Player Specialty_Role Player_FK
| Is Identifying Relationship | false |
| Child Table | Party Specialty |
| Child Role Name | is specialty of |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Role Player |
| Parent Role Name | has specialty |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |