-- Create Table Statement for 'Employee Record'
DROP TABLE IF EXISTS `EMPLOYEE_RECORD`;
CREATE TABLE `EMPLOYEE_RECORD` (
	HIRE_DATE date,
	LEGAL_STATUS_CL varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	TERMINATION_DATE date,
	EMPLOYEE_FK bigint(20) NOT NULL,
	ALIEN_NUMBER varchar,
	ALIENT_STATUS_EXPIRATION_DATE date,
	ALLOWANCE_RATE_CL varchar,
	ALLOWANCE_RATE_CL_KS varchar,
	ALLOWANCES_COUNT int(11),
	ALLOWANCES_COUNT_KS int(11),
	ADDITIONAL_WITHHOLDING_AMOUNT int(11),
	ADDITIONAL_WITHHOLDING_AMOUNT_KS int(11),
	IS_WITHHOLDING_EXEMPT tinyint(1),
	IS_WITHHOLDING_EXEMPT_KS tinyint(1),
	STATUS_CL varchar NOT NULL,
	IS_LAST_NAME_DIFFERENT_ON_SOCIAL_SECURITY tinyint(1),
	LEGAL_DOCUMENT_CL_A varchar,
	ISSUING_AUTHORITY_A varchar,
	DOCUMENT_NUMBER_A varchar,
	DOCUMENT_EXPIRATION_DATE_A date,
	DOCUMENT_NUMBER_AS varchar,
	DOCUMENT_EXPIRATION_DATE_AS date,
	LEGAL_DOCUMENT_CL_B varchar,
	LEGAL_DOCUMENT_CL_C varchar,
	ISSUING_AUTHORITY_B varchar,
	ISSUING_AUTHORITY_C varchar,
	DOCUMENT_NUMBER_B varchar,
	DOCUMENT_NUMBER_C varchar,
	DOCUMENT_EXPIRATION_DATE_B date,
	DOCUMENT_EXPIRATION_DATE_C date,
	EMPLOYMENT_STATE varchar,
	WORKSHEET_W4_PERSONAL_ALLOWANCES_A int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_B int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_C int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_D int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_E int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_F int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_G int(11),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_H int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_A varchar,
	WORKSHEET_K4_PERSONAL_ALLOWANCES_B int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_C int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_D int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_E int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_F int(11),
	WORKSHEET_K4_PERSONAL_ALLOWANCES_G int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS01 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS02 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS03 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS04 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS05 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS06 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS07 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS08 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS09 int(11),
	WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS10 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS00 tinyint(1),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS01 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS02 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS03 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS04 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS05 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS06 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS07 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS08 int(11),
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09 int(11),
	POSITION varchar,
	CREATOR_CODE varchar,
	CREATOR_EXTERNAL_CODE varchar,
	BENEFITS_POLICY_CL varchar,
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09_A varchar,
	WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09_B int(11),
	EMPLOYEE_FK bigint(20) NOT NULL,
	WORKSHEET_W4_PERSONAL_ALLOWANCES_H1 tinyint(1),
	WORKSHEET_W4_PERSONAL_ALLOWANCES_H2 tinyint(1),
	INTEGRATION_ACTION_CL varchar,
	PAYMENT_CL varchar,
	PAYMENT_RATE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;