CLM_3PP_PRICING_HX

Description: |
This table stores the third-party pricing activities for the 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 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 | PRICING_ENTITY_ID | NUMERIC | No |
This item stores third-party pricing entity.
4 | PRICING_ENTITY_ID_RUL_NAME | VARCHAR | No |
The name of the third-party pricing entity, grouper, or rule.
5 | ENTITY_GROUPER_ID | NUMERIC | No |
This item stores the third-party pricing entity grouper.
6 | ENTITY_GROUPER_ID_RUL_NAME | VARCHAR | No |
The name of the third-party pricing entity, grouper, or rule.
7 | SEND_DT | DATETIME | No |
This item stores the date the claim was sent for third-party pricing.
8 | DUE_DT | DATETIME | No |
This item stores the due date for the third-party pricing.
9 | COMPLETE_DT | DATETIME | No |
This item stores the third-party pricing complete date.
10 | CANCEL_DT | DATETIME | No |
This item stores the date the claim batch for third-party pricing was cancelled.
11 | REJECTED_YN | VARCHAR | No |
This item stores whether the third-party pricer rejected the claim.
May contain organization-specific values: No
Category Entries:
No
Yes
12 | ACTION_C_NAME | VARCHAR | No |
This item stores the action that should be taken for a claim that has been rejected by the third party pricer.
May contain organization-specific values: No
Category Entries:
Continue
Stop