Table: dbo.Insurepay_Payroll_Transmission
Table containing client specific InsurePay payroll file information.
Columns
Name | Type | Constraints | Description
insurepay_payroll_transmission_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | Foreign key for this table.The associated InsurePay_Client key.
number_of_employee | int (4) | NOT NULL | number of employee included in the Insurepay payroll file.
gross_pay | decimal (9, 2) | NOT NULL | Total of all payroll checks included in this Insurepay payroll file.
check_date | smalldatetime (4) | NOT NULL | check_date for insurepay payroll file
payroll_data_xml | nvarchar (-1) | NOT NULL | insurepay payroll file xml data for the client.
period_begin_date | smalldatetime (4) | NOT NULL | Period beginning date that this payroll transmission covers
period_end_date | smalldatetime (4) | NOT NULL | Period ending date that this payroll transmission covers

Primary key
Name | Columns | Description
PK_Insurepay_Payroll_Transmission | insurepay_payroll_transmission_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Payroll_Transmission__Insurepay_Client__client_KEY | client_KEY | Insurepay_Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Insurepay_Payroll_Transmission_Result__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEY | insurepay_payroll_transmission_KEY | Insurepay_Payroll_Transmission_Result |
FK_Insurepay_N_Payroll_Bank_Transaction__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEY | insurepay_payroll_transmission_KEY | Insurepay_N_Payroll_Bank_Transaction |