Test Database › Demo Data
Demo Data
*********************************************************************
INSERT INTO DEMOEMPL.DIVISION
VALUES ('D02', NULL, 'USED CARS');
INSERT INTO DEMOEMPL.DIVISION
VALUES ('D04', NULL, 'NEW CARS');
INSERT INTO DEMOEMPL.DIVISION
VALUES ('D06', NULL, 'SERVICE');
INSERT INTO DEMOEMPL.DIVISION
VALUES ('D09', NULL, 'CORPORATE');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (3510, NULL, 'D02', 'APPRAISAL - USED CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (2200, NULL, 'D02', 'SALES - USED CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (1100, NULL, 'D02', 'PURCHASING - USED CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (3520, NULL, 'D04', 'APPRAISAL NEW CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (2210, NULL, 'D04', 'SALES - NEW CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (4200, NULL, 'D04', 'LEASING - NEW CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (1110, NULL, 'D04', 'PURCHASING - NEW CARS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (1120, NULL, 'D06', 'PURCHASING - SERVICE');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (4600, NULL, 'D06', 'MAINTENANCE');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (3530, NULL, 'D06', 'APPRAISAL - SERVICE');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (5100, NULL, 'D06', 'BILLING');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (6200, NULL, 'D09', 'CORPORATE ADMINISTRATION');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (5200, NULL, 'D09', 'CORPORATE MARKETING');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (5000, NULL, 'D09', 'CORPORATE ACCOUNTING');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (4900, NULL, 'D09', 'MIS');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (6000, NULL, 'D09', 'LEGAL');
INSERT INTO DEMOEMPL.DEPARTMENT
VALUES (4500, NULL, 'D09', 'HUMAN RESOURCES');
INSERT INTO DEMOPROJ.PROJECT
values ('P634', 3411, '2000-02-01', '2000-03-01',
null, null, 320, null, 'TV ads - WTVK');
INSERT INTO DEMOPROJ.PROJECT
values ('C200', 3411, '1999-01-15', '2000-04-30', '1999-01-15',
'2000-04-30', 1776, 2010, 'New brand research');
INSERT INTO DEMOPROJ.PROJECT
values ('P400', null, '2000-09-01', '2000-12-10',
null, null, 2960, null, 'Christmas media' );
INSERT INTO DEMOPROJ.PROJECT
values ('C203', 2894, '1998-02-01', '1998-03-15', '1998-02-10',
'1998-03-10', 960, 901.50, 'Consumer study' );
INSERT INTO DEMOPROJ.PROJECT
values ('C240', 4358, '1998-06-01', '1998-07-01', '1998-06-01',
'1998-08-15', 320, 722.75, 'Service study');
INSERT INTO DEMOPROJ.PROJECT
values ('D880', 2466, '1999-11-01', '2001-02-01',
null, null, 960, null, 'Systems analysis' );
INSERT INTO DEMOEMPL.JOB
values (8001, 'Vice President', 90000, 136000, 'S', 1,
'1988-01-01',
'Takes overall responsibility upon president absence',
'Oversees coordination among divisions and departments');
INSERT INTO DEMOEMPL.JOB
values (4023, 'Accountant', 44000, 120000, 'S', 1,
'1985-01-01', 'Responsible for quarterly and final reports',
' Works with outside consultants on taxes');
INSERT INTO DEMOEMPL.JOB
values (2051, 'AP Clerk', 8.80, 14.60, 'H', 2,
'1989-03-01',
'Responds to incoming invoices by sending out issued checks',
'Files invoices');
INSERT INTO DEMOEMPL.JOB
values (2053, 'AR Clerk', 8.80, 14.60, 'H', 3,
'1989-03-01', 'Sends out customer invoices',
'Sends out monthly statements and accepts payments');
INSERT INTO DEMOEMPL.JOB
values (2077, 'Purch Clerk', 17000, 30000, 'S', 3,
'1989-03-01',
'Responsible for soliciting quotes from vendors', null);
INSERT INTO DEMOEMPL.JOB
values (3029, 'Computer Operator', 25000, 44000, 'S', 1,
'1993-06-01',
'Responsible for regular operation of computer system',
'Calls outside maintenance as necessary');
INSERT INTO DEMOEMPL.JOB
values (3051, 'Data Entry Clerk', 8.50, 11.45, 'H', 1,
'1993-06-02', 'Enters A/P and A/R data as necessary',
null);
INSERT INTO DEMOEMPL.JOB
values (6011, 'Manager - Acctng', 59400, 121000, 'S', 1,
'1988-01-01',
'RESPONSIBILITY FOR ACCOUNTING INCLUDING A/P AND A/R',
null);
INSERT INTO DEMOEMPL.JOB
values (4560, 'Mechanic', 11.45, 21.00, 'H', 7,
'1984-01-01',
'Works under supervision of senior mechanic to repair cars', null);
INSERT INTO DEMOEMPL.JOB
values (4666, 'Sr Mechanic', 41000, 91000, 'S', 1,
'1988-06-01',
'Oversees maintenance of all cars under warranty or not',
null);
INSERT INTO DEMOEMPL.JOB
values (4734, 'Mktng Admin', 25000, 62000, 'S', 2,
'1994-06-01',
'Provides marketing plans and ideas for marketing', null);
INSERT INTO DEMOEMPL.JOB
values (3333, 'Sales Trainee', 21600, 39000, 'S', 4,
'1994-10-01',
'Initial sales position for incoming salespeople',
'Works under supervision of salesperson');
INSERT INTO DEMOEMPL.JOB
values (5555, 'Salesperson', 30000, 79000, 'S', 9,
'1984-01-01',
'Primary responsibility to sell new or used cars', null);
INSERT INTO DEMOEMPL.JOB
values (6004, 'Manager - HR', 66000, 138000, 'S', 1,
'1990-06-01',
'Responsible for hiring, benefits, and education',
'Also responsible for OSHA compliance');
INSERT INTO DEMOEMPL.JOB
values (6021, 'Manager - Mktng', 76000, 150000, 'S', 1,
'1992-01-02',
'Responsible for all marketing for used and new cars', null);
INSERT INTO DEMOEMPL.JOB
VALUES (2055, 'PAYROLL CLERK', 17000, 30000, 'S',1,'1989-03-01',
'Issue payroll checks to employees and maintains records', null);
INSERT INTO DEMOEMPL.JOB
values (4025, 'Writer - Mktng', 31000, 50000, 'S', 1,
'1996-06-01', 'Writes marketing material based on marketingplans',
null);
INSERT INTO DEMOEMPL.JOB
values (9001, 'President', 111000, 190000, 'S', 1,
'1984-01-01', 'Overall responsibility for well-beingof company',
null);
INSERT INTO DEMOEMPL.JOB
values (4123, 'Recruiter', 35000, 56000, 'S', 1,
'1994-03-01',
'Posts job openings and submits newspaper ads for openings', null);
INSERT INTO DEMOEMPL.JOB
values (4130, 'Benefits Analyst', 35000, 56000, 'S', 1,
'1994-03-01',
'Maintains benefits information, conforms to govt regulations',
null);
INSERT INTO DEMOEMPL.JOB
values (4012, 'Admin Asst', 21000, 44000, 'S', 4,
'1994-03-01', 'Assists managers as necessary',
'Answers phone, files, writes letters, etc.');
INSERT INTO DEMOEMPL.JOB
VALUES (5111, 'CUST SER REP', 27000, 54000, 'S',4,
'1989-06-01',
'Provides customer support-takes care of complaints',
'Provides information for customers over the phone');
INSERT INTO DEMOEMPL.JOB
values (4700, 'Purch Agnt', 33000, 60000, 'S', 5,
'1993-06-01',
'Responsible for purchasing decisions for parts and vehicles', null);
INSERT INTO DEMOEMPL.JOB
values (5890, 'Appraisal Spec', 45000, 70000, 'S', 5,
'1993-06-01',
'Responsible for assessing value of vehicles traded in', null);
INSERT INTO DEMOEMPL.JOB
VALUES (5110, 'CUST SER MGR', 40000, 108000, 'S',1, '1989-06-01',
'Responsible for overseeing all customer support', null);
INSERT INTO DEMOPROJ.SKILL
values (4444, 'Assembly', 'Auto body assembly experience' );
INSERT INTO DEMOPROJ.SKILL
values (3333, 'Bodywork',
'Experience in repairing auto bodies' );
INSERT INTO DEMOPROJ.SKILL
values (3088, 'Brake work', 'Brake diagnosis and repair' );
INSERT INTO DEMOPROJ.SKILL
values (3065, 'Electronics',
'Electronic diagnosis and repair' );
INSERT INTO DEMOPROJ.SKILL
values (1030, 'Acct Mgt',
'Experience in managing acctng activities' );
INSERT INTO DEMOPROJ.SKILL
values (5130, 'Basic Math',
'Knowledge of basic math functions' );
INSERT INTO DEMOPROJ.SKILL
values (5160, 'Calculus',
'Knowledge of advanced mathematics' );
INSERT INTO DEMOPROJ.SKILL
values (4250, 'Data Entry',
'Familiarity with computer keyboard' );
INSERT INTO DEMOPROJ.SKILL
values (4370, 'Filing',
'Ability to organize correspondence/invoices' );
INSERT INTO DEMOPROJ.SKILL
values (5200, 'Gen Acctng',
'Familiarity with basic AR and AP' );
INSERT INTO DEMOPROJ.SKILL
values (5500, 'Gen Mktng',
'Knowledge of basic marketing concepts' );
INSERT INTO DEMOPROJ.SKILL
values (5430, 'Mktng Writing',
'Background in promotional writing' );
INSERT INTO DEMOPROJ.SKILL
values (5420, 'Writing', 'General writing skills' );
INSERT INTO DEMOPROJ.SKILL
values (4490, 'Gen Ledger',
'Experience with general ledger' );
INSERT INTO DEMOPROJ.SKILL
values (4430, 'Interviewing',
'Basic interviewing experience' );
INSERT INTO DEMOPROJ.SKILL
values (1000, 'Management', 'Experience managing people' );
INSERT INTO DEMOPROJ.SKILL
values (4420, 'Telephone', 'Basic customer support' );
INSERT INTO DEMOPROJ.SKILL
values (5180, 'Statistics',
'Creating & evaluating statistics' );
INSERT INTO DEMOPROJ.SKILL
values (4410, 'Typing', 'Minimum 60 wpm' );
INSERT INTO DEMOPROJ.SKILL
values (5309, 'Appraising', 'Used car evaluation' );
INSERT INTO DEMOPROJ.SKILL
values (6770, 'Purchasing',
'Basic buying & negotiation procedures' );
INSERT INTO DEMOPROJ.SKILL
values (7000, 'Sales', 'Background in sales techniques' );
INSERT INTO DEMOPROJ.SKILL
values (6666, 'Billing', 'Basic billing procedures' );
INSERT INTO DEMOPROJ.SKILL
values (6650, 'Diesel Engine Repair',
'Experience in diesel engine repair' );
INSERT INTO DEMOPROJ.SKILL
values (6670, 'Gas Engine Repair',
'Experience in gasoline engine repair' );
INSERT INTO DEMOPROJ.SKILL
values (6470, 'Window Installation',
'Installation of automotive windows' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (1003, null, 'James', 'Baldwin', 6200,
'21 South St', 'Boston', 'MA', '02010',
'6173295757', 'A', 076598765, '1984-02-01',
null, '1951-08-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3222, 1003, 'Louise', 'Voltmer', 4500,
'28 Hayden St', 'Brookline', 'MA', '02066',
'6176635520', 'A', 090588361, '1993-01-07',
null, '1968-12-27' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4321, 1003, 'George', 'Bradley', 6200,
'344 East Main St', 'Grover', 'MA', '02976',
'5087463300', 'A', 082999642, '1996-08-04',
null, '1966-10-31' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (1234, 1003, 'Thomas', 'Mills', 6200,
'14 Pleasant St', 'Brookline', 'MA', '02066',
'6176646602', 'A', 055711009, '1985-03-14',
null, '1969-10-19' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2466, 1003, 'Patricia', 'Bennett', 5000,
'152B Central St', 'Medford', 'MA', '02432',
'5089487709', 'A', 098339556, '1991-10-29',
null, '1963-12-23');
INSERT INTO DEMOEMPL.EMPLOYEE
values (2894, 1003, 'William', 'Griffin', 5200,
'390 Sherman St', 'Taunton', 'MA', '02678',
'5088449008', 'A', 077442111, '1992-05-11',
null, '1966-07-10' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2174, 3222, 'Jonathan', 'Zander', 4500,
'54 Bradford St', 'Brookline', 'MA', '02066',
'6176633854', 'A', 032423789, '1997-09-30',
null, '1969-05-17' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3118, 3222, 'Alan', 'Wooding', 4500,
'196 School St', 'Canton', 'MA', '02020',
'5083766984', 'A', 098746783, '1992-11-18',
null, '1969-05-17' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2461, 1234, 'Alice', 'Anderson', 6200,
'534 Newton St', 'Medford', 'MA', '02432',
'5083873664', 'A', 068338909, '1991-09-09',
null, '1966-07-01');
INSERT INTO DEMOEMPL.EMPLOYEE
values (3841, 2461, 'Michelle', 'Cromwell', 6200,
'452 Great Rd', 'Boston', 'MA', '02010',
'6173298763', 'A', 055848876, '1994-10-25',
null, '1971-05-20' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4002, 2461, 'Linda', 'Roy', 6200,
'29 Westville Ave', 'Wilmington', 'MA', '02476',
'5088477701', 'A', 098354660, '1995-12-11',
null, '1972-12-13' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (5103, 2466, 'Adele', 'Ferguson', 5000,
'12 York Dr', 'Brookline', 'MA', '02066',
'6176600684', 'A', 095877432, '1999-10-11',
null, '1977-04-19' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3449, 2466, 'Cynthia', 'Taylor', 5000,
'201 Washington St', 'Concord', 'MA', '01342',
'5082684508', 'A', 088930884, '1993-12-07',
null, '1968-06-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3411, 2894, 'Catherine', 'Williams', 5200,
'566 Lincoln St', 'Boston', 'MA', '02010',
null, 'A', 083356561, '1993-09-30',
null, '1967-10-28' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4358, 2894, 'Judith', 'Robinson', 5200,
'139 White St', 'Wilmington', 'MA', '02476',
'5087488011', 'A', 075399870, '1996-09-13',
null, '1964-10-24' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2781, 4358, 'Joseph', 'Thurston', 5200,
'4 Birch St', 'Stoneham', 'MA', '02928',
'6173286008', 'A', 087700466, '1992-04-12',
null, '1968-11-29' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2246, 2466, 'Marylou', 'Hamel', 1100,
'11 Main St', 'Medford', 'MA', '02432',
'5083457789', 'A', 059975848, '1998-12-07',
null, '1968-10-24' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4703, 2246, 'Martin', 'Halloran', 1100,
'27 Elm St', 'Brookline', 'MA', '02066',
'6176648290', 'A', 054475888, '1997-03-19',
null, '1971-12-28' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (5008, 2246, 'Timothy', 'Fordman', 1100,
'60 Boston Rd', 'Brookline', 'MA', '02066',
'6176642209', 'A', 033767754, '1998-01-31',
null, '1973-06-07' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3082, 2894, 'John', 'Brooks', 3510,
'129 Bedford St', 'Camden', 'MA', '02113',
'5089273644', 'A', 098234567, '1992-07-03',
null, '1970-09-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4773, 3082, 'Janice', 'Dexter', 3510,
'399 Pine St', 'Medford', 'MA', '02432',
'5083847566', 'A', 089675632, '1997-06-14',
null, '1969-11-19' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2180, 2894, 'Joan', 'Albertini', 2200,
'501 Piper Rd', 'Medford', 'MA', '02432',
'5083145366', 'A', 066783225, '1989-10-27',
null, '1964-03-26' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4660, 2180, 'Bruce', 'MacGregor', 2200,
'254 Waterside Rd', 'Camden', 'MA', '02113',
'5092344620', 'A', 098363389, '1997-01-20',
null, '1965-10-28' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3767, 2180, 'Frank', 'Lowe', 2200,
'25 Rutland St', 'Natick', 'MA', '02364',
'5082844094', 'A', 066985009, '1994-08-31',
null, '1964-12-08' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2448, 2180, 'David', 'Lynn', 2200,
'93 Hubbard St', 'Natick', 'MA', '02364',
'5082844736', 'A', 028448958, '1991-09-01',
null, '1961-03-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3704, 2448, 'Richard', 'Moore', 2200,
'130 Swanson St', 'Dedham', 'MA', '02026',
'6177739440', 'A', 095435467, '1994-04-10',
null, '1961-11-23' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (1765, 2466, 'David', 'Alexander', 1110,
'18 Cross St', 'Grover', 'MA', '02976',
'5087394772', 'A', 048903743, '1985-10-23',
null, '1955-11-13' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2106, 1765, 'Susan', 'Widman', 1110,
'43 Oak St', 'Medford', 'MA', '02432',
'5083346364', 'A', 109857893, '1989-05-01',
null, '1971-05-11' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3769, 2894, 'Julie', 'Donelson', 3520,
'14 Atwood Rd', 'Grover', 'MA', '02976',
'5084850432', 'A', 067783532, '1994-08-31',
null, '1967-08-15' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2010, 2894, 'Cora', 'Parker', 2210,
'2 Spring St', 'Boston', 'MA', '02010',
null, 'A', 086574983, '1988-03-18',
null, '1962-05-25' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4001, 2010, 'Jason', 'Thompson', 2210,
'3 Flintlock St', 'Natick', 'MA', '02364',
'5082649956', 'A', 054578957, '1995-12-11',
null, '1964-08-15' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4008, 2010, 'Robert', 'Clark', 2210,
'54 Tenny St', 'Brookline', 'MA', '02066',
null, 'A', 198546272, '1996-01-23',
null, '1959-11-01' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4962, 2010, 'Peter', 'White', 2210,
'1440 Mass Ave', 'Boston', 'MA', '02010',
'6177732280', 'A', 123395857, '1997-10-04',
null, '1959-07-01' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3764, 2010, 'Deborah', 'Park', 2210,
'379 Center St', 'Brookline', 'MA', '02066',
'6179458377', 'A', 034222564, '1994-08-25',
null, '1960-03-08' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (5090, 2010, 'Stephen', 'Wills', 2210,
'34 Avon Dr', 'Canton', 'MA', '02020',
'5083389935', 'A', 012434452, '1998-07-12',
null, '1972-04-25' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3991, 2010, 'Fred', 'Wilkins', 2210,
'344 Stevens St', 'Taunton', 'MA', '02678',
'5081840883', 'A', 026475929, '1994-11-12',
null, '1963-03-29' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4027, 3991, 'Cecile', 'Courtney', 2210,
'99 West Main St', 'Natick', 'MA', '02364',
'5089445386', 'A', 012209982, '1996-04-01',
null, '1967-07-07' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3778, 2466, 'Jane', 'Ferndale', 5100,
'15 Dawson St', 'Medford', 'MA', '02432',
'6173450099', 'A', 10477822, '1994-09-07',
null, '1962-11-30' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2598, 3778, 'Mary', 'Jacobs', 5100,
'24A Main St', 'Camden', 'MA', '02113',
null, 'A', 339000022, '1992-01-03',
null, '1974-05-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2004, 2466, 'Eleanor', 'Johnson', 1120,
'225 Fisk St', 'Medford', 'MA', '02432',
'5089253998', 'A', 01010885, '1988-02-28',
null, '1952-12-23' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3294, 2004, 'Carolyn', 'Johnson', 1120,
'79 High St', 'Brookline', 'MA', '02066',
'6175567551', 'A', 038800922, '1993-02-19',
null, '1967-10-05' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3338, 2004, 'Mark', 'White', 1120,
'560 Camden St', 'Canton', 'MA', '02020',
'6179238844', 'A', 055002432, '1993-07-02',
null, '1964-08-15' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2209, 2894, 'Michael', 'Smith', 3530,
'201 Summer St', 'Brookline', 'MA', '02066',
'6175563331', 'A', 093666540, '1990-06-17',
null, '1959-12-13' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3341, 2209, 'Carl', 'Smith', 3530,
'18 South St', 'Newton', 'MA', '02576',
'6179658099', 'A', 033970385, '1993-07-02',
null, '1962-02-03' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2096, 4321, 'Thomas', 'Carlson', 4600,
'23 Hemmingway Ln', 'Brookline', 'MA', '02066',
'6175553643', 'A', 041783445, '1989-01-26',
null, '1964-04-14');
INSERT INTO DEMOEMPL.EMPLOYEE
values (2437, 2096, 'Henry', 'Thompson', 4600,
'1467 West Ave', 'Boston', 'MA', '02030',
'6179264105', 'S', 44622905, '1991-08-06',
null, '1966-10-12' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3433, 2096, 'Herbert', 'Crane', 4600,
'20 W Bloomfield Ave', 'Newton', 'MA', '02456',
'6178653440', 'A', 209338445, '1993-11-01',
null, '1958-05-30' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (1034, 2096, 'James', 'Gallway', 4600,
'12 East Speen St', 'Stoneham', 'MA', '02928',
'6172251178', 'A', 067775312, '1984-02-01',
null, '1951-11-23');
INSERT INTO DEMOEMPL.EMPLOYEE
values (2424, 1034, 'Ronald', 'Wilder', 4600,
'30 Heron Ave', 'Natick', 'MA', '02178',
'5083347700', 'A', 056668338, '1991-07-24',
null, '1948-09-09' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (4456, 1034, 'Thomas', 'Thompson', 4600,
'32 South Broadway', 'Newton', 'MA', '02576',
'6179660089', 'A', 077492347, '1997-01-04',
null, '1978-09-13' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3288, 1034, 'Ralph', 'Sampson', 4600,
'99 Vale Ave', 'Newton', 'MA', '02576',
'6179654443', 'A', 077447333, '1993-01-29',
null, '1962-09-30' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2299, null, 'Samuel', 'Spade', 4600,
'47 London St', 'Canton', 'MA', '02020',
null, 'L', 033892200, '1991-02-04',
null, '1958-01-09' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (3199, null, 'Martin', 'Loren', 4600,
'401 Cross St', 'Grover', 'MA', '02976',
null, 'L', 098884332, '1992-12-05',
null, '1962-10-19' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2145, null, 'Martin', 'Catlin', 5200,
'44 Smithville Hts', 'Wilmington', 'MA', '02476',
'5087486625', 'L', 044895224, '1989-09-24',
null, '1954-03-02' );
INSERT INTO DEMOEMPL.EMPLOYEE
values (2898, null, 'Mary', 'Umidy', 1120,
'895A Braintree Circle', 'Medford', 'MA', '02432',
'6173458860', 'S', 056906868, '1992-05-11',
null, '1962-05-11' );
INSERT INTO DEMOEMPL.POSITION
values (4773, 5890, '1997-06-14', null, null, 45240.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (1234, 8001, '1985-03-14', null, null, 117832.68,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3082, 5890, '1992-07-03', null, null, 68016.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2180, 5555, '1990-04-18', null, null, 76961.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4660, 5555, '1997-03-31', null, null, 36400.00,
.25, .157, null );
INSERT INTO DEMOEMPL.POSITION
values (3767, 5555, '1995-01-11', null, null, 50440.50,
.23, .125, null );
INSERT INTO DEMOEMPL.POSITION
values (2448, 5555, '1991-09-01', null, null, 70720.00,
.255, .157, null );
INSERT INTO DEMOEMPL.POSITION
values (3704, 3333, '1994-04-10', null, null, 22880.00,
null, .105, null );
INSERT INTO DEMOEMPL.POSITION
values (4703, 2077, '1997-03-19', null, null, 24857.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2246, 4700, '1993-09-28', null, null, 59488.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (5008, 4700, '1998-01-31', null, null, 47944.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3769, 5890, '1994-08-31', null, null, 41600.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4001, 5555, '1995-12-11', null, null, 36921.00,
.23, .125, null );
INSERT INTO DEMOEMPL.POSITION
values (4008, 3333, '1996-01-23', null, null, 24441.00,
null, .99, null );
INSERT INTO DEMOEMPL.POSITION
values (4962, 3333, '1997-10-04', null, null, 30680.00,
null, .125, null );
INSERT INTO DEMOEMPL.POSITION
values (2010, 5555, '1988-03-18', null, null, 76440.00,
.275, .180, null );
INSERT INTO DEMOEMPL.POSITION
values (3764, 5555, '1995-10-02', null, null, 54184.00,
.26, .170, null );
INSERT INTO DEMOEMPL.POSITION
values (5090, 5555, '1998-07-12', null, null, 48568.48,
.205, .135, null );
INSERT INTO DEMOEMPL.POSITION
values (4027, 3333, '1996-04-01', null, null, 28081.40,
null, .120, null );
INSERT INTO DEMOEMPL.POSITION
values (3991, 5555, '1995-06-06', null, null, 42016.00,
.235, .125, null );
INSERT INTO DEMOEMPL.POSITION
values (1765, 4700, '1992-06-10', null, null, 47009.34,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2106, 2077, '1989-05-01', null, null, 23920.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2096, 4666, '1994-10-10', null, null, 85280.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2437, 4560, '1991-08-06', null, 14.55, null,
null, null, 21.83 );
INSERT INTO DEMOEMPL.POSITION
values (2598, 2053, '1992-01-03', null, 10.50, null,
null, null, 15.00 );
INSERT INTO DEMOEMPL.POSITION
values (3433, 4560, '1993-11-01', null, 19.15, null,
null, null, 28.00 );
INSERT INTO DEMOEMPL.POSITION
values (3778, 2053, '1994-09-07', null, 9.98, null,
null, null, 14.00 );
INSERT INTO DEMOEMPL.POSITION
values (1034, 4560, '1984-02-01', null, 20.93, null,
null, null, 29.50 );
INSERT INTO DEMOEMPL.POSITION
values (2424, 4560, '1991-07-24', null, 13.60, null,
null, null, 19.40 );
INSERT INTO DEMOEMPL.POSITION
values (2004, 4700, '1993-11-19', null, null, 59280.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4456, 4560, '1997-01-04', null, 14.58, null,
null, null, 19.87 );
INSERT INTO DEMOEMPL.POSITION
values (3288, 4560, '1993-01-29', null, 16.40, null,
null, null, 23.60 );
INSERT INTO DEMOEMPL.POSITION
values (3341, 5890, '1993-07-02', null, null, 48465.80,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2209, 5890, '1990-06-17', null, null, 66144.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3294, 4700, '1993-02-19', null, null, 53665.56,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3338, 2077, '1993-07-02', null, null, 22048.84,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2174, 4123, '1989-09-30', null, null, 49921.76,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3118, 4130, '1992-11-18', null, null, 45241.94,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3222, 6004, '1993-01-07', null, null, 110448.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4321, 5110, '1996-08-04', null, null, 56977.80,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2461, 4012, '1991-09-09', null, null, 43784.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3841, 4012, '1994-10-25', null, null, 33800.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4002, 4012, '1995-12-11', null, null, 28601.80,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (1003, 9001, '1984-02-01', null, null, 146432.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (5103, 2051, '1999-10-11', null, 7.13, null,
null, null, 11.70 );
INSERT INTO DEMOEMPL.POSITION
values (2466, 6011, '1991-10-29', null, null, 94953.52,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3449, 4023, '1993-12-07', null, null, 74776.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2781, 4025, '1992-04-12', null, null, 43888.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2894, 6021, '1992-05-11', null, null, 111593.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3411, 4734, '1995-04-02', null, null, 53665.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (4358, 4734, '1996-09-13', null, null, 57824.50,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
VALUES (3764, 3333, '1994-08-25', '1995-10-01', NULL, 28912.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (3991, 3333, '1994-11-12', '1995-06-05', null, 27976.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2246, 2077, '1990-12-07', '1993-09-27', null, 29536.00,
null, null, null );
INSERT INTO DEMOEMPL.POSITION
values (2096, 4560, '1989-01-26', '1994-10-09', 17.90, null,
null, null, 28.85 );
INSERT INTO DEMOEMPL.POSITION
values (3767, 3333, '1994-08-31', '1995-01-10', null, 2200.00,
null, .105, null);
INSERT INTO DEMOEMPL.POSITION
values (2180, 3333, '1997-10-27', '1990-04-17', null, 19000.10,
null, .09, null);
INSERT INTO DEMOEMPL.POSITION
values (4660, 3333, '1997-01-20', '1997-03-30', null, 24000.00,
null, .11, null);
INSERT INTO DEMOEMPL.POSITION
values (1765, 2077, '1985-10-23', '1992-06-10', null, 18001.00,
null, null, null);
INSERT INTO DEMOEMPL.POSITION
values (2004, 2053, '1988-02-28', '1993-11-18', 9.50, null,
null, null, 13.50);
INSERT INTO DEMOEMPL.POSITION
values (3411, 4012, '1993-09-30', '1995-04-01', null, 44001.40,
null, null, null);
INSERT INTO DEMOPROJ.EXPERTISE
values (4773, 5309, '02', '1995-10-14' );
INSERT INTO DEMOPROJ.EXPERTISE
values (1234, 1000, '04', '1988-06-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3082, 5309, '04', '1994-06-03' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2180, 7000, '04', '1993-01-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4660, 7000, '03', '1995-10-09' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3767, 7000, '04', '1994-09-20' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2448, 7000, '03', '1991-06-10' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3704, 7000, '01', '1993-08-21' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4703, 4250, '03', '1996-11-20' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2246, 1000, '03', '1993-10-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2246, 6670, '04', '1990-03-29' );
INSERT INTO DEMOPROJ.EXPERTISE
values (5008, 6770, '04', '1998-01-31' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4703, 5130, '03', '1998-03-30' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3769, 5309, '04', '1992-10-04' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4001, 7000, '03', '1994-12-11' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4008, 4420, '01', '1994-12-14' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4962, 5130, '02', '1992-11-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2010, 7000, '03', '1988-02-18' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3764, 7000, '03', '1992-01-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (5090, 7000, '03', '1997-02-12' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4027, 7000, '01', '1995-03-19' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3991, 7000, '03', '1995-01-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (1765, 6770, '04', '1985-10-23' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2106, 6770, '03', '1991-10-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2096, 3333, '02', '1995-03-03' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2096, 3065, '03', '1998-04-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2437, 3333, '04', '1995-03-15' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2437, 4444, '04', '1997-05-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2598, 6666, '03', '1997-07-25' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3433, 6650, '02', '1991-10-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3778, 5200, '03', '1998-01-21' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3778, 6666, '04', '1998-05-15' );
INSERT INTO DEMOPROJ.EXPERTISE
values (1034, 6470, '02', '1984-02-21' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2424, 6470, '03', '1989-04-18' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2004, 6770, '04', '1988-02-28' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4456, 6670, '01', '1993-06-02' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4456, 3065, '02', '1993-09-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3288, 6650, '02', '1993-06-12' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3288, 6670, '01', '1994-12-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3288, 3333, '04', '1993-12-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3341, 5309, '03', '1993-10-02' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2209, 5309, '04', '1992-08-12' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3294, 6770, '01', '1989-09-21' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3338, 6770, '03', '1994-12-11' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2174, 4430, '04', '1995-03-30' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3118, 5180, '03', '1995-07-23' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3222, 1000, '04', '1995-10-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3222, 4430, '04', '1996-12-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4321, 4430, '04', '1997-03-24' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4321, 1000, '03', '1998-06-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2461, 4370, '04', '1994-03-12' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2461, 4250, '04', '1997-03-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2461, 5180, '03', '1997-06-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3841, 4370, '03', '1995-10-10' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3841, 4410, '02', '1996-06-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4002, 4370, '03', '1996-02-15' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4002, 4410, '04', '1999-01-15' );
INSERT INTO DEMOPROJ.EXPERTISE
values (1003, 1000, '04', '1984-02-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (5103, 5200, '04', '1997-10-11' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2466, 1030, '04', '1991-10-29' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2466, 5200, '04', '1999-06-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2466, 4490, '03', '1999-12-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3449, 5200, '03', '1993-09-29' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2781, 5430, '01', '1995-09-27' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2781, 5420, '02', '1996-12-01' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2894, 1000, '04', '1995-11-12' );
INSERT INTO DEMOPROJ.EXPERTISE
values (2894, 5500, '04', '1996-12-15' );
INSERT INTO DEMOPROJ.EXPERTISE
values (3411, 5500, '04', '1997-01-30' );
INSERT INTO DEMOPROJ.EXPERTISE
values (4358, 5500, '03', '1996-12-30' );
INSERT INTO DEMOPROJ.CONSULTANT
values (9443, 'Diane', 'Jones', 2466, 5200, 'D880',
'183 Hawthorne Ln', 'Medford', 'MA', '02432',
'5084475583', '1957-01-23', '1999-08-08', 089393334,
50.00 );
INSERT INTO DEMOPROJ.CONSULTANT
values (9439, 'Charles', 'Miller', 2466, 4900, 'D880',
'85 St. James St', 'Brookline', 'MA', '02066',
'6174800873', '1963-09-12', '1999-02-18', 085763854,
47.00 );
INSERT INTO DEMOPROJ.CONSULTANT
values (9388, 'Linda', 'Candido', 2466, 5200, 'D880',
'54 Church St', 'Newton', 'MA', '02456',
'6179943082', '1959-08-30', '1997-12-21', 033006132,
76.00 );
INSERT INTO DEMOPROJ.CONSULTANT
values (9000, 'James', 'Legato', 1003, 6000, null,
'85 North Rd', 'Newton', 'MA', '02456',
'6179964874', '1970-05-20', '1994-03-20', 095578460,
148.00 );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4773, 68, 68, 8.00, 5.00, 0 ,0
, '2000-10-15', .05, null,
NULL, NULL, 900.00,0 ,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3082, 68, 52, 8, 8, 0 ,0
, '2000-10-20', .055, null,
'401K', .08, 1400.00,0 ,0,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2180, 92.50, 0, 8.00, 4.00, 0 ,0
, '2000-10-30', .06, null,
'STOCK', .05, 2100.00, 16, 0 ,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 4660, 68, 56, 8.00, 0, .07,
3095, '2000-01-13', .06, null,
'401K', .05, 850.68,0,0,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3767, 68, 68, 8.00, 0, .07,
2250, '2000-09-22', .045, null,
'401K', .05, 1350.50, 16, 16,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2448, 68, 20.50, 8.00, 3, .075,
6600, '2000-07-13', .05, null,
'BONDS', .08, 2100.00, 0,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3704, 68, 48, 8.00, 8.00, .05,
3470, '2000-04-30', .045, null,
'BONDS', .04, 1800.00, 8, 8,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 4703, 46.75, 16, 8.00, 14.5, .05,
3010, '2000-03-10', .08, null,
NULL, NULL, 1107.50,0,0,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2246, 92.50, 72, 8.00, 5, .05,
4500, '2000-12-15', .08, '1993-09-27',
null, null, 2300.00, 24.5, 16.00,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 5008, 46.5, 40, 8.00, 0, .10,
2000, '2000-01-29', .06, null,
'401K', .05, 307.50,0,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3769, 68, 0, 8.00, 6.00, .10,
6600, '2000-10-01', .04, null,
'401K', .03, 1356.70,0,0,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4001, 68, 40, 8.00, 2.5, 0,0
, '2000-12-20', .04, null,
NULL, NULL, 1756.50,0,0,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4008, 68, 0, 8.00, 3.5,0,0
, '2000-01-14', .05, null,
'401K', .05, 1750.00,0,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4962, 68, 16, 8.00, 7.5, 0,0
, '2000-10-04', .06, null,
'401K', .06, 1307.80, 8.5, 8.5,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2010, 92.75, 16.00, 8.00, 2.5,0,0
, '2000-03-18', .05, null,
'STOCK', .05, 2450.50, 0,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3764, 68, 80, 8.00, 5.00, .08,
3060, '2000-06-11', .065, '1991-05-10',
'STOCK', .06, 1406.90, 32.5, 16.0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 5090, 46, 0, 8.00, 0,0,0
, '2000-07-14', .04, null,
NULL, NULL, 0,0,0,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 4027, 68, 40, 8.00, 4.00, .08,
3000, '2000-07-19', .035, null,
'401K', .04, 1750.00,0,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3991, 68, 68, 8.00, 3.00, .08,
4500, '2000-11-12', .055, '1995-06-05',
'401K', .06, 1354.60, 8.0, 0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 1765, 92.5, 32, 8.00, 0, .10,
7600, '2000-10-23', .07, null,
'401K', .08, 2500.00, 32, 0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2106, 92.5, 32, 8.00, 1.00, .08,
5500, '2000-04-16', .06, '1999-08-17',
'BONDS', .04, 2100.00, 0,0,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2096, 92.5, 80, 8.00, 5.00, .05,
5300, '2000-02-28', .055,
'1998-10-09','STOCK', .05, 2300.00, 0,0,
'HSDIP', NULL, NULL);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2437, 68, 0, 8.00, 4.5, 0,0
, '2000-08-16', .04, null,
NULL, NULL, 2100.00, 0,0,
'GED', 'MC655-690l', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000,2598, 60, 8, 20.00, 8.5, 0 ,0
, '2000-01-26', .035, null,
NULL, NULL, 2300.00, 0,0,
'HSDIP', 'HP302-7409', 50.50);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3433, 68, 40, 8.00, 4.00,0,0
, '2000-10-23', .05, null,
NULL, NULL, 1456.70,0,0,
'JRCOLL', 'MC655-7487', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3778, 68, 40, 8.00, 4,0,0
, '2000-09-24', .06, null,
NULL, NULL, 1350.50,0,0,
'HSDIP', 'HP302-7487', 50.50);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 1034, 92.5, 72, 8.00, 2.5, .10,
5540, '2000-01-24', .05, null,
'BONDS', .06, 2900.00, 0,0,
'HSDIP', 'MC655-4490', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2424, 92.5, 48, 8.00, 3.5, .05,
2460, '2000-07-19', .04, null,
NULL, NULL, 2100.00, 0,0,
'HSDIP', 'MC655-5571', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2004, 92.5, 40, 8.00, 0, .05,
2300, '2000-02-28', .03, null,
'401K', .04, 2450.50,0,0,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4456, 68, 40, 8.00, 7.00,0,0
, '2000-01-05', .03, null,
NULL, NULL, 906.50,0,0,
'HSDIP', 'MC655-6680', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3288, 68, 56, 8.00, 2.00,0,0
, '2000-01-05', .04, null,
NULL, NULL, 1500.00, 0,0,
'HSDIP', 'MC655-4402', 90.55);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3341, 68, 32.5, 8.00, 3.00,0,0
, '2000-10-05', .045, null,
'401K', .07, 1500.00, 0,0,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2209, 92.50, 32, 8.00, 5.5,0,0
, '2000-06-14', .06, null,
'401K', .06, 2300.00, 16.00, 16.00,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3294, 68, 16, 8.00, 3.00,0,0
, '2000-02-28', .055, null,
'401K', .03, 1500.00, 0,0,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3338, 68, 0, 8.00, 1.5,0,0
, '2000-07-02', .05, null,
NULL, NULL, 1450.50,0,0,
'HSDIP', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2174, 92, 48, 8.00, 9.00,0,0
, '2000-09-27', .06, null,
'401K', .04, 2100.00, 0,0,
'JRCOLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3118, 68, 8, 8.00, 7.00, .05,
2010, '2000-11-24', .045, null,
'BONDS', .08, 1500.00, 8.5, 8.00,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3222, 68, 0, 8.00, 2.5, .05,
2240, '2000-01-02', .07, '1999-06-08',
'401K', .09, 1350.50, 32, 8,
'MAS', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 4321, 68, 48, 8.00, 3.00, .05,
1991, '2000-08-02', .05, null,
NULL, NULL, 1200.00, 0,0,
'JRCOLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2461, 68, 40, 8.00, 1.5,0,0
, '2000-09-13', .04, null,
NULL, NULL, 2100.00,0 ,0,
'HSDIP', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3841, 68, 0, 8.00, 2.00,0,0
, '2000-10-10', .06, null,
NULL, NULL, 1300.00, 0,0,
'JRCOLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 4002, 68, 40, 8.00, 4.5,0,0
, '2000-12-15', .045, null,
NULL, NULL, 1750.50,0,0,
'HSDIP', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 1003, 92, 0, 8.00, 0, .10,
12340, null, .05, null,
'401K', .10, NULL,0,0,
'MAS', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 5103, 46, 0, 8, 0, .05,
530, '2000-10-11', .05, null,
NULL, NULL, NULL,0,0,
'HSDIP', 'HP302-8403', 50.50);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 2466, 92.5, 40, 8.00, 3.5, .05,
3400, '2000-10-30', .055, null,
'401K', .05, 2100.00, 16, 16,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 3449, 68, 56, 8.00, 10.5, .07,
3700, '2000-12-02', .045, null,
'401K', .03, 1453.70,0,0,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2781, 68, 60, 8.00, 7.00,0,0
, '2000-04-25', .05, null,
'401K', .03, 2105.90,0,0,
'COLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 2894, 68, 0, 8.00, 2.5,0,0
, '2000-05-04', .055, null,
'STOCK', .08, 2155.30, 16.5, 8,
'MAS', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (2000, 3411, 68, 68, 8, 8,0,0
, '2000-09-30', .05, NULL,
'401K', .03, 1400.00, 0,0,
'JRCOLL', null, null );
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 4358, 68, 0, 8.00, 6.5, .07,
1430, '2000-09-27', .055, null,
NULL, NULL, 950.50,0,0,
'HSDIP', null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4773, 80, 80, 15, 1, 0 ,0, '1999-07-02',
.04, NULL, NULL, NULL, 600.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4773, 80, 48, 10, 10, 0 ,0, '1998-07-05',
.03, NULL, NULL, NULL, 500.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4773, 24, 24, 4.5, 0, 0 , 0 , NULL, NULL,
NULL, NULL, NULL, NULL,0,0, 'COLL', NULL,
null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3082, 120, 120, 15, 8, 0 ,0, '1999-10-12',
.05, NULL, NULL, NULL, 1100.00, 0,0, 'JRCOLL', NULL,
null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3082, 120, 120, 15, 4.5, 0 ,0,
'1998-01-09',
.05, NULL, NULL, NULL, 1000.00,0 ,0, 'JRCOLL', NULL,
NULL);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3082, 120, 120, 15, 2, 0 , 0 , '1997-10-01',
.05, NULL, NULL, NULL, 1000.00, 0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2180, 160, 160, 15, 6, 0 ,0, '1999-10-17',
.05, NULL, 'STOCK', .05, 2000.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2180, 120, 120, 15, 2.5, 0 ,0, '1998-10-25',
.055, NULL, 'STOCK', .05, 1900.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2180, 120, 120, 15, 7, 0 ,0, '1997-10-02',
.05, NULL, 'STOCK', .05, 2000.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 4660, 80, 80, 15, 10, .05, 2060, '1999-01-15',
.055, NULL, '401K', .05, 750.60, 0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4660, 80, 80, 10, 5, 0 ,0, '1998-01-30',
.04, NULL, '401K', .05, 500.00,0 ,0, 'HSDIP', NULL,
null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4660, 48, 48, 8, 2.5, 0 , 0 , NULL, NULL,
NULL, '401K', .04, 400.00, 0,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 3767, 120, 120, 15, 0, .07, 2400, '1999-08-17',
.05, NULL, '401K', .05, 1000.00, 0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 3767, 120, 120, 15, 0, .07, 2200, '1998-08-10',
.05, NULL, '401K', .05, 1000.00, 0,0,
'JRCOLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 3767, 120, 120, 15, 0, .07, 2000, '1997-08-01',
.05, NULL, '401K', .05, 1350.00,0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2448, 120, 120, 15, 8,0 ,0, '1999-09-18',
.04, NULL, 'BONDS', .08, 1700.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2448, 120, 120, 15, 15, 0,0, '1998-09-15',
.035, NULL, 'BONDS', .08, 1500.00,0,0 , 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2448, 120, 120, 15, 5, 0,0, '1997-08-30',
.03, NULL, 'BONDS', .08, 1500.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 3704, 120, 120, 15, 15, .04, 2800, '1999-04-24',
.045, NULL, 'BONDS', .04, 1700.00, 0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 3704, 120, 120, 15, 15, .03, 2200, '1998-04-30',
.04, NULL, 'BONDS', .04, 1500.00, 0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3704, 120, 120, 15, 15, 0,0, '1997-04-20',
.035, null, null, null, 1300.00, 12, 12, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 4703, 80, 80, 15, 1, .04, 2300, '1999-03-10',
.065, NULL, NULL, NULL, 950.00,0,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 4703, 80, 80, 10, 2.5, .04, 2010, '1998-03-30',
.05, NULL, NULL, NULL, 800.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4703, 36, 36, 6, 0, 0 , 0 , NULL, NULL,
NULL, NULL, NULL, NULL,0,0, 'HSDIP', NULL,
null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 2246, 160, 160, 15, 3, .04, 3500, '1999-12-06',
.07, '1993-09-27', NULL, NULL, 2100.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2246, 120, 120, 15, 3,0 ,0, '1998-12-01',
.065, '1993-09-27', NULL, NULL, 1700.00, 0,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2246, 120, 120, 15, 5,0 ,0, '1997-12-20',
.06, '1993-09-27', NULL, NULL, 1600.00, 0,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 5008, 80, 80, 10, 6, .10, 1700, '1999-02-07',
.04, NULL, NULL, NULL, 200.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 5008, 48, 48, 8, 7, .10, 1500, null, null,
NULL, '401K', .05, NULL,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3769, 120, 120, 15, 14,0 ,0, '1999-09-17',
.04, NULL, '401K', .03, 1200.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3769, 120, 120, 15, 8.5,0 ,0, '1998-09-01',
.04, NULL, '401K', .04, 1100.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3769, 120, 120, 15, 3, 0,0, '1997-09-06',
.04, NULL, '401K', .04, 1000.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4001, 120, 120, 15, 3,0 ,0, '1999-12-01',
.045, NULL, NULL, NULL, 1500.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4001, 80, 80, 15, 8,0 ,0, '1998-12-18',
.04, NULL, NULL, NULL, 1200.00,0 ,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4001, 80, 80, 15, 3, 0,0, '1997-12-10',
.04, NULL, NULL, NULL, 1000.00, 0,0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4008, 120, 120, 15, 2, 0,0, '1999-01-15',
.04, NULL, '401K', .05, 1500.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4008, 80, 80, 15, 1, 0,0, '1998-01-31',
.035, NULL, '401K', .05, 1350.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4008, 80, 72, 15, 0, 0,0, '1997-01-30',
.035, NULL, NULL, NULL, 1100.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4962, 80, 80, 15, 4.5,0 ,0, '1999-10-10',
.06, NULL, '401K', .05, 1150.50,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4962, 80, 80, 10, 1,0 ,0, '1998-10-16',
.05, null, '401K', .05, 1000.00, 2, 2, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 4962, 12, 0, 2, 0, .05, 3000, null, null,
NULL, NULL, NULL, NULL,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2010, 160, 160, 15, 4,0 ,0, '1999-03-01',
.055, NULL, 'STOCK', .05, 2100.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2010, 160, 152.5, 15, 3, 0,0, '1998-03-30',
.05, NULL, 'STOCK', .05, 2000.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2010, 160, 160, 15, 3,0 ,0, '1997-03-10',
.05, null, 'BONDS', .05, 1600.00, 2, 2, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3764, 120, 120, 15, 2, 0,0, '1999-08-01',
.055, '1991-05-10', 'STOCK', .06, 1500.00,0 ,0,
'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3764, 120, 120, 15, 3, 0,0, '1998-08-30',
.05, '1991-05-10', 'STOCK', .05, 1200.00, 14, 14,
'COLL', NULL,NULL);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3764, 120, 120, 15, 5, 0,0, '1997-08-17',
.045, '1991-05-10', 'STOCK', .05, 1000.00,0 ,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 5090, 80, 80, 15, 2,0 ,0, '1999-07-30',
.035, NULL, NULL, NULL, 800.00,0 ,0, 'JRCOLL',
NULL,NULL);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 5090, 24, 24, 4, 2, 0 , 0 , NULL, NULL,
NULL, NULL, NULL, NULL,0,0, 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4027, 120, 120, 15, 8,0 ,0, '1999-03-15',
.03, null, null, null, 1500.00, 16, 16, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4027, 120, 120, 15, 0, 0,0, '1998-04-30',
.03, NULL, NULL, NULL, 1200.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4027, 80, 80, 10, 2.5,0 ,0, '1997-04-01',
.03, NULL, NULL, NULL, 1000.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 3991, 120, 120, 15, 8, .08, 4000, '1999-12-04',
.05, '1995-06-05', '401K', .05, 1300.00, 0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3991, 120, 116, 15, 2, 0 , 0 , '1998-11-28',
.045, '1995-06-05', '401K', .05, 1100.00, 8, 8, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3991, 120, 120, 15, 8, 0,0, '1997-11-30',
.045, '1995-06-05', NULL, NULL, 1000.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 1765, 160, 160, 15, 0, .10, 7000, '1999-11-15',
.07, null, '401K', .08, 2500.50, 36, 0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 1765, 160, 160, 15, 0, .10, 6500, '1998-11-01',
.07, null, '401K', .08, 2500.00, 88, 0, 'COLL', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 1765, 160, 160, 15, 0, .10, 6000, '1997-10-30',
.065, null, '401K', .07, 2400.00, 72, 0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 2106, 160, 160, 15, 9.5, .07, 4500, '1999-05-01',
.055, '1999-08-17', 'BONDS', .04, 1800.00, 0 , 0 ,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2106, 160, 160, 15, 3,0 ,0, '1998-05-15',
.05, null, 'BONDS', .05, 1800.00, 8, 8, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2106, 120, 120, 15, 8, 0,0, '1997-04-30',
.03, NULL, NULL, NULL, 1700.00, 0,0 ,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 2096, 160, 128, 15, 3, .04, 4500, '1999-02-18',
.05, '1998-10-09', 'STOCK', .05, 2000.00, 0,0 ,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2096, 160, 160, 15, 3,0 ,0, '1998-02-01',
.05, '1998-10-09', 'STOCK', .05, 2500.00,0 ,0 ,
'HSDIP', null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2096, 120, 104, 15, 3,0 ,0, '1997-02-15',
.06, NULL, NULL, NULL, 1700.00, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2437, 120, 16, 15, 11.5,0 ,0, '1999-08-01',
.035, NULL, NULL, NULL, 1800.00, 0,0 , 'GED',
'MC655-6901', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2437, 120, 120, 15, 6.5,0 ,0, '1998-08-30',
.03, NULL, NULL, NULL, 1200.00, 0,0 , 'GED',
'MC655-6901', 79.62);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2437, 120, 120, 15, 15, 0,0, '1997-08-16',
.03, NULL, '401K', .05, 1100.00,0 ,0 , 'GED',
'MC655-6901', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2598, 120, 120, 15, 15, 0,0, '1999-01-30',
.035, NULL, NULL, NULL, 2150.50, 0,0 , 'HSDIP',
'HP302-7409', 54.86);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2598, 120, 120, 15, 14, 0,0, '1998-01-15',
.03, NULL, NULL, NULL, 1800.00,0 ,0 , 'HSDIP',
'HP302-7409', 50.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2598, 120, 120, 15, 6, 0,0, '1997-02-01',
.03, NULL, NULL, NULL, 1700.00, 0,0 , 'HSDIP',
'HP302-7409', 45.75);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3433, 120, 120, 15, 8,0 ,0, '1999-10-17',
.05, NULL, NULL, NULL, 1400.00, 0, 0, 'JRCOLL',
'MC655-7487', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3433, 120, 120, 15, 4, 0,0, '1998-10-30',
.05, NULL, NULL, NULL, 1300.00, 0 ,0 , 'JRCOLL',
'MC655-7487', 79.62);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3433, 120, 120, 15, 4,0 ,0, '1997-10-15',
.055, NULL, NULL, NULL, 1200.00,0 ,0 , 'JRCOLL',
'MC655-7487', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3778, 120, 120, 15, 0,0 ,0, '1999-09-01',
.055, NULL, NULL, NULL, 1240.50,0 ,0 , 'HSDIP',
'HP302-7487', 54.86);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3778, 120, 120, 15, 14,0 ,0, '1998-09-26',
.05, NULL, NULL, NULL, 1100.00, 0,0 , 'HSDIP',
'HP302-7487', 50.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3778, 120, 120, 15, 10, 0,0, '1997-09-18',
.05, NULL, NULL, NULL, 1000.00,0 ,0 , 'HSDIP',
'HP302-7487', 45.75);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 1034, 160, 112, 15, 6, .10, 5000, '1999-02-01',
.05, NULL, 'BONDS', .06, 2850.60, 0, 0, 'HSDIP',
'MC655-4490', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 1034, 160, 112, 15, 15, 0,0, '1998-02-17',
.05, NULL, 'BONDS', .06, 2720.80,0 ,0 , 'HSDIP',
'MC655-4490',79.62);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 1034, 160, 48, 15, 8.5, 0,0, '1997-02-15',
.05, NULL, NULL, NULL, 2500.00, 0,0 , 'HSDIP',
'MC655-4490', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2424, 120, 120, 15, 15,0 ,0, '1999-06-25',
.04, NULL, NULL, NULL, 1900.00, 0,0 , 'HSDIP',
'MC655-5571', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2424, 120, 120, 15, 7, 0,0, '1998-07-01',
.035, NULL, NULL, NULL, 1700.00,0 ,0 , 'HSDIP',
'MC655-5571', 79.62);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2424, 120, 120, 15, 3,0 ,0, '1997-07-17',
.035, NULL, NULL, NULL, 1500.00,0 ,0 , 'HSDIP',
'MC655-5571', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 2004, 160, 160, 15, 8, .04, 1550, '1999-02-17',
.03, NULL, '401K', .04, 1850.00, 0 , 0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2004, 160, 160, 15, 2, 0,0, '1998-02-01',
.035, NULL, '401K', .04, 1700.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2004, 160, 160, 15, 3.5, 0,0, '1997-02-15',
.03, NULL, NULL, NULL, 1600.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4456, 80, 80, 15, 3, 0,0, '1999-02-05',
.03, NULL, NULL, NULL, 650.00,0 ,0 , 'HSDIP',
'MC655-6680', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4456, 80, 80, 10, 0, 0,0, '1998-02-17',
.02, NULL, NULL, NULL, 700.00,0 ,0 , 'HSDIP',
'MC655-6680', 79.62);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 4456, 48, 48, 8, 1, 0 , 0 , null, null,
NULL, NULL, NULL, NULL, 0,0 , 'HSDIP',
'MC655-6680', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3288, 120, 120, 15, 9,0 ,0, '1999-02-01',
.035, NULL, NULL, NULL, 1380.00,0 ,0 , 'HSDIP',
'MC655-4402', 84.05);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3288, 120, 120, 15, 8,0 ,0, '1998-02-03',
.035, NULL, NULL, NULL, 1250.00,0 ,0 , 'HSDIP',
'MC655-4402', 79.62);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3288, 120, 120, 15, 11,0 ,0, '1997-01-28',
.03, NULL, NULL, NULL, 1000.00, 0,0 , 'HSDIP',
'MC655-4402', 70.00);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3341, 120, 120, 15, 9,0 ,0, '1999-07-25',
.05, NULL, '401K', .06, 1350.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3341, 120, 116, 15, 8, 0,0, '1998-07-26',
.06, null, '401K', .05, 1400.00, 16, 16, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3341, 120, 120, 15, 6.5, 0,0, '1997-07-15',
.04, NULL, NULL, NULL, 900.00, 0,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2209, 120, 120, 15, 6, 0,0, '1999-07-02',
.05, NULL, '401K', .05, 1200.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2209, 120, 120, 15, 7,0 ,0, '1998-06-17',
.05, NULL, '401K', .05, 1200.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2209, 120, 120, 15, 3, 0,0, '1997-06-28',
.045, null, null, null, 1550.80, 8, 8, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3294, 120, 120, 15, 10, 0,0, '1999-02-20',
.05, NULL, '401K', .03, 1380.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3294, 120, 120, 15, 13, 0,0, '1998-01-28',
.05, NULL, '401K', .03, 1100.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3294, 120, 120, 15, 3, 0,0, '1997-02-04',
.05, NULL, '401K', .02, 1150.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3338, 120, 120, 15, 0, 0,0, '1999-07-17',
.05, NULL, NULL, NULL, 1200.00, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3338, 120, 120, 15, 1,0 ,0, '1998-07-19',
.045, NULL, NULL, NULL, 1130.00,0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3338, 120, 120, 15, 2, 0,0, '1997-07-08',
.05, NULL, NULL, NULL, 950.70, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2174, 160, 160, 15, 9, 0,0, '1999-09-26',
.055, NULL, '401K', .04, 1900.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2174, 160, 160, 15, 11, 0,0, '1998-09-10',
.05, NULL, '401K', .03, 1600.00, 0,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2174, 120, 120, 15, 8, 0,0, '1997-09-09',
.06, NULL, NULL, NULL, 1120.90, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 3118, 120, 120, 15, 3, .05, 2000, '1999-11-02',
.04, NULL, 'BONDS', .08, 1350.60,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3118, 120, 112, 15, 8, 0,0, '1998-11-16',
.04, NULL, 'BONDS', .07, 1200.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3118, 120, 120, 15, 6,0 ,0, '1997-11-30',
.04, NULL, 'STOCK', .06, 1100.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 3222, 120, 120, 15, 6, .04, 1780, '1999-01-16',
.06, '1999-06-08', '401K', .06, 1200.00, 32, 16, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3222, 120, 120, 15, 4,0 ,0, '1998-01-28',
.06, null, '401K', .06, 1150.00, 48, 8.5, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3222, 120, 120, 15, 7, 0,0, '1997-01-13',
.05, null, '401K', .05, 980.00, 16, 16, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 4321, 120, 96, 15, 2, .05, 1720, '1999-08-24',
.055, null, null, null, 1100.00, 16, 16, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4321, 80, 80, 15, 4, 0,0, '1998-08-29',
.05, NULL, NULL, NULL, 980.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4321, 80, 80, 10, 4,0 ,0, '1997-08-08',
.04, NULL, NULL, NULL, 850.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2461, 120, 112, 15, 0, 0,0, '1999-09-18',
.05, NULL, NULL, NULL, 1950.00, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2461, 120, 120, 15, 4, 0,0, '1998-09-01',
.04, null, null, null, 1830.00, 48, 48, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2461, 120, 120, 15, 3, 0,0, '1997-09-18',
.035, NULL, NULL, NULL, 1600.00,0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3841, 120, 120, 15, 1,0 ,0, '1999-10-05',
.06, NULL, 'BONDS', .05, 1200.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3841, 120, 120, 15, 3,0 ,0, '1998-10-31',
.05, NULL, 'BONDS', .05, 1020.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3841, 80, 80, 15, 2,0 ,0, '1997-10-11',
.07, NULL, NULL, NULL, 980.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 4002, 120, 120, 15, 3,0 ,0, '1999-12-01',
.05, NULL, NULL, NULL, 1630.00,0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 4002, 120, 120, 15, 6, 0,0, '1998-12-05',
.04, NULL, NULL, NULL, 1400.00, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 4002, 80, 80, 15, 5, 0,0, '1997-12-01',
.04, NULL, NULL, NULL, 1380.00,0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 1003, 160, 56, 15, 0, .10, 11500, null,
.05, NULL, '401K', .10, NULL, 0,0 , 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 1003, 160, 80, 15, 0, .10, 10000, null,
.05, NULL, '401K', .10, NULL, 0,0 , 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 1003, 160, 40, 15, 0, .10, 10000, null,
.05, NULL, '401K', .10, NULL, 0, 0, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 5103, 12, 12, 2, 0, 0 , 0 , null, null,
NULL, NULL, NULL, NULL, 0,0 , 'HSDIP',
'HP302-8403', 54.86);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 2466, 120, 120, 15, 9, .05, 2650, '1999-10-26',
.05, null, '401K', .03, 1800.00, 16, 16, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2466, 120, 112, 15, 11, 0,0, '1998-10-18',
.04, NULL, NULL, NULL, 1300.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2466, 120, 120, 15, 10,0 ,0, '1997-10-10',
.035, NULL, NULL, NULL, 980.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3449, 120, 120, 15, 8, 0,0, '1999-12-08',
.04, NULL, NULL, NULL, 240.50,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3449, 120, 104, 15, 8, 0,0, '1998-12-02',
.05, NULL, NULL, NULL, 1100.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3449, 120, 112, 15, 9,0 ,0, '1997-12-18',
.03, NULL, NULL, NULL, 080.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2781, 120, 120, 15, 8, 0,0, '1999-04-11',
.05, NULL, '401K', .03, 1700.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2781, 120, 96, 15, 15, 0,0, '1998-04-26',
.05, NULL, '401K', .03, 1450.80,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2781, 120, 120, 15, 2,0 ,0, '1997-04-18',
.05, NULL, NULL, NULL, 1100.00,0,0, 'COLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 2894, 120, 48, 15, 1,0 ,0, '1999-05-01',
.05, null, 'STOCK', .08, 1920.00, 16, 0, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 2894, 120, 40, 15, 0,0 ,0, '1998-05-18',
.08, null, 'STOCK', .08, 1750.00, 32, 32, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 2894, 120, 0, 15, 0, 0,0, '1997-05-11',
.06, null, 'STOCK', .08, 1600.00, 16, 8, 'MAS',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1999, 3411, 120, 120, 15, 3, 0,0, '1999-10-10',
.04, NULL, '401K', .03, 1350.00,0 ,0 , 'JRCOLL',
null, null );
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1998, 3411, 120, 120, 15, 15, 0,0, '1998-09-10',
.04, NULL, '401K', .03, 1250.00, 0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
VALUES (1997, 3411, 120, 120, 15, 15,0 ,0, '1997-09-28',
.03, NULL, NULL, NULL, 1100.00,0 ,0 , 'JRCOLL',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 4358, 120, 112, 15, 2, .07, 1300, '1999-10-01',
.055, NULL, NULL, NULL, 790.80, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 4358, 120, 80, 15, 0, .07, 1230, '1998-09-15',
.055, NULL, NULL, NULL, 820.00, 0,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 4358, 80, 80, 15, 14.5, .06, 980, '1997-09-26',
.055, NULL, NULL, NULL, 700.00,0 ,0 , 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (2000, 1234, 92, 40, 8, 12, .05, 9800, '2000-04-18',
.06, '1998-07-10', 'BONDS', .10, 1750.00, 72, 0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1999, 1234, 160, 16, 15, 0, .05, 8870, '1999-04-26',
.07, '1998-07-10', 'BONDS', .08, 1600.00, 48, 0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1998, 1234, 160, 32, 15, 0, .05, 8440, '1998-04-10',
.06, '1998-07-10', 'BONDS', .07, 1600.00, 56, 0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.BENEFITS
values (1997, 1234, 160, 0, 15, 0, .05, 7690, '1997-04-01',
.06, null, 'BONDS', .06, 1580.50, 48, 0, 'HSDIP',
null, null);
INSERT INTO DEMOEMPL.INSURANCE_PLAN
values ('PLI', 'Providential Life Insurance',
'950 Gibraltar Ave', 'Lisbon', 'VA', '03097',
'7033548300', 7815, null, 1000000, null, null, '1988-02-01');
INSERT INTO DEMOEMPL.INSURANCE_PLAN
values ('HHM', 'Homeostasis Health Maintenance Program',
'57 Goodwill Blvd', 'Bellingham', 'MA', '01988',
'5083535600', 2867, 300, 100000, 30, NULL, '1992-01-03');
INSERT INTO DEMOEMPL.INSURANCE_PLAN
values ('HGH', 'Holistic Group Health Association',
'2 Technology Park', 'Winnetka', 'IL', '06060',
'9413865700', 9471, NULL, 900000, 10, 5, '1992-01-08');
INSERT INTO DEMOEMPL.INSURANCE_PLAN
values ('DAS', 'Dental Associates',
'52 Dedham Pl', 'Medford', 'MA', '03032',
'6174445362', 5598, 50, 15000, NULL, NULL, '1993-01-04');
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 2096, '1995-03-03',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 2096, '1995-03-03',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 2096, '1995-03-03',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 2437, '1995-03-15',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 2598, '1997-07-25',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 3433, '1993-12-31',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3433, '1993-11-01',
'1993-12-31', 1) ;
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3433, '1993-12-31',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3778, '1998-01-21',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3778, '1998-01-21',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 1034, '1992-06-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 1034, '1993-12-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 2424, '1993-07-24',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 4456, '1994-01-04',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3288, '1993-06-12',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3288, '1993-12-01',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3341, '1993-10-02',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3341, '1997-01-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 2209, '1992-08-12',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 2209, '1993-12-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3294, '1993-02-19',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3338, '1994-12-11',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 2299, '1996-01-01',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 3199, '1995-10-20',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3199, '1995-10-20',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3199, '1995-10-20',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 4001, '1995-12-11',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 4001, '1997-01-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 4008, '1996-01-23',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 4008, '1996-01-23',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 4962, '1997-10-04',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 4962, '1997-12-01',
null, 4);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3764, '1994-08-25',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 5090, '1998-07-12',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 4027, '1996-04-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3991, '1994-11-12',
'1995-12-31',5) ;
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 3991, '1996-01-01',
null, 5);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3991, '1994-11-12',
null, 5);
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 1765, '1992-06-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 1765, '1993-12-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 4773, '1995-10-14',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 3767, '1994-09-20',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 3767, '1994-09-20',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3767, '1995-01-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('PLI', 2448, '1992-01-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 2448, '1993-12-01',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3704, '1997-01-01',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HGH', 4703, '1997-03-19',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 4703, '1997-03-19',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 2246, '1992-06-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 2246, '1998-01-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 5008, '1998-01-31',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 5008, '1998-01-31',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE values ('HHM', 1234, '1993-06-01',
null, 5);
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 2174, '1995-03-30',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE values ('HGH', 3118, '1995-07-23',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE values ('DAS', 3222, '1995-10-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('PLI', 1003, '1988-02-01',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HHM', 1003, '1992-06-01',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 1003, '1993-12-01',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('PLI', 5103, '1999-10-11',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HHM', 5103, '1999-10-11',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 5103, '1999-10-11',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('PLI', 2781, '1995-09-27',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 2781, '1998-01-01',
null, 2);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('PLI', 2894, '1995-11-12',
NULL, 0 );
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HGH', 2894, '1995-11-12',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 2894, '1995-11-12',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HGH', 3411, '1997-01-30',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 3411, '1997-01-30',
null, 3);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('HHM', 4358, '1996-09-13',
null, 1);
INSERT INTO DEMOEMPL.COVERAGE VALUES ('DAS', 4358, '1996-09-13',
null, 1);
INSERT INTO DEMOPROJ.ASSIGNMENT
VALUES (2466, 'D880', '1999-11-01', NULL);
INSERT INTO DEMOPROJ.ASSIGNMENT
values (2894, 'P634', '2000-02-15', null);
INSERT INTO DEMOPROJ.ASSIGNMENT
values (3411, 'P634', '2000-03-01', null);
INSERT INTO DEMOPROJ.ASSIGNMENT
VALUES (4358, 'C240', '1998-06-01', '1998-08-15') ;
UPDATE DEMOEMPL.DIVISION
SET DIV_HEAD_ID =2180
WHERE DIV_CODE = 'D02';
UPDATE DEMOEMPL.DIVISION
SET DIV_HEAD_ID =2010
WHERE DIV_CODE = 'D04';
UPDATE DEMOEMPL.DIVISION
SET DIV_HEAD_ID =4321
WHERE DIV_CODE = 'D06';
UPDATE DEMOEMPL.DIVISION
SET DIV_HEAD_ID =1003
WHERE DIV_CODE = 'D09';
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =3082
WHERE DEPT_ID = 3510 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2180
WHERE DEPT_ID = 2200 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2246
WHERE DEPT_ID = 1100 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =3769
WHERE DEPT_ID = 3520 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2010
WHERE DEPT_ID = 2210 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =1003
WHERE DEPT_ID = 4200 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =1765
WHERE DEPT_ID = 1110 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2004
WHERE DEPT_ID = 1120 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2096
WHERE DEPT_ID = 4600 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2209
WHERE DEPT_ID = 3530 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2598
WHERE DEPT_ID = 5100 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2461
WHERE DEPT_ID = 6200 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2894
WHERE DEPT_ID = 5200 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2466
WHERE DEPT_ID = 5000 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =2466
WHERE DEPT_ID = 4900 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =1003
WHERE DEPT_ID = 6000 ;
UPDATE DEMOEMPL.DEPARTMENT
SET DEPT_HEAD_ID =3222
WHERE DEPT_ID = 4500 ;
COMMIT WORK RELEASE;
Copyright © 2013 CA.
All rights reserved.
|
|