Effective From DtEffective To DtLoad Info SkRelationship Type Code SkSource Code SkTenant SkUser Selection Criteria SeqUser Selection Criteria Value TxtUser Template Selection Criteria SkValid From TsValid To Ts
| Atomic Warehouse 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. |
| Relationship | |
 User Template Selection Criteria Detail_User Template Selection Criteria_FK |
|
| Primary Key | |
 User Template Selection Criteria Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Relationship Type Code Sk
| Description | Identifies the type of the relationship as defined in the business data model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [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 sequence 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, etc. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | true |
| 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 |
User Template Selection Criteria Sk
| Description | Surrogate key for the User Template Selection Criteria. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
User Template Selection Criteria Detail_User Template Selection Criteria_FK
| Is Identifying Relationship | false |
| Child Table | User Template Selection Criteria Detail |
| 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 Template Selection Criteria |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
User Template Selection Criteria Detail PK
| Key Attribute | User Template Selection Criteria Sk |
| Key Attribute | User Selection Criteria Seq |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |