OverviewTopPackageEntity
Dimensional Warehouse Model Data Model

Entity Recommended Treatment Program Dimension

DescriptionA recommended program that is composed of multiple steps that the practitioner or patient completes in the treatment of a particular problem or diagnosis.

For example:
Anger management program
Behavioral addiction program
Drug abuse program

Attributes
AWM Load Info SkAWM Load Info Sk
Current IndCurrent Ind
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Recommended Treatment Program BkRecommended Treatment Program Bk
Recommended Treatment Program CdRecommended Treatment Program Cd
Recommended Treatment Program Code SkRecommended Treatment Program Code Sk
Recommended Treatment Program DescrRecommended Treatment Program Descr
Recommended Treatment Program DkRecommended Treatment Program Dk
Recommended Treatment Program Life Cycle Status CdRecommended Treatment Program Life Cycle Status Cd
Recommended Treatment Program Life Cycle Status Code SkRecommended Treatment Program Life Cycle Status Code Sk
Recommended Treatment Program Life Cycle Status TsRecommended Treatment Program Life Cycle Status Ts
Recommended Treatment Program SkRecommended Treatment Program Sk
Source CdSource Cd
Source Code DescrSource Code Descr
Source Code SkSource Code Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Primary Key
Recommended Treatment Program Dimension PKRecommended Treatment Program Dimension PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

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


 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 DWM 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


 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


 Recommended Treatment Program Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Cd
DescriptionIndicates a specific recommended treatment program.
Data TypeStandards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Code Sk
DescriptionIndicates a specific recommended treatment program.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Descr
DescriptionThe description associated with the recommended treatment program.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue


 Recommended Treatment Program Life Cycle Status Cd
DescriptionIndicates the life cycle status of the recommended treatment program.

For example:
Active
Canceled
Inactive
Suspended
Data TypeStandards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Life Cycle Status Code Sk
DescriptionIndicates the life cycle status of the recommended treatment program.

For example:
Active
Canceled
Inactive
Suspended
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Life Cycle Status Ts
DescriptionThe effective date and time upon which the life cycle status of the recommended treatment program has changed.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Recommended Treatment Program Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Source Code Descr
DescriptionThe description that corresponds to the Source Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
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


 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 PrimaryKeyfalse
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

Primary Key Details

 Recommended Treatment Program Dimension PK
Key AttributeRecommended Treatment Program Dk


OverviewTopPackageEntity
Dimensional Warehouse Model Data Model