HSP_BDC_CHNG_HX

Description: |
Change History for the Denial/Correspondence (BDC) record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
BDC_ID | 1 |
LINE_COUNT | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BDC_ID | NUMERIC | No |
This column stores the unique identifier for the denial or correspondence record.
2 | LINE_COUNT | INTEGER | No |
Line number of change history that is being extracted by enterprise reporting.
3 | CHNG_INSTANT | DATETIME (Local) | No |
Instant this change occurred
4 | CHNG_USER_ID | VARCHAR | No |
User who initiated the change
5 | CHNG_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | CHNG_TYPE_C_NAME | VARCHAR | No |
Type of change that occurred.
May contain organization-specific values: No
Category Entries:
Created
Updated
Transferred to Other Account
Transferred to Other Bucket
Status Changed
Closed
Re-opened
Voided
Changed Follow-up Date
Changed Stage
Expected Allowed Amount Updated
Owning Area Changed
Owning User Changed
Billing System Changed
Payer Downgrade Type Changed
Payer Downgrade Outcome Changed
Updated by Billing Activity
Release Created
Result Changed
Appeal Started
Appeal Voided
Claim Status Codes Updated
Owning Area ID Changed
Owning User ID Changed
7 | CHNG_SOURCE_VAL | VARCHAR | No |
This column stores the source value before change. It can be the unique identifier for the liability bucket or the denial/correspondence type (I BDC 30) depending on the type of change.
8 | CHNG_TARGET_VAL | VARCHAR | No |
This column stores the target value after change. It can be the unique identifier for the liability bucket or the denial/correspondence type (I BDC 30) depending on the type of change.
9 | CHNG_FOLLOW_UP_DT | DATETIME | No |
The follow-up date associated with the change.
10 | CHNG_COMMENTS | VARCHAR | No |
Comments for change.
11 | BFH_ID | NUMERIC | No |
Stores the Billing Follow-up History (BFH) record ID that contains the information about the billing activity that was performed on this BDC.