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.