BILL_SCHED_PMT
Description:
This table contains information about scheduled payments. This can include payment plan agreements and payments, Visit Auto Pay payment plans and payments, and trust transfers and payments.

Primary Key
Column Name Ordinal Position
SCHED_PMT_ID 1

Column Information
Name Type Discontinued?
1 SCHED_PMT_ID NUMERIC No
This column stores the unique identifier for the scheduled payment record.
2 RECORD_NAME VARCHAR No
Record name
3 EXTERNAL_IDENT VARCHAR No
This column stores the external identifier for the scheduled payment.
4 SCHED_PMT_TYPE_C_NAME VARCHAR No
Stores the scheduled payment record type.
May contain organization-specific values: No
Category Entries:
Payment Plan Agreement
Trust Recurring Payment
Visit Auto Pay Agreement
Visit Auto Pay One-Time Payment
Trust Recurring Transfer
Payment Plan Auto Pay Payment
Payment Plan Expected Payment Tracker
5 SCHED_PMT_STATUS_C_NAME VARCHAR No
Stores the status of the scheduled payment.
May contain organization-specific values: No
Category Entries:
Scheduled
Unscheduled
Completed
Deactivated
Replaced
Suspended
In Progress
Skipped
Pending Consent
Pending Statement
Pending Completion
Voided
Canceled
Terminated
Signed Up
Outstanding Due
6 IS_ACTIVE_YN VARCHAR No
Indicates whether the scheduled payment record is considered active. 'Y' indicates that the payment record is active. 'N' indicates that it is inactive.
May contain organization-specific values: No
Category Entries:
Yes
7 PARENT_SCHED_PMT_ID NUMERIC No
Stores the parent scheduled payment record associated with the current scheduled payment record.
8 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
9 ACCOUNT_ID NUMERIC No
Stores the guarantor account associated with the scheduled payment.
10 HSP_ACCOUNT_ID NUMERIC No
Stores the hospital account associated with the scheduled payment.
11 CARD_ID NUMERIC No
This column stores the unique identifier for the payment method record of the scheduled payment.
12 PMT_PROCESS_MODE_C_NAME VARCHAR No
Stores the processing mode of the scheduled payment.
May contain organization-specific values: No
Category Entries:
Fixed Amount
Up To Amount
Patient Responsibility
One-Time Payment
13 PMT_PROCESS_MODE_AMT NUMERIC No
Stores the amount associated with the payment processing mode for the scheduled payment.
14 RECUR_TYPE_C_NAME VARCHAR No
Stores the recurrence type of the scheduled payment.
May contain organization-specific values: No
Category Entries:
Monthly
15 RECUR_DAY_OF_MONTH INTEGER No
Stores the recurrence day of month if it is a monthly scheduled payment.
16 RECUR_DAY_OF_WEEK_C_NAME VARCHAR No
Stores the recurrence day of week if it is a bi-weekly or weekly scheduled payment.
May contain organization-specific values: No
Category Entries:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
17 START_DATE DATETIME No
Stores the start date of the scheduled payment.
18 EXP_DATE DATETIME No
Stores the expiration date of the scheduled payment.
19 CREATION_UTC_DTTM DATETIME (UTC) No
Stores the instant at which the scheduled payment record is created.
20 CREATION_SRC_C_NAME VARCHAR No
Stores the source from which the payment schedule was created. For example, it will tell if the scheduled payment was setup through Hyperspace, or MyChart Web etc.
May contain organization-specific values: No
Category Entries:
Hyperspace - Billing Activities
MyChart Web
MyChart Mobile
Welcome
SBO Conversion
Payment Plan Import Utility
System Automatic Action
Advance Bill
Two-Way SMS
Consolidated Balances Conversion
Hyperspace - Payment Collection
System
21 CREATION_USER_ID VARCHAR No
Stores the user who set up the scheduled payment.
22 CREATION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
23 CREATION_MYPT_ID VARCHAR No
Stores the MyChart account that set up the scheduled payment.
24 NEXT_PMT_DATE DATETIME No
Stores the next date on which the payment will be processed.
25 NEXT_PMT_AMT NUMERIC No
Stores the amount that will be processed on the next scheduled date.
26 POSTED_PMT_AMT NUMERIC No
Stores the total amount processed and posted in the system by the scheduled payment.
27 REMAINING_AMT NUMERIC No
This column stores the remaining amount that can be processed to the payment method if the payment processing mode is "Up To Amount."
28 LAST_PROCESS_DATE DATETIME No
Stores the date when the payment method was last processed.
29 LAST_PROCESS_PMT_AMT NUMERIC No
Stores the amount that was processed during the last attempt.
30 LAST_PROCESS_CARD_TX_STS_C_NAME VARCHAR No
Stores the status of the last processing attempt.
May contain organization-specific values: No
Category Entries:
Error
Accepted
Declined
31 LAST_PROCESS_USER_ID VARCHAR No
Stores the user who attempted the last processing of the payment method.
32 LAST_PROCESS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
33 LAST_STATUS_DATE DATETIME No
Shows the date on which the payment schedule was set to the current status.
34 EMAIL_ADDRESS_OVRIDE VARCHAR No
If set, this email will be used when sending notifications for this scheduled payment instead of the guarantor's email.
35 MOBILE_PHONE_OVRIDE VARCHAR No
If set, this mobile phone number will be used when sending notifications for this scheduled payment instead of the guarantor's mobile phone number.
36 TRANSFER_FROM_GUAR_ID NUMERIC No
Stores the source guarantor account associated with the scheduled trust transfer.
37 LAST_BSP_CONSENT_TYPE_C_NAME VARCHAR No
The type of the most current consent for the Visit Auto Pay agreement represented by this scheduled payment.
May contain organization-specific values: No
Category Entries:
Verbal
Paper - Not Yet Scanned
Paper - Scanned
E-Signature
Self Service
38 LAST_CONSENT_USER_ID VARCHAR No
The user that collected or updated the most current consent for the Visit Auto Pay agreement represented by this scheduled payment.
39 LAST_CONSENT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
40 LAST_CONSENT_DOCUMENT_ID VARCHAR No
The document representing the most current consent for the Visit Auto Pay agreement represented by this BSP.
41 CONSENT_DATE DATETIME No
The date the patient consented to the terms for this scheduled payment.
42 CREATION_DATE DATETIME No
The date at which the scheduled payment record was created.
43 RESOLUTION_DTTM DATETIME (Local) No
The instant (local, guarantor's time zone) in which the scheduled payment record was resolved, either by completing successfully or being cancelled.
44 RESOLUTION_DATE DATETIME No
The date in which the scheduled payment record was resolved, either by completing successfully or being cancelled.
45 RESOLUTION_STATUS_C_NAME VARCHAR No
The resolution status category ID for this scheduled payment record. Use this to indicate the extent to which a the agreement was successful in collecting a payment.
May contain organization-specific values: No
Category Entries:
Payment Received
Partial Payment
No Payment Needed
No Payment Received or Never Active
46 RESOLUTION_REASON_C_NAME VARCHAR No
The resolution reason category ID for this scheduled payment. Use this to indicate the specific path-to-arrival to a resolution status (RESOLUTION_STATUS_C).
May contain organization-specific values: No
Category Entries:
Self-Pay Liability Covered
No Self-Pay Liability
Self-Pay Liability Exceeded Threshold
Consent Not Received
Consent Duration Exceeded
Canceled by Patient
Canceled by User
Voided
Sent to Payment Plan
Sent to Bad Debt
Guarantor Changed
Notification Failed
Canceled by System
Automatic Payment Declined
Appointment Canceled
System Error
Payment Plan Cycle Completed
Account Contested
47 CANCELLATION_REASON_C_NAME VARCHAR No
The cancelation reason category ID for this scheduled payment. This column can be used to see the user-specified reason that a patient is canceling the agreement.
May contain organization-specific values: Yes
Category Entries:
Financial Status Changed
Changed Mind
Disputed Terms
Patient Canceled
Legal
Consolidated Balances Conversion
48 TOTAL_SP_RESP_AMT NUMERIC No
This column contains the total self-pay responsibility on a Visit Auto Pay agreement, regardless of the agreement being cancelled.
49 ALL_HAR_BAL_IN_FULL_SP_DATE DATETIME No
This column contains the most recent date in which all balances were on self-pay for all associated hospital accounts.
50 LAST_CONSENT_DTTM DATETIME (Local) No
The consent date and time for the Visit Auto Pay agreement.
51 CUR_ACTIVE_SCHED_PMT_ID NUMERIC No
This column contains the current active agreement (Visit Auto Pay or Payment Plans) in a replacement chain for any given agreement. If the agreement is not in a replacement chain, this column will match the agreement ID.
52 CANCELLATION_USER_ID VARCHAR No
This column contains the user who canceled the scheduled payment.
53 CANCELLATION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
54 CANCELLATION_MYPT_ID VARCHAR No
This column contains the MyChart account that canceled the scheduled payment.
55 FINAL_RESOLUTION_DATE DATETIME No
This column contains the date when the agreement was resolved and all charges were in full self-pay for all accounts. - If the agreement is not resolved, this column will be empty. - If the agreement has not ever been in a state where all charges were in full self-pay, this column will be empty - If both the agreement is resolved and all charges on all visits were in full self-pay at least once in the agreement's lifetime, this column will contain the later of Resolution Date (I BSP 155) and All Hospital Account Balances in Full Self-Pay Date (I BSP 1752). By comparing this item with the Resolution Date, reports can find cases where VAP-eligible balances are dropping to self pay after the agreement was completed.
56 FINAL_VAP_SCHED_PMT_ID NUMERIC No
This column contains the final Visit Auto Pay agreement for a visit. This is determined by finding either the current active Visit Auto Pay agreement or finding the agreement that was most recently resolved. This uses the associated hospital account for Hospital Billing and the associated visit for Professional Billing.
57 VISIT_DATE DATETIME No
This column stores the visit date of the primary visit at the time of consent.
58 VISIT_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
59 CREATION_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
60 PAT_PMT_COLL_WKFL_C_NAME VARCHAR No
This column contains the workflow category ID performed to collect a patient payment from the point of view of the user. For example, MyChart eCheck-in vs. MyChart One-Touch.
May contain organization-specific values: No
Category Entries:
Staff Collected
MyChart Billing
MyChart One-Touch
MyChart Pay as Guest
MyChart Visit Payment
MyChart eCheck-in
Welcome Balance Payment
Welcome Check-in
Two-Way SMS
Payment Posting
Lockbox
Release of Information
Willow Ambulatory
Web Service
61 MYC_SIGNIN_METHOD_C_NAME VARCHAR No
This column denotes how the patient or guarantor logged in to MyChart to create the agreement. Only populated for agreements made via MyChart.
May contain organization-specific values: No
Category Entries:
Password Sign-in
Demographics Sign-in
No Sign-in
62 GUAR_MYC_STATUS_C_NAME VARCHAR No
This column stores the MyChart account status for the guarantor at the time the agreement is created or updated. An active MyChart account status is defined as whether a MyChart user could log into the account with a user name and password. Accounts that are not yet active, deactivated, or are proxy accounts are considered inactive.
May contain organization-specific values: Yes
Category Entries:
ACTIVE
INACTIVE
63 CREATION_MYC_STATUS_C_NAME VARCHAR No
This column stores the MyChart account status for the MyChart account who created or last updated the agreement. An active MyChart account status is defined as whether a MyChart user could log into the account with a user name and password. Accounts that are not yet active, deactivated, or are proxy accounts are considered inactive.
The category values for this column were already listed for column: GUAR_MYC_STATUS_C_NAME
64 PREV_SCHED_PMT_ID NUMERIC No
Stores the previous record that was replaced with the current scheduled payment record.
65 PMT_TRACKER_SCHED_PMT_ID NUMERIC No
The unique ID of the expected payment tracker record associated with this scheduled payment. This is currently only used for payment plans to track each month's Auto Pay.
66 REPLACEMENT_REASON_C_NAME VARCHAR No
The reason a BSP was replaced. For example, if a payment plan had new balances added, the Agreement BSP will be replaced with one representing the new terms. The previous BSP will be marked as "Replaced" and have a replacement reason of "Principal Edit".
May contain organization-specific values: No
Category Entries:
Principal Edit
Monthly Amount Edit
Administrative Edit
One Time Date Override
Discrepancy Resolution
Account Disqualified
Account Combined
Payment Plan Tracker BSP Conversion
Estimate Replaced
Visit Changes
67 REMAINING_NUMBER_PAYMENTS INTEGER No
The number of payments remaining if this agreement has a recurring payment cycle.
68 PP_INITIAL_BALANCE NUMERIC No
The total initial balance on the payment plan agreement.
69 PP_MONTHLY_AMT NUMERIC No
The amount agreed to be paid each month on the payment plan.
70 PP_INITIAL_NUMBER_PAYMENTS INTEGER No
The initial number of payments on a payment plan agreement.
71 PP_DUE_DAY_OF_MONTH INTEGER No
The recurring day of month on which payment will be due for this payment plan.
72 PP_NEXT_DUE_DATE DATETIME No
The upcoming due date for this month's payment.
73 PP_TOTAL_DEFER_MONTHS INTEGER No
The total number of payments that have been delayed as a result of a deferral over the course of the plan. This is only incremented if the deferred months have elapsed.
74 PP_CURRENT_DEFER_MONTHS INTEGER No
The number of months that a payment plan is currently deferred.
75 PP_IS_AUTO_PAY_YN VARCHAR No
Indicates whether the payment plan is set up as an Auto Pay agreement. 'Y' indicates that the payment plan is Auto Pay. 'N' indicates that the payment plan does not have a payment method attached and therefore isn't Auto Pay. NULL indicates that this agreement is not a payment plan.
May contain organization-specific values: No
Category Entries:
No
Yes
76 PP_IS_OVERDUE_YN VARCHAR No
Indicates whether the payment plan has a balance overdue from the previous cycle. 'Y' indicates that the payment plan has an overdue balance. 'N' indicates that the payment plan does not have an overdue balance. NULL indicates that this agreement is not a payment plan.
The category values for this column were already listed for column: PP_IS_AUTO_PAY_YN
77 PP_AUTO_PAY_SUSPENDED_YN VARCHAR No
Indicates whether the payment plan's Auto Pay is suspended due to a payment error or declined payment. 'Y' indicates that the payment plan has suspended Auto Pay. 'N' indicates the payment plan's Auto Pay is not suspended. NULL indicates that this is not a payment plan agreement or does not have Auto Pay.
The category values for this column were already listed for column: PP_IS_AUTO_PAY_YN
78 ORIGINAL_PARENT_SCHED_PMT_ID NUMERIC No
The unique ID of the original agreement record in a replacement chain of agreement records.
79 VAP_RESOLUTION_SP_AMT NUMERIC No
The difference between the remaining self-pay balance of all accounts on a Visit Auto Pay agreement on its resolution date (BSP-155) and posted payments from the agreement (BSP-161).
80 VAP_RESOLUTION_SP_DATE DATETIME No
The latest date on which all accounts associated with the Visit Auto Pay agreement reached full self-pay, as of the Visit Auto Pay's resolution date (BSP-155). This date can be any time before or equal to the agreement's resolution date. If all of the accounts on the agreement were not fully in self-pay by the resolution date of the agreement, this column is blank.