OverviewTopPackageEntity
Dimensional Warehouse Model Data Model

Entity Coverage Agreement Dimension

DescriptionAn agreement detailing the circumstances and mechanisms under which healthcare benefits (money or services) will be delivered. Each benefit category in a benefit schedule will have an entry in coverage agreement that specifies the parameters for that benefit category.

For example:
Dental care coverage
Prenatal care
Routine exams

Attributes
Additional Member Designation CdAdditional Member Designation Cd
Additional Member Designation Code DescrAdditional Member Designation Code Descr
Additional Member Designation Code SkAdditional Member Designation Code Sk
AWM Load Info SkAWM Load Info Sk
Benefit Delivery Frequency CdBenefit Delivery Frequency Cd
Benefit Delivery Frequency Code DescrBenefit Delivery Frequency Code Descr
Benefit Delivery Frequency Code SkBenefit Delivery Frequency Code Sk
Benefit Unit of Measure CdBenefit Unit of Measure Cd
Benefit Unit of Measure Code DescrBenefit Unit of Measure Code Descr
Benefit Unit of Measure Code SkBenefit Unit of Measure Code Sk
Bound DtBound Dt
Co-Insurance PctCo-Insurance Pct
Coverage Agreement Dimension BkCoverage Agreement Dimension Bk
Coverage Agreement Dimension DkCoverage Agreement Dimension Dk
Coverage Agreement Dimension SkCoverage Agreement Dimension Sk
Coverage Agreement Status CdCoverage Agreement Status Cd
Coverage Agreement Status Code DescrCoverage Agreement Status Code Descr
Coverage Agreement Status Code SkCoverage Agreement Status Code Sk
Coverage Agreement Status Reason CdCoverage Agreement Status Reason Cd
Coverage Agreement Status Reason Code DescrCoverage Agreement Status Reason Code Descr
Coverage Agreement Status Reason Code SkCoverage Agreement Status Reason Code Sk
Coverage DescrCoverage Descr
Coverage End DtCoverage End Dt
Coverage IdCoverage Id
Coverage Identifier Type CdCoverage Identifier Type Cd
Coverage Identifier Type Code DescrCoverage Identifier Type Code Descr
Coverage Identifier Type Code SkCoverage Identifier Type Code Sk
Coverage Out-of-Network PctCoverage Out-of-Network Pct
Coverage PctCoverage Pct
Coverage Priority CdCoverage Priority Cd
Coverage Priority Code DescrCoverage Priority Code Descr
Coverage Priority Code SkCoverage Priority Code Sk
Coverage Start DtCoverage Start Dt
Coverage Type CdCoverage Type Cd
Coverage Type Code DescrCoverage Type Code Descr
Coverage Type Code SkCoverage Type Code Sk
Current IndCurrent Ind
Dependent Coverage Age LimitDependent Coverage Age Limit
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Eligibility PeriodEligibility Period
Eligibility Period Unit CdEligibility Period Unit Cd
Eligibility Period Unit Code DescrEligibility Period Unit Code Descr
Eligibility Period Unit Code SkEligibility Period Unit Code Sk
Exposure Amount Unit Of Measure CdExposure Amount Unit Of Measure Cd
Exposure Amount Unit Of Measure Code DescrExposure Amount Unit Of Measure Code Descr
Exposure Amount Unit Of Measure Code SkExposure Amount Unit Of Measure Code Sk
Extended Reporting PeriodExtended Reporting Period
Line Of Business CdLine Of Business Cd
Line Of Business Code DescrLine Of Business Code Descr
Line Of Business Code SkLine Of Business Code Sk
Next Renewal DtNext Renewal Dt
Next Review DtNext Review Dt
Planned End DtPlanned End Dt
Plan Network IndPlan Network Ind
Retroactive Start DtRetroactive Start Dt
Selected Currency CdSelected Currency Cd
Selected Currency Code DescrSelected Currency Code Descr
Selected Currency Code SkSelected Currency Code 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
Waiting PeriodWaiting Period
Waiting Period Unit CdWaiting Period Unit Cd
Waiting Period Unit Code DescrWaiting Period Unit Code Descr
Waiting Period Unit Code SkWaiting Period Unit Code Sk

Primary Key
Coverage Agreement Dimension PKCoverage Agreement Dimension PK

Dependencies
 
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Additional Member Designation Cd
DescriptionIndicates how any additional members are identified.

For example:
By name
Spouse and children
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Additional Member Designation Code Descr
DescriptionIndicates how any additional members are identified.

For example:
By name
Spouse and children
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Additional Member Designation Code Sk
DescriptionIndicates how any additional members are identified.

For example:
By name
Spouse and children
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 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


 Benefit Delivery Frequency Cd
DescriptionIndicates the benefit delivery frequency of coverage agreement.

For example:
- 1 exam every calendar year for mammograms
- 6 exams from birth to 1 year of age for Well Child Care
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Benefit Delivery Frequency Code Descr
DescriptionIndicates the benefit delivery frequency of coverage agreement.

For example:
- 1 exam every calendar year for mammograms
- 6 exams from birth to 1 year of age for Well Child Care
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Benefit Delivery Frequency Code Sk
DescriptionIndicates the benefit delivery frequency of coverage agreement.

For example:
- 1 exam every calendar year for mammograms
- 6 exams from birth to 1 year of age for Well Child Care
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Benefit Unit of Measure Cd
DescriptionIndicates the unit of measure of the coverage agreement benefit.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Benefit Unit of Measure Code Descr
DescriptionIndicates the unit of measure of the coverage agreement benefit.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Benefit Unit of Measure Code Sk
DescriptionIndicates the unit of measure of the coverage agreement benefit.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Bound Dt
DescriptionThe date upon which the agreement is considered legally binding, or in force. Depending on the legislation the bound date can be the date when the coverage agreement is signed by both parties and/or when the first premium has been paid.
Derived from the status related information.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Co-Insurance Pct
DescriptionThe specific co-insurance percentage applying to the coverage agreement on the policy. In other words the percentage of covered benefits that the member will be liable for up to their out-of-pocket or other maximums.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Dimension 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


 Coverage Agreement Dimension 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


 Coverage Agreement Dimension 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


 Coverage Agreement Status Cd
DescriptionIndicates the coverage agreement's current status.

For Example:
Active
Cancelled
Expired
Final
In Force
In Process
Initial
Lapsed
Not taken up
Offered
Rejected
Suspended
Terminated
Under Negotiation
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Status Code Descr
DescriptionIndicates the coverage agreement's current status.

For Example:
Active
Cancelled
Expired
Final
In Force
In Process
Initial
Lapsed
Not taken up
Offered
Rejected
Suspended
Terminated
Under Negotiation
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Status Code Sk
DescriptionIndicates the coverage agreement's current status.

For Example:
Active
Cancelled
Expired
Final
In Force
In Process
Initial
Lapsed
Not taken up
Offered
Rejected
Suspended
Terminated
Under Negotiation
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Status Reason Cd
DescriptionAgreement Status Reason classifies agreements according to the motivation for changing the Agreement Status of the agreement.

For example:
Not eligible (if agreement rejected)
Not taken up (if agreement rejected)
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Status Reason Code Descr
DescriptionAgreement Status Reason classifies agreements according to the motivation for changing the Agreement Status of the agreement.

For example:
Not eligible (if agreement rejected)
Not taken up (if agreement rejected)
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Agreement Status Reason Code Sk
DescriptionAgreement Status Reason classifies agreements according to the motivation for changing the Agreement Status of the agreement.

For example:
Not eligible (if agreement rejected)
Not taken up (if agreement rejected)
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Descr
DescriptionTextual description of the Coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage End Dt
DescriptionThe date on which the coverage actually terminates. This may pre- or post-date the Planned End Date. The termination date of the coverage is also represented in the status date for the terminated status.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Id
DescriptionIdentifies an instance of an coverage agreement
Data TypeStandards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Identifier Type Cd
DescriptionDescribes the kind or nature of the coverage agreement identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Identifier Type Code Descr
DescriptionDescribes the kind or nature of the coverage agreement identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Identifier Type Code Sk
DescriptionDescribes the kind or nature of the coverage agreement identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Out-of-Network Pct
DescriptionThe percentage of eligible benefits that will be paid for under the coverage agreement. Applies to 'out-of-network' benefits, where applicable.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Pct
DescriptionThe percentage of eligible benefits that will be paid for under the coverage agreement. Applies to 'in-network' benefits, where applicable.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Priority Cd
DescriptionIndicates the priority of the coverage in relation to other insurance policies that cover the same member for the same risks.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Priority Code Descr
DescriptionIndicates the priority of the coverage in relation to other insurance policies that cover the same member for the same risks.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Priority Code Sk
DescriptionIndicates the priority of the coverage in relation to other insurance policies that cover the same member for the same risks.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Start Dt
DescriptionThe date upon which the coverage agreement first starts. For renewable coverage agreements, this date represents the date of the original coverage agreement before any renewal.
Derived from the status related information.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Type Cd
DescriptionType of the coverage this specification is for.

For example:
Dental Coverage
Hospital Indemnity Coverage
Pharmacy Coverage
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Type Code Descr
DescriptionType of the coverage this specification is for.

For example:
Dental Coverage
Hospital Indemnity Coverage
Pharmacy Coverage
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Type Code Sk
DescriptionType of the coverage this specification is for.

For example:
Dental Coverage
Hospital Indemnity Coverage
Pharmacy Coverage
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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


 Dependent Coverage Age Limit
DescriptionThe maximum age that a person can attain before becoming ineligible to receive benefits under this coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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


 Eligibility Period
DescriptionTime following the eligibility date during which the member may apply for insurance without evidence of insurability.

For example:
31 days
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Eligibility Period Unit Cd
DescriptionEligibility period unit specifies the unit of the coverage agreement eligibility period.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Eligibility Period Unit Code Descr
DescriptionEligibility period unit specifies the unit of the coverage agreement eligibility period.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Eligibility Period Unit Code Sk
DescriptionEligibility period unit specifies the unit of the coverage agreement eligibility period.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Exposure Amount Unit Of Measure Cd
DescriptionExposure amount unit of measure specifies the unit of measure of the coverage agreement exposure amount.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Exposure Amount Unit Of Measure Code Descr
DescriptionExposure amount unit of measure specifies the unit of measure of the coverage agreement exposure amount.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Exposure Amount Unit Of Measure Code Sk
DescriptionExposure amount unit of measure specifies the unit of measure of the coverage agreement exposure amount.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Extended Reporting Period
DescriptionPeriod following the termination date of the policy or coverage in which a claim can still be accepted, provided the claimed loss has occurred during the coverage period.

For example:
2 years
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Line Of Business Cd
DescriptionIndicates the nature of commercial enterprise of the modeled organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Line Of Business Code Descr
DescriptionIndicates the nature of commercial enterprise of the modeled organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Line Of Business Code Sk
DescriptionIndicates the nature of commercial enterprise of the modeled organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Next Renewal Dt
DescriptionThe next date at which the enforce status of the coverage agreement must be re-evaluated or re-conducted.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Next Review Dt
DescriptionThe date upon which a review of the coverage agreement is planned.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Planned End Dt
DescriptionThe planned end date of the coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Plan Network Ind
DescriptionIndicates whether or not the related benefits are restricted to in-plan network providers.

For example:
Yes
No
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Retroactive Start Dt
DescriptionStart date of policy coverage chosen as a date in the past preceding the policy inception date.

For example:
1 June 2004 where inception date is 1 March 2005
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Selected Currency Cd
DescriptionIndicates the currency as selected by the customer to be used on any monetary information provided to the customer.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Selected Currency Code Descr
DescriptionIndicates the currency as selected by the customer to be used on any monetary information provided to the customer.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Selected Currency Code Sk
DescriptionIndicates the currency as selected by the customer to be used on any monetary information provided to the customer.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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


 Waiting Period
DescriptionThe period of time after the start date of the coverage agreement during which the member is not covered. Any loss occurring before the end of the waiting period will not be subject to a benefit.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Waiting Period Unit Cd
DescriptionSpecifies the unit of measure of the coverage agreement waiting period.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Waiting Period Unit Code Descr
DescriptionSpecifies the unit of measure of the coverage agreement waiting period.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Waiting Period Unit Code Sk
DescriptionSpecifies the unit of measure of the coverage agreement waiting period.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Coverage Agreement Dimension PK
Key AttributeCoverage Agreement Dimension Dk


OverviewTopPackageEntity
Dimensional Warehouse Model Data Model