Entity Code Domain

DescriptionThe domain name or "type" of a group or set of codes.

Attributes
Domain Column NameDomain Column Name
Domain DescrDomain Descr
Domain NameDomain Name
Mapping Required IndMapping Required Ind
Tenant Common Code Override IndTenant Common Code Override Ind

Relationship
Code Domain_Common Code_FKCode Domain_Common Code_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Domain Column Name
DescriptionThe name of the column that will be used to reference this Domains data throughout the model.

For example, if the Domain is "State" this column may have "State_Cd" as its value.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Domain Descr
DescriptionThe description or explanation of a code domain.  This is to more fully describe the "Domain Name" 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



 Domain Name
DescriptionA unique name for a group or type of codes, STATE might refer to data that defined State in the United States of America or Provinces in Canada.
Data TypeStandards - Data Domains.ddm/Data Domains/Domain Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Mapping Required Ind
DescriptionIndicates that this Domain requires mapping.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Common Code Override Ind
DescriptionIndicates whether a domain may have a Tenant Common Code override. This indicates that an overriding note or observation will be displayed/consumed in place of the one received in OBX-3 or UOM received in OBX-6.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Code Domain_Common Code_FK
Is Identifying Relationshipfalse
Child TableCode Domain
Child Role Namegroups
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCommon Code
Parent Role Namehas domain
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE