CodeCode Source IndCode Source Value TxtCommon Code Status ReasonDescrDescription Full DescrStatus Ind
| Business Data Model Data Model |
| Description | The set of unified standard codes used for reporting and application purposes. |
| Attributes | |
| Code |
|
| Code Source Ind |
|
| Code Source Value Txt |
|
| Common Code Status Reason |
|
| Descr |
|
| Description Full Descr |
|
| Status Ind |
|
| Relationship | |
 Common Code_Code Version_FK |
|
| Common Code_Common Code_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Code
| Description | The actual Code for which this record exists. |
| 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 |
Code Source Ind
| Description | Indicates whether the Common Code is purchased from a Code Publisher or added to the domain. |
| 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 |
Code Source Value Txt
| Description | The non-purchased value of the code (Proxy) that was added to extend the specific code set. |
| 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 |
Common Code Status Reason
| Description | Identifies the reason for the current status of a code. For example, why a code has been made inactive. |
| 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 |
Descr
| Description | The description of this Code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Description Full Descr
| Description | The full (extended) description for the code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Status Ind
| Description | An indicator that shows whether a code is active and available to be mapped or inactive and carried for compatibility with an earlier version. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Common Code_Code Version_FK
| Is Identifying Relationship | false |
| Child Table | Common Code |
| Child Role Name | has 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 |
Common Code_Common Code_FK
| Description | The association between one Common Code to another. Reasons can include; NHSN associations. |
| Is Identifying Relationship | false |
| Child Table | Common Code |
| 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 | Common Code |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |