| Atomic Warehouse 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 |
| Relationship | |
 Product Category_Coding System Version_FK |
|
| Primary Key | |
 Procedure Category PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Coding System Version Sk
| Description | The Version for a set of related codes. This exists to make it easier to produce a list of current valid codes, or in conjunction with the relative dates find the correct Version of a set of codes that was valid at a point in time. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Inpatient Ind
| Description | An indicator stating if 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 |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Multiple
| Description | Multiple refers to the possibility that a given procedure category may actually consist of multiple procedures for a given patient. In that case, when doing the procedure forms for denominator purposes, the IP would need to fill out multiple procedures for the given surgery case. For example, a knee prosthesis procedure category could require two procedure forms IF both knees were replaced. Assumption is that the actual number is the MAXIMUM number of procedures that may be done 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 Nm
| 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 stating if 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 Cd
| Description | Categorizes a procedure as defined by a regulatory / monitoring body such as NHSN. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |
Procedure Category Sk
| Description | The generated unique key for a Procedure Category. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Product Category_Coding System Version_FK
| Is Identifying Relationship | false |
| Child Table | Procedure Category |
| Child Role Name | is of version |
| 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 |
| Primary Key Details |
Procedure Category PK
| Key Attribute | Procedure Category Sk |
| Atomic Warehouse Model Data Model |