CLM_ADJUD_INFO

Description: |
This table contains claim adjudication information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_PRINT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_PRINT_ID | NUMERIC | No |
The unique identifier for the claim print record.
2 | COMPONENT_ID | VARCHAR | No |
The unique ID of the component or component group used in adjudicating this claim line.
3 | COMPONENT_ID_COMPONENT_INDEX_NAME | VARCHAR | No |
The name of the component index record
4 | CONTRACT_ID | NUMERIC | No |
The unique ID of the contract used in adjudicating this claim line.
5 | CONTRACT_ID_CONTRACT_NAME | VARCHAR | No |
The name of the Vendor-Network contract.
6 | CONTRACT_CONTACT_DATE_REAL | FLOAT | No |
A numerical representation of the contact date for the contract used in adjudicating this claim line. Used to help link to the VEN_NET_CONT_SVC table.
7 | CONTRACT_LN | INTEGER | No |
The contract line number used in adjudicating this claim line.
8 | PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
9 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
10 | DRG_ID | VARCHAR | No |
The unique ID of the DRG that is associated with this claim line.
11 | DRG_ID_DRG_NAME | VARCHAR | No |
The name of the Diagnoses Related Group name.
12 | COMPONENT_GROUP_ID_COMP_GRP_NAME | VARCHAR | No |
The name for the whole claim component group.
13 | PROC_COMMENT | VARCHAR | No |
The free text comment about the procedure that is associated with this claim line.