Logical Dimension Table Name

Dimension Table Description

Dimension Claim Refusal Reason

This table stores the list of all the reasons for which a claim can be refused by the entity.

Dimension Claim Status

This table stores the list of all status codes and descriptions, which are applicable for a claim transaction.

Claim Dimension

This table stores the list of all claims.

Claim Referral Reason Dimension

This table stores different referral reasons for a claim.

Claim Feature Dimension

This tables stores feature details that describes an aspect of a claim for injuries to a person.

Claim Feature Status Dimension

This table stores the status of a claim feature, based on which various calculations changes.

Claim Reopening Reason Type Dimension

This table stores the reopening reason type.

Sample values: R1 – Mathematical or computational mistake, R2 – Inaccurate data entry, D0 – Changes in service date, E0 – Change in patient status, etc.

Map Reference Number

Source Table Name

Logical Stage Table Name

Dimension Table Name

Logical Dimension Table Name

233

STG_CLAIM_REFUSAL_REAS_MASTER

Stage Claim Refusal Reason Master

DIM_CLAIM_REFUSAL_REASON

Dimension Claim Refusal Reason

234

STG_CLAIM_STATUS_MASTER

Stage Claim Status Master

DIM_CLAIM_STATUS

Dimension Claim Status

239

STG_CLAIM_DETAILS

Stage Claim Details

DIM_CLAIM

Claim Dimension

242

STG_CLAIM_REFERRAL_REAS_MASTER

Stage Claim Referral Reason

DIM_CLAIM_REFERRAL_REASON

Claim Referral Reason Dimension

599

STG_CLAIM_FEATURE_MASTER

Stage Claim Feature Master

DIM_CLAIM_FEATURE

Claim Feature Dimension

605

STG_CLAIM_FEATURE_STTS_MASTER

Stage Claim Feature Status Master

DIM_CLAIM_FEATURE_STATUS

Claim Feature Status Dimension

648

STG_CLM_REOPEN_RSN_TYPE_MASTER

Stage Claim Reopening Reason Type Master

DIM_CLM_REOPEN_RSN_TYPE

Claim Reopening Reason Type Dimension