AP_CLAIM_IF_ANALYZER

Description:

The AP_CLAIM_IF_ANALYZER table contains claim-level response data from the code editor interface that was received about a claim when run against an analyzer interface.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier 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	START_VISIT_LEVEL	VARCHAR	No
	Visit level submitted on the claim to be processed by the analyzer interface
4	END_VISIT_LEVEL	VARCHAR	No
	Final visit level after the analyzer makes any adjustments.
5	START_HCPCS	VARCHAR	No
	Procedure code submitted on the claim to be processed by the analyzer.
6	END_HCPCS	VARCHAR	No
	Final procedure code after the analyzer makes any adjustments.
7	FINAL_PSCA	VARCHAR	No
	The final PSCA (Proportional Standard Cost Allocation) assigned to this claim taking into consideration all the reason for visit diagnosis codes, age, and gender of the patient.
8	VISIT_REASON_PSCA	VARCHAR	No
	The PSCA (Proportional Standard Cost Allocation) assigned to each reason for visit code taking into consideration the age and gender of the patient.
9	DIAGNOSTIC_CATEGORY	VARCHAR	No
	An array of the diagnostic test categories on the claim found by the analyzer.
10	PSCA_WEIGHT	VARCHAR	No
	The final PSCA (Proportional Standard Cost Allocation) weight for this claim, based on all of the reason for visit diagnosis codes, as well as the patient's age and sex.
11	DIAGNOSTIC_CATEGORY_WEIGHT	VARCHAR	No
	The weight for each diagnostic category found on this claim, based on all line-level procedure codes representing the ancillary services ordered for the patient.
12	COMPLEXITY_WEIGHT	VARCHAR	No
	The final patient complexity weight for this claim, based on the principal diagnosis, all secondary diagnosis codes, and all external cause of injury diagnosis codes.
13	TOTAL_WEIGHT	VARCHAR	No
	The total weight used to assign the final visit level.