Table: dbo.Insurepay_Payroll_Transmission
Table containing client specific InsurePay payroll file information.
Columns
NameTypeConstraintsDescription
insurepay_payroll_transmission_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLForeign key for this table.The associated InsurePay_Client key.
number_of_employeeint (4)NOT NULLnumber of employee included in the Insurepay payroll file.
gross_paydecimal (9, 2)NOT NULLTotal of all payroll checks included in this Insurepay payroll file.
check_datesmalldatetime (4)NOT NULLcheck_date for insurepay payroll file
payroll_data_xmlnvarchar (-1)NOT NULLinsurepay payroll file xml data for the client.
period_begin_datesmalldatetime (4)NOT NULLPeriod beginning date that this payroll transmission covers
period_end_datesmalldatetime (4)NOT NULLPeriod ending date that this payroll transmission covers
Primary key
NameColumnsDescription
PK_Insurepay_Payroll_Transmissioninsurepay_payroll_transmission_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Payroll_Transmission__Insurepay_Client__client_KEYclient_KEYInsurepay_Client (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Insurepay_Payroll_Transmission_Result__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEYinsurepay_payroll_transmission_KEYInsurepay_Payroll_Transmission_Result
FK_Insurepay_N_Payroll_Bank_Transaction__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEYinsurepay_payroll_transmission_KEYInsurepay_N_Payroll_Bank_Transaction

Schema diagram