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