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.