Insurance Claims T2T and its description is given here.
T2T Name |
T2T Description |
T2T_FCT_CLAIM_DETAILS |
This T2T stores all the attributes of a policy claims paid until date along with the summary of transactions. |
T2T_FCT_CLAIM_CLAIMANT_MAPPING |
This T2T stores the details of all the claimants involved in a claim process. |
T2T_FCT_CLAIM_TRANSACTIONS |
This T2T stores all the transactions related to claims reported with the entity. |
The mapping details for the Insurance Claims T2T is given here.
Source Table Name |
Logical Stage Table Name |
Fact Table Name |
Logical Fact Table Name |
T2T Name |
STG_CLAIM_DETAILS |
Stage Claim Details |
FCT_CLAIM_DETAILS |
Fact Claim Details |
T2T_FCT_CLAIM_DETAILS |
STG_CLAIM_CLAIMANT |
Stage Claim Claimant |
FCT_CLAIM_CLAIMANT_MAPPING |
Fact Claim Claimant Mapping |
T2T_FCT_CLAIM_CLAIMANT_MAPPING |
STG_CLAIM_TXNS |
Stage Claim Transactions |
FCT_CLAIM_TRANSACTION |
Fact Claim Transaction |
T2T_FCT_CLAIM_TRANSACTIONS |