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
SMS
Utility
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
Skipped - Expecting negative retroactivity
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
Government Withholdings
9 | AUTO_PAY_HX_ACT_TM | DATETIME (Local) | No |
This item stores the time when a particular auto pay workflow was performed
10 | AUTO_PAY_HX_PMT_MTHD_ID | NUMERIC | No |
Stores the payment method in place when a current auto pay setup is edited.