Entity Person Identification

DescriptionA set of identifiers (one or more) that are used to uniquely identify a person.

Attributes
Identification NumIdentification Num
JurisdictionJurisdiction
Registration TypeRegistration Type

Relationship
Person Identification_Person_FKPerson Identification_Person_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Identification Num
DescriptionAn alpha-numeric identifier for a person's registration.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Jurisdiction
DescriptionIndicates the entity responsible for granting a registration or certifying a credential.

For example:
State of California
AMA
CMMS
FDA
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Registration Type
DescriptionIndicates the kind of registration held.

For example:
Medical record number
Billing number
Birth registry
National unique individual identifier
Organization id
Canadian provincial healthcare number
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Person Identification_Person_FK
Is Identifying Relationshiptrue
Child TablePerson Identification
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE