Entity Selection Template

DescriptionA pre-defined plan that is used to generate a report or view. It includes metadata to describe the criteria a user may choose to be included in the report as well as metadata to map the source data fields to the user interface and to build a query to populate the user interface selections.

For example:
A template used to produce a rounds report for hospital staff when conducting their patient rounds.

Attributes
Template Edit CodeTemplate Edit Code
Template IdTemplate Id
Template Share TypeTemplate Share Type
Template TypeTemplate Type
Template Type DescrTemplate Type Descr

Relationship
Selection Template_Tenant_FKSelection Template_Tenant_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Template Edit Code
DescriptionIdentifies how a template may be edited or copied.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Template Id
DescriptionA number that uniquely identifies the selection template.
Data TypeStandards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Template Share Type
DescriptionIndicates how the selection template can be shared.

For example:
Anywhere 
Specific facility or organization
Particular applications
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Template Type
DescriptionIndicates the nature of a selection template.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Template Type Descr
DescriptionA word or phrase that describes the nature of a selection template.

For example:
Facility
Diagnosis
Rounds
Alert
Diagnostic report
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Selection Template_Tenant_FK
Is Identifying Relationshiptrue
Child TableSelection Template
Child Role Nameis defined by / for
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableTenant
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE