Business Data Model Data Model

Entity

Entity User

Description

A party role that describes a person who has been registered with an organization, has received a unique identifier and password to authorize a defined set of system access permissions.

Attributes
User Job Title
User Login Name
User Num
User Type

Relationship
User_Tenant_FK
User_Organization_FK
User_Business Role_FK
User_Patient Tag_FK
User_Patient Tag_FK1
User_Patient Tag_FK2
User_Encounter_FK
User_Patient Tag_FK3
User_Patient Tag_FK4
User_Patient Tag_FK5
User_Encounter_FK1

Generalization
Generalization1

Dependencies
NONE

Reverse Dependencies

Attribute Details

User Job Title

Description	A brief description or name of the job position held by the user. For example: Manager of Quality Services Quality Analyst
Data Type	Standards - Data Domains.ddm/Data Domains/Job Title Short [VARCHAR(128)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

User Login Name

Description	The user's login identifier.
Data Type	Standards - Data Domains.ddm/Data Domains/Login Name [VARCHAR(75)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

User Num

Description	The identifier that uniquely identifies the user.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

User Type

Description	Indicates whether the user is an Internal User or an External User.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

User_Tenant_FK

Is Identifying Relationship	true
Child Table	User
Child Role Name	has registered
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Tenant
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Organization_FK

Is Identifying Relationship	false
Child Table	User
Child Role Name	is part of
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Business Role_FK

Is Identifying Relationship	false
Child Table	User
Child Role Name	play
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Business Role
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK

Is Identifying Relationship	false
Child Table	User
Child Role Name	assigned by
Child Multiplicity	ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK1

Is Identifying Relationship	false
Child Table	User
Child Role Name	updated by
Child Multiplicity	ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK2

Is Identifying Relationship	false
Child Table	User
Child Role Name	deleted by
Child Multiplicity	ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Encounter_FK

Is Identifying Relationship	false
Child Table	User
Child Role Name	other
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK3

Is Identifying Relationship	false
Child Table	User
Child Role Name	assigned by
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK4

Is Identifying Relationship	false
Child Table	User
Child Role Name	assigned
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Patient Tag_FK5

Is Identifying Relationship	false
Child Table	User
Child Role Name	updated
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Tag
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

User_Encounter_FK1

Is Identifying Relationship	false
Child Table	User
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Generalization Details

Generalization1

Supertype	Party Role
Subtype	User
Transform As	TABLE

Overview

Top

Package

Entity

Business Data Model Data Model