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.