PB_ACCT_AUTO_PAY_HX

Description:

The PB_AUTO_PAY_HX table stores the history of auto pay status for a premium billing account.

Primary Key

Column Name	Ordinal Position
PB_ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_ACCT_ID	VARCHAR	No
	The unique identifier (.1 item) for the account record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	AUTO_PAY_HX_ACT_C_NAME	VARCHAR	No
	Stores the auto pay action performed. May contain organization-specific values: No Category Entries: Enrolled Canceled Edited
4	AUTO_PAY_HX_ACT_SRC_C_NAME	VARCHAR	No
	Stores the source of the auto pay action performed. May contain organization-specific values: No Category Entries: Hyperspace MyChart Batch Tapestry Link
5	AUTO_PAY_HX_EDIT_TYPE_C_NAME	VARCHAR	No
	When a current auto pay setup is edited, this columns stores the thing that changed. May contain organization-specific values: No Category Entries: Payment Method Payment Day Payment Day and Method Billing Email
6	AUTO_PAY_HX_MYPT_ID	VARCHAR	No
	Stores the MyChart ID of the member if the auto pay action was performed from MyChart
7	AUTO_PAY_HX_ACT_DATE	DATETIME	No
	Stores the date when a particular auto pay workflow was perfomed
8	AUTO_PAY_HX_TERM_RSN_C_NAME	VARCHAR	No
	Stores the reason as to why auto pay was terminated May contain organization-specific values: No Category Entries: User Canceled Member Canceled Payment Failed No Current Coverages Payment Method Expired Employer Canceled