ACCOUNT_CONTACT_2

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 |
--- | --- | ---
ACCT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_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 | FOL_UP_MYC_USER_ID | VARCHAR | No |
The ID of the MyChart user who created the contact. This ID may be encrypted if you have elected to use enterprise reporting’s security utility.
4 | PAY_PLAN_SOURCE_C_NAME | VARCHAR | No |
The source workflow category ID that set up the payment plan for the guarantor.
May contain organization-specific values: No
Category Entries:
Hyperspace
MyChart Web
MyChart Mobile
SBO Conversion
Import Utility
Welcome
System Action
Advance Bill
Two-Way SMS
Consolidated Balances Conversion
Virtual Assistant