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	NUMERIC	No
	Stores the service area associated with the scheduled payment.
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	NUMERIC	No
	This column contains the department of the primary visit at the time of consent.
59	CREATION_DEPARTMENT_ID	NUMERIC	No
	This column contains the department in which the user was logged into at the time of consent. This will be empty for agreements created via MyChart or Welcome.
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.