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
NameTypeConstraintsDescription
client_pay_schedule_detail_KEYint (4)NOT NULLPrimary key. Doubles as the link to the paschedule detail that was processed by the Autopay session.
session_start_datesmalldatetime (4)NOT NULLDate and time the session started.
autopay_session_status_KEYtinyint (1)NOT NULLStatus of the session.
user_session_guiduniqueidentifier (16)NOT NULLUser session that started the Autopay session. Used for cleanup if the Autopay session stops abruptly.
detailsnvarchar (-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
NameColumnsDescription
PK_Autopay_Session$client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEY
Unique constraints
NameColumnsDescription
UK_Autopay_Session$client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Autopay_Session__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)
FK_Autopay_Session__Autopay_Session_Status__autopay_session_status_KEYautopay_session_status_KEYAutopay_Session_Status (autopay_session_status_KEY)

Schema diagram