PRE_AR_CHG_HX
Description:
This table contains one row for each activity performed on a temporary accounts receivable (TAR) record of type charge. This table contains basic information about the activity (activity code, user, date, and comment). Note: TAR records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table might be lost if you truncate the table.

Primary Key
Column Name Ordinal Position
TAR_ID 1
CHARGE_HX_LINE 2

Column Information
Name Type Discontinued?
1 TAR_ID NUMERIC No
The unique ID of the temporary transaction record.
2 CHARGE_HX_LINE INTEGER No
The line number for the history information associated with this record. This does not correspond to the CHARGE_LINE columns of other PRE_AR_CHG tables.
3 ACTIVITY_C_NAME VARCHAR No
The activity performed category ID for the temporary transaction.
May contain organization-specific values: No
Category Entries:
Enter WQ
Review
Reenter WQ
Force Resubmit
Transfer
Deletion
Automatic Transfer
Automatic Reentry
Resubmit
Automatic Filing
Defer
Activate
Charge Homed
Automatic Update
Retroadjudication
Pre Charge Review Extension
Research Review
Request for Billing Information
Research Correct
Anesthesia Session Flagged
Anesthesia Session Unflagged
Skip
Start User Access
End User Access
WQ Processing
Edit
Release from HPF WQ
Charge Session Created
Start Charge Review Filing
Violate Rule
Rule Resolved
Exit WQ
Charge Filed
Coding Flag Added
Coding Flag Removed
4 ACTIVITY_DATE DATETIME No
The date when the activity is performed.
5 ACTIVITY_EXIT_DT DATETIME No
The date when the "resolve" activity is performed.
6 ACTIVITY_TIMESTAMP NUMERIC No
The time when the activity was performed in seconds from 12/31/1840.
7 USER_ID VARCHAR No
The unique ID of the user who performed the activity. This column is frequently used to link to the CLARITY_EMP table.
8 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 USER_COMMENT VARCHAR No
The comments that the user added when performing the activity.
10 EXIT_TIMESTAMP NUMERIC No
The time when the resolving activity was performed in seconds from 12/31/1840.
11 EXIT_USER_ID VARCHAR No
The unique ID of the user who performed the resolving activity. This column is frequently used to link to the CLARITY_EMP table.
12 EXIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 EXIT_ACTIVITY_C_NAME VARCHAR No
The category number of the resolving activity.
The category values for this column were already listed for column: ACTIVITY_C_NAME
14 DEFER_UNTIL_DTTM DATETIME (UTC) No
Records the date & time (including time zone in UTC format) that a charge session was deferred until.