ACCOUNT_CONTACT

Description:

This table contains the information recorded in billing system account contact for each account. Each row in this table contains information about one contact and is uniquely identified by the Account ID and line number combination.

Primary Key

Column Name	Ordinal Position
ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCOUNT_ID	NUMERIC	No
	The unique ID for the account record. This ID number could be encrypted if you have elected to implement enterprise reporting’s encryption security function.
2	LINE	INTEGER	No
	Line number to identify the account contact information within the account.
3	CONTACT_DATE	DATETIME	No
	The date the contact was recorded.
4	USER_ID	VARCHAR	No
	The ID of the system user who recorded the contact. This ID may be encrypted if you have elected to use enterprise reporting’s security utility.
5	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	CONTACT_STATUS_C_NAME	VARCHAR	No
	The category value associated with the activity performed by collections staff on the account, such as No Contact, Check Mailed, Promised Payment, etc. May contain organization-specific values: Yes Category Entries: No Contact Check Mailed Promised Payment Phone Disconnected Letter Billing Note Contacted Inquiry Account Put on Hold Reminder Set Collections Write-Off Applied Account Reassigned Account Status Changed Account Note Made Account Completed Account Transferred In Account Transferred Out External Agency Bad Debt Written Off Account Sent to External Agency Account Recalled from External Agency Update Sent to External Agency Payment Plan Billing Status Patient Flag Made Credit WQ Info Refund Credit WQ Transfer Defer in Credit WQ Appointment Desk Registration Credit WQ Manual Complete Demand Bill Customer Relationship Management Balance Transfer Dismiss Tickler Enable Paperless Billing Disable Paperless Billing Send Transactions to Agency Recall Transactions from Agency Manually Assigned Remove Payment Plan Edit Payment Plan Unlock Pay as Guest Skip in Guarantor WQ Defer in Guarantor WQ Activate in Guarantor WQ
7	TICKLER_DATE	DATETIME	No
	The date the account should be contacted again.
8	LETTER_NUMBER	VARCHAR	No
	The letter number of the letter associated with this guarantor.
9	REFUND_REQ_ID	NUMERIC	No
	Stores payment transaction numbers of a refund request for the Account Contact activity.
10	REFUND_REQ_STATUS_C_NAME	VARCHAR	No
	Stores the refund request status associated with the Account Contact activity. May contain organization-specific values: No Category Entries: Requested Reviewed Approved Declined Posted
11	REFUND_REQ_AMT	NUMERIC	No
	Stores the amount of the refund request associated with the activity.
12	PAYMENT_TXS	VARCHAR	No
	A comma-delimited list of follow-up transactions.
13	FOL_UP_CUR_INS_BAL	NUMERIC	No
	Follow-up current insurance balance.
14	FOL_UP_CUR_PAT_BAL	NUMERIC	No
	Follow-up current patient balance.
15	FOL_UP_ACT_INFO	VARCHAR	No
	This item stores the activity info to be displayed in account contact.
16	LETTER_SUMMARY	VARCHAR	No
	A short summary of the letter that was sent to the patient. This can be customized by your organization, and may include information like the patient's name, address and balance.
17	LETTER_STATUS_C_NAME	VARCHAR	No
	The letter status category ID for the guarantor, for example "queued" or "sent". May contain organization-specific values: No Category Entries: Not yet printed Queued Printed Sent Rejected Purged Hidden
18	NOTE_ID	VARCHAR	No
	The ID of the note associated with this contact.
19	FOL_UP_HX_CRM_ID	NUMERIC	No
	Stores the ID for an customer service record that is related to the guarantor.
20	FOL_UP_NOTE	VARCHAR	No
	Each guarantor account may have a follow-up note posted to it per contact. This column holds either a system generated or custom note that further describes the contact, if a note was produced.
21	LETTER_NAME	VARCHAR	No
	The name of the letter.
22	PAPERLESS_UPD_WHY_C_NAME	VARCHAR	No
	Reason for updating the guarantor's MyChart paperless billing status. May contain organization-specific values: Yes