Logical OperationSelection Criteria DescrSelection Criteria NameSelection Criteria SQL Txt
| Business Data Model Data Model |
| Description | A set of criteria that is used to select the items or members to form a group. For example: Age range is 35-45 and sex is male |
| Attributes | |
| Logical Operation |
|
| Selection Criteria Descr |
|
| Selection Criteria Name |
|
| Selection Criteria SQL Txt |
|
| Relationship | |
 Criterion Logical Group_Criterion Logical Group_FK |
|
| Group Selection Criteria_Group_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Logical Operation
| Description | Indicates a logical operation (i.e. and, or, exclusive or) applied to the child criteria to form the complete selection criteria. |
| 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 |
Selection Criteria Descr
| Description | A descriptive text that provides the details of the criteria that were applied. For example: None Status of control Age range 35 - 45 |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Selection Criteria Name
| Description | A name that is given to a group of criterion that is used as part of a selection process. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Selection Criteria SQL Txt
| Description | An SQL statement that can be used for selection. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Criterion Logical Group_Criterion Logical Group_FK
| Is Identifying Relationship | false |
| Child Table | Group Selection Criteria |
| Child Role Name | parent |
| 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 | Group Selection Criteria |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Group Selection Criteria_Group_FK
| Is Identifying Relationship | true |
| Child Table | Group Selection Criteria |
| 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 | Group |
| 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 |