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
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
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