About Insurance Claims T2T (Result Table)

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