Entity Randomization Book Entry / Stratum Group

DescriptionAn association between a randomization book entry and a stratum group.

Attributes
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Load Info SkLoad Info Sk
Randomization Book Entry SkRandomization Book Entry Sk
Relationship Type Code SkRelationship Type Code Sk
Source Code SkSource Code Sk
Stratum Group SkStratum Group Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Randomization Book Entry / Stratum Group_Randomization Book Entry_FKRandomization Book Entry / Stratum Group_Randomization Book Entry_FK
Randomization Book Entry / Stratum Group_Stratum Group_FKRandomization Book Entry / Stratum Group_Stratum Group_FK

Primary Key
Randomization Book Entry / Stratum Group PKRandomization Book Entry / Stratum Group PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Randomization Book Entry Sk
DescriptionSurrogate key for the anchor entity.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Relationship Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Stratum Group Sk
DescriptionSurrogate key for the anchor entity.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Randomization Book Entry / Stratum Group_Randomization Book Entry_FK
Is Identifying Relationshiptrue
Child TableRandomization Book Entry / Stratum Group
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableRandomization Book Entry
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Randomization Book Entry / Stratum Group_Stratum Group_FK
Is Identifying Relationshiptrue
Child TableRandomization Book Entry / Stratum Group
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableStratum Group
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Randomization Book Entry / Stratum Group PK
Key AttributeRandomization Book Entry Sk
Key AttributeStratum Group Sk
Key AttributeRelationship Type Code Sk
Key AttributeValid From Ts