HSP_CLP_CLAIM_HX
Description:
This table contains the claim action histories for the claim print records associated with the hospital account/liability bucket.

Primary Key
Column Name Ordinal Position
CLAIM_PRINT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 CLAIM_PRINT_ID NUMERIC No
The ID of the claim record associated with a single hospital account.
2 CONTACT_DATE_REAL FLOAT No
The contact date for the creation of the record in internal format. (There is only one contact date per claim print record.)
3 LINE INTEGER No
The line number of one of the multiple values associated with a specific group of data within this record.
4 CLM_ACTION_HIST_C_NAME VARCHAR No
The type of claim action that was taken.
May contain organization-specific values: No
Category Entries:
Viewed
Refreshed
Comment Added
Submitted
Force Submitted
Created
Processed
Accepted
Resubmitted
Printed to Paper
Filed Electronically
EOB Printed
Removed From Queue
Edited Claim
Forced to Paper
Cancel Claim Created
Sent to External Grouper
Received Update From External Grouper
Sent Claim to Claim Edit Workqueue
Added Late Charges
Auto-processed by External Grouper
Reset Edited Values
Replaced Corrected Charge
Removed Reversed Charge
Rapid Retest: Sent Claim
Rapid Retest: Received Update
Rapid Retest: Transmission Failed
Rapid Retest: Response Timed Out
Demand Claim Print Failed
Changed Bundled Episode
Error Bypass
5 HSP_ACCOUNT_ID NUMERIC No
The unique ID of the hospital account with which this claim record is associated.
6 CM_PHY_OWN_ID VARCHAR No
ID of the physical deployment owner for this record. Physical owners will be where the data is hosted, either on the cross-over server or the owner deployment.
7 CLM_HIST_USER_ID VARCHAR No
The user ID who performed claim action for the claim record.
8 CLM_HIST_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 CLM_HIST_CMT_PTR VARCHAR No
The pointer to the comments for the claim action for the claim record.
10 CLM_HIST_DTTM DATETIME (Attached) No
The date and time the claim action was performed.