Dimensional Warehouse Model Data Model

Entity

Entity Employee / Professional Certification Bridge

Description

An association between Employee and Organization and capture professional certification information.

Attributes
Activation Dt
AWM Load Info Sk
Certification Num
Certification Status Cd
Certification Status Code Sk
Certification Status Descr
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Expiration Dt
Granting Dt
Inactivation Dt
Organization Dk
Party Role Dk
Professional Certification Status Reason Cd
Professional Certification Status Reason Code Sk
Professional Certification Type Cd
Professional Certification Type Code Sk
Relationship Type Cd
Relationship Type Code Sk
Renewal Dt
Revocation Dt
Source Code Sk
Tax Registration Type Cd
Tax Registration Type Code Sk
Tenant Sk
Type of License Cd
Type of License Code Sk
Valid From Ts
Valid To Ts

Relationship
Employee / Professional Certification Bridge_Organization Dimension_FK
Employee / Professional Certification Bridge_Party Role Dimension_FK

Primary Key
Employee / Professional Certification Bridge PK

Dependencies

Reverse Dependencies

Attribute Details

Activation Dt

Description	The date upon which the employee's certification with a professional organization was activated.
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

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Certification Num

Description	The official identifier assigned to the certification.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Certification Status Cd

Description	The state of the certificate held by the health professional. For example: Provisional Revoked Active/Valid Expired Inactive
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Certification Status Code Sk

Description	The state of the certificate held by the health professional. For example: Provisional Revoked Active/Valid Expired Inactive
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Certification Status Descr

Description	The state of the certificate held by the health professional. For example: Provisional Revoked Active/Valid Expired Inactive
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM 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

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

Expiration Dt

Description	The date upon which the employee's professional certificate/license to practice expires.
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

Granting Dt

Description	The date upon which the employee's professional certificate/license to practice is issued by the authorizing body.
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

Inactivation Dt

Description	The date upon which the employee's professional certificate/license to practice was inactivated by the authorizing body.
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

Organization Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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

Party Role Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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

Professional Certification Status Reason Cd

Description	Classifies certifications according to the motivation for changing the Professional Certification Status of the certification.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Certification Status Reason Code Sk

Description	Classifies certifications according to the motivation for changing the Professional Certification Status of the certification.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Certification Type Cd

Description	Classifies a certification according to its type. For example: Corporate Product-specific Profession-wide
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Certification Type Code Sk

Description	Classifies a certification according to its type. For example: Corporate Product-specific Profession-wide
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Type Cd

Description	The code that corresponds to the Relationship Type Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Type Code Sk

Description	The code identifying the actual 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

Renewal Dt

Description	The date upon which the employee's professional certificate/license to practice is renewed by the authorizing body.
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

Revocation Dt

Description	The date upon which the employee's professional certificate/license to practice is revoked or annulled by the authorizing body.
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

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

Tax Registration Type Cd

Description	Classifies a tax registration according to its type.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tax Registration Type Code Sk

Description	Classifies a tax registration according to its type.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Type of License Cd

Description	The type of license that a healthcare provider has obtained. For example: D.D.S. D.O. M.D. Mid, N.P. Occ.Th.. Phys. Th Psych. R.S.N.A.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Type of License Code Sk

Description	The type of license that a healthcare provider has obtained. For example: D.D.S. D.O. M.D. Mid, N.P. Occ.Th.. Phys. Th Psych. R.S.N.A.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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	false
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

Employee / Professional Certification Bridge_Organization Dimension_FK

Is Identifying Relationship	true
Child Table	Employee / Professional Certification Bridge
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	Organization Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Employee / Professional Certification Bridge_Party Role Dimension_FK

Is Identifying Relationship	true
Child Table	Employee / Professional Certification Bridge
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	Party Role Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Employee / Professional Certification Bridge PK

Key Attribute	Organization Dk
Key Attribute	Party Role Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model