AP_CLAIM_ICD_PROC

Description: |
The AP_CLAIM_ICD_PROC table contains the ICD-9 Procedure information on an accounts payable claim.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier of the accounts payable claim record.
2 | LINE | INTEGER | No |
Line counter of the ICD-9 procedure code on the claim.
3 | ICD_PX_ID | VARCHAR | No |
The unique ID of the ICD-9 procedure code on the claim.
4 | ICD_PX_ID_ICD_PX_NAME | VARCHAR | No |
The name of the ICD procedure record.
5 | ICD_PX_DT | DATETIME | No |
The date of the ICD-9 procedure code.
6 | ICD_PX_RANK | INTEGER | No |
The rank of this International Classification of Diseases (ICD) procedure compared to the other ICD procedures on the claim.