V_AP_CLAIM_CHANGE_HX_DTL

Description: |
Contains detailed information about changes made to an AP 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 |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ACTION_C_NAME | VARCHAR | No |
The Change History Action category ID for the claim record. Indicates the item changed on the claim (i.e. workflow, workflow other status, etc.).
May contain organization-specific values: No
Category Entries:
Coverage Selection for Crossover
Downstream Crossover Claim
Possible Duplicate Warning
Claim Restoration
Automatic Action
Referring Provider
Attachment
MC Claims Workflow
Provider
Place of Service
Operating Provider
Other Provider
Attending Provider
Rendering Provider
Supervising Provider
Vendor
Coverage Selection
Owning Business Segment
Referrals
Deny Claim Source
Frozen Status Change
Claim Specialty
Status Change
AP Status Change
Date Received
CMS Unclean Status
Date Received by Carrier
Claim EOB Code
Background Adjudication Queue Entry ID
Network Override
Service Change
Workflow Other Status
Workflow Print Status
Is Clinically Invalid Claim?
Override Is Clinically Invalid Claim?
Trait 1 Evaluation
Trait 2 Evaluation
Trait 3 Evaluation
Trait 4 Evaluation
Trait 5 Evaluation
Upstream Crossover Claim
Original Claim for this Reversal Claim
Original Claim for this Corrected Claim
Original Claim for this Adjustment Claim
Third-Party Pricer
Finalization Status
Override Interest Start Date
Adjustment Interest Start Date
Held for AP Reasons Change
Modifiers
Assoc Diags
Service Line EOB Codes
Assigned Referrals
POS Type
Revenue Code
DRG Code
PPS Price - For PPS Code
Service Line Billed
Payer Initiated Reduction
Primary Insurance Amount
Primary Patient Portion
Override Allowed Amount Reason
Override Disallowed Amount Reason
NDC Code
NDC Quantity
NDC Units
NDC Prescription Number
NDC Link Sequence Number
NDC Section 340B
Original Downcoded Code
Original Downcoded Qualifying Payment Amount
Override Service Interest Start Date
Service Code
Quantity
Service From Date
Service To Date
Type Of Service
External System Action
4 | PREV_VAL_RAW | VARCHAR | No |
The value of the item before the change was made to the claim. IDs are not translated, so if Intraconnect is used, mapping to CIDs is necessary.
5 | NEW_VAL_RAW | VARCHAR | No |
The value of the item after the change was made to the claim. IDs are not translated, so if Intraconnect is used, mapping to CIDs is necessary.
6 | PREV_CLAIM_ID | NUMERIC | No |
The claim ID stored in the the item before the change was made to the claim. This column only contains data for items that store claim IDs.
7 | NEW_CLAIM_ID | NUMERIC | No |
The claim ID stored in the the item after the change was made to the claim. This column only contains data for items that store claim IDs.
8 | PREV_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
9 | NEW_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
10 | PREV_POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
11 | NEW_POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
12 | PREV_VENDOR_ID_VENDOR_NAME | VARCHAR | No |
The name of the vendor.
13 | NEW_VENDOR_ID_VENDOR_NAME | VARCHAR | No |
The name of the vendor.
14 | PREV_COVERAGE_ID | NUMERIC | No |
The coverage ID stored in the item before the change was made to the claim. This column only contains data for items that store coverage IDs.
15 | NEW_COVERAGE_ID | NUMERIC | No |
The coverage ID stored in the item after the change was made to the claim. This column only contains data for items that store coverage IDs.
16 | PREV_REFERRAL_ID | NUMERIC | No |
The referral ID stored in the item before the change was made to the claim. This column only contains data for items that store referral IDs.
17 | NEW_REFERRAL_ID | NUMERIC | No |
The referral ID stored in the item after the change was made to the claim. This column only contains data for items that store referral IDs.
18 | PREV_RUL_ID | NUMERIC | No |
The third party pricing rule, entity or grouper ID stored in the item before the change was made to the claim. This column only contains data for items that store third party pricing rule, entity or grouper IDs.
19 | PREV_RUL_ID_RUL_NAME | VARCHAR | No |
The name of the third-party pricing entity, grouper, or rule.
20 | NEW_RUL_ID | NUMERIC | No |
The third party pricing rule, entity or grouper ID stored in the item after the change was made to the claim. This column only contains data for items that store third party pricing rule, entity or grouper IDs.
21 | NEW_RUL_ID_RUL_NAME | VARCHAR | No |
The name of the third-party pricing entity, grouper, or rule.
22 | PREV_FRZN_STATUS_C | INTEGER | No |
The category ID of the frozen status stored in the item before the change was made to the claim. This column only contains data for items that store frozen status category IDs.
23 | NEW_FRZN_STATUS_C | INTEGER | No |
The category ID of the frozen status stored in the item after the change was made to the claim. This column only contains data for items that store frozen status category IDs.
24 | PREV_CLM_STATUS_C | INTEGER | No |
The category ID of the claim status stored in the item before the change was made to the claim. This column only contains data for items that store claim status category IDs.
25 | NEW_CLM_STATUS_C | INTEGER | No |
The category ID of the claim status stored in the item after the change was made to the claim. This column only contains data for items that store claim status category IDs.
26 | PREV_AP_STATUS_C | INTEGER | No |
The category ID of the AP status stored in the item before the change was made to the claim. This column only contains data for items that store AP status category IDs.
27 | NEW_AP_STATUS_C | INTEGER | No |
The category ID of the AP status stored in the item after the change was made to the claim. This column only contains data for items that store AP status category IDs.
28 | PREV_WKFLW_OTHER_STATUS_C | INTEGER | No |
The category ID of the workflow other status stored in the item before the change was made to the claim. This column only contains data for items that store workflow other status category IDs.
29 | NEW_WKFLW_OTHER_STATUS_C | INTEGER | No |
The category ID of the workflow other status stored in the item after the change was made to the claim. This column only contains data for items that store workflow other status category IDs.
30 | PREV_WKFLW_PRINT_STATUS_C | INTEGER | No |
The category ID of the workflow print status stored in the item before the change was made to the claim. This column only contains data for items that store workflow print status category IDs.
31 | NEW_WKFLW_PRINT_STATUS_C | INTEGER | No |
The category ID of the workflow print status stored in the item after the change was made to the claim. This column only contains data for items that store workflow print status category IDs.
32 | PREV_CLAIM_TRAIT_1_C | INTEGER | No |
The category ID of the first claim trait stored in the item before the change was made to the claim. This column only contains data for items that store claim trait category IDs.
33 | NEW_CLAIM_TRAIT_1_C | INTEGER | No |
The category ID of the first claim trait stored in the item after the change was made to the claim. This column only contains data for items that store claim trait category IDs.
34 | PREV_CLAIM_TRAIT_2_C | INTEGER | No |
The category ID of the second claim trait stored in the item before the change was made to the claim. This column only contains data for items that store claim trait category IDs.
35 | NEW_CLAIM_TRAIT_2_C | INTEGER | No |
The category ID of the second claim trait stored in the item after the change was made to the claim. This column only contains data for items that store claim trait category IDs.
36 | PREV_CLAIM_TRAIT_3_C | INTEGER | No |
The category ID of the third claim trait stored in the item before the change was made to the claim. This column only contains data for items that store claim trait category IDs.
37 | NEW_CLAIM_TRAIT_3_C | INTEGER | No |
The category ID of the third claim trait stored in the item after the change was made to the claim. This column only contains data for items that store claim trait category IDs.
38 | PREV_CLAIM_TRAIT_4_C | INTEGER | No |
The category ID of the fourth claim trait stored in the item before the change was made to the claim. This column only contains data for items that store claim trait category IDs.
39 | NEW_CLAIM_TRAIT_4_C | INTEGER | No |
The category ID of the fourth claim trait stored in the item after the change was made to the claim. This column only contains data for items that store claim trait category IDs.
40 | PREV_CLAIM_TRAIT_5_C | INTEGER | No |
The category ID of the fifth claim trait stored in the item before the change was made to the claim. This column only contains data for items that store claim trait category IDs.
41 | NEW_CLAIM_TRAIT_5_C | INTEGER | No |
The category ID of the fifth claim trait stored in the item after the change was made to the claim. This column only contains data for items that store claim trait category IDs.
42 | PREV_HELD_FOR_AP_RSN_C | INTEGER | No |
The category ID of the held for AP reason stored in the item before the change was made to the claim. This column only contains data for items that store held for AP reason category IDs.
43 | NEW_HELD_FOR_AP_RSN_C | INTEGER | No |
The category ID of the held for AP reason stored in the item after the change was made to the claim. This column only contains data for items that store held for AP reason category IDs.
44 | PREV_POS_TYPE_C | INTEGER | No |
The category ID of the place of service type stored in the item before the change was made to the claim. This column only contains data for items that store place of service type category IDs.
45 | NEW_POS_TYPE_C | INTEGER | No |
The category ID of the place of service type stored in the item after the change was made to the claim. This column only contains data for items that store place of service type category IDs.
46 | PREV_CLAIM_SPEC_C | VARCHAR | No |
The category ID of the claim specialty stored in the item before the change was made to the claim. This column only contains data for items that store claim specialty category IDs.
47 | NEW_CLAIM_SPEC_C | VARCHAR | No |
The category ID of the claim specialty stored in the item after the change was made to the claim. This column only contains data for items that store claim specialty category IDs.
48 | PREV_OVRIDE_DISALW_AMT_RSN_C | INTEGER | No |
The category ID of the override disallow amount reason stored in the item before the change was made to the claim. This column only contains data for items that store override disallow amount reason category IDs.
49 | NEW_OVRIDE_DISALW_AMT_RSN_C | INTEGER | No |
The category ID of the override disallow amount reason stored in the item after the change was made to the claim. This column only contains data for items that store override disallow amount reason category IDs.
50 | PREV_OVRIDE_ALLOW_AMT_RSN_C | INTEGER | No |
The category ID of the override allow amount reason stored in the item before the change was made to the claim. This column only contains data for items that store override allow amount reason category IDs.
51 | NEW_OVRIDE_ALLOW_AMT_RSN_C | INTEGER | No |
The category ID of the override allow amount reason stored in the item after the change was made to the claim. This column only contains data for items that store override allow amount reason category IDs.
52 | PREV_TYPE_OF_SERVICE_C | INTEGER | No |
The category ID of the type of service stored in the item before the change was made to the claim. This column only contains data for items that store type of service category IDs.
53 | NEW_TYPE_OF_SERVICE_C | INTEGER | No |
The category ID of the type of service stored in the item after the change was made to the claim. This column only contains data for items that store type of service category IDs.
54 | PREV_WORKFLOW_C | INTEGER | No |
The category ID of the claim workflow stored in the item before the change was made to the claim. This column only contains data for items that store claim workflow category IDs.
55 | NEW_WORKFLOW_C | INTEGER | No |
The category ID of the claim workflow stored in the item after the change was made to the claim. This column only contains data for items that store claim workflow category IDs.
56 | PREV_VAL_YN | VARCHAR | No |
The Yes/No value stored in the item before the change was made to the claim. This column only contains data for items that store Yes/No values.
57 | NEW_VAL_YN | VARCHAR | No |
The Yes/No value stored in the item after the change was made to the claim. This column only contains data for items that store Yes/No values.
58 | PREV_NDC_ID | VARCHAR | No |
The NDC code ID stored in the item before the change was made to the claim. This column only contains data for items that store NDC code IDs.
59 | PREV_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
60 | NEW_NDC_ID | VARCHAR | No |
The NDC code ID stored in the item after the change was made to the claim. This column only contains data for items that store NDC code IDs.
61 | NEW_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
62 | PREV_NDC_UNITS_C | INTEGER | No |
The category ID of the NDC Units before the change was made to the claim. This column only contains data for items that store NDC Units category IDs.
63 | NEW_NDC_UNITS_C | INTEGER | No |
The category ID of the NDC Units after the change was made to the claim. This column only contains data for items that store NDC Units category IDs.
64 | PREV_DENY_CLAIM_SOURCE_C | INTEGER | No |
The category ID of the deny claim source stored in the item before the change was made to the claim. This column only contains data for items that store deny claim source category IDs.
65 | NEW_DENY_CLAIM_SOURCE_C | INTEGER | No |
The category ID of the deny claim source stored in the item after the change was made to the claim. This column only contains data for items that store deny claim source category IDs.
66 | PREV_HCFA_UNCLEAN_YN | VARCHAR | No |
The category ID of the CMS (un)clean status stored in the item before the change was made to the claim. This column only contains data for items that store the CMS (un)clean status of a claim.
May contain organization-specific values: No
Category Entries:
Clean
Unclean
67 | NEW_HCFA_UNCLEAN_YN | VARCHAR | No |
The category ID of the CMS (un)clean status stored in the item after the change was made to the claim. This column only contains data for items that store the CMS (un)clean status of a claim.
The category values for this column were already listed for column: PREV_HCFA_UNCLEAN_YN