Table: dbo.Autopay_Session
Contains info about Autopay sessions. In an Autopay session the system automatically creates checks from a pay schedule detail record.
Columns
Name | Type | Constraints | Description
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Primary key. Doubles as the link to the paschedule detail that was processed by the Autopay session.
session_start_date | smalldatetime (4) | NOT NULL | Date and time the session started.
autopay_session_status_KEY | tinyint (1) | NOT NULL | Status of the session.
user_session_guid | uniqueidentifier (16) | NOT NULL | User session that started the Autopay session. Used for cleanup if the Autopay session stops abruptly.
details | nvarchar (-1) |  | Details, if any, of what happened in the session. Nonscalar data stored using JSON. Can include error messages as well as basic processing information.

Primary key
Name | Columns | Description
PK_Autopay_Session$client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Autopay_Session$client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Autopay_Session__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |
FK_Autopay_Session__Autopay_Session_Status__autopay_session_status_KEY | autopay_session_status_KEY | Autopay_Session_Status (autopay_session_status_KEY) |