User Selection Criteria IdUser Selection Criteria SeqUser Selection Criteria Value Txt
| Business Data Model Data Model |
| Description | An association between a user selection and selection template criteria. It is an option selected from one of the criteria included in the pre-defined selection template for use in the user modified report or view. For example: The rounds template includes five criteria for use on the report or view but the user only chooses to include two of the criteria and only specific values for each of the criteria. |
| Attributes | |
| User Selection Criteria Id |
|
| User Selection Criteria Seq |
|
| User Selection Criteria Value Txt |
|
| Relationship | |
 User Selection Criteria_Selection Template Criteria_FK |
|
| User Selection Criteria_User Selection_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
User Selection Criteria Id
| Description | A number that uniquely identifies the report or view selection criteria selected by the user. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
User Selection Criteria Seq
| Description | A number identifying the order in which a single user template selection criteria value is selected. The first criteria selected has a sequence number of one, the second a value of two, and so on. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
User Selection Criteria Value Txt
| Description | A default value that the user selects for the report or view criteria. For example: ICU - Unit ALL - All units |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
User Selection Criteria_Selection Template Criteria_FK
| Is Identifying Relationship | true |
| Child Table | User Selection Criteria |
| Child Role Name | is selected from |
| 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 | Selection Template Criteria |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
User Selection Criteria_User Selection_FK
| Is Identifying Relationship | true |
| Child Table | User Selection Criteria |
| 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 | User Selection |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |