Approach Anatomic SiteApproach Anatomic Site LateralityName Code Modified TxtProcedure MethodTarget Anatomic SiteTarget Anatomic Site Laterality
| Business Data Model Data Model |
| Description | An activity defined at a global library level that is an action whose immediate and primary intention is the alteration of the physical condition of the subject, study subject or experimental unit. For example: Procedures may involve the disruption of some body surface (for example, an incision in a surgical procedure). Conservative procedures such as reduction of a luxated joint, including physiotherapy such as chiropractic treatment, massage, balneotherapy, acupuncture, shiatsu. |
| Attributes | |
| Approach Anatomic Site |
|
| Approach Anatomic Site Laterality |
|
| Name Code Modified Txt |
|
| Procedure Method |
|
| Target Anatomic Site |
|
| Target Anatomic Site Laterality |
|
| Relationship | |
 Defined Procedure_Product_FK |
|
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Approach Anatomic Site
| Description | Identifies the anatomic location or access point for an observation or procedure. Neither target anatomic site nor approach anatomic site is necessarily required or relevant for certain observations, however if either or both are present then the distinction between them is that the approach site is the access point for the measurement or observation and the target site is what is ultimately being evaluated. For example: Anus for a colonoscopy observation Arm for an injection Trans-abdominal for a nephrectomy |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Approach Anatomic Site Laterality
| Description | Specifies the side of the body (or a paired organ) that is an access point for an observation or procedure. For example: Bilateral Left Right |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Name Code Modified Txt
| Description | A character string that is a revision of the original text of the procedure to enable the coding of the text. For example: If the original text is "message", the Name Code Modified Text could be set to "massage", so that the text can be successfully coded. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Procedure Method
| Description | Identifies the technique that is used for the procedure. For example: Finger stick Veni puncture Abdominal/ ascites effusion Biopsy Bronchial alveolar lavage (BAL) Open Laparoscopic |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Target Anatomic Site
| Description | Specifies the anatomic location that is the focus of the observation, procedure, study or result. The target site of an observation result may be different than the target site of the observation that generated it. For instance, the target site of the observation may be broad (for example, skin) while the target site of the observation result is specific (for example, skin on chest). Multiple contiguous sites within the same organ system may be referenced. For example: Lower intestine Arm Breast Ovary Kidney |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Target Anatomic Site Laterality
| Description | Specifies the side of the body (or a paired organ) that is a target site for an observation. For example: Bilateral Left Right |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Defined Procedure_Product_FK
| Is Identifying Relationship | false |
| Child Table | Defined Procedure |
| 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 | Product |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Activity |
| Subtype | Defined Procedure |
| Transform As | TABLE |
| Business Data Model Data Model |