Inpatient IndMultipleOperative Procedure NameOutpatient IndProcedure CategoryProcedure Category Descr
| Business Data Model Data Model |
| Description | The category of a procedure as defined by a regulatory or monitoring body such as the National Healthcare Safety Network (NHSN). For example: Abdominal aortic aneurysm repair Bile duct, liver or pancreatic surgery Appendix surgery |
| Attributes | |
| Inpatient Ind |
|
| Multiple |
|
| Operative Procedure Name |
|
| Outpatient Ind |
|
| Procedure Category |
|
| Procedure Category Descr |
|
| Relationship | |
 Procedure Category_Coding System Version_FK |
|
| Procedure Category_Preference Cart_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Inpatient Ind
| Description | An indicator that shows whether the NHSN patient is an inpatient. NHSN Inpatient: A patient whose date of admission to the healthcare facility and the date of discharge are different calendar days. NOTE: A patient who is admitted to an inpatient location as an "observation" patient is identified as an inpatient on the first and subsequent days for the purposes of counting a location's total patient days and device days. |
| 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 |
Multiple
| Description | The possibility that a given procedure category can consist of multiple procedures for a given patient. When completing the procedure forms for denominator purposes, the IP must complete multiple procedure forms for the given surgery case. For example: A knee prosthesis procedure category can require two procedure forms IF both knees were replaced. The assumption is that the number is the MAXIMUM number of procedures that can be completed for a given case. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Operative Procedure Name
| Description | Text description issued by a regulatory/monitoring body of a procedure which takes place during an operation. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Outpatient Ind
| Description | An indicator that shows whether the NHSN patient is an outpatient. NHSN outpatient: A patient whose date of admission to the healthcare facility and the date of discharge are the same day. |
| 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 |
Procedure Category
| Description | Categorizes a procedure as defined by a regulatory / monitoring body such as NHSN. |
| 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 |
Procedure Category Descr
| Description | Describes the procedure category. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Procedure Category_Coding System Version_FK
| Is Identifying Relationship | true |
| Child Table | Procedure Category |
| 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 | Coding System Version |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Procedure Category_Preference Cart_FK
| Is Identifying Relationship | false |
| Child Table | Procedure Category |
| 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 | Preference Card |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |