| Business Data Model Data Model |
| Description | A grouping of codes that associates codes to a specific version number. It also is used to identify the dates on which the code types were entered and became available for use, as well as when they are no longer available for current use. It references the publisher or "system of record" that defines the type of codes being named (for example, "diagnostic codes" may be published by the "World Health Organization"). |
| Attributes | |
Code Version Num |
|
Version Descr |
|
| Relationship | |
Code Version_Domain Code_FK |
|
Code Version_Terminology Originator_FK |
|
Code Version_Standard Publisher_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Code Version Num
| Description | The designation of a unique set of codes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Version Descr
| Description | The description or explanation of a code domain. This is to more fully describe the "Code Type" which may be an abbreviation or acronym. |
| 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 |
| Relationship Details |
Code Version_Domain Code_FK
| Is Identifying Relationship | false |
| Child Table | Coding System Version |
| Child Role Name | has domain |
| 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 | Code Domain |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Code Version_Terminology Originator_FK
| Is Identifying Relationship | false |
| Child Table | Coding System Version |
| Child Role Name | is created by |
| 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 | Terminology Author |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Code Version_Standard Publisher_FK
| Is Identifying Relationship | false |
| Child Table | Coding System Version |
| Child Role Name | has publisher |
| 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 | Standard Publisher |
| 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 |