ACCOUNT_VIS_ACT_HX

Description: |
The ACCOUNT_VIS_ACT_HX table contains information about visit-level actions performed on guarantor accounts. The LINE column gives the order in which the actions happened, so rows with a higher LINE happened after rows with a lower LINE. The VIS_ACT_NUM column gives the visit number on the account.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier for the guarantor 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 | VIS_ACT_NUM | VARCHAR | No |
Visit number on the account.
4 | VIS_ACT_DATE | DATETIME | No |
The date the action happened.
5 | VIS_ACT_ACTION_C_NAME | VARCHAR | No |
The category ID that represents an action taken on a visit.
May contain organization-specific values: No
Category Entries:
Not Allowed Adjustment
Transfer to Self-Pay
Next Responsible Party
Resubmit Insurance
Write Off Self-Pay
Write Off Insurance
Transfer to Insurance
Gramm Rudman Adjustment
Denied
Turn Off Automatic Self-Pay Write-Off
Turn On Automatic Self-Pay Write-Off
Close Claim
Debit Adjustment
Research
Do Not Bill Insurance
Bill Insurance
Suspended NRP
Recalculate Discount
Service Level Authorization Edit
Post Dental Upgrade Adjustment
Create Shadow Charges
6 | VIS_ACT_CVG_ID | VARCHAR | No |
The visit coverage at the time the action happened.
7 | VIS_ACT_AMT | NUMERIC | No |
Action amount; what this amount represents is determined by the specific action taken (see VIS_ACT_ACTION_C column). Some actions (e.g. Research) may not have an amount.
8 | VIS_ACT_USER_ID | VARCHAR | No |
The unique identifier for the user record of the user who performed the action.
9 | VIS_ACT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.