ADD SAMPLE DATA TO EMPLOYEESFINANCIAL TABLE

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1001, 5259876, ‘RBC’, ‘R999’, ‘S’, 999565565000000000001111);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1002, 5258765, ‘RBC’, ‘R999’, ‘S’, 999565565000000000001112);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1003, 5257654, ‘TD’, ‘T2222’, ‘S’, 444565565000000000001111);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1004, 5256543, ‘TD’, ‘T2222’, ‘S’, 444565565000000000001112);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1005, 7885432, ‘TD’, ‘T2222’, ‘S’, 444565565000000000001113);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1006, 7884321, ‘RBC’, ‘R999’, ‘S’, 999565565000000000001113);

INSERT INTO EMPLOYEESFINANCIAL (FINANCIALID, EMPLOYEEID, BANKNAME, BRANCHCODE, ACCOUNTTYPE, ACCOUNT#)

VALUES (1007, 7881234, ‘RBC’, ‘R999’, ‘S’, 999565565000000000001114);