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.