Entity Column

DescriptionA data element or attribute that can be accessed by a user from an application.

Attributes
Column DescrColumn Descr
Column LabelColumn Label
Column NameColumn Name
Column PHI ClassColumn PHI Class

Relationship
Column_Object_FKColumn_Object_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Column Descr
DescriptionDescription of the column.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Column Label
DescriptionAn alternative, more descriptive name of the column. Name of the logical model attribute from which the column in physical table was transformed can be used.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Column Name
DescriptionThe name of the physical column as created in the target database.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Column PHI Class
DescriptionIndicates the default privacy classification according to PHI regardless the business role or application accessing the column.

For example:
an identifier
health information
neither
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Column_Object_FK
Is Identifying Relationshipfalse
Child TableColumn
Child MultiplicityONE_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableObject
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE