OverviewTopPackageEntity
Dimensional Warehouse Model Data Model

Entity Insurance Policy Dimension

DescriptionAn agreement (individual agreement or group agreement) between a healthcare insurer and a member based on a health plan product. The agreement specifies the obligation of the healthcare insurer to pay benefits and of the premium payer to pay premiums.

Attributes
Agreement Status CdAgreement Status Cd
Agreement Status Code DescrAgreement Status Code Descr
Agreement Status Code SkAgreement Status Code Sk
AWM Load Info SkAWM Load Info Sk
Bound DtBound Dt
Coverage Out-of-Network PctCoverage Out-of-Network Pct
Coverage PctCoverage Pct
Current IndCurrent Ind
Discount Category CdDiscount Category Cd
Discount Category Code DescrDiscount Category Code Descr
Discount Category Code SkDiscount Category Code Sk
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Entry CdEntry Cd
Entry Code DescrEntry Code Descr
Entry Code SkEntry Code Sk
Insurance Policy DescrInsurance Policy Descr
Insurance Policy Dimension BkInsurance Policy Dimension Bk
Insurance Policy Dimension DkInsurance Policy Dimension Dk
Insurance Policy Dimension SkInsurance Policy Dimension Sk
Insurance Policy End DtInsurance Policy End Dt
Insurance Policy Start DtInsurance Policy Start Dt
Insurance Policy Status Reason CdInsurance Policy Status Reason Cd
Insurance Policy Status Reason Code DescrInsurance Policy Status Reason Code Descr
Insurance Policy Status Reason Code SkInsurance Policy Status Reason Code Sk
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
Membership Card IndMembership Card Ind
Membership Eligibility CdMembership Eligibility Cd
Membership Eligibility Code DescrMembership Eligibility Code Descr
Membership Eligibility Code SkMembership Eligibility Code Sk
Next Renewal DtNext Renewal Dt
Next Review DtNext Review Dt
Planned End DtPlanned End Dt
Policy IdPolicy Id
Policy Identifier Type CdPolicy Identifier Type Cd
Policy Identifier Type Code DescrPolicy Identifier Type Code Descr
Policy Identifier Type Code SkPolicy Identifier Type Code Sk
Policy Type CdPolicy Type Cd
Policy Type Code DescrPolicy Type Code Descr
Policy Type Code SkPolicy Type Code Sk
Premium Payment Frequency CdPremium Payment Frequency Cd
Premium Payment Frequency Code DescrPremium Payment Frequency Code Descr
Premium Payment Frequency Code SkPremium Payment Frequency Code Sk
Premium Payment Method CdPremium Payment Method Cd
Premium Payment Method Code DescrPremium Payment Method Code Descr
Premium Payment Method Code SkPremium Payment Method Code Sk
Rate Class CdRate Class Cd
Rate Class Code DescrRate Class Code Descr
Rate Class Code SkRate Class Code Sk
Renewal IndRenewal Ind
Risk Type CdRisk Type Cd
Risk Type Code DescrRisk Type Code Descr
Risk Type Code SkRisk Type Code Sk
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

Primary Key
Insurance Policy Dimension PKInsurance Policy Dimension PK

Dependencies
 
 
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Agreement Status Cd
DescriptionIndicates the Insurance Policy'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


 Agreement Status Code Descr
DescriptionIndicates the Insurance Policy'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


 Agreement Status Code Sk
DescriptionIndicates the Insurance Policy'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


 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


 Bound Dt
DescriptionThe date upon which the Insurance Policy is considered legally binding, or in force. Depending on the legislation the bound date can be the date when the Insurance Policy 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


 Coverage Out-of-Network Pct
DescriptionPercent of charges payable under the contract, for covered medical services or products delivered by and out-of-network provider, under this insurance policy.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Coverage Pct
DescriptionPercent of charges payable under the contract, for 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


 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


 Discount Category Cd
DescriptionIndicates a discount category that determines the reductions in premium or price from the standard rating structure based on the presence of factors that reduce the risk or increase profitability.

For example:
No claim
No Discount
Percentage of Usual and Customary Fee
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Discount Category Code Descr
DescriptionIndicates a discount category that determines the reductions in premium or price from the standard rating structure based on the presence of factors that reduce the risk or increase profitability.

For example:
No claim
No Discount
Percentage of Usual and Customary Fee
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Discount Category Code Sk
DescriptionIndicates a discount category that determines the reductions in premium or price from the standard rating structure based on the presence of factors that reduce the risk or increase profitability.

For example:
No claim
No Discount
Percentage of Usual and Customary Fee
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [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


 Entry Cd
DescriptionIdentifies whether the insurance policy was entered by an external party or by a party within the modeled organization.

For example:
Agency entered
Branch entered
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Entry Code Descr
DescriptionIdentifies whether the insurance policy was entered by an external party or by a party within the modeled organization.

For example:
Agency entered
Branch entered
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Entry Code Sk
DescriptionIdentifies whether the insurance policy was entered by an external party or by a party within the modeled organization.

For example:
Agency entered
Branch entered
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


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


 Insurance Policy 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


 Insurance Policy 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


 Insurance Policy 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


 Insurance Policy End Dt
DescriptionThe date upon which the Insurance Policy actually terminates. This may pre- or post-date the Planned End Date. For example, early termination of a contract due to poor performance. The termination date of the Insurance Policy 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


 Insurance Policy Start Dt
DescriptionThe date on which the Insurance Policy first starts. For renewable Insurance Policy, this date represents the date of the original Insurance Policy 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


 Insurance Policy Status Reason Cd
DescriptionIndicates the motivation or cause for changing the agreement status of the Insurance Policy.

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


 Insurance Policy Status Reason Code Descr
DescriptionIndicates the motivation or cause for changing the agreement status of the Insurance Policy.

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


 Insurance Policy Status Reason Code Sk
DescriptionIndicates the motivation or cause for changing the agreement status of the Insurance Policy.

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


 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


 Membership Card Ind
DescriptionIndicates whether membership cards are to be issued to members under the policy.

For example:
Not required.
To be issued.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Membership Eligibility Cd
DescriptionIndicates the qualification conditions for membership to an insurance policy.

For example:
Full Time Employees
Full Time Employees Only
Subscriber and Dependents
Subscriber and Spouse
Subscriber Only
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Membership Eligibility Code Descr
DescriptionIndicates the qualification conditions for membership to an insurance policy.

For example:
Full Time Employees
Full Time Employees Only
Subscriber and Dependents
Subscriber and Spouse
Subscriber Only
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Membership Eligibility Code Sk
DescriptionIndicates the qualification conditions for membership to an insurance policy.

For example:
Full Time Employees
Full Time Employees Only
Subscriber and Dependents
Subscriber and Spouse
Subscriber Only
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 Insurance Policy 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 Insurance Policy 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 date upon which the end of the Insurance Policy is planned.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


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


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


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


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


 Policy Type Cd
DescriptionIdentifies the type of the Insurance Policy.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Policy Type Code Descr
DescriptionIdentifies the type of the Insurance Policy.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Policy Type Code Sk
DescriptionIdentifies the type of the Insurance Policy.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Premium Payment Frequency Cd
DescriptionIndicates the frequency with which the payment of the premium will occur.

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


 Premium Payment Frequency Code Descr
DescriptionIndicates the frequency with which the payment of the premium will occur.

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


 Premium Payment Frequency Code Sk
DescriptionIndicates the frequency with which the payment of the premium will occur.

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


 Premium Payment Method Cd
DescriptionIndicates the payment method that will be used to pay the premiums for the policy.

For example:
Check
Direct debit mandate
Electronic funds transfer
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Premium Payment Method Code Descr
DescriptionIndicates the payment method that will be used to pay the premiums for the policy.

For example:
Check
Direct debit mandate
Electronic funds transfer
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Premium Payment Method Code Sk
DescriptionIndicates the payment method that will be used to pay the premiums for the policy.

For example:
Check
Direct debit mandate
Electronic funds transfer
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Rate Class Cd
DescriptionIndicates the category that determines premium rates or rating structures for the insurance policy.

For example:
Single Male Principal Operator Age 20-25
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Rate Class Code Descr
DescriptionIndicates the category that determines premium rates or rating structures for the insurance policy.

For example:
Single Male Principal Operator Age 20-25
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Rate Class Code Sk
DescriptionIndicates the category that determines premium rates or rating structures for the insurance policy.

For example:
Single Male Principal Operator Age 20-25
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Renewal Ind
DescriptionIndicates whether or not the insurance policy is a renewal. If not, it indicates that the insurance policy is in its first renewal period.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Risk Type Cd
DescriptionIndicates the types of risk or financial exposure to the health plan.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Risk Type Code Descr
DescriptionIndicates the types of risk or financial exposure to the health plan.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse


 Risk Type Code Sk
DescriptionIndicates the types of risk or financial exposure to the health plan.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
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

Primary Key Details

 Insurance Policy Dimension PK
Key AttributeInsurance Policy Dimension Dk


OverviewTopPackageEntity
Dimensional Warehouse Model Data Model