Entity Coding System Version

DescriptionA 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 NumCode Version Num
Version DescrVersion Descr

Relationship
Code Version_Domain Code_FKCode Version_Domain Code_FK
Code Version_Terminology Originator_FKCode Version_Terminology Originator_FK
Code Version_Standard Publisher_FKCode Version_Standard Publisher_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Code Version Num
DescriptionThe designation of a unique set of codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Version Descr
DescriptionThe description or explanation of a code domain. This is to more fully describe the "Code Type" which may be an abbreviation or acronym.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Code Version_Domain Code_FK
Is Identifying Relationshipfalse
Child TableCoding System Version
Child Role Namehas domain
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCode Domain
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Code Version_Terminology Originator_FK
Is Identifying Relationshipfalse
Child TableCoding System Version
Child Role Nameis created by
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableTerminology Author
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Code Version_Standard Publisher_FK
Is Identifying Relationshipfalse
Child TableCoding System Version
Child Role Namehas publisher
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStandard Publisher
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE