Entity Organization Attributes

DescriptionA generic construct that is used to store additional attributes that describe an organization.

Attributes
Attribute CodeAttribute Code
Attribute PurposeAttribute Purpose
Attribute Value TxtAttribute Value Txt

Relationship
Organization Attributes_Organization_FKOrganization Attributes_Organization_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Attribute Code
DescriptionIdentifies the attribute associated with an organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Attribute Purpose
DescriptionIndicates the reason an organization uses a specific attribute.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Attribute Value Txt
DescriptionTextual representation of the value of a specific attribute for an organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Organization Attributes_Organization_FK
Is Identifying Relationshiptrue
Child TableOrganization Attributes
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE