AP_CLAIM_ICIV_RSN

Description:

The table lists the reasons a claim is marked as not clinically valid for derivation in I CLM 18619.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier (.1 item) for the claim info record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	ICIV_REASON_C_NAME	VARCHAR	No
	Stores the reasons that I CLM 18619 is set to No. May contain organization-specific values: No Category Entries: VOIDED CLAIM ADJUSTED CLAIM CANCELLED CLAIM INTERMEDIATE CLAIM CANCELLATION CLAIM DENIED PHARMACY CLAIM OVERRIDDEN INVALID INVALID ADJUSTMENT SEQUENCE NOT FINAL ACTION PHARMACY SUPPLY UNSUCCESSFULLY FILED NON ALLOWED DENIAL REASON FINAL ACTION CODE HOOK ISCLINICALLYVALIDFORCEDTOZERO MAPPING