ACCOUNT_2
Description:
Accounts contain information about billing for services, while coverages contain information about insurance payors, benefits, subscribers, and members. This table contains one row for each account record in your system. This table is the continuation of the ACCOUNT table.

Primary Key
Column Name Ordinal Position
ACCT_ID 1

Column Information
Name Type Discontinued?
1 ACCT_ID NUMERIC No
The unique identifier for the account record.
2 FOL_UP_LEVEL_CUR INTEGER No
Current follow up level.
3 EMPL_ID_NUM VARCHAR No
Employee ID number of the guarantor.
4 BILLING_NOTE_EXP_DT DATETIME No
Billing note expiration date.
5 ALT_BILL_ADDR_YN VARCHAR No
Indicates whether the Alternate Billing Address is used. "Y" indicates that the Alternate Billing Address is used. "N" indicates that the Alternate Billing Address is not used.
May contain organization-specific values: No
Category Entries:
Yes
No
6 ALT_BILL_CITY VARCHAR No
This is the city on the Alternate Billing Address.
7 ALT_BILL_STATE_C_NAME VARCHAR No
The category value of the state on the Alternate Billing Address.
May contain organization-specific values: Yes
8 ALT_BILL_ZIP VARCHAR No
This is the zip code on the Alternate Billing Address.
9 RQG_ACCT_YN VARCHAR No
Indicates whether this is a requisition grouper account.
May contain organization-specific values: No
Category Entries:
No
Yes
10 GUAR_SYNC_OWNER_ID NUMERIC No
When using guarantor account syncing, this item is the record pointer to the owning guarantor account, if one exists.
11 EAR_ISOLATED_YN VARCHAR No
This flag is set if the guarantor is considered "isolated" for patient data restrictions. Isolated guarantors are guarantors created from isolated patients.
May contain organization-specific values: No
Category Entries:
No
Yes
Needs review
12 CVG_LAST_VERIF_DT DATETIME No
Contains the date that the corresponding coverage was last verified.
13 USER_CVG_LST_VER_ID VARCHAR No
Contains the date that the corresponding coverage was last verified.
14 USER_CVG_LST_VER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 EMPLOYMENT_DATE DATETIME No
The date the guarantor was employed.
16 EMPLOYER_FAX VARCHAR No
The guarantor's employer's fax number.
17 FAX VARCHAR No
The fax number associated with this guarantor account.
18 LAST_BILLED_AMT NUMERIC No
Last statement's billed amount
19 LAST_INS_BAL NUMERIC No
Last statement's insurance amount
20 LAST_CLAIM_DATE DATETIME No
Last date the claim was produced
21 BILL_STATUS_EXP_DT DATETIME No
Billing status expiration date
22 PMT_PLAN_FREQ_C_NAME VARCHAR No
Payment plan frequency
May contain organization-specific values: No
Category Entries:
Weekly
Semi-Monthly
Monthly
23 ACCT_VIP_STAT_YN VARCHAR No
Indicates whether there is VIP status for this account. Y indicates the account has VIP status. N indicates the account does not have VIP status.
May contain organization-specific values: No
Category Entries:
Yes
No
24 HBMYC_LST_ST_V_DTTM DATETIME (UTC) No
The date and time when a Hospital Billing statement was last viewed in MyChart by this guarantor. This field will be updated when either a guarantor-level or hospital account-level statement is viewed in MyChart for this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
25 HBMYC_LST_DB_V_DTTM DATETIME (UTC) No
The date and time when a Hospital Billing detail bill was last viewed in MyChart by this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
26 HBMYC_LST_LT_V_DTTM DATETIME (UTC) No
The date and time when a Hospital Billing letter was last viewed in MyChart by this guarantor. This field will be updated when either a guarantor-level or hospital account-level letter is viewed in MyChart for this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
27 CREDIT_SCORE INTEGER No
The guarantor's credit score.
28 PROPENSITY_TO_PAY_C_NAME VARCHAR No
Category describing the likelihood for this guarantor to pay.
May contain organization-specific values: Yes
29 FOL_UP_LAST_LET_DT DATETIME No
Date the last follow-up letter was sent.
30 UNDIST_CREDIT_BAL NUMERIC No
Total account undistributed credit balance
31 UNDIST_INS_CR_BAL NUMERIC No
Account undistributed credit balance - insurance credits only.
32 UNDIST_SP_CR_BAL NUMERIC No
Account undistributed credit balance - self-pay credits only.
33 DELIVERY_POINT VARCHAR No
The billing delivery point is a two digit extension to the nine digit US zip code, with values from 00 to 99.
34 MILITARY_RANK_C_NAME VARCHAR No
This column stores the military rank to which the patient's guarantor belongs.
May contain organization-specific values: Yes
No Entries Defined
35 BRANCH_OF_SERVICE_C_NAME VARCHAR No
This column stores the military branch of service to which the guarantor belongs.
May contain organization-specific values: Yes
36 MIL_COMPONENT_C_NAME VARCHAR No
This column stores the guarantor's military component, which is used to distinguish between guarantors who are on regular active duty and those who are members of one of the augmenting support groups.
May contain organization-specific values: Yes
No Entries Defined
37 MIL_PAY_GRADE_C_NAME VARCHAR No
This column stores the military pay grade to which the patient's guarantor belongs.
May contain organization-specific values: Yes
No Entries Defined
38 DIST_LATER_COUNT INTEGER No
Number of undistributed credits that are marked as for later distribution in this account.
39 GUAR_EMPR_COUNTY_C_NAME VARCHAR No
The category value corresponding to the county in which the guarantor's employer is located.
May contain organization-specific values: Yes
40 ALT_BILL_COUNTY_C_NAME VARCHAR No
The category number for the alternate county of the guarantor's billing address.
The category values for this column were already listed for column: GUAR_EMPR_COUNTY_C_NAME
41 ALT_BILL_COUNTRY_C_NAME VARCHAR No
The category number for the alternate country of the guarantor's billing address.
May contain organization-specific values: Yes
42 ALT_BILL_HOUSE_NUM VARCHAR No
The alternate billing house number for the guarantor.
43 ALT_BILL_DISTRICT_C_NAME VARCHAR No
The category number for the alternate district of the guarantor's billing address.
May contain organization-specific values: Yes
44 STMT_HOLD_DT DATETIME No
The most recent date on which the account was held from the Professional Billing (PB) statement processing.
45 STMT_HOLD_REASON_C_NAME VARCHAR No
The reason why the account was held in Professional Billing statement processing.
May contain organization-specific values: Yes
Category Entries:
Minimum guarantor account balance not met
Credit balance on the guarantor account
Guarantor account already on another run
Guarantor account status not to bill
Minimum days between two statements not met
Guarantor address has no ZIP code
Charge Homing is turned on and guarantor account is not in its home
Skip guarantor account extension
No professional balance and no hospital account to bill
No hospital account to bill
Guarantor account has a hospital account with a self-pay payment/adjustment posted today
Guarantor account has a hospital account on payment plan that did not qualify
Form not found
Cannot demand if form requires importing images
Undistributed non self-pay credits
Undistributed self-pay payment
Zero Charge
Statement already processed this month for payment plan
SmartText and Classic forms cannot be included in the same run
Cannot send tickler to guarantor for paperless bill
Minimum days between guarantor detail bill and statement not met
Payment plan already paid for this month
Guarantor has a balance notification scheduled or recently sent
Payment plan is currently deferred, and guarantor has only plan balances
Guarantor billing status not to bill
Statement intervention
Guarantor does not have new activity
Guarantor does not have transactions to bill
Excluded during printing
Guarantor special billing status set to hold statements
Visit auto pay scheduled
Cannot send another statement before processing auto pay from the last statement
Payment plan processing in progress
Voided transactions
Payor hold
Transaction skip function
Contested
Debit adjustments
Fully Paid Insurance Activity
Visit is not discharged
Posted Not Billed
Consolidated Balance
Transaction skip extension
Service date range
Small balance write off
Client guarantor
Client next statement date is not before or equal to end batch date
46 MYPT_ID VARCHAR No
The unique ID of the MyChart account that is linked to this guarantor record. This is used when the guarantor is not a patient in the system but needs to have access to the billing information in MyChart.
47 GUAR_SUBDIV_CODE_C_NAME VARCHAR No
Capture the guarantor's country subdivision code.
May contain organization-specific values: Yes
No Entries Defined
48 MOBILE_PHONE VARCHAR No
Mobile phone for guarantor accounts.
49 FOL_UP_LAST_LEVEL INTEGER No
This retains the value of the current follow up level (I EAR 3007) when a letter was last generated.
50 PMT_PLAN_DLQ_AMT NUMERIC No
This is the sum of delinquent payment plan payments.
51 PMT_PLAN_DUE_AMT NUMERIC No
This includes both the delinquent amount and the amount due for the current month.
52 PMT_PLAN_PAID_AMT NUMERIC No
This is the total amount of the payment plan payments.
53 PMT_PLAN_REMAIN_AMT NUMERIC No
This is the remaining amount of the payment plan.
54 HB_EXT_AR_SELF_PAY_BAL NUMERIC No
This item stores the Hospital Billing (HB) external Accounts Receivable (AR) self-pay balance for the account.
55 HB_EXT_AR_INS_BAL NUMERIC No
This item stores the Hospital Billing (HB) external Accounts Receivable (AR) insurance balance for the account.
56 HB_EXT_AR_UNDIST_BAL NUMERIC No
This item stores the Hospital Billing (HB) external Accounts Receivable (AR) undistributed balance for the account.
57 HB_LAST_AUTOPAY_DATE DATETIME No
The most recent Auto Pay date for guarantor set up with a payment plan on Auto Pay.
58 EMAIL_ADDRESS VARCHAR No
Email address documented on the guarantor. Any clarity report looking for the guarantor's email address must search in the following sequence, and use the first found one: - The primary email address from the associated patient of the guarantor. - The email address from the MyChart account associated with the guarantor. - The email address returned by this clarity column.
59 ADDR_CHG_USER_ID VARCHAR No
The user who initiated the linked address changes.
60 ADDR_CHG_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
61 ADDR_CHG_INSTANT_DTTM DATETIME (Local) No
The instant that the linked address change was initiated.
62 ADDR_CHG_SOURCE VARCHAR No
The source record that initiated the linked address changes.
63 PREFERENCE_ID NUMERIC No
The ID number of the communication preferences record for the guarantor.
64 PMT_PLAN_CURRENT_MISS_CNT INTEGER No
This item will store the number of payments that are currently late on the payment plan
65 PMT_PLAN_TOTAL_MISS_CNT INTEGER No
This item will store the total number of missed payments on the account's payment plan.
66 PMT_PLAN_AUTOPAY_CARD_ID NUMERIC No
Credit card associated with the payment plan. This credit card will be charged automatically when an installment is due for the payment plan. This column will be deprecated in the future release as the payment plan is being transitioned to use the scheduled payment framework. Once the transition is complete, reference the scheduled payment record for the current credit card.
67 PB_PP_AUTOPAY_SCHED_PMT_ID NUMERIC No
The scheduled payment record (BSP) associated with the guarantor's payment plan. Scheduled payment record is used to define the auto pay payment plan terms, including the payment method, day to trigger payment, and monthly amount.
68 PMT_PLAN_CURR_AMT NUMERIC No
If Guarantor is on autopayment plan using Scheduled Payment architecture, this item stores the monthly amount to be used for this payment plan cycle if the value is different than the updated payment plan monthly amount in payment plan amount.
69 KI_GUAR_ACCT_VERIF_DATE DATETIME No
This item indicates the most recent date the patient verified the self-guarantor billing information is correct in Welcome.
70 KI_GUAR_ACCT_VERIF_STS_C_NAME VARCHAR No
This item indicates the most recent patient-selected status of whether the self-guarantor billing information is correct in Welcome.
May contain organization-specific values: No
Category Entries:
Kiosk - Needs Review
Kiosk - Verified
71 LAST_PB_BAL_NOTIF_DATE DATETIME No
The date on which the last balance notification was sent to the guarantor for their Professional Billing (PB) balances.
72 LAST_HB_BAL_NOTIF_DATE DATETIME No
The date on which the last balance notification was sent to the guarantor for their Hospital Billing (HB) / Single Billing Office (SBO) balances.
73 PB_SELF_PAY_BAL_UPDATE_DATE DATETIME No
This is updated based on changes to patient balance.
74 HB_SELF_PAY_BAL_UPDATE_DATE DATETIME No
This is updated based on changes to Hospital Billing (HB) self-pay balance (I EAR 20003).