| Table containing client specific InsurePay payroll file information. |
| 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 |