Entity Organization Identifier

DescriptionInformation that is used to uniquely identify an organization. There can be multiple identifiers for the same organization.

For example:
Tax registration number
Company Registration Number

Attributes
Identification NumIdentification Num
Organization Identifier TypeOrganization Identifier Type
Primary IndPrimary Ind

Relationship
Organization Identifier_Organization_FKOrganization Identifier_Organization_FK
assigningSystemOfRecordassigningSystemOfRecord

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Identification Num
DescriptionA code or reference number used to uniquely identify an organization.

For example:
Tax registration number
Company Registration Number
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Identifier Type
DescriptionIndicates the nature of the organization identifier.

For example:
Tax registration number
Company Registration Number
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Ind
DescriptionIndicates whether this is the main or principal identifier for an organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Organization Identifier_Organization_FK
Is Identifying Relationshiptrue
Child TableOrganization Identifier
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



 assigningSystemOfRecord
Is Identifying Relationshipfalse
Child TableOrganization Identifier
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSystem Of Record
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE