4.3 Fact Data Flow
Most of the Fact tables are mapped to staging counterparts through Table to Table (T2T) mappings.
Data from source systems can be loaded into staging through flat file or source system interfaces. T2T process then loads data to fact tables. Examples include Fact Common Policy Summary, Fact IPA Policy Summary, and so on. Some of the Fact tables are loaded with processed fact information from other fact tables. Examples include Fact Policy Profitability, Fact Aggregate Producer Summary, and so on.
Table 4-2 Fact Data Flow
Fact Entity Name | Source | Source Entities | Method of Populating Measures |
---|---|---|---|
Fact Aggregate Producer Summary | Fact | Fact Common Policy Summary, Fact IPA Policy Summary, Fact PFT Policy Summary, Fact Insurance Quotes, Fact Insurance Quote Reports, and Fact Claim Details | T2T/DT |
Fact Claim Claimant Mapping | Stage | T2T | |
Fact Claim Details | Stage | Stage Claim Details | T2T |
Fact Claim Referral Reason Mapping | Stage | Stage Claim Referral Reason Mapping | T2T |
Fact Claim Transaction | Stage | Stage Claim Transactions | T2T |
Fact Common Policy Summary | Stage | Stage Property and Casualty Contracts | T2T |
Fact Insurance Quotes Report | Stage | Stage Insurance Quote with Reports | T2T |
Fact IPA Policy Summary | Stage | Stage Property and Casualty Contracts | T2T |
Fact PFT Policy Summary | Stage | Stage Property and Casualty Contracts | T2T |
Fact Policy Coverage's | Stage | Stage Policy Coverage's | T2T |
Fact Policy Profitability | Fact | Fact Common Policy Summary, Fact IPA Policy Summary, Fact PFT Policy Summary, Fact Insurance Quotes, Fact Insurance Quote Reports, and Fact Claim Details | T2T |
Fact Policy Rate Modifiers Map | Stage | Stage Policy Rate Modifier | T2T |
Fact Policy Relationship | Stage | Stage Policy Customer Relationship | T2T |
Fact Policy Transactions | Stage | Stage Property And Casualty Policy Transactions | T2T |
Fact Premium Transactions | Stage | Stage Premium Transactions | T2T |
Fact Producer Appointments | Stage | Stage Producer Contracts | T2T |
Insurance Quotes Fact | Stage | Stage Insurance Quotes | T2T |
FCT_PARTY_INS_POLICY_ROLE_MAP | Stage | STG_PARTY_INS_POLICY_ROLE_MAP | T2T |
FCT_PARTY_PARTY_RELATIONSHIP | Stage | STG_PARTY_PARTY_RELATIONSHIP | T2T |
FCT_PARTY_FINANCIALS | Stage | STG_PARTY_FINANCIALS | T2T |
FCT_PARTY_FINANCIAL_DETAIL | Fact | FCT_PARTY_FINANCIALS | T2T |