|
// Creating Empdemo in Neo4j |
|
|
|
//create departments |
|
create (n3:Department {NodeID:1, DeptID:'0100', DeptName:'EXECUTIVE ADMINISTRATION', DeptHeadID:'0030'}); |
|
create (n4:Department {NodeID:2, DeptID:'1000', DeptName:'PERSONNEL', DeptHeadID:'0013'}); |
|
create (n5:Department {NodeID:3, DeptID:'2000', DeptName:'ACCOUNTING AND PAYROLL', DeptHeadID:'0011'}); |
|
create (n6:Department {NodeID:4, DeptID:'3100', DeptName:'INTERNAL SOFTWARE', DeptHeadID:'0003'}); |
|
create (n7:Department {NodeID:5, DeptID:'3200', DeptName:'COMPUTER OPERATIONS', DeptHeadID:'0004'}); |
|
create (n8:Department {NodeID:6, DeptID:'4000', DeptName:'PUBLIC RELATIONS', DeptHeadID:'0007'}); |
|
create (n9:Department {NodeID:7, DeptID:'5100', DeptName:'BRAINSTORMING', DeptHeadID:'0015'}); |
|
create (n10:Department {NodeID:8, DeptID:'5200', DeptName:'THERMOREGULATION', DeptHeadID:'0349'}); |
|
create (n11:Department {NodeID:9, DeptID:'5300', DeptName:'BLUE SKIES', DeptHeadID:'0321'}); |
|
|
|
//create offices |
|
create (n13:Office {NodeID:10, OfficeCode:'001', OfficeStreet:'20 W BLOOMFIELD ST', OfficeCity:'SPRINGFIELD', OfficeState:'MA', OfficeZip1:'02076', OfficeZip2:'0013', OfficePhone:'697721000000000000006', OfficeAreaCode:'170', OfficeSpeedDial:'13'}); |
|
create (n15:Office {NodeID:11, OfficeCode:'002', OfficeStreet:'567 BOYLSTON ST', OfficeCity:'BOSTON', OfficeState:'MA', OfficeZip1:'02243', OfficeZip2:'0029', OfficePhone:'562377956257195623986', OfficeAreaCode:'170', OfficeSpeedDial:'10'}); |
|
create (n17:Office {NodeID:12, OfficeCode:'005', OfficeStreet:'7690 NEAR SIGHT AVE', OfficeCity:'GLASSTER', OfficeState:'MA', OfficeZip1:'02967', OfficeZip2:'0054', OfficePhone:'578123457999900000004', OfficeAreaCode:'130', OfficeSpeedDial:'30'}); |
|
create (n19:Office {NodeID:13, OfficeCode:'008', OfficeStreet:'910 E NORTHSOUTH AVE', OfficeCity:'WESTON', OfficeState:'MA', OfficeZip1:'02371', OfficeZip2:'0083', OfficePhone:'679191367929236713276', OfficeAreaCode:'170', OfficeSpeedDial:'33'}); |
|
create (n21:Office {NodeID:14, OfficeCode:'012', OfficeStreet:'734 MASS. AVE', OfficeCity:'CAMBRIDGE', OfficeState:'MA', OfficeZip1:'02139', OfficeZip2:'0128', OfficePhone:'762020000000000000006', OfficeAreaCode:'170', OfficeSpeedDial:'35'}); |
|
|
|
//create employees |
|
create (n299:Employee {NodeID:124, EmpID:'0001', EmpFirstName:'JOHN', EmpLastName:'RUPEE', EmpStreet:'114 WEST INDIA ST', EmpCity:'METHUEN', EmpState:'MA', EmpZip1:'02312', EmpZip2:'', EmpPhone:'6173421515', Status:'01', SSNumber:'013445656', StartDate:'19750223', TerminationDate:'00000000', BirthDate:'19330219'}); |
|
create (n312:Employee {NodeID:133, EmpID:'0003', EmpFirstName:'JENNIFER', EmpLastName:'GARFIELD', EmpStreet:'110A FIRTH ST', EmpCity:'STONEHAM', EmpState:'MA', EmpZip1:'02928', EmpZip2:'', EmpPhone:'6173321967', Status:'01', SSNumber:'021994516', StartDate:'19770121', TerminationDate:'00000000', BirthDate:'19450818'}); |
|
create (n325:Employee {NodeID:144, EmpID:'0004', EmpFirstName:'HERBERT', EmpLastName:'CRANE', EmpStreet:'30 HERON AVE', EmpCity:'KINGSTON', EmpState:'NJ', EmpZip1:'21341', EmpZip2:'', EmpPhone:'2013341433', Status:'01', SSNumber:'016777451', StartDate:'19770514', TerminationDate:'00000000', BirthDate:'19420321'}); |
|
create (n336:Employee {NodeID:153, EmpID:'0007', EmpFirstName:'MONTE', EmpLastName:'BANK', EmpStreet:'45 EAST GROVE DR', EmpCity:'HANIBAL', EmpState:'MA', EmpZip1:'02415', EmpZip2:'', EmpPhone:'6173321933', Status:'01', SSNumber:'022446676', StartDate:'19780430', TerminationDate:'00000000', BirthDate:'19500101'}); |
|
create (n341:Employee {NodeID:156, EmpID:'0011', EmpFirstName:'RUPERT', EmpLastName:'JENSON', EmpStreet:'999 HARVEY ST', EmpCity:'MELROSE', EmpState:'MA', EmpZip1:'02176', EmpZip2:'', EmpPhone:'6176655556', Status:'01', SSNumber:'022347891', StartDate:'19800929', TerminationDate:'00000000', BirthDate:'19480817'}); |
|
create (n348:Employee {NodeID:161, EmpID:'0013', EmpFirstName:'ELEANOR', EmpLastName:'PEOPLES', EmpStreet:'756 YELLOWSTONE DR', EmpCity:'BOSTON', EmpState:'MA', EmpZip1:'02834', EmpZip2:'', EmpPhone:'6173291212', Status:'01', SSNumber:'011765923', StartDate:'19810102', TerminationDate:'00000000', BirthDate:'19490526'}); |
|
create (n353:Employee {NodeID:164, EmpID:'0015', EmpFirstName:'RENE', EmpLastName:'MAKER', EmpStreet:'10 DROVER DR', EmpCity:'BOSTON', EmpState:'MA', EmpZip1:'02123', EmpZip2:'', EmpPhone:'6174521414', Status:'01', SSNumber:'010673343', StartDate:'19780102', TerminationDate:'00000000', BirthDate:'19450521'}); |
|
create (n362:Employee {NodeID:171, EmpID:'0016', EmpFirstName:'TERENCE', EmpLastName:'KLWELLEN', EmpStreet:'12 RAUNCH ST., APT1', EmpCity:'DEDHAM', EmpState:'MA', EmpZip1:'02034', EmpZip2:'', EmpPhone:'6174456123', Status:'01', SSNumber:'010201239', StartDate:'19780106', TerminationDate:'00000000', BirthDate:'19550921'}); |
|
create (n368:Employee {NodeID:175, EmpID:'0019', EmpFirstName:'JULIE', EmpLastName:'JENSEN', EmpStreet:'15 THINGER AVE', EmpCity:'SAUGUS', EmpState:'MA', EmpZip1:'02276', EmpZip2:'', EmpPhone:'6172241955', Status:'01', SSNumber:'033456718', StartDate:'19820929', TerminationDate:'00000000', BirthDate:'19480730'}); |
|
create (n375:Employee {NodeID:180, EmpID:'0020', EmpFirstName:'JAMES', EmpLastName:'JACOBI', EmpStreet:'555 JAKAS DR', EmpCity:'GROVER', EmpState:'MA', EmpZip1:'02976', EmpZip2:'', EmpPhone:'6173348912', Status:'01', SSNumber:'018813465', StartDate:'19811111', TerminationDate:'00000000', BirthDate:'19401101'}); |
|
create (n386:Employee {NodeID:189, EmpID:'0021', EmpFirstName:'RALPH', EmpLastName:'TYRO', EmpStreet:'888 FORTITHE ST', EmpCity:'SINGER', EmpState:'MA', EmpZip1:'02254', EmpZip2:'', EmpPhone:'6174459191', Status:'01', SSNumber:'019893456', StartDate:'19801221', TerminationDate:'00000000', BirthDate:'19551225'}); |
|
create (n392:Employee {NodeID:193, EmpID:'0023', EmpFirstName:'KATHERINE', EmpLastName:'OHEARN', EmpStreet:'12 EAST SPEEN ST', EmpCity:'NATICK', EmpState:'MA', EmpZip1:'02364', EmpZip2:'', EmpPhone:'6178897134', Status:'01', SSNumber:'019556712', StartDate:'19780504', TerminationDate:'00000000', BirthDate:'19540407'}); |
|
create (n401:Employee {NodeID:200, EmpID:'0024', EmpFirstName:'JANE', EmpLastName:'DOUGH', EmpStreet:'15 LOCATION DR', EmpCity:'NEWTON', EmpState:'MA', EmpZip1:'02456', EmpZip2:'', EmpPhone:'6174458155', Status:'01', SSNumber:'022337878', StartDate:'19760808', TerminationDate:'00000000', BirthDate:'19510329'}); |
|
create (n408:Employee {NodeID:205, EmpID:'0027', EmpFirstName:'VLADIMIR', EmpLastName:'HEAROWITZ', EmpStreet:'19 TERRACE TERR', EmpCity:'TAUNTON', EmpState:'MA', EmpZip1:'02678', EmpZip2:'', EmpPhone:'6173349634', Status:'01', SSNumber:'031896154', StartDate:'19810909', TerminationDate:'00000000', BirthDate:'19560425'}); |
|
create (n413:Employee {NodeID:208, EmpID:'0028', EmpFirstName:'PERCY', EmpLastName:'GRANGER', EmpStreet:'14 BYTE WAY', EmpCity:'TAUNTON', EmpState:'MA', EmpZip1:'02678', EmpZip2:'', EmpPhone:'6173341212', Status:'01', SSNumber:'011234545', StartDate:'19800527', TerminationDate:'00000000', BirthDate:'19580222'}); |
|
create (n418:Employee {NodeID:211, EmpID:'0029', EmpFirstName:'JAMES', EmpLastName:'GALLWAY', EmpStreet:'15 DAWSON ST', EmpCity:'MEDFORD', EmpState:'MA', EmpZip1:'02432', EmpZip2:'', EmpPhone:'6173349155', Status:'01', SSNumber:'014567777', StartDate:'19811010', TerminationDate:'00000000', BirthDate:'19471006'}); |
|
create (n424:Employee {NodeID:215, EmpID:'0030', EmpFirstName:'HENRIETTA', EmpLastName:'HENDON', EmpStreet:'16 HENDON DR', EmpCity:'WELLESLEY', EmpState:'MA', EmpZip1:'02198', EmpZip2:'', EmpPhone:'6178881212', Status:'01', SSNumber:'011334444', StartDate:'19731121', TerminationDate:'00000000', BirthDate:'19331006'}); |
|
create (n428:Employee {NodeID:217, EmpID:'0031', EmpFirstName:'HERBERT', EmpLastName:'LIPSICH', EmpStreet:'6 FORENOON ST', EmpCity:'WALDEN', EmpState:'MA', EmpZip1:'02986', EmpZip2:'', EmpPhone:'6175555555', Status:'01', SSNumber:'013456787', StartDate:'19810429', TerminationDate:'00000000', BirthDate:'19530121'}); |
|
create (n433:Employee {NodeID:220, EmpID:'0032', EmpFirstName:'JANE', EmpLastName:'FERNDALE', EmpStreet:'60 FOREST AVE', EmpCity:'NEWTON', EmpState:'MA', EmpZip1:'02576', EmpZip2:'', EmpPhone:'6178888112', Status:'01', SSNumber:'034567891', StartDate:'19790909', TerminationDate:'00000000', BirthDate:'19580117'}); |
|
create (n439:Employee {NodeID:224, EmpID:'0035', EmpFirstName:'LARRY', EmpLastName:'LITERATA', EmpStreet:'123 SATURDAY TERR', EmpCity:'WILMINGTON', EmpState:'MA', EmpZip1:'02476', EmpZip2:'', EmpPhone:'6175912323', Status:'01', SSNumber:'023567831', StartDate:'19800909', TerminationDate:'00000000', BirthDate:'19550430'}); |
|
create (n446:Employee {NodeID:229, EmpID:'0045', EmpFirstName:'GEORGE', EmpLastName:'FONRAD', EmpStreet:'99 VERDE ST', EmpCity:'STOUGHTON', EmpState:'MA', EmpZip1:'02456', EmpZip2:'', EmpPhone:'6178882323', Status:'01', SSNumber:'092348763', StartDate:'19800414', TerminationDate:'00000000', BirthDate:'19500504'}); |
|
create (n452:Employee {NodeID:233, EmpID:'0053', EmpFirstName:'ROBIN', EmpLastName:'GARDNER', EmpStreet:'68 75TH ST', EmpCity:'LOWELL', EmpState:'MA', EmpZip1:'02945', EmpZip2:'', EmpPhone:'6174521111', Status:'01', SSNumber:'022334444', StartDate:'19810615', TerminationDate:'00000000', BirthDate:'19590321'}); |
|
create (n457:Employee {NodeID:236, EmpID:'0067', EmpFirstName:'MARIANNE', EmpLastName:'KIMBALL', EmpStreet:'561 LEXINGTON AVE', EmpCity:'LITTLETON', EmpState:'MA', EmpZip1:'01239', EmpZip2:'', EmpPhone:'6174921212', Status:'01', SSNumber:'022778878', StartDate:'19800919', TerminationDate:'00000000', BirthDate:'19490423'}); |
|
create (n465:Employee {NodeID:242, EmpID:'0069', EmpFirstName:'JUNE', EmpLastName:'BLOOMER', EmpStreet:'14 ZITHER TERR', EmpCity:'LEXINGTON', EmpState:'MA', EmpZip1:'01675', EmpZip2:'', EmpPhone:'6175555544', Status:'01', SSNumber:'039557818', StartDate:'19800505', TerminationDate:'00000000', BirthDate:'19600425'}); |
|
create (n472:Employee {NodeID:247, EmpID:'0074', EmpFirstName:'SANDY', EmpLastName:'KRAAMER', EmpStreet:'56 NASTY WAY', EmpCity:'WESTWOOD', EmpState:'MA', EmpZip1:'02090', EmpZip2:'', EmpPhone:'6173290002', Status:'01', SSNumber:'023786666', StartDate:'19810404', TerminationDate:'00000000', BirthDate:'19540616'}); |
|
create (n478:Employee {NodeID:251, EmpID:'0081', EmpFirstName:'TOM', EmpLastName:'FITZHUGH', EmpStreet:'450 THRUWAY ST', EmpCity:'MANSFIELD', EmpState:'MA', EmpZip1:'03458', EmpZip2:'', EmpPhone:'6178820123', Status:'01', SSNumber:'112345678', StartDate:'19810919', TerminationDate:'00000000', BirthDate:'19560213'}); |
|
create (n484:Employee {NodeID:255, EmpID:'0091', EmpFirstName:'MADELINE', EmpLastName:'ORGRATZI', EmpStreet:'67 RAINBOW DR', EmpCity:'KENDON', EmpState:'MA', EmpZip1:'06182', EmpZip2:'', EmpPhone:'6174311919', Status:'01', SSNumber:'231067878', StartDate:'19801010', TerminationDate:'00000000', BirthDate:'19511016'}); |
|
create (n491:Employee {NodeID:260, EmpID:'0100', EmpFirstName:'EDWARD', EmpLastName:'HUTTON', EmpStreet:'781 CROSS ST', EmpCity:'MELROSE', EmpState:'MA', EmpZip1:'02176', EmpZip2:'', EmpPhone:'6176651010', Status:'01', SSNumber:'011223333', StartDate:'19770907', TerminationDate:'00000000', BirthDate:'19410304'}); |
|
create (n498:Employee {NodeID:265, EmpID:'0101', EmpFirstName:'BRIAN', EmpLastName:'NICEMAN', EmpStreet:'60 FLORENCE AVE', EmpCity:'MELROSE', EmpState:'MA', EmpZip1:'02176', EmpZip2:'', EmpPhone:'6176654315', Status:'01', SSNumber:'033456110', StartDate:'19800506', TerminationDate:'00000000', BirthDate:'19551213'}); |
|
create (n505:Employee {NodeID:270, EmpID:'0106', EmpFirstName:'DORIS', EmpLastName:'KING', EmpStreet:'716 MORRIS ST', EmpCity:'MELROSE', EmpState:'MA', EmpZip1:'02176', EmpZip2:'', EmpPhone:'6176656161', Status:'01', SSNumber:'067845516', StartDate:'19800816', TerminationDate:'00000000', BirthDate:'19600916'}); |
|
create (n512:Employee {NodeID:275, EmpID:'0119', EmpFirstName:'CHARLES', EmpLastName:'BOWER', EmpStreet:'30 RALPH ST', EmpCity:'WELLESLEY', EmpState:'MA', EmpZip1:'01568', EmpZip2:'', EmpPhone:'6178841212', Status:'01', SSNumber:'092345812', StartDate:'19771214', TerminationDate:'00000000', BirthDate:'19390304'}); |
|
create (n518:Employee {NodeID:279, EmpID:'0120', EmpFirstName:'MICHAEL', EmpLastName:'ANGELO', EmpStreet:'507 CISTINE DR', EmpCity:'WELLESLEY', EmpState:'MA', EmpZip1:'01568', EmpZip2:'', EmpPhone:'6178870235', Status:'01', SSNumber:'127675593', StartDate:'19790908', TerminationDate:'00000000', BirthDate:'19570405'}); |
|
create (n526:Employee {NodeID:285, EmpID:'0127', EmpFirstName:'CAROL', EmpLastName:'MCDOUGALL', EmpStreet:'19 URITOP DR', EmpCity:'WELLESLEY', EmpState:'MA', EmpZip1:'01568', EmpZip2:'', EmpPhone:'6178871324', Status:'01', SSNumber:'153897789', StartDate:'19800607', TerminationDate:'00000000', BirthDate:'19590304'}); |
|
create (n532:Employee {NodeID:289, EmpID:'0149', EmpFirstName:'LAURA', EmpLastName:'PENMAN', EmpStreet:'45 THRUSH LN', EmpCity:'WALTHAM', EmpState:'MA', EmpZip1:'01476', EmpZip2:'', EmpPhone:'6175341199', Status:'01', SSNumber:'014593186', StartDate:'19770908', TerminationDate:'00000000', BirthDate:'19440504'}); |
|
create (n536:Employee {NodeID:291, EmpID:'0158', EmpFirstName:'JOCK', EmpLastName:'JACKSON', EmpStreet:'65 BROWN ST', EmpCity:'WALTHAM', EmpState:'MA', EmpZip1:'01476', EmpZip2:'', EmpPhone:'6175346767', Status:'01', SSNumber:'019996919', StartDate:'19770707', TerminationDate:'00000000', BirthDate:'19500904'}); |
|
create (n540:Employee {NodeID:293, EmpID:'0301', EmpFirstName:'BURT', EmpLastName:'LANCHESTER', EmpStreet:'45 PINKERTON AVE', EmpCity:'WALTHAM', EmpState:'MA', EmpZip1:'01476', EmpZip2:'', EmpPhone:'6175341109', Status:'01', SSNumber:'129040506', StartDate:'19750203', TerminationDate:'00000000', BirthDate:'19320419'}); |
|
create (n549:Employee {NodeID:300, EmpID:'0321', EmpFirstName:'DANIEL', EmpLastName:'MOON', EmpStreet:'16 SKYHIGH DR', EmpCity:'WESTON', EmpState:'MA', EmpZip1:'04371', EmpZip2:'', EmpPhone:'6174921414', Status:'01', SSNumber:'023481101', StartDate:'19780103', TerminationDate:'00000000', BirthDate:'19440324'}); |
|
create (n556:Employee {NodeID:305, EmpID:'0329', EmpFirstName:'PHINEAS', EmpLastName:'FINN', EmpStreet:'79 HIGH ST', EmpCity:'WESTON', EmpState:'MA', EmpZip1:'04371', EmpZip2:'', EmpPhone:'6174920003', Status:'01', SSNumber:'011787878', StartDate:'19790616', TerminationDate:'00000000', BirthDate:'19380324'}); |
|
create (n561:Employee {NodeID:308, EmpID:'0334', EmpFirstName:'CAROLYN', EmpLastName:'CROW', EmpStreet:'891 SUMMER ST', EmpCity:'WESTWOOD', EmpState:'MA', EmpZip1:'02090', EmpZip2:'', EmpPhone:'6173291776', Status:'01', SSNumber:'023980110', StartDate:'19790617', TerminationDate:'00000000', BirthDate:'19440403'}); |
|
create (n567:Employee {NodeID:312, EmpID:'0341', EmpFirstName:'RICHARD', EmpLastName:'MUNYON', EmpStreet:'17 BLACKHILL DR', EmpCity:'WESTWOOD', EmpState:'MA', EmpZip1:'02090', EmpZip2:'', EmpPhone:'6173290017', Status:'01', SSNumber:'111002081', StartDate:'19801114', TerminationDate:'00000000', BirthDate:'19501214'}); |
|
create (n574:Employee {NodeID:317, EmpID:'0349', EmpFirstName:'ROGER', EmpLastName:'WILCO', EmpStreet:'671A SNOWBANK RD', EmpCity:'TYNGSBORO', EmpState:'MA', EmpZip1:'01879', EmpZip2:'', EmpPhone:'6176490190', Status:'01', SSNumber:'111000023', StartDate:'19791111', TerminationDate:'00000000', BirthDate:'19501112'}); |
|
create (n583:Employee {NodeID:324, EmpID:'0355', EmpFirstName:'MARK', EmpLastName:'TIME', EmpStreet:'44 CLOCK ST', EmpCity:'MALDEN', EmpState:'MA', EmpZip1:'01776', EmpZip2:'', EmpPhone:'6175551919', Status:'01', SSNumber:'034560128', StartDate:'19810505', TerminationDate:'00000000', BirthDate:'19580309'}); |
|
create (n589:Employee {NodeID:328, EmpID:'0366', EmpFirstName:'ALAN', EmpLastName:'DONOVAN', EmpStreet:'6781 CORNWALL AVE', EmpCity:'MELROSE', EmpState:'MA', EmpZip1:'02176', EmpZip2:'', EmpPhone:'6176655412', Status:'01', SSNumber:'025503622', StartDate:'19811010', TerminationDate:'00000000', BirthDate:'19511117'}); |
|
create (n595:Employee {NodeID:332, EmpID:'0371', EmpFirstName:'BETH', EmpLastName:'CLOUD', EmpStreet:'3456 PINKY LN', EmpCity:'NATICK', EmpState:'MA', EmpZip1:'02178', EmpZip2:'', EmpPhone:'6174321212', Status:'01', SSNumber:'326710472', StartDate:'19770304', TerminationDate:'00000000', BirthDate:'19450909'}); |
|
create (n602:Employee {NodeID:337, EmpID:'0458', EmpFirstName:'RICHARD', EmpLastName:'WAGNER', EmpStreet:'677 GERMANY LN', EmpCity:'NATICK', EmpState:'MA', EmpZip1:'02178', EmpZip2:'', EmpPhone:'6174321109', Status:'01', SSNumber:'011776663', StartDate:'19780607', TerminationDate:'00000000', BirthDate:'19340304'}); |
|
create (n609:Employee {NodeID:342, EmpID:'0467', EmpFirstName:'C.', EmpLastName:'BREEZE', EmpStreet:'200 NIGHTINGALE ST', EmpCity:'FRAMINGHAM', EmpState:'MA', EmpZip1:'03461', EmpZip2:'', EmpPhone:'6175542387', Status:'01', SSNumber:'111556692', StartDate:'19790602', TerminationDate:'00000000', BirthDate:'19340504'}); |
|
create (n614:Employee {NodeID:345, EmpID:'0471', EmpFirstName:'THEMIS', EmpLastName:'PAPAZEUS', EmpStreet:'234 TRANSWORLD ST', EmpCity:'NORTHBORO', EmpState:'MA', EmpZip1:'03256', EmpZip2:'', EmpPhone:'6174561277', Status:'01', SSNumber:'022887770', StartDate:'19780907', TerminationDate:'00000000', BirthDate:'19350304'}); |
|
create (n626:Employee {NodeID:355, EmpID:'0472', EmpFirstName:'ROBBY', EmpLastName:'WILDER', EmpStreet:'4567 E. GROWTH ST', EmpCity:'SOUTHBORO', EmpState:'MA', EmpZip1:'03145', EmpZip2:'', EmpPhone:'6174317709', Status:'01', SSNumber:'038779010', StartDate:'19790716', TerminationDate:'00000000', BirthDate:'19550304'}); |
|
create (n632:Employee {NodeID:359, EmpID:'0479', EmpFirstName:'TERRY', EmpLastName:'CLOTH', EmpStreet:'5 ASPHALT ST', EmpCity:'EASTON', EmpState:'MA', EmpZip1:'05491', EmpZip2:'', EmpPhone:'6177738398', Status:'01', SSNumber:'028701666', StartDate:'19791102', TerminationDate:'00000000', BirthDate:'19450304'}); |
|
create (n639:Employee {NodeID:364, EmpID:'0476', EmpFirstName:'BETSY', EmpLastName:'ZEDI', EmpStreet:'34 VALE AVE', EmpCity:'SOUTHBORO', EmpState:'MA', EmpZip1:'03145', EmpZip2:'', EmpPhone:'6174319909', Status:'05', SSNumber:'010004560', StartDate:'19760223', TerminationDate:'00000000', BirthDate:'19401229'}); |
|
create (n643:Employee {NodeID:366, EmpID:'0457', EmpFirstName:'HARRY', EmpLastName:'ARM', EmpStreet:'77 SUNSET STRIP', EmpCity:'NATICK', EmpState:'MA', EmpZip1:'02178', EmpZip2:'', EmpPhone:'6174320923', Status:'05', SSNumber:'028770147', StartDate:'19771201', TerminationDate:'00000000', BirthDate:'19340405'}); |
|
create (n648:Employee {NodeID:369, EmpID:'0466', EmpFirstName:'ROY', EmpLastName:'ANDALE', EmpStreet:'44 TRIGGER RD', EmpCity:'FRAMINGHAM', EmpState:'MA', EmpZip1:'03461', EmpZip2:'', EmpPhone:'6175541108', Status:'03', SSNumber:'027601115', StartDate:'19780615', TerminationDate:'00000000', BirthDate:'19600304'}); |
|
create (n657:Employee {NodeID:376, EmpID:'0469', EmpFirstName:'JOE', EmpLastName:'KASPAR', EmpStreet:'133 NORTH ST', EmpCity:'WESTBORO', EmpState:'MA', EmpZip1:'03156', EmpZip2:'', EmpPhone:'6179341290', Status:'04', SSNumber:'036768888', StartDate:'19800605', TerminationDate:'00000000', BirthDate:'19400504'}); |
|
create (n665:Employee {NodeID:382, EmpID:'0048', EmpFirstName:'NANCY', EmpLastName:'TERNER', EmpStreet:'14 TYPO TERR', EmpCity:'READING', EmpState:'MA', EmpZip1:'02317', EmpZip2:'', EmpPhone:'6173333333', Status:'02', SSNumber:'045672222', StartDate:'19820526', TerminationDate:'00000000', BirthDate:'19600717'}); |
|
create (n672:Employee {NodeID:387, EmpID:'0049', EmpFirstName:'DOUGLAS', EmpLastName:'KAHALLY', EmpStreet:'56 SPELLING AVE', EmpCity:'READING', EmpState:'MA', EmpZip1:'02317', EmpZip2:'', EmpPhone:'6173339056', Status:'05', SSNumber:'029661234', StartDate:'19790929', TerminationDate:'00000000', BirthDate:'19520421'}); |
|
create (n680:Employee {NodeID:393, EmpID:'0051', EmpFirstName:'CYNTHIA', EmpLastName:'JOHNSON', EmpStreet:'17 MANIFESTO DR', EmpCity:'WALPOLE', EmpState:'MA', EmpZip1:'02546', EmpZip2:'', EmpPhone:'6177778888', Status:'05', SSNumber:'011347878', StartDate:'19770323', TerminationDate:'00000000', BirthDate:'19450107'}); |
|
|
|
//create coverage |
|
create (n701:Coverage {NodeID:402, SelectionDate:'19750301', TerminationDate:'00000000', Type:'M', InsPlanCode:'002'}); |
|
create (n708:Coverage {NodeID:404, SelectionDate:'19750301', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n714:Coverage {NodeID:406, SelectionDate:'19770201', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n715:Coverage {NodeID:407, SelectionDate:'19770201', TerminationDate:'00000000', Type:'D', InsPlanCode:'002'}); |
|
create (n716:Coverage {NodeID:408, SelectionDate:'19770601', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n717:Coverage {NodeID:409, SelectionDate:'19770601', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n718:Coverage {NodeID:410, SelectionDate:'19770601', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n725:Coverage {NodeID:412, SelectionDate:'19780601', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n726:Coverage {NodeID:413, SelectionDate:'19780601', TerminationDate:'19790531', Type:'F', InsPlanCode:'002'}); |
|
create (n727:Coverage {NodeID:414, SelectionDate:'19790601', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n735:Coverage {NodeID:416, SelectionDate:'19780201', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n736:Coverage {NodeID:417, SelectionDate:'19780201', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n743:Coverage {NodeID:419, SelectionDate:'19780201', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n744:Coverage {NodeID:420, SelectionDate:'19750301', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n745:Coverage {NodeID:421, SelectionDate:'19750301', TerminationDate:'19781031', Type:'F', InsPlanCode:'002'}); |
|
create (n751:Coverage {NodeID:423, SelectionDate:'19781101', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n752:Coverage {NodeID:424, SelectionDate:'19750301', TerminationDate:'00000000', Type:'D', InsPlanCode:'004'}); |
|
create (n753:Coverage {NodeID:425, SelectionDate:'19770121', TerminationDate:'00000000', Type:'M', InsPlanCode:'002'}); |
|
create (n754:Coverage {NodeID:426, SelectionDate:'19780430', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n755:Coverage {NodeID:427, SelectionDate:'19800929', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n756:Coverage {NodeID:428, SelectionDate:'19810102', TerminationDate:'00000000', Type:'D', InsPlanCode:'002'}); |
|
create (n757:Coverage {NodeID:429, SelectionDate:'19780106', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n758:Coverage {NodeID:430, SelectionDate:'19821004', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n759:Coverage {NodeID:431, SelectionDate:'19811111', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n760:Coverage {NodeID:432, SelectionDate:'19801221', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n761:Coverage {NodeID:433, SelectionDate:'19780504', TerminationDate:'19790531', Type:'F', InsPlanCode:'002'}); |
|
create (n762:Coverage {NodeID:434, SelectionDate:'19790601', TerminationDate:'00000000', Type:'F', InsPlanCode:'001'}); |
|
create (n763:Coverage {NodeID:435, SelectionDate:'19760808', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n764:Coverage {NodeID:436, SelectionDate:'19810909', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n765:Coverage {NodeID:437, SelectionDate:'19800527', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n766:Coverage {NodeID:438, SelectionDate:'19811012', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n767:Coverage {NodeID:439, SelectionDate:'19810429', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n768:Coverage {NodeID:440, SelectionDate:'19790909', TerminationDate:'19801031', Type:'F', InsPlanCode:'002'}); |
|
create (n769:Coverage {NodeID:441, SelectionDate:'19801101', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n770:Coverage {NodeID:442, SelectionDate:'19800911', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n771:Coverage {NodeID:443, SelectionDate:'19800414', TerminationDate:'00000000', Type:'D', InsPlanCode:'004'}); |
|
create (n772:Coverage {NodeID:444, SelectionDate:'19820526', TerminationDate:'00000000', Type:'M', InsPlanCode:'002'}); |
|
create (n773:Coverage {NodeID:445, SelectionDate:'19790929', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n774:Coverage {NodeID:446, SelectionDate:'19770323', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n775:Coverage {NodeID:447, SelectionDate:'19810616', TerminationDate:'00000000', Type:'D', InsPlanCode:'002'}); |
|
create (n776:Coverage {NodeID:448, SelectionDate:'19780919', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n777:Coverage {NodeID:449, SelectionDate:'19800505', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n778:Coverage {NodeID:450, SelectionDate:'19810404', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n779:Coverage {NodeID:451, SelectionDate:'19810919', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n780:Coverage {NodeID:452, SelectionDate:'19801010', TerminationDate:'19801231', Type:'F', InsPlanCode:'002'}); |
|
create (n781:Coverage {NodeID:453, SelectionDate:'19810101', TerminationDate:'00000000', Type:'F', InsPlanCode:'001'}); |
|
create (n782:Coverage {NodeID:454, SelectionDate:'19770907', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n783:Coverage {NodeID:455, SelectionDate:'19800506', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n784:Coverage {NodeID:456, SelectionDate:'19800816', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n785:Coverage {NodeID:457, SelectionDate:'19771214', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n786:Coverage {NodeID:458, SelectionDate:'19790908', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n787:Coverage {NodeID:459, SelectionDate:'19800607', TerminationDate:'19810331', Type:'M', InsPlanCode:'002'}); |
|
create (n788:Coverage {NodeID:460, SelectionDate:'19810401', TerminationDate:'00000000', Type:'F', InsPlanCode:'002'}); |
|
create (n789:Coverage {NodeID:461, SelectionDate:'19770908', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n790:Coverage {NodeID:462, SelectionDate:'19770707', TerminationDate:'00000000', Type:'D', InsPlanCode:'004'}); |
|
create (n791:Coverage {NodeID:463, SelectionDate:'19780103', TerminationDate:'00000000', Type:'M', InsPlanCode:'002'}); |
|
create (n792:Coverage {NodeID:464, SelectionDate:'19790616', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n793:Coverage {NodeID:465, SelectionDate:'19790617', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n794:Coverage {NodeID:466, SelectionDate:'19801114', TerminationDate:'00000000', Type:'D', InsPlanCode:'002'}); |
|
create (n795:Coverage {NodeID:467, SelectionDate:'19791115', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n796:Coverage {NodeID:468, SelectionDate:'19810505', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n797:Coverage {NodeID:469, SelectionDate:'19811011', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n798:Coverage {NodeID:470, SelectionDate:'19770304', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n799:Coverage {NodeID:471, SelectionDate:'19771201', TerminationDate:'19790531', Type:'F', InsPlanCode:'002'}); |
|
create (n800:Coverage {NodeID:472, SelectionDate:'19790601', TerminationDate:'00000000', Type:'F', InsPlanCode:'001'}); |
|
create (n801:Coverage {NodeID:473, SelectionDate:'19780607', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n802:Coverage {NodeID:474, SelectionDate:'19780615', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n803:Coverage {NodeID:475, SelectionDate:'19790602', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
create (n804:Coverage {NodeID:476, SelectionDate:'19800605', TerminationDate:'00000000', Type:'F', InsPlanCode:'004'}); |
|
create (n805:Coverage {NodeID:477, SelectionDate:'19790716', TerminationDate:'00000000', Type:'M', InsPlanCode:'001'}); |
|
create (n806:Coverage {NodeID:478, SelectionDate:'19760201', TerminationDate:'19781031', Type:'F', InsPlanCode:'002'}); |
|
create (n807:Coverage {NodeID:479, SelectionDate:'19781101', TerminationDate:'00000000', Type:'M', InsPlanCode:'002'}); |
|
create (n808:Coverage {NodeID:480, SelectionDate:'19781101', TerminationDate:'00000000', Type:'D', InsPlanCode:'002'}); |
|
create (n809:Coverage {NodeID:481, SelectionDate:'19791102', TerminationDate:'00000000', Type:'F', InsPlanCode:'003'}); |
|
|
|
//Claims |
|
create (n703:HospitalClaim {NodeID:403, ClaimDate:'19821107', PatientFirstName:'HATFIELD', PatientLastName:'HENDON', PatientBirthDate:'19740528', PatientSex:'M', RelationToEmployee:'SON', HospitalName:'ANGELS OF MERCY HOSPITAL', HospitalStreet:'9 CLOUD BLVD', HospitalCity:'CHELSEA', HospitalState:'MA', HospitalZip1:'02239', HospitalZip2:'', AdmitDate:'19821015', DischargeDate:'19821017', Diagnosis:'TONSILITIS - TONSILECTOMY PERFORMED', HospitalCharges:'000000000002500000037500'}); |
|
create (n710:DentalClaim {NodeID:405, ClaimDate:'19770523', PatientFirstName:'HELOISE', PatientLastName:'HENDON', PatientBirthDate:'19680315', PatientSex:'F', RelationToEmployee:'DAUGHTER', DentistFirstName:'SAL', DentistLastName:'SARDONICUS', DentistStreet:'402 NATURES WAY', DentistCity:'NEEDHAM', DentistState:'MA', DentistZip1:'02243', DentistZip2:'', DentistLicensesNr:'459631', NrOfProcedures:'01', DentistCharges:'FILLING'}); |
|
create (n719:DentalClaim {NodeID:411, ClaimDate:'19801004', PatientFirstName:'JESSICA', PatientLastName:'CRANE', PatientBirthDate:'19570111', PatientSex:'F', RelationToEmployee:'WIFE', DentistFirstName:'DR', DentistLastName:'PEPPER', DentistStreet:'78 COLA RD', DentistCity:'PRINCETON', DentistState:'NJ', DentistZip1:'01762', DentistZip2:'', DentistLicensesNr:'877073', NrOfProcedures:'02', DentistCharges:'FILLING'}); |
|
create (n729:NonHospitalClaim {NodeID:415, ClaimDate:'19810818', PatientFirstName:'ATHENA', PatientLastName:'PAPAZEUS', PatientBirthDate:'19760722', PatientSex:'F', RelationToEmployee:'DAUGHTER', PhysicianFirstName:'FRANK', PhysicianLastName:'FAUSTUS', PhysicianStreet:'666 DEAD END ST', PhysicianCity:'BROOKLINE', PhysicianState:'MA', PhysicianZip1:'02731', PhysicianZip2:'', PhysicianID:'005036', Diagnosis:'ARGYLOPHOBIA - UNREASONING FEAR OF ARGYLE SOCKS', NrOfProcedures:'NA', PhysicianCharges:'NA'}); |
|
create (n737:NonHospitalClaim {NodeID:418, ClaimDate:'19821007', PatientFirstName:'PETE', PatientLastName:'MAKER', PatientBirthDate:'19430212', PatientSex:'M', RelationToEmployee:'HUSBAND', PhysicianFirstName:'BEN', PhysicianLastName:'CASEY', PhysicianStreet:'10A VIENNA RD', PhysicianCity:'CAMBRIDGE', PhysicianState:'MA', PhysicianZip1:'02138', PhysicianZip2:'', PhysicianID:'191770', Diagnosis:'ANNUAL PHYSICAL', NrOfProcedures:'NA', PhysicianCharges:'NA'}); |
|
create (n746:HospitalClaim {NodeID:422, ClaimDate:'19790918', PatientFirstName:'KATE', PatientLastName:'HEPBURN', PatientBirthDate:'19400414', PatientSex:'F', RelationToEmployee:'WIFE', HospitalName:'GENERAL HOSPITAL', HospitalStreet:'8200 ADMIRAL AVE', HospitalCity:'NEWTON', HospitalState:'MA', HospitalZip1:'02075', HospitalZip2:'', AdmitDate:'19790322', DischargeDate:'19790327', Diagnosis:'FULL-TERM PREGNANCY - NORMAL DELIVERY', HospitalCharges:'001500000007750000015000'}); |
|
|
|
//Expertise |
|
create (n306:Expertise {NodeID:127, ExpertiseID:'1050', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19721230'}); |
|
create (n307:Expertise {NodeID:128, ExpertiseID:'2010', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19611230'}); |
|
create (n308:Expertise {NodeID:129, ExpertiseID:'6410', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19800303'}); |
|
create (n309:Expertise {NodeID:130, ExpertiseID:'6430', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19800321'}); |
|
create (n310:Expertise {NodeID:131, ExpertiseID:'6450', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19800315'}); |
|
create (n311:Expertise {NodeID:132, ExpertiseID:'6470', EmpID:'0001', SkillLevel:'04', ExpertiseDate:'19800310'}); |
|
create (n318:Expertise {NodeID:137, ExpertiseID:'2010', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19700525'}); |
|
create (n319:Expertise {NodeID:138, ExpertiseID:'2020', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19700525'}); |
|
create (n320:Expertise {NodeID:139, ExpertiseID:'2030', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19700525'}); |
|
create (n321:Expertise {NodeID:140, ExpertiseID:'2040', EmpID:'0003', SkillLevel:'03', ExpertiseDate:'19700525'}); |
|
create (n322:Expertise {NodeID:141, ExpertiseID:'6410', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19800230'}); |
|
create (n323:Expertise {NodeID:142, ExpertiseID:'6430', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19800230'}); |
|
create (n324:Expertise {NodeID:143, ExpertiseID:'6450', EmpID:'0003', SkillLevel:'04', ExpertiseDate:'19800310'}); |
|
create (n331:Expertise {NodeID:148, ExpertiseID:'2040', EmpID:'0004', SkillLevel:'04', ExpertiseDate:'19701010'}); |
|
create (n332:Expertise {NodeID:149, ExpertiseID:'2080', EmpID:'0004', SkillLevel:'03', ExpertiseDate:'19701010'}); |
|
create (n333:Expertise {NodeID:150, ExpertiseID:'6290', EmpID:'0004', SkillLevel:'04', ExpertiseDate:'19731210'}); |
|
create (n334:Expertise {NodeID:151, ExpertiseID:'6340', EmpID:'0004', SkillLevel:'03', ExpertiseDate:'19751210'}); |
|
create (n335:Expertise {NodeID:152, ExpertiseID:'6410', EmpID:'0004', SkillLevel:'04', ExpertiseDate:'19800529'}); |
|
create (n340:Expertise {NodeID:155, ExpertiseID:'1010', EmpID:'0007', SkillLevel:'04', ExpertiseDate:'19740615'}); |
|
create (n345:Expertise {NodeID:158, ExpertiseID:'1030', EmpID:'0011', SkillLevel:'04', ExpertiseDate:'19770610'}); |
|
create (n346:Expertise {NodeID:159, ExpertiseID:'5100', EmpID:'0011', SkillLevel:'04', ExpertiseDate:'19700615'}); |
|
create (n347:Expertise {NodeID:160, ExpertiseID:'5180', EmpID:'0011', SkillLevel:'04', ExpertiseDate:'19700615'}); |
|
create (n352:Expertise {NodeID:163, ExpertiseID:'1040', EmpID:'0013', SkillLevel:'04', ExpertiseDate:'19760115'}); |
|
create (n358:Expertise {NodeID:167, ExpertiseID:'1060', EmpID:'0015', SkillLevel:'04', ExpertiseDate:'19501020'}); |
|
create (n359:Expertise {NodeID:168, ExpertiseID:'7020', EmpID:'0015', SkillLevel:'03', ExpertiseDate:'19501020'}); |
|
create (n360:Expertise {NodeID:169, ExpertiseID:'7070', EmpID:'0015', SkillLevel:'04', ExpertiseDate:'19540615'}); |
|
create (n361:Expertise {NodeID:170, ExpertiseID:'7330', EmpID:'0015', SkillLevel:'04', ExpertiseDate:'19540615'}); |
|
create (n366:Expertise {NodeID:173, ExpertiseID:'2040', EmpID:'0016', SkillLevel:'03', ExpertiseDate:'19760615'}); |
|
create (n367:Expertise {NodeID:174, ExpertiseID:'2010', EmpID:'0016', SkillLevel:'03', ExpertiseDate:'19760615'}); |
|
create (n372:Expertise {NodeID:177, ExpertiseID:'2010', EmpID:'0019', SkillLevel:'03', ExpertiseDate:'19711228'}); |
|
create (n373:Expertise {NodeID:178, ExpertiseID:'2080', EmpID:'0019', SkillLevel:'02', ExpertiseDate:'19711228'}); |
|
create (n374:Expertise {NodeID:179, ExpertiseID:'2020', EmpID:'0019', SkillLevel:'03', ExpertiseDate:'19800115'}); |
|
create (n379:Expertise {NodeID:182, ExpertiseID:'2020', EmpID:'0020', SkillLevel:'04', ExpertiseDate:'19720615'}); |
|
create (n380:Expertise {NodeID:183, ExpertiseID:'2010', EmpID:'0020', SkillLevel:'02', ExpertiseDate:'19730615'}); |
|
create (n381:Expertise {NodeID:184, ExpertiseID:'6290', EmpID:'0020', SkillLevel:'04', ExpertiseDate:'19771105'}); |
|
create (n382:Expertise {NodeID:185, ExpertiseID:'6410', EmpID:'0020', SkillLevel:'02', ExpertiseDate:'19790312'}); |
|
create (n383:Expertise {NodeID:186, ExpertiseID:'6430', EmpID:'0020', SkillLevel:'04', ExpertiseDate:'19780701'}); |
|
create (n384:Expertise {NodeID:187, ExpertiseID:'6450', EmpID:'0020', SkillLevel:'03', ExpertiseDate:'19800325'}); |
|
create (n385:Expertise {NodeID:188, ExpertiseID:'6470', EmpID:'0020', SkillLevel:'04', ExpertiseDate:'19800325'}); |
|
create (n390:Expertise {NodeID:191, ExpertiseID:'2040', EmpID:'0021', SkillLevel:'01', ExpertiseDate:'19760615'}); |
|
create (n391:Expertise {NodeID:192, ExpertiseID:'2010', EmpID:'0021', SkillLevel:'02', ExpertiseDate:'19760615'}); |
|
create (n397:Expertise {NodeID:196, ExpertiseID:'2040', EmpID:'0023', SkillLevel:'03', ExpertiseDate:'19751228'}); |
|
create (n398:Expertise {NodeID:197, ExpertiseID:'2010', EmpID:'0023', SkillLevel:'03', ExpertiseDate:'19780623'}); |
|
create (n399:Expertise {NodeID:198, ExpertiseID:'2030', EmpID:'0023', SkillLevel:'03', ExpertiseDate:'19751228'}); |
|
create (n400:Expertise {NodeID:199, ExpertiseID:'6470', EmpID:'0023', SkillLevel:'02', ExpertiseDate:'19800708'}); |
|
create (n405:Expertise {NodeID:202, ExpertiseID:'2080', EmpID:'0024', SkillLevel:'04', ExpertiseDate:'19720128'}); |
|
create (n406:Expertise {NodeID:203, ExpertiseID:'2010', EmpID:'0024', SkillLevel:'04', ExpertiseDate:'19720128'}); |
|
create (n407:Expertise {NodeID:204, ExpertiseID:'2020', EmpID:'0024', SkillLevel:'02', ExpertiseDate:'19750130'}); |
|
create (n412:Expertise {NodeID:207, ExpertiseID:'2010', EmpID:'0027', SkillLevel:'03', ExpertiseDate:'19801025'}); |
|
create (n417:Expertise {NodeID:210, ExpertiseID:'2010', EmpID:'0028', SkillLevel:'03', ExpertiseDate:'19800222'}); |
|
create (n422:Expertise {NodeID:213, ExpertiseID:'2010', EmpID:'0029', SkillLevel:'03', ExpertiseDate:'19781012'}); |
|
create (n423:Expertise {NodeID:214, ExpertiseID:'2020', EmpID:'0029', SkillLevel:'03', ExpertiseDate:'19781012'}); |
|
create (n432:Expertise {NodeID:219, ExpertiseID:'6290', EmpID:'0031', SkillLevel:'03', ExpertiseDate:'19660424'}); |
|
create (n437:Expertise {NodeID:222, ExpertiseID:'6290', EmpID:'0032', SkillLevel:'04', ExpertiseDate:'19770605'}); |
|
create (n438:Expertise {NodeID:223, ExpertiseID:'6410', EmpID:'0032', SkillLevel:'04', ExpertiseDate:'19801005'}); |
|
create (n443:Expertise {NodeID:226, ExpertiseID:'2010', EmpID:'0035', SkillLevel:'02', ExpertiseDate:'19780505'}); |
|
create (n444:Expertise {NodeID:227, ExpertiseID:'6440', EmpID:'0035', SkillLevel:'02', ExpertiseDate:'19740930'}); |
|
create (n445:Expertise {NodeID:228, ExpertiseID:'3560', EmpID:'0035', SkillLevel:'03', ExpertiseDate:'19770930'}); |
|
create (n450:Expertise {NodeID:231, ExpertiseID:'4250', EmpID:'0045', SkillLevel:'03', ExpertiseDate:'19720615'}); |
|
create (n451:Expertise {NodeID:232, ExpertiseID:'4370', EmpID:'0045', SkillLevel:'02', ExpertiseDate:'19720615'}); |
|
create (n456:Expertise {NodeID:235, ExpertiseID:'4250', EmpID:'0053', SkillLevel:'03', ExpertiseDate:'19801210'}); |
|
create (n461:Expertise {NodeID:238, ExpertiseID:'4490', EmpID:'0067', SkillLevel:'03', ExpertiseDate:'19721228'}); |
|
create (n462:Expertise {NodeID:239, ExpertiseID:'5100', EmpID:'0067', SkillLevel:'03', ExpertiseDate:'19721228'}); |
|
create (n463:Expertise {NodeID:240, ExpertiseID:'5160', EmpID:'0067', SkillLevel:'03', ExpertiseDate:'19730625'}); |
|
create (n464:Expertise {NodeID:241, ExpertiseID:'5180', EmpID:'0067', SkillLevel:'04', ExpertiseDate:'19721228'}); |
|
create (n469:Expertise {NodeID:244, ExpertiseID:'4450', EmpID:'0069', SkillLevel:'03', ExpertiseDate:'19791228'}); |
|
create (n470:Expertise {NodeID:245, ExpertiseID:'5130', EmpID:'0069', SkillLevel:'03', ExpertiseDate:'19791228'}); |
|
create (n471:Expertise {NodeID:246, ExpertiseID:'4410', EmpID:'0069', SkillLevel:'02', ExpertiseDate:'19791228'}); |
|
create (n476:Expertise {NodeID:249, ExpertiseID:'4410', EmpID:'0074', SkillLevel:'03', ExpertiseDate:'19760625'}); |
|
create (n477:Expertise {NodeID:250, ExpertiseID:'4290', EmpID:'0074', SkillLevel:'03', ExpertiseDate:'19760625'}); |
|
create (n482:Expertise {NodeID:253, ExpertiseID:'4370', EmpID:'0081', SkillLevel:'03', ExpertiseDate:'19790505'}); |
|
create (n483:Expertise {NodeID:254, ExpertiseID:'4250', EmpID:'0081', SkillLevel:'03', ExpertiseDate:'19790505'}); |
|
create (n488:Expertise {NodeID:257, ExpertiseID:'1000', EmpID:'0091', SkillLevel:'03', ExpertiseDate:'19750615'}); |
|
create (n489:Expertise {NodeID:258, ExpertiseID:'4430', EmpID:'0091', SkillLevel:'03', ExpertiseDate:'19750615'}); |
|
create (n490:Expertise {NodeID:259, ExpertiseID:'6440', EmpID:'0091', SkillLevel:'03', ExpertiseDate:'19800505'}); |
|
create (n495:Expertise {NodeID:262, ExpertiseID:'5100', EmpID:'0100', SkillLevel:'04', ExpertiseDate:'19650630'}); |
|
create (n496:Expertise {NodeID:263, ExpertiseID:'5180', EmpID:'0100', SkillLevel:'03', ExpertiseDate:'19650630'}); |
|
create (n497:Expertise {NodeID:264, ExpertiseID:'6470', EmpID:'0100', SkillLevel:'03', ExpertiseDate:'19800605'}); |
|
create (n502:Expertise {NodeID:267, ExpertiseID:'5130', EmpID:'0101', SkillLevel:'03', ExpertiseDate:'19770607'}); |
|
create (n503:Expertise {NodeID:268, ExpertiseID:'4490', EmpID:'0101', SkillLevel:'03', ExpertiseDate:'19770607'}); |
|
create (n504:Expertise {NodeID:269, ExpertiseID:'5100', EmpID:'0101', SkillLevel:'03', ExpertiseDate:'19770607'}); |
|
create (n509:Expertise {NodeID:272, ExpertiseID:'5130', EmpID:'0106', SkillLevel:'03', ExpertiseDate:'19790505'}); |
|
create (n510:Expertise {NodeID:273, ExpertiseID:'4450', EmpID:'0106', SkillLevel:'03', ExpertiseDate:'19790505'}); |
|
create (n511:Expertise {NodeID:274, ExpertiseID:'4410', EmpID:'0106', SkillLevel:'03', ExpertiseDate:'19790505'}); |
|
create (n516:Expertise {NodeID:277, ExpertiseID:'3620', EmpID:'0119', SkillLevel:'04', ExpertiseDate:'19650625'}); |
|
create (n517:Expertise {NodeID:278, ExpertiseID:'3630', EmpID:'0119', SkillLevel:'04', ExpertiseDate:'19650625'}); |
|
create (n523:Expertise {NodeID:282, ExpertiseID:'3710', EmpID:'0120', SkillLevel:'04', ExpertiseDate:'19780625'}); |
|
create (n524:Expertise {NodeID:283, ExpertiseID:'3610', EmpID:'0120', SkillLevel:'03', ExpertiseDate:'19780625'}); |
|
create (n525:Expertise {NodeID:284, ExpertiseID:'7220', EmpID:'0120', SkillLevel:'04', ExpertiseDate:'19800422'}); |
|
create (n530:Expertise {NodeID:287, ExpertiseID:'3670', EmpID:'0127', SkillLevel:'04', ExpertiseDate:'19790625'}); |
|
create (n531:Expertise {NodeID:288, ExpertiseID:'3550', EmpID:'0127', SkillLevel:'03', ExpertiseDate:'19790625'}); |
|
create (n546:Expertise {NodeID:297, ExpertiseID:'7020', EmpID:'0301', SkillLevel:'04', ExpertiseDate:'19600925'}); |
|
create (n547:Expertise {NodeID:298, ExpertiseID:'7110', EmpID:'0301', SkillLevel:'04', ExpertiseDate:'19600925'}); |
|
create (n548:Expertise {NodeID:299, ExpertiseID:'7120', EmpID:'0301', SkillLevel:'03', ExpertiseDate:'19611113'}); |
|
create (n554:Expertise {NodeID:303, ExpertiseID:'7140', EmpID:'0321', SkillLevel:'04', ExpertiseDate:'19650505'}); |
|
create (n555:Expertise {NodeID:304, ExpertiseID:'1060', EmpID:'0321', SkillLevel:'03', ExpertiseDate:'19751215'}); |
|
create (n560:Expertise {NodeID:307, ExpertiseID:'7410', EmpID:'0329', SkillLevel:'03', ExpertiseDate:'19600606'}); |
|
create (n565:Expertise {NodeID:310, ExpertiseID:'5360', EmpID:'0334', SkillLevel:'04', ExpertiseDate:'19660919'}); |
|
create (n566:Expertise {NodeID:311, ExpertiseID:'7020', EmpID:'0334', SkillLevel:'04', ExpertiseDate:'19660919'}); |
|
create (n571:Expertise {NodeID:314, ExpertiseID:'7010', EmpID:'0341', SkillLevel:'04', ExpertiseDate:'19710707'}); |
|
create (n572:Expertise {NodeID:315, ExpertiseID:'7080', EmpID:'0341', SkillLevel:'04', ExpertiseDate:'19710707'}); |
|
create (n573:Expertise {NodeID:316, ExpertiseID:'7230', EmpID:'0341', SkillLevel:'03', ExpertiseDate:'19710707'}); |
|
create (n578:Expertise {NodeID:319, ExpertiseID:'7080', EmpID:'0349', SkillLevel:'03', ExpertiseDate:'19721111'}); |
|
create (n579:Expertise {NodeID:320, ExpertiseID:'7230', EmpID:'0349', SkillLevel:'04', ExpertiseDate:'19770628'}); |
|
create (n580:Expertise {NodeID:321, ExpertiseID:'7250', EmpID:'0349', SkillLevel:'04', ExpertiseDate:'19770628'}); |
|
create (n581:Expertise {NodeID:322, ExpertiseID:'7260', EmpID:'0349', SkillLevel:'03', ExpertiseDate:'19790901'}); |
|
create (n582:Expertise {NodeID:323, ExpertiseID:'1060', EmpID:'0349', SkillLevel:'03', ExpertiseDate:'19801111'}); |
|
create (n587:Expertise {NodeID:326, ExpertiseID:'7230', EmpID:'0355', SkillLevel:'04', ExpertiseDate:'19780606'}); |
|
create (n588:Expertise {NodeID:327, ExpertiseID:'7010', EmpID:'0355', SkillLevel:'03', ExpertiseDate:'19780606'}); |
|
create (n593:Expertise {NodeID:330, ExpertiseID:'7140', EmpID:'0366', SkillLevel:'03', ExpertiseDate:'19751010'}); |
|
create (n594:Expertise {NodeID:331, ExpertiseID:'7250', EmpID:'0366', SkillLevel:'03', ExpertiseDate:'19751010'}); |
|
create (n599:Expertise {NodeID:334, ExpertiseID:'7140', EmpID:'0371', SkillLevel:'04', ExpertiseDate:'19651010'}); |
|
create (n600:Expertise {NodeID:335, ExpertiseID:'7210', EmpID:'0371', SkillLevel:'04', ExpertiseDate:'19751010'}); |
|
create (n601:Expertise {NodeID:336, ExpertiseID:'7220', EmpID:'0371', SkillLevel:'03', ExpertiseDate:'19751010'}); |
|
create (n606:Expertise {NodeID:339, ExpertiseID:'7310', EmpID:'0458', SkillLevel:'04', ExpertiseDate:'19540404'}); |
|
create (n607:Expertise {NodeID:340, ExpertiseID:'7500', EmpID:'0458', SkillLevel:'04', ExpertiseDate:'19540404'}); |
|
create (n608:Expertise {NodeID:341, ExpertiseID:'7050', EmpID:'0458', SkillLevel:'04', ExpertiseDate:'19590525'}); |
|
create (n613:Expertise {NodeID:344, ExpertiseID:'7080', EmpID:'0467', SkillLevel:'04', ExpertiseDate:'19570606'}); |
|
create (n619:Expertise {NodeID:348, ExpertiseID:'1060', EmpID:'0471', SkillLevel:'04', ExpertiseDate:'19800831'}); |
|
create (n620:Expertise {NodeID:349, ExpertiseID:'7310', EmpID:'0471', SkillLevel:'04', ExpertiseDate:'19781222'}); |
|
create (n621:Expertise {NodeID:350, ExpertiseID:'7070', EmpID:'0471', SkillLevel:'03', ExpertiseDate:'19760606'}); |
|
create (n622:Expertise {NodeID:351, ExpertiseID:'7090', EmpID:'0471', SkillLevel:'03', ExpertiseDate:'19760606'}); |
|
create (n623:Expertise {NodeID:352, ExpertiseID:'7050', EmpID:'0471', SkillLevel:'04', ExpertiseDate:'19750606'}); |
|
create (n624:Expertise {NodeID:353, ExpertiseID:'7040', EmpID:'0471', SkillLevel:'04', ExpertiseDate:'19750606'}); |
|
create (n625:Expertise {NodeID:354, ExpertiseID:'7080', EmpID:'0471', SkillLevel:'04', ExpertiseDate:'19750606'}); |
|
create (n630:Expertise {NodeID:357, ExpertiseID:'1000', EmpID:'0472', SkillLevel:'03', ExpertiseDate:'19750625'}); |
|
create (n631:Expertise {NodeID:358, ExpertiseID:'9170', EmpID:'0472', SkillLevel:'02', ExpertiseDate:'19740606'}); |
|
create (n636:Expertise {NodeID:361, ExpertiseID:'7240', EmpID:'0479', SkillLevel:'04', ExpertiseDate:'19690909'}); |
|
create (n637:Expertise {NodeID:362, ExpertiseID:'7250', EmpID:'0479', SkillLevel:'04', ExpertiseDate:'19690909'}); |
|
create (n638:Expertise {NodeID:363, ExpertiseID:'7260', EmpID:'0479', SkillLevel:'04', ExpertiseDate:'19690909'}); |
|
create (n647:Expertise {NodeID:368, ExpertiseID:'7310', EmpID:'0457', SkillLevel:'04', ExpertiseDate:'19580808'}); |
|
create (n652:Expertise {NodeID:371, ExpertiseID:'7090', EmpID:'0466', SkillLevel:'02', ExpertiseDate:'19791010'}); |
|
create (n653:Expertise {NodeID:372, ExpertiseID:'7040', EmpID:'0466', SkillLevel:'02', ExpertiseDate:'19791010'}); |
|
create (n654:Expertise {NodeID:373, ExpertiseID:'7050', EmpID:'0466', SkillLevel:'02', ExpertiseDate:'19800505'}); |
|
create (n655:Expertise {NodeID:374, ExpertiseID:'7310', EmpID:'0466', SkillLevel:'02', ExpertiseDate:'19791010'}); |
|
create (n656:Expertise {NodeID:375, ExpertiseID:'7330', EmpID:'0466', SkillLevel:'04', ExpertiseDate:'19791010'}); |
|
create (n661:Expertise {NodeID:378, ExpertiseID:'7070', EmpID:'0469', SkillLevel:'04', ExpertiseDate:'19651225'}); |
|
create (n662:Expertise {NodeID:379, ExpertiseID:'7090', EmpID:'0469', SkillLevel:'04', ExpertiseDate:'19651212'}); |
|
create (n663:Expertise {NodeID:380, ExpertiseID:'7050', EmpID:'0469', SkillLevel:'04', ExpertiseDate:'19661212'}); |
|
create (n664:Expertise {NodeID:381, ExpertiseID:'7040', EmpID:'0469', SkillLevel:'04', ExpertiseDate:'19661212'}); |
|
create (n669:Expertise {NodeID:384, ExpertiseID:'4410', EmpID:'0048', SkillLevel:'03', ExpertiseDate:'19800615'}); |
|
create (n670:Expertise {NodeID:385, ExpertiseID:'4420', EmpID:'0048', SkillLevel:'03', ExpertiseDate:'19800415'}); |
|
create (n671:Expertise {NodeID:386, ExpertiseID:'4370', EmpID:'0048', SkillLevel:'03', ExpertiseDate:'19800615'}); |
|
create (n676:Expertise {NodeID:389, ExpertiseID:'4410', EmpID:'0049', SkillLevel:'04', ExpertiseDate:'19730615'}); |
|
create (n677:Expertise {NodeID:390, ExpertiseID:'4370', EmpID:'0049', SkillLevel:'04', ExpertiseDate:'19730615'}); |
|
create (n678:Expertise {NodeID:391, ExpertiseID:'4290', EmpID:'0049', SkillLevel:'04', ExpertiseDate:'19740615'}); |
|
create (n679:Expertise {NodeID:392, ExpertiseID:'4420', EmpID:'0049', SkillLevel:'03', ExpertiseDate:'19730615'}); |
|
create (n684:Expertise {NodeID:395, ExpertiseID:'4410', EmpID:'0051', SkillLevel:'04', ExpertiseDate:'19670625'}); |
|
create (n685:Expertise {NodeID:396, ExpertiseID:'4420', EmpID:'0051', SkillLevel:'04', ExpertiseDate:'19670625'}); |
|
create (n686:Expertise {NodeID:397, ExpertiseID:'6440', EmpID:'0051', SkillLevel:'04', ExpertiseDate:'19800405'}); |
|
|
|
//Empositions |
|
create (n303:Emposition {NodeID:125, EmpositionCode:'3001', EmpID:'0001', StartDate:'19750223', FinishDate:'19790630', SalaryGrade:'72', SalaryAmount:'76000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n304:Emposition {NodeID:126, EmpositionCode:'9003', EmpID:'0001', StartDate:'19790701', FinishDate:'00000000', SalaryGrade:'81', SalaryAmount:'80000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n315:Emposition {NodeID:134, EmpositionCode:'3031', EmpID:'0003', StartDate:'19770121', FinishDate:'19790615', SalaryGrade:'44', SalaryAmount:'45000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n316:Emposition {NodeID:135, EmpositionCode:'3011', EmpID:'0003', StartDate:'19790616', FinishDate:'19811111', SalaryGrade:'63', SalaryAmount:'55000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n317:Emposition {NodeID:136, EmpositionCode:'3001', EmpID:'0003', StartDate:'19820101', FinishDate:'00000000', SalaryGrade:'71', SalaryAmount:'65000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n328:Emposition {NodeID:145, EmpositionCode:'3003', EmpID:'0004', StartDate:'19770514', FinishDate:'19791114', SalaryGrade:'71', SalaryAmount:'60000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n329:Emposition {NodeID:146, EmpositionCode:'3003', EmpID:'0004', StartDate:'19791115', FinishDate:'19820513', SalaryGrade:'71', SalaryAmount:'70000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n330:Emposition {NodeID:147, EmpositionCode:'3003', EmpID:'0004', StartDate:'19820514', FinishDate:'00000000', SalaryGrade:'71', SalaryAmount:'75000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n339:Emposition {NodeID:154, EmpositionCode:'4001', EmpID:'0007', StartDate:'19780430', FinishDate:'00000000', SalaryGrade:'72', SalaryAmount:'80000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n344:Emposition {NodeID:157, EmpositionCode:'2001', EmpID:'0011', StartDate:'19800929', FinishDate:'00000000', SalaryGrade:'72', SalaryAmount:'82000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n351:Emposition {NodeID:162, EmpositionCode:'1001', EmpID:'0013', StartDate:'19810102', FinishDate:'00000000', SalaryGrade:'72', SalaryAmount:'80000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n356:Emposition {NodeID:165, EmpositionCode:'5001', EmpID:'0015', StartDate:'19780102', FinishDate:'19800101', SalaryGrade:'71', SalaryAmount:'75000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n357:Emposition {NodeID:166, EmpositionCode:'5001', EmpID:'0015', StartDate:'19800102', FinishDate:'00000000', SalaryGrade:'72', SalaryAmount:'85000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n365:Emposition {NodeID:172, EmpositionCode:'3023', EmpID:'0016', StartDate:'19780106', FinishDate:'00000000', SalaryGrade:'52', SalaryAmount:'43000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n371:Emposition {NodeID:176, EmpositionCode:'3025', EmpID:'0019', StartDate:'19820929', FinishDate:'00000000', SalaryGrade:'43', SalaryAmount:'37000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n378:Emposition {NodeID:181, EmpositionCode:'3011', EmpID:'0020', StartDate:'19811111', FinishDate:'00000000', SalaryGrade:'63', SalaryAmount:'55000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n389:Emposition {NodeID:190, EmpositionCode:'3027', EmpID:'0021', StartDate:'19801221', FinishDate:'00000000', SalaryGrade:'21', SalaryAmount:'20000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n395:Emposition {NodeID:194, EmpositionCode:'3027', EmpID:'0023', StartDate:'19780504', FinishDate:'19790504', SalaryGrade:'43', SalaryAmount:'38000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n396:Emposition {NodeID:195, EmpositionCode:'3025', EmpID:'0023', StartDate:'19790505', FinishDate:'00000000', SalaryGrade:'44', SalaryAmount:'42500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n404:Emposition {NodeID:201, EmpositionCode:'3025', EmpID:'0024', StartDate:'19760808', FinishDate:'00000000', SalaryGrade:'42', SalaryAmount:'33000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n411:Emposition {NodeID:206, EmpositionCode:'3025', EmpID:'0027', StartDate:'19810909', FinishDate:'00000000', SalaryGrade:'42', SalaryAmount:'33000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n416:Emposition {NodeID:209, EmpositionCode:'3025', EmpID:'0028', StartDate:'19800527', FinishDate:'00000000', SalaryGrade:'42', SalaryAmount:'34500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n421:Emposition {NodeID:212, EmpositionCode:'3025', EmpID:'0029', StartDate:'19811010', FinishDate:'00000000', SalaryGrade:'42', SalaryAmount:'33000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n427:Emposition {NodeID:216, EmpositionCode:'9001', EmpID:'0030', StartDate:'19731121', FinishDate:'00000000', SalaryGrade:'93', SalaryAmount:'40000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n431:Emposition {NodeID:218, EmpositionCode:'3029', EmpID:'0031', StartDate:'19810429', FinishDate:'00000000', SalaryGrade:'21', SalaryAmount:'18500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n436:Emposition {NodeID:221, EmpositionCode:'3029', EmpID:'0032', StartDate:'19790909', FinishDate:'00000000', SalaryGrade:'22', SalaryAmount:'22500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n442:Emposition {NodeID:225, EmpositionCode:'3031', EmpID:'0035', StartDate:'19800909', FinishDate:'00000000', SalaryGrade:'43', SalaryAmount:'37500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n449:Emposition {NodeID:230, EmpositionCode:'3051', EmpID:'0045', StartDate:'19800414', FinishDate:'00000000', SalaryGrade:'13', SalaryAmount:'14750', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n455:Emposition {NodeID:234, EmpositionCode:'3051', EmpID:'0053', StartDate:'19810615', FinishDate:'00000000', SalaryGrade:'12', SalaryAmount:'14000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n460:Emposition {NodeID:237, EmpositionCode:'2023', EmpID:'0067', StartDate:'19780919', FinishDate:'00000000', SalaryGrade:'62', SalaryAmount:'45000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n468:Emposition {NodeID:243, EmpositionCode:'2055', EmpID:'0069', StartDate:'19800505', FinishDate:'00000000', SalaryGrade:'13', SalaryAmount:'15000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n475:Emposition {NodeID:248, EmpositionCode:'3051', EmpID:'0074', StartDate:'19810404', FinishDate:'00000000', SalaryGrade:'12', SalaryAmount:'14000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n481:Emposition {NodeID:252, EmpositionCode:'1051', EmpID:'0081', StartDate:'19810919', FinishDate:'00000000', SalaryGrade:'11', SalaryAmount:'13000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n487:Emposition {NodeID:256, EmpositionCode:'1023', EmpID:'0091', StartDate:'19801010', FinishDate:'00000000', SalaryGrade:'43', SalaryAmount:'39000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n494:Emposition {NodeID:261, EmpositionCode:'2025', EmpID:'0100', StartDate:'19770907', FinishDate:'00000000', SalaryGrade:'62', SalaryAmount:'44000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n501:Emposition {NodeID:266, EmpositionCode:'2051', EmpID:'0101', StartDate:'19800506', FinishDate:'00000000', SalaryGrade:'12', SalaryAmount:'14000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n508:Emposition {NodeID:271, EmpositionCode:'2053', EmpID:'0106', StartDate:'19800816', FinishDate:'00000000', SalaryGrade:'12', SalaryAmount:'14500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n515:Emposition {NodeID:276, EmpositionCode:'4023', EmpID:'0119', StartDate:'19771214', FinishDate:'00000000', SalaryGrade:'33', SalaryAmount:'38500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n521:Emposition {NodeID:280, EmpositionCode:'4053', EmpID:'0120', StartDate:'19790908', FinishDate:'19800606', SalaryGrade:'21', SalaryAmount:'17000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n522:Emposition {NodeID:281, EmpositionCode:'4051', EmpID:'0120', StartDate:'19800607', FinishDate:'00000000', SalaryGrade:'21', SalaryAmount:'18000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n529:Emposition {NodeID:286, EmpositionCode:'4053', EmpID:'0127', StartDate:'19800607', FinishDate:'00000000', SalaryGrade:'21', SalaryAmount:'18000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n535:Emposition {NodeID:290, EmpositionCode:'4025', EmpID:'0149', StartDate:'19770908', FinishDate:'00000000', SalaryGrade:'33', SalaryAmount:'39000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n539:Emposition {NodeID:292, EmpositionCode:'4021', EmpID:'0158', StartDate:'19770707', FinishDate:'00000000', SalaryGrade:'42', SalaryAmount:'34000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n543:Emposition {NodeID:294, EmpositionCode:'5021', EmpID:'0301', StartDate:'19750203', FinishDate:'19770202', SalaryGrade:'52', SalaryAmount:'39000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n544:Emposition {NodeID:295, EmpositionCode:'5021', EmpID:'0301', StartDate:'19770203', FinishDate:'19800202', SalaryGrade:'52', SalaryAmount:'45000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n545:Emposition {NodeID:296, EmpositionCode:'5021', EmpID:'0301', StartDate:'19800203', FinishDate:'00000000', SalaryGrade:'53', SalaryAmount:'54500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n552:Emposition {NodeID:301, EmpositionCode:'5037', EmpID:'0321', StartDate:'19780103', FinishDate:'19811009', SalaryGrade:'53', SalaryAmount:'55000', BonusPercent:'00', CommissionPercent:'07', OvertimeRate:'00'}); |
|
create (n553:Emposition {NodeID:302, EmpositionCode:'5005', EmpID:'0321', StartDate:'19811010', FinishDate:'00000000', SalaryGrade:'71', SalaryAmount:'72000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n559:Emposition {NodeID:306, EmpositionCode:'5031', EmpID:'0329', StartDate:'19790616', FinishDate:'00000000', SalaryGrade:'52', SalaryAmount:'45000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n564:Emposition {NodeID:309, EmpositionCode:'5023', EmpID:'0334', StartDate:'19790617', FinishDate:'00000000', SalaryGrade:'43', SalaryAmount:'37500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n570:Emposition {NodeID:313, EmpositionCode:'5025', EmpID:'0341', StartDate:'19801114', FinishDate:'00000000', SalaryGrade:'51', SalaryAmount:'36000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n577:Emposition {NodeID:318, EmpositionCode:'5003', EmpID:'0349', StartDate:'19791111', FinishDate:'00000000', SalaryGrade:'72', SalaryAmount:'80000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n586:Emposition {NodeID:325, EmpositionCode:'5033', EmpID:'0355', StartDate:'19810505', FinishDate:'00000000', SalaryGrade:'51', SalaryAmount:'33000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n592:Emposition {NodeID:329, EmpositionCode:'5037', EmpID:'0366', StartDate:'19811010', FinishDate:'00000000', SalaryGrade:'51', SalaryAmount:'33500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n598:Emposition {NodeID:333, EmpositionCode:'5039', EmpID:'0371', StartDate:'19770304', FinishDate:'00000000', SalaryGrade:'53', SalaryAmount:'52750', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n605:Emposition {NodeID:338, EmpositionCode:'5029', EmpID:'0458', StartDate:'19780607', FinishDate:'00000000', SalaryGrade:'53', SalaryAmount:'47000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n612:Emposition {NodeID:343, EmpositionCode:'5027', EmpID:'0467', StartDate:'19790602', FinishDate:'00000000', SalaryGrade:'51', SalaryAmount:'38000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n617:Emposition {NodeID:346, EmpositionCode:'5001', EmpID:'0471', StartDate:'19780907', FinishDate:'19811231', SalaryGrade:'72', SalaryAmount:'90000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n618:Emposition {NodeID:347, EmpositionCode:'9007', EmpID:'0471', StartDate:'19820101', FinishDate:'00000000', SalaryGrade:'82', SalaryAmount:'00000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n629:Emposition {NodeID:356, EmpositionCode:'9005', EmpID:'0472', StartDate:'19790716', FinishDate:'00000000', SalaryGrade:'81', SalaryAmount:'90000', BonusPercent:'00', CommissionPercent:'01', OvertimeRate:'00'}); |
|
create (n635:Emposition {NodeID:360, EmpositionCode:'5035', EmpID:'0479', StartDate:'19791102', FinishDate:'00000000', SalaryGrade:'43', SalaryAmount:'38000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n642:Emposition {NodeID:365, EmpositionCode:'4025', EmpID:'0476', StartDate:'19760223', FinishDate:'19770908', SalaryGrade:'33', SalaryAmount:'37000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n646:Emposition {NodeID:367, EmpositionCode:'5029', EmpID:'0457', StartDate:'19771201', FinishDate:'19780601', SalaryGrade:'53', SalaryAmount:'46000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n651:Emposition {NodeID:370, EmpositionCode:'5025', EmpID:'0466', StartDate:'19780615', FinishDate:'19801001', SalaryGrade:'51', SalaryAmount:'33500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n660:Emposition {NodeID:377, EmpositionCode:'5033', EmpID:'0469', StartDate:'19800605', FinishDate:'19810624', SalaryGrade:'51', SalaryAmount:'31000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'70'}); |
|
create (n668:Emposition {NodeID:383, EmpositionCode:'3051', EmpID:'0048', StartDate:'19820526', FinishDate:'19821103', SalaryGrade:'11', SalaryAmount:'13000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n675:Emposition {NodeID:388, EmpositionCode:'3029', EmpID:'0049', StartDate:'19790929', FinishDate:'19810401', SalaryGrade:'21', SalaryAmount:'20000', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
create (n683:Emposition {NodeID:394, EmpositionCode:'1051', EmpID:'0051', StartDate:'19770323', FinishDate:'19810831', SalaryGrade:'11', SalaryAmount:'13500', BonusPercent:'00', CommissionPercent:'00', OvertimeRate:'40'}); |
|
|
|
//InsurancePlan |
|
create (n688:InsurancePlan {NodeID:398, InsPlanCode:'001', InsCoName:'PROVIDENTIAL LIFE INSURANCE', InsCoStreet:'GIBRALTAR AVE', InsCoCity:'LISBON', InsCoState:'VA', InsCoZip1:'23097', InsCoZip2:'', InsCoPhone:'7035486302', GroupNumber:'347815', PlanDescription:'00000000100000000000'}); |
|
create (n691:InsurancePlan {NodeID:399, InsPlanCode:'002', InsCoName:'HOMOSTASIS HEALTH MAINTENANCE PROGRAM', InsCoStreet:'57 GOODWILL BLVD', InsCoCity:'WELLWOOD', InsCoState:'MA', InsCoZip1:'01988', InsCoZip2:'', InsCoPhone:'6173538600', GroupNumber:'952867', PlanDescription:'00000000000000009000'}); |
|
create (n694:InsurancePlan {NodeID:400, InsPlanCode:'003', InsCoName:'HOLISTIC GROUP HEALTH ASSOCIATION', InsCoStreet:'2 ELYSIAN FIELDS', InsCoCity:'WINNETKA', InsCoState:'IL', InsCoZip1:'06060', InsCoZip2:'', InsCoPhone:'9413862343', GroupNumber:'329471', PlanDescription:'00020000000000000002'}); |
|
create (n697:InsurancePlan {NodeID:401, InsPlanCode:'004', InsCoName:'TEETH R US', InsCoStreet:'6 TORTURE ST', InsCoCity:'MEDFORD', InsCoState:'MA', InsCoZip1:'02032', InsCoZip2:'', InsCoPhone:'6174445362', GroupNumber:'545598', PlanDescription:'00005000000000000050'}); |
|
|
|
//Jobs |
|
create (n93:Job {NodeID:83, JobID:'9001', JobTitle:'PRESIDENT', JobDescription:'FORMULATES CORPORATE POLICY AND REPRESENTS COMPANY IN THE BUSINESS COMMUNITY. MANY FRINGE BENEFITS.', JobRequirements:'INSIDE-OUT KNOWLEDGE OF COMPANY; UNDERSTANDING OF COMPANY GOALS; PREVIOUS EXECUTIVE EXPERIENCE.', JobMinSalary:'1750', JobMaxSalary:'3000', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n98:Job {NodeID:84, JobID:'9003', JobTitle:'DIR OPERATIONS', JobDescription:'OVERSEES ALL COMPANY OPERATIONS; ENFORCES CORPORATE POLICY REPORTS DIRECTLY TO PRESIDENT.', JobRequirements:'10 YEARS SENIOR MANAGEMENT EXPERIENCE; MBA FROM REPUTABLE INSTITUTION; PROVEN ABILITY.', JobMinSalary:'750', JobMaxSalary:'1250', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n103:Job {NodeID:85, JobID:'3001', JobTitle:'MGR INTERNL SOFTWARE', JobDescription:'RESPONSIBLE FOR DEVELOPMENT AND MAINTENANCE OF SOFTWARE USED INHOUSE.', JobRequirements:'15 YEARS SOFTWARE DEVELOPMENT; PROVEN PLANNING AND MGMT ABILITY; AT LEAST 7 YEARS MANAGEMENT EXPERIENCE.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n108:Job {NodeID:86, JobID:'3003', JobTitle:'MGR COMPUTER OPS', JobDescription:'RESPONSIBLE FOR INHOUSE COMPUTER OPERATIONS; SUPPLIES USER COMMUNITY WITH RELIABLE, QUALITY COMPUTER SERVICE.', JobRequirements:'10 YEARS IN COMPUTER OPERATIONS; AT LEAST 5 IN SUPERVISORY POSITION; PROVEN SUPERVISORY ABILITY A MUST.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n113:Job {NodeID:87, JobID:'9005', JobTitle:'DIR CORP CONFUSION', JobDescription:'PROLIFERATES STANDARDS (PREFERABLY CONFLICTING); PRODUCES MASS QUANTITIES OF PAPERWORK.', JobRequirements:'PHD IN INDUSTRIAL PSYCHOLOGY, BOMBASTIC STYLE, NO EXPERIENCE NECESSARY.', JobMinSalary:'750', JobMaxSalary:'1250', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n118:Job {NodeID:88, JobID:'1001', JobTitle:'MGR PERSONNEL', JobDescription:'RESPONSIBLE FOR EMPLOYEE RECRUITING, BENEFITS, TRAINING, AND MORALE.', JobRequirements:'MBA WITH SPECIALIZATION IN PERSONNEL MANAGEMENT, AT LEAST 5 YEARS EXPERIENCE AS PERSONNEL MANAGER.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n123:Job {NodeID:89, JobID:'1023', JobTitle:'RECRUITER/INTERVWR', JobDescription:'RECRUITS AND INTERVIEWS POTENTIAL EMPLOYEES, PARTICULARLY FOR WEATHER PRODUCTION POSITIONS.', JobRequirements:'3-4 YEARS EXPERIENCE IN PERSONNEL, GOOD "PEOPLE" SKILLS. POSITION INVOLVES SOME TRAVEL.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'002', NrOpen:'000'}); |
|
create (n128:Job {NodeID:90, JobID:'1051', JobTitle:'PERSONNEL CLERK', JobDescription:'KEEPS EMPLOYEE RECORDS, PREPARES ORIENTATION MATERIAL, TRACKS INSURANCE CLAIMS.', JobRequirements:'TYPING, FILING, ORGANIZATIONAL SKILLS; PREVIOUS OFFICE EXPERIENCE.', JobMinSalary:'120', JobMaxSalary:'160', SalaryGrades:'00000000', NrOfPositions:'002', NrOpen:'001'}); |
|
create (n133:Job {NodeID:91, JobID:'2001', JobTitle:'MGR ACCTNG/PAYROLL', JobDescription:'SUPERVISES ALL FINANCIAL ACCOUNTING AND PAYROLL FUNCTIONS, INCLUDING GOVERNMENT REPORTING.', JobRequirements:'MBA WITH SPECIALIZATION IN ACCOUNTING OR FINANCE. AT LEAST 7 YEARS EXPERIENCE IN SIMILAR POSITION.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n138:Job {NodeID:92, JobID:'2023', JobTitle:'ACCOUNTANT', JobDescription:'KEEPS ALL FINANCIAL RECORDS, PREPARES TAXES AND ANNUAL REPORTS, ENTERTAINS AUDITORS.', JobRequirements:'CPA AND 5 YEARS EXPERIENCE.', JobMinSalary:'350', JobMaxSalary:'600', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n143:Job {NodeID:93, JobID:'2025', JobTitle:'FINANCIAL ANALYST', JobDescription:'ADVISES PRESIDENT ON COMPANY INVESTMENTS AND MARKET POSITIONING.', JobRequirements:'MBA WITH SPECIALIZATION IN FINANCIAL MANAGEMENT, PROVEN ABILITY IN INVESTMENT ANALYSIS.', JobMinSalary:'350', JobMaxSalary:'600', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n148:Job {NodeID:94, JobID:'2051', JobTitle:'AP CLERK', JobDescription:'PROCESSES ALL OUTGOING PAYMENTS FOR MATERIALS AND SERVICES.', JobRequirements:'2 YEARS EXPERIENCE IN BILLING.', JobMinSalary:'120', JobMaxSalary:'160', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n153:Job {NodeID:95, JobID:'2053', JobTitle:'AR CLERK', JobDescription:'PROCESSES ALL PAYMENTS DUE AND PAYMENTS RECEIVED.', JobRequirements:'2 YEARS EXPERIENCE IN BILLING.', JobMinSalary:'120', JobMaxSalary:'160', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n158:Job {NodeID:96, JobID:'2055', JobTitle:'PAYROLL CLERK', JobDescription:'PROCESSES SEMI-MONTHLY PAYROLL, COORDINATES WITH PERSONNEL DEPT REGARDING TAXES, BENEFITS, AND REPORTING.', JobRequirements:'2 YEARS EXPERIENCE IN BILLING OR PAYROLL.', JobMinSalary:'120', JobMaxSalary:'160', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n163:Job {NodeID:97, JobID:'3023', JobTitle:'SYSTEMS PROGRAMMER', JobDescription:'CONFIGURES OPERATING ENVIRONMENT, MAINTAINS SYSTEM SOFTWARE, INSTALLS NEW SOFTWARE RELEASES.', JobRequirements:'7 YEARS SYSTEMS PROGRAMMING EXPERIENCE, PREFERABLY IN IBM INSTALLATIONS.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n168:Job {NodeID:98, JobID:'3025', JobTitle:'PROGRAMMER/ANALYST', JobDescription:'DESIGNS, CODES, AND MAINTAINS BATCH AND ONLINE PROGRAMS FOR VARIOUS APPLICATIONS.', JobRequirements:'3-5 YEARS PROGRAMMING IN IBM ENVIRONMENT. COBOL, ASSEMBLER, JCL, DATABASE.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'007', NrOpen:'001'}); |
|
create (n173:Job {NodeID:99, JobID:'3027', JobTitle:'PROGRAMMER TRAINEE', JobDescription:'ENTRY-LEVEL PROGRAMMING, ASSISTING EXPERIENCED PROGRAMMER/ANALYSTS.', JobRequirements:'COLLEGE OR VOCATIONAL DEGREE IN CS, MATH, OR RELATED FIELD WITH SUBSTANTIAL PROGRAMMING COURSEWORK.', JobMinSalary:'170', JobMaxSalary:'240', SalaryGrades:'00000000', NrOfPositions:'002', NrOpen:'001'}); |
|
create (n178:Job {NodeID:100, JobID:'3029', JobTitle:'COMPUTER OPERATOR', JobDescription:'OPERATES MAINFRAME, SERVICES USER TERMINALS AND PRINTERS, MAINTAINS TAPE LIBRARY.', JobRequirements:'2 YEARS EXPERIENCE WITH IBM EQUIPMENT. WILLINGNESS TO WORK SHIFTS.', JobMinSalary:'170', JobMaxSalary:'240', SalaryGrades:'00000000', NrOfPositions:'002', NrOpen:'000'}); |
|
create (n183:Job {NodeID:101, JobID:'3051', JobTitle:'DATA ENTRY CLERK', JobDescription:'ENTER ALL TYPES OF DATA INTO CRT.', JobRequirements:'1-2 YEARS EXPERIENCE, FAST AND ACCURATE WITH NUMBERS.', JobMinSalary:'120', JobMaxSalary:'160', SalaryGrades:'00000000', NrOfPositions:'004', NrOpen:'001'}); |
|
create (n188:Job {NodeID:102, JobID:'3031', JobTitle:'DOCUMENTATION SPEC', JobDescription:'CREATES AND MAINTAINS DOCUMENTATION FOR ALL AUTOMATED PROCEDURES.', JobRequirements:'COLLEGE DEGREE IN ANYTHING, GOOD WRITING SKILLS, FAMILIARITY WITH DP, ESP. JCL AND DATA DICTIONARY.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n193:Job {NodeID:103, JobID:'3011', JobTitle:'DATABASE ADMIN.', JobDescription:'RESPONSIBLE FOR ALL ASPECTS OF DATABASE AND DATA DICTIONARY DESIGN AND USE.', JobRequirements:'5-7 YEARS EXPERIENCE AS DBA, INTIMATE KNOWLEDGE OF IDMS/IDD.', JobMinSalary:'350', JobMaxSalary:'600', SalaryGrades:'0', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n198:Job {NodeID:104, JobID:'4001', JobTitle:'MGR PUBLIC RELATIONS', JobDescription:'KEEPS PUBLIC INFORMED OF PRESENT AND FUTURE CLIMACTIC CONDITIONS, KEEPS THE MEDIA HAPPY.', JobRequirements:'4-5 YEARS PR AND MANAGEMENT EXPERIENCE, AMIABLE MANNER, QUICK WITS. MUST EXCEL AT DOUBLETALK.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n203:Job {NodeID:105, JobID:'4021', JobTitle:'SPORTS CONSULTANT', JobDescription:'KEEPS ABREAST OF SPORTS EVENTS WORLDWIDE AND HOW THEY ARE AFFECTED BY THE WEATHER.', JobRequirements:'LIFELONG MANIA FOR SPORTS OF ALL TYPES, PENCHANT FOR HANGING OUT WITH JOCKS.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n208:Job {NodeID:106, JobID:'4023', JobTitle:'PHOTOGRAPHER', JobDescription:'TAKES WEATHER PICTURES FOR DOCUMENTARY, HUMAN INTEREST, AND PROPAGANDA PURPOSES.', JobRequirements:'MUST BE QUICK AND INNOVATIVE, GOOD WITH BOTH BLACK AND WHITE AND COLOR.', JobMinSalary:'250', JobMaxSalary:'400', SalaryGrades:'00000000', NrOfPositions:'002', NrOpen:'001'}); |
|
create (n213:Job {NodeID:107, JobID:'4025', JobTitle:'PR WRITER', JobDescription:'WRITES ADS, PUBLIC SERVICE ANNOUNCEMENTS, FORECASTS, ANECDOTES, JINGLES, ETC.', JobRequirements:'GOOD WRITING SKILLS, IMAGINATION, ENDLESS SUPPLY OF WEATHER-RELATED ADJECTIVES.', JobMinSalary:'250', JobMaxSalary:'400', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n218:Job {NodeID:108, JobID:'4051', JobTitle:'ILLUSTRATOR', JobDescription:'DRAWS CLOUDS, RAINBOWS, TIDAL WAVES, SUN SCENES, ETC FOR PR PUBLICATIONS.', JobRequirements:'PROVEN SKILL IN BOTH REALISTIC AND ABSTRACT LANDSCAPE PAINTING.', JobMinSalary:'170', JobMaxSalary:'240', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n223:Job {NodeID:109, JobID:'4053', JobTitle:'PASTE-UP ARTIST', JobDescription:'PREPARES TEXT, PHOTOS, AND ARTWORK FOR TYPSETTING.', JobRequirements:'MUST LIKE TO SNIFF GLUE.', JobMinSalary:'170', JobMaxSalary:'240', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n228:Job {NodeID:110, JobID:'9007', JobTitle:'DIR WEATHER', JobDescription:'OVERSEES ALL ASPECTS OF WEATHER PRODUCTION, COORDINATES WORLDWIDE WEATHER CONDITIONS.', JobRequirements:'7 YEARS MANAGEMENT IN MANUFACTURING, PHD IN PHYSICS, EXCELLENT ORGANIZATIONAL ABILITIES.', JobMinSalary:'750', JobMaxSalary:'1250', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n233:Job {NodeID:111, JobID:'5001', JobTitle:'MGR BRAINSTORMING', JobDescription:'SUPERVISES INCLEMENT CONDITIONS; BLOWS ILL WINDS; MASTERMINDS MAELSTROMS.', JobRequirements:'MUST BE CREATIVE, ARBITRARY, MOODY. MUST BE ABLE TO SUPERVISE AND MOTIVATE OTHER TEMPERAMENTAL TYPES.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n238:Job {NodeID:112, JobID:'5021', JobTitle:'RAINMAKER', JobDescription:'BRINGS LIFE TO GREEN THINGS, MILDEW TO BASEMENTS, AND DISMAY TO OUTDOOR ENTHUSIASTS.', JobRequirements:'MUST ENJOY MAKING OTHERS WET AND MISERABLE.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n243:Job {NodeID:113, JobID:'5023', JobTitle:'RAINDANCE CONSULTANT', JobDescription:'CHOREOGRAPHS RITUAL EXERCISES TO ASSIST RAINMAKER.', JobRequirements:'MUST HAVE STAGED SEVERAL SUCCESSFUL RAINDANCE RITUALS, ON OR OFF BROADWAY.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n248:Job {NodeID:114, JobID:'5025', JobTitle:'SNOWBLOWER', JobDescription:'CREATES LIGHT TO HEAVY SNOWFALL, AT UNPREDICTABLE TIMES, TO ANNOY ADULTS AND DELIGHT CHILDREN.', JobRequirements:'MUST LIKE KIDS, MOUNTAINS, WINTER SPORTS.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n253:Job {NodeID:115, JobID:'5027', JobTitle:'KEEPER OF THE WINDS', JobDescription:'CONTROLS THE DIRECTIONAL FORCES OF AIR CURRENTS.', JobRequirements:'MUST WORK WELL WITH OTHERS, MUST HAVE EXCELLENT SELF-CONTROL, MUST HAVE MS IN AERODYNAMICS.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n258:Job {NodeID:116, JobID:'5029', JobTitle:'STURM/DRANG ADMIN', JobDescription:'WREAKS HAVOC ON PEACEFUL SCENES BY GENERATING TYPHOONS, MONSOONS, HURRICANES, AND TORNADOS.', JobRequirements:'MUST BE FLUENT IN TURBULENCE, TURMOIL, AND TUMULT.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n263:Job {NodeID:117, JobID:'5003', JobTitle:'MGR THERMOREGULATION', JobDescription:'SUPERVISES THE MEASUREMENT AND CONTROL OF ATMOSPHERIC TEMPERATURE.', JobRequirements:'PHD IN METEOROLOGY WITH SPECIALTY IN INSTRUMENTATION.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n268:Job {NodeID:118, JobID:'5031', JobTitle:'KEEPER OF BALLOONS', JobDescription:'MAINTAINS THE COSMIC FLEET OF ALL-PURPOSE WEATHER BALLOONS.', JobRequirements:'REQUIRES PILOTS LICENSE, AIR TRAFFIC CONTROL CERT. MUST NOT SUFFER FROM VERTIGO OR FREE-FLOATING ANXIETY.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n273:Job {NodeID:119, JobID:'5033', JobTitle:'WINTERIZER', JobDescription:'ADVISES THE PUBLIC ON PREPAREDNESS FOR ICE, SNOW, AND FREEZING TEMPERATURES.', JobRequirements:'MUST HAVE IN-DEPTH KNOWLEDGE OF ANTIFREEZE, SALT, POT HOLES, AND CABIN FEVER. MUST BE OBSESSIVE.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n278:Job {NodeID:120, JobID:'5035', JobTitle:'HUMIDITY CONTROL CLK', JobDescription:'REGULATES ATMOSPHERIC SATURATION.', JobRequirements:'SADISTIC TENDENCIES A DEFINITE PLUS. MUST WORK WELL UNDER PRESSURE.', JobMinSalary:'250', JobMaxSalary:'450', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n283:Job {NodeID:121, JobID:'5005', JobTitle:'MGR BLUE SKIES', JobDescription:'COORDINATES FAIR WEATHER PRODUCTION, INCLUDING TEMPERATURE MODERATION, AND SKY PIGMENTATION.', JobRequirements:'MUST HAVE BEEN BORN AND RAISED IN THE SUNBELT OR THE SOUTH PACIFIC, MUST PLAY TENNIS AND TAN EASILY.', JobMinSalary:'600', JobMaxSalary:'900', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n288:Job {NodeID:122, JobID:'5037', JobTitle:'SUNSHINE SUPERVISOR', JobDescription:'CONTROLS SOLAR RADIATION, MONITORS SUN SPOTS, DESIGNS SOLAR POWER COLLECTORS.', JobRequirements:'REQUIRES SUNNY DISPOSITION.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
create (n293:Job {NodeID:123, JobID:'5039', JobTitle:'CUMULUS CARETAKER', JobDescription:'WHIPS UP CLOUDS (WITH LINING) AT A MOMENTS NOTICE.', JobRequirements:'REQUIRES LAID BACK, IMAGINATIVE TYPE WITH A FLAIR FOR EXTERIOR DECORATING.', JobMinSalary:'300', JobMaxSalary:'550', SalaryGrades:'00000000', NrOfPositions:'001', NrOpen:'000'}); |
|
|
|
//Skill |
|
create (n24:Skill {NodeID:15, SkillID:'1000', SkillName:'MANAGEMENT'}); |
|
create (n25:Skill {NodeID:16, SkillID:'1010', SkillName:'PUB REL MGT'}); |
|
create (n26:Skill {NodeID:17, SkillID:'1030', SkillName:'ACCT MGT'}); |
|
create (n27:Skill {NodeID:18, SkillID:'1040', SkillName:'PERS MGT'}); |
|
create (n28:Skill {NodeID:19, SkillID:'1050', SkillName:'DP MGT'}); |
|
create (n29:Skill {NodeID:20, SkillID:'1060', SkillName:'WEATHER MGT'}); |
|
create (n30:Skill {NodeID:21, SkillID:'2010', SkillName:'COBOL'}); |
|
create (n31:Skill {NodeID:22, SkillID:'2020', SkillName:'PL/1'}); |
|
create (n32:Skill {NodeID:23, SkillID:'2030', SkillName:'FORTRAN'}); |
|
create (n33:Skill {NodeID:24, SkillID:'2040', SkillName:'ASSEMBLER'}); |
|
create (n34:Skill {NodeID:25, SkillID:'2080', SkillName:'RPGII'}); |
|
create (n35:Skill {NodeID:26, SkillID:'3550', SkillName:'LAYOUT'}); |
|
create (n36:Skill {NodeID:27, SkillID:'3560', SkillName:'EDITING'}); |
|
create (n37:Skill {NodeID:28, SkillID:'3610', SkillName:'PASTEUP'}); |
|
create (n38:Skill {NodeID:29, SkillID:'3620', SkillName:'PHOTO B/W'}); |
|
create (n39:Skill {NodeID:30, SkillID:'3630', SkillName:'PHOTO COLOR'}); |
|
create (n40:Skill {NodeID:31, SkillID:'3650', SkillName:'TYPSETTING'}); |
|
create (n41:Skill {NodeID:32, SkillID:'3660', SkillName:'PRINTING'}); |
|
create (n42:Skill {NodeID:33, SkillID:'3670', SkillName:'CUT/PASTE'}); |
|
create (n43:Skill {NodeID:34, SkillID:'3710', SkillName:'ART DESIGN'}); |
|
create (n44:Skill {NodeID:35, SkillID:'4250', SkillName:'DATA ENTRY'}); |
|
create (n45:Skill {NodeID:36, SkillID:'4290', SkillName:'KEYPUNCH'}); |
|
create (n46:Skill {NodeID:37, SkillID:'4370', SkillName:'FILING'}); |
|
create (n47:Skill {NodeID:38, SkillID:'4410', SkillName:'TYPING'}); |
|
create (n48:Skill {NodeID:39, SkillID:'4420', SkillName:'PHONE'}); |
|
create (n49:Skill {NodeID:40, SkillID:'4430', SkillName:'INTERVIEWING'}); |
|
create (n50:Skill {NodeID:41, SkillID:'4450', SkillName:'CALCULATING'}); |
|
create (n51:Skill {NodeID:42, SkillID:'4490', SkillName:'GEN LEDGER'}); |
|
create (n52:Skill {NodeID:43, SkillID:'5100', SkillName:'GEN ACCTNG'}); |
|
create (n53:Skill {NodeID:44, SkillID:'5130', SkillName:'BASIC MATH'}); |
|
create (n54:Skill {NodeID:45, SkillID:'5140', SkillName:'ADV MATH'}); |
|
create (n55:Skill {NodeID:46, SkillID:'5160', SkillName:'CALCULUS'}); |
|
create (n56:Skill {NodeID:47, SkillID:'5180', SkillName:'STATISTICS'}); |
|
create (n57:Skill {NodeID:48, SkillID:'5360', SkillName:'CHOREOGRAPHY'}); |
|
create (n58:Skill {NodeID:49, SkillID:'6290', SkillName:'IBM'}); |
|
create (n59:Skill {NodeID:50, SkillID:'6320', SkillName:'HONEYWELL'}); |
|
create (n60:Skill {NodeID:51, SkillID:'6340', SkillName:'DEC'}); |
|
create (n61:Skill {NodeID:52, SkillID:'6350', SkillName:'HP'}); |
|
create (n62:Skill {NodeID:53, SkillID:'6410', SkillName:'IDMSDC'}); |
|
create (n63:Skill {NodeID:54, SkillID:'6430', SkillName:'IDMSDB'}); |
|
create (n64:Skill {NodeID:55, SkillID:'6440', SkillName:'INTERACT'}); |
|
create (n65:Skill {NodeID:56, SkillID:'6450', SkillName:'OLQ'}); |
|
create (n66:Skill {NodeID:57, SkillID:'6470', SkillName:'IDD'}); |
|
create (n67:Skill {NodeID:58, SkillID:'6490', SkillName:'ADSO'}); |
|
create (n68:Skill {NodeID:59, SkillID:'7010', SkillName:'SNOW'}); |
|
create (n69:Skill {NodeID:60, SkillID:'7020', SkillName:'RAIN'}); |
|
create (n70:Skill {NodeID:61, SkillID:'7030', SkillName:'HAIL'}); |
|
create (n71:Skill {NodeID:62, SkillID:'7040', SkillName:'TORNADO'}); |
|
create (n72:Skill {NodeID:63, SkillID:'7050', SkillName:'HURRICANE'}); |
|
create (n73:Skill {NodeID:64, SkillID:'7060', SkillName:'MONSOON'}); |
|
create (n74:Skill {NodeID:65, SkillID:'7070', SkillName:'TYPHOON'}); |
|
create (n75:Skill {NodeID:66, SkillID:'7080', SkillName:'WIND'}); |
|
create (n76:Skill {NodeID:67, SkillID:'7090', SkillName:'TIDAL WAVE'}); |
|
create (n77:Skill {NodeID:68, SkillID:'7110', SkillName:'DRIZZLE'}); |
|
create (n78:Skill {NodeID:69, SkillID:'7120', SkillName:'FOG'}); |
|
create (n79:Skill {NodeID:70, SkillID:'7130', SkillName:'SMOG'}); |
|
create (n80:Skill {NodeID:71, SkillID:'7140', SkillName:'BLUE SKY'}); |
|
create (n81:Skill {NodeID:72, SkillID:'7210', SkillName:'CLOUD'}); |
|
create (n82:Skill {NodeID:73, SkillID:'7220', SkillName:'RAINBOW'}); |
|
create (n83:Skill {NodeID:74, SkillID:'7230', SkillName:'COLD'}); |
|
create (n84:Skill {NodeID:75, SkillID:'7240', SkillName:'HAZE'}); |
|
create (n85:Skill {NodeID:76, SkillID:'7250', SkillName:'HEAT'}); |
|
create (n86:Skill {NodeID:77, SkillID:'7260', SkillName:'HUMIDITY'}); |
|
create (n87:Skill {NodeID:78, SkillID:'7310', SkillName:'THUNDER'}); |
|
create (n88:Skill {NodeID:79, SkillID:'7330', SkillName:'LIGHTNING'}); |
|
create (n89:Skill {NodeID:80, SkillID:'7410', SkillName:'BALLOON'}); |
|
create (n90:Skill {NodeID:81, SkillID:'7500', SkillName:'OPERA'}); |
|
create (n91:Skill {NodeID:82, SkillID:'9170', SkillName:'THINKING'}); |
|
|
|
//Structure |
|
create (n811:Structure {NodeID:482, StartEmp:'0003',EndEmp:'0001',StructureCode:'A', StructureDate:'19820101'}); |
|
create (n812:Structure {NodeID:483, StartEmp:'0004',EndEmp:'0001',StructureCode:'A', StructureDate:'19830820'}); |
|
create (n813:Structure {NodeID:484, StartEmp:'0011',EndEmp:'0001',StructureCode:'A', StructureDate:'19800929'}); |
|
create (n814:Structure {NodeID:485, StartEmp:'0013',EndEmp:'0001',StructureCode:'A', StructureDate:'19810501'}); |
|
create (n815:Structure {NodeID:486, StartEmp:'0019',EndEmp:'0003',StructureCode:'A', StructureDate:'19820929'}); |
|
create (n816:Structure {NodeID:487, StartEmp:'0020',EndEmp:'0003',StructureCode:'A', StructureDate:'19820101'}); |
|
create (n817:Structure {NodeID:488, StartEmp:'0021',EndEmp:'0003',StructureCode:'A', StructureDate:'19820301'}); |
|
create (n818:Structure {NodeID:489, StartEmp:'0023',EndEmp:'0003',StructureCode:'A', StructureDate:'19820715'}); |
|
create (n819:Structure {NodeID:490, StartEmp:'0024',EndEmp:'0003',StructureCode:'A', StructureDate:'19820101'}); |
|
create (n820:Structure {NodeID:491, StartEmp:'0027',EndEmp:'0003',StructureCode:'A', StructureDate:'19840201'}); |
|
create (n821:Structure {NodeID:492, StartEmp:'0028',EndEmp:'0003',StructureCode:'A', StructureDate:'19830125'}); |
|
create (n822:Structure {NodeID:493, StartEmp:'0029',EndEmp:'0003',StructureCode:'A', StructureDate:'19820321'}); |
|
create (n823:Structure {NodeID:494, StartEmp:'0035',EndEmp:'0003',StructureCode:'A', StructureDate:'19821101'}); |
|
create (n824:Structure {NodeID:495, StartEmp:'0016',EndEmp:'0004',StructureCode:'A', StructureDate:'19820530'}); |
|
create (n825:Structure {NodeID:496, StartEmp:'0031',EndEmp:'0004',StructureCode:'A', StructureDate:'19821210'}); |
|
create (n826:Structure {NodeID:497, StartEmp:'0032',EndEmp:'0004',StructureCode:'A', StructureDate:'19820514'}); |
|
create (n827:Structure {NodeID:498, StartEmp:'0045',EndEmp:'0004',StructureCode:'A', StructureDate:'19820615'}); |
|
create (n828:Structure {NodeID:499, StartEmp:'0048',EndEmp:'0004',StructureCode:'A', StructureDate:'19820526'}); |
|
create (n829:Structure {NodeID:500, StartEmp:'0049',EndEmp:'0004',StructureCode:'A', StructureDate:'19831001'}); |
|
create (n830:Structure {NodeID:501, StartEmp:'0053',EndEmp:'0004',StructureCode:'A', StructureDate:'19820514'}); |
|
create (n831:Structure {NodeID:502, StartEmp:'0074',EndEmp:'0004',StructureCode:'A', StructureDate:'19820520'}); |
|
create (n832:Structure {NodeID:503, StartEmp:'0119',EndEmp:'0007',StructureCode:'A', StructureDate:'19790430'}); |
|
create (n833:Structure {NodeID:504, StartEmp:'0120',EndEmp:'0007',StructureCode:'A', StructureDate:'19800607'}); |
|
create (n834:Structure {NodeID:505, StartEmp:'0127',EndEmp:'0007',StructureCode:'A', StructureDate:'19800622'}); |
|
create (n835:Structure {NodeID:506, StartEmp:'0149',EndEmp:'0007',StructureCode:'A', StructureDate:'19780430'}); |
|
create (n836:Structure {NodeID:507, StartEmp:'0158',EndEmp:'0007',StructureCode:'A', StructureDate:'19780525'}); |
|
create (n837:Structure {NodeID:508, StartEmp:'0476',EndEmp:'0007',StructureCode:'A', StructureDate:'19811025'}); |
|
create (n838:Structure {NodeID:509, StartEmp:'0067',EndEmp:'0011',StructureCode:'A', StructureDate:'19801020'}); |
|
create (n839:Structure {NodeID:510, StartEmp:'0069',EndEmp:'0011',StructureCode:'A', StructureDate:'19800929'}); |
|
create (n840:Structure {NodeID:511, StartEmp:'0100',EndEmp:'0011',StructureCode:'A', StructureDate:'19810215'}); |
|
create (n841:Structure {NodeID:512, StartEmp:'0101',EndEmp:'0011',StructureCode:'A', StructureDate:'19800929'}); |
|
create (n842:Structure {NodeID:513, StartEmp:'0106',EndEmp:'0011',StructureCode:'A', StructureDate:'19820520'}); |
|
create (n843:Structure {NodeID:514, StartEmp:'0051',EndEmp:'0013',StructureCode:'A', StructureDate:'19840115'}); |
|
create (n844:Structure {NodeID:515, StartEmp:'0081',EndEmp:'0013',StructureCode:'A', StructureDate:'19810919'}); |
|
create (n845:Structure {NodeID:516, StartEmp:'0091',EndEmp:'0013',StructureCode:'A', StructureDate:'19810102'}); |
|
create (n846:Structure {NodeID:517, StartEmp:'0301',EndEmp:'0015',StructureCode:'A', StructureDate:'19800203'}); |
|
create (n847:Structure {NodeID:518, StartEmp:'0334',EndEmp:'0015',StructureCode:'A', StructureDate:'19790617'}); |
|
create (n848:Structure {NodeID:519, StartEmp:'0341',EndEmp:'0015',StructureCode:'A', StructureDate:'19801114'}); |
|
create (n849:Structure {NodeID:520, StartEmp:'0457',EndEmp:'0015',StructureCode:'A', StructureDate:'19820305'}); |
|
create (n850:Structure {NodeID:521, StartEmp:'0458',EndEmp:'0015',StructureCode:'A', StructureDate:'19800102'}); |
|
create (n851:Structure {NodeID:522, StartEmp:'0466',EndEmp:'0015',StructureCode:'A', StructureDate:'19780615'}); |
|
create (n852:Structure {NodeID:523, StartEmp:'0467',EndEmp:'0015',StructureCode:'A', StructureDate:'19811220'}); |
|
create (n853:Structure {NodeID:524, StartEmp:'0001',EndEmp:'0030',StructureCode:'A', StructureDate:'19790701'}); |
|
create (n854:Structure {NodeID:525, StartEmp:'0471',EndEmp:'0030',StructureCode:'A', StructureDate:'19820101'}); |
|
create (n855:Structure {NodeID:526, StartEmp:'0472',EndEmp:'0030',StructureCode:'A', StructureDate:'19791107'}); |
|
create (n856:Structure {NodeID:527, StartEmp:'0366',EndEmp:'0321',StructureCode:'A', StructureDate:'19811110'}); |
|
create (n857:Structure {NodeID:528, StartEmp:'0371',EndEmp:'0321',StructureCode:'A', StructureDate:'19811110'}); |
|
create (n858:Structure {NodeID:529, StartEmp:'0329',EndEmp:'0349',StructureCode:'A', StructureDate:'19820601'}); |
|
create (n859:Structure {NodeID:530, StartEmp:'0355',EndEmp:'0349',StructureCode:'A', StructureDate:'19840201'}); |
|
create (n860:Structure {NodeID:531, StartEmp:'0469',EndEmp:'0349',StructureCode:'A', StructureDate:'19810522'}); |
|
create (n861:Structure {NodeID:532, StartEmp:'0479',EndEmp:'0349',StructureCode:'A', StructureDate:'19820220'}); |
|
create (n862:Structure {NodeID:533, StartEmp:'0015',EndEmp:'0471',StructureCode:'A', StructureDate:'19820101'}); |
|
create (n863:Structure {NodeID:534, StartEmp:'0321',EndEmp:'0471',StructureCode:'A', StructureDate:'19830101'}); |
|
create (n864:Structure {NodeID:535, StartEmp:'0349',EndEmp:'0471',StructureCode:'A', StructureDate:'19820425'}); |
|
create (n865:Structure {NodeID:536, StartEmp:'0007',EndEmp:'0472',StructureCode:'A', StructureDate:'19810710'}); |
|
create (n866:Structure {NodeID:537, StartEmp:'0023',EndEmp:'0472',StructureCode:'P1', StructureDate:'19831010'}); |
|
create (n867:Structure {NodeID:538, StartEmp:'0045',EndEmp:'0472',StructureCode:'P1', StructureDate:'19831015'}); |
|
create (n868:Structure {NodeID:539, StartEmp:'0149',EndEmp:'0472',StructureCode:'P1', StructureDate:'19831010'}); |
|
create (n869:Structure {NodeID:540, StartEmp:'0371',EndEmp:'0472',StructureCode:'P1', StructureDate:'19831021'}); |
|
create (n870:Structure {NodeID:541, StartEmp:'0471',EndEmp:'0472',StructureCode:'P1', StructureDate:'19831019'}); |
|
create (n871:Structure {NodeID:542, StartEmp:'0003',EndEmp:'0030',StructureCode:'P2', StructureDate:'19841203'}); |
|
create (n872:Structure {NodeID:543, StartEmp:'0013',EndEmp:'0030',StructureCode:'P2', StructureDate:'19841203'}); |
|
create (n873:Structure {NodeID:544, StartEmp:'0019',EndEmp:'0030',StructureCode:'P2', StructureDate:'19841201'}); |
|
create (n874:Structure {NodeID:545, StartEmp:'0321',EndEmp:'0030',StructureCode:'P2', StructureDate:'19841120'}); |
|
create (n875:Structure {NodeID:546, StartEmp:'0349',EndEmp:'0030',StructureCode:'P2', StructureDate:'19841020'}); |
|
create (n876:Structure {NodeID:547, StartEmp:'0007',EndEmp:'0119',StructureCode:'P4', StructureDate:'19840520'}); |
|
create (n877:Structure {NodeID:548, StartEmp:'0030',EndEmp:'0119',StructureCode:'P4', StructureDate:'19840520'}); |
|
create (n878:Structure {NodeID:549, StartEmp:'0476',EndEmp:'0119',StructureCode:'P4', StructureDate:'19840520'}); |
|
|
|
//setup relationship creation |
|
match (n) set n:Node; |
|
create index on :Node(NodeID); |
|
|
|
//create relationships |
|
match (start:Node {NodeID:124}), (end:Node {NodeID:1}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:124}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:125}), (end:Node {NodeID:124}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:125}), (end:Node {NodeID:85}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:126}), (end:Node {NodeID:124}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:126}), (end:Node {NodeID:84}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:127}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:127}), (end:Node {NodeID:19}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:128}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:128}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:129}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:129}), (end:Node {NodeID:53}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:130}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:130}), (end:Node {NodeID:54}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:131}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:131}), (end:Node {NodeID:56}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:132}), (end:Node {NodeID:124}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:132}), (end:Node {NodeID:57}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:133}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:133}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:134}), (end:Node {NodeID:133}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:134}), (end:Node {NodeID:102}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:135}), (end:Node {NodeID:133}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:135}), (end:Node {NodeID:103}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:136}), (end:Node {NodeID:133}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:136}), (end:Node {NodeID:85}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:137}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:137}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:138}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:138}), (end:Node {NodeID:22}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:139}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:139}), (end:Node {NodeID:23}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:140}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:140}), (end:Node {NodeID:24}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:141}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:141}), (end:Node {NodeID:53}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:142}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:142}), (end:Node {NodeID:54}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:143}), (end:Node {NodeID:133}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:143}), (end:Node {NodeID:56}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:144}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:144}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:145}), (end:Node {NodeID:144}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:145}), (end:Node {NodeID:86}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:146}), (end:Node {NodeID:144}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:146}), (end:Node {NodeID:86}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:147}), (end:Node {NodeID:144}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:147}), (end:Node {NodeID:86}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:148}), (end:Node {NodeID:144}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:148}), (end:Node {NodeID:24}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:149}), (end:Node {NodeID:144}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:149}), (end:Node {NodeID:25}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:150}), (end:Node {NodeID:144}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:150}), (end:Node {NodeID:49}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:151}), (end:Node {NodeID:144}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:151}), (end:Node {NodeID:51}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:152}), (end:Node {NodeID:144}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:152}), (end:Node {NodeID:53}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:153}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:153}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:154}), (end:Node {NodeID:153}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:154}), (end:Node {NodeID:104}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:155}), (end:Node {NodeID:153}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:155}), (end:Node {NodeID:16}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:156}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:156}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:157}), (end:Node {NodeID:156}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:157}), (end:Node {NodeID:91}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:158}), (end:Node {NodeID:156}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:158}), (end:Node {NodeID:17}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:159}), (end:Node {NodeID:156}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:159}), (end:Node {NodeID:43}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:160}), (end:Node {NodeID:156}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:160}), (end:Node {NodeID:47}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:161}), (end:Node {NodeID:2}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:161}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:162}), (end:Node {NodeID:161}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:162}), (end:Node {NodeID:88}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:163}), (end:Node {NodeID:161}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:163}), (end:Node {NodeID:18}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:164}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:164}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:165}), (end:Node {NodeID:164}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:165}), (end:Node {NodeID:111}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:166}), (end:Node {NodeID:164}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:166}), (end:Node {NodeID:111}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:167}), (end:Node {NodeID:164}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:167}), (end:Node {NodeID:20}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:168}), (end:Node {NodeID:164}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:168}), (end:Node {NodeID:60}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:169}), (end:Node {NodeID:164}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:169}), (end:Node {NodeID:65}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:170}), (end:Node {NodeID:164}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:170}), (end:Node {NodeID:79}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:171}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:171}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:172}), (end:Node {NodeID:171}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:172}), (end:Node {NodeID:97}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:173}), (end:Node {NodeID:171}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:173}), (end:Node {NodeID:24}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:174}), (end:Node {NodeID:171}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:174}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:175}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:175}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:176}), (end:Node {NodeID:175}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:176}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:177}), (end:Node {NodeID:175}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:177}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:178}), (end:Node {NodeID:175}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:178}), (end:Node {NodeID:25}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:179}), (end:Node {NodeID:175}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:179}), (end:Node {NodeID:22}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:180}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:180}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:181}), (end:Node {NodeID:180}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:181}), (end:Node {NodeID:103}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:182}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:182}), (end:Node {NodeID:22}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:183}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:183}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:184}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:184}), (end:Node {NodeID:49}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:185}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:185}), (end:Node {NodeID:53}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:186}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:186}), (end:Node {NodeID:54}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:187}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:187}), (end:Node {NodeID:56}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:188}), (end:Node {NodeID:180}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:188}), (end:Node {NodeID:57}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:189}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:189}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:190}), (end:Node {NodeID:189}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:190}), (end:Node {NodeID:99}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:191}), (end:Node {NodeID:189}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:191}), (end:Node {NodeID:24}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:192}), (end:Node {NodeID:189}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:192}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:193}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:193}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:194}), (end:Node {NodeID:193}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:194}), (end:Node {NodeID:99}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:195}), (end:Node {NodeID:193}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:195}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:196}), (end:Node {NodeID:193}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:196}), (end:Node {NodeID:24}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:197}), (end:Node {NodeID:193}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:197}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:198}), (end:Node {NodeID:193}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:198}), (end:Node {NodeID:23}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:199}), (end:Node {NodeID:193}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:199}), (end:Node {NodeID:57}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:200}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:200}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:201}), (end:Node {NodeID:200}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:201}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:202}), (end:Node {NodeID:200}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:202}), (end:Node {NodeID:25}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:203}), (end:Node {NodeID:200}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:203}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:204}), (end:Node {NodeID:200}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:204}), (end:Node {NodeID:22}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:205}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:205}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:206}), (end:Node {NodeID:205}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:206}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:207}), (end:Node {NodeID:205}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:207}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:208}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:208}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:209}), (end:Node {NodeID:208}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:209}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:210}), (end:Node {NodeID:208}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:210}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:211}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:211}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:212}), (end:Node {NodeID:211}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:212}), (end:Node {NodeID:98}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:213}), (end:Node {NodeID:211}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:213}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:214}), (end:Node {NodeID:211}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:214}), (end:Node {NodeID:22}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:215}), (end:Node {NodeID:1}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:215}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:216}), (end:Node {NodeID:215}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:216}), (end:Node {NodeID:83}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:217}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:217}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:218}), (end:Node {NodeID:217}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:218}), (end:Node {NodeID:100}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:219}), (end:Node {NodeID:217}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:219}), (end:Node {NodeID:49}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:220}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:220}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:221}), (end:Node {NodeID:220}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:221}), (end:Node {NodeID:100}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:222}), (end:Node {NodeID:220}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:222}), (end:Node {NodeID:49}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:223}), (end:Node {NodeID:220}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:223}), (end:Node {NodeID:53}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:224}), (end:Node {NodeID:4}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:224}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:225}), (end:Node {NodeID:224}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:225}), (end:Node {NodeID:102}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:226}), (end:Node {NodeID:224}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:226}), (end:Node {NodeID:21}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:227}), (end:Node {NodeID:224}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:227}), (end:Node {NodeID:55}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:228}), (end:Node {NodeID:224}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:228}), (end:Node {NodeID:27}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:229}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:229}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:230}), (end:Node {NodeID:229}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:230}), (end:Node {NodeID:101}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:231}), (end:Node {NodeID:229}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:231}), (end:Node {NodeID:35}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:232}), (end:Node {NodeID:229}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:232}), (end:Node {NodeID:37}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:233}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:233}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:234}), (end:Node {NodeID:233}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:234}), (end:Node {NodeID:101}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:235}), (end:Node {NodeID:233}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:235}), (end:Node {NodeID:35}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:236}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:236}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:237}), (end:Node {NodeID:236}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:237}), (end:Node {NodeID:92}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:238}), (end:Node {NodeID:236}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:238}), (end:Node {NodeID:42}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:239}), (end:Node {NodeID:236}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:239}), (end:Node {NodeID:43}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:240}), (end:Node {NodeID:236}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:240}), (end:Node {NodeID:46}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:241}), (end:Node {NodeID:236}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:241}), (end:Node {NodeID:47}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:242}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:242}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:243}), (end:Node {NodeID:242}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:243}), (end:Node {NodeID:96}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:244}), (end:Node {NodeID:242}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:244}), (end:Node {NodeID:41}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:245}), (end:Node {NodeID:242}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:245}), (end:Node {NodeID:44}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:246}), (end:Node {NodeID:242}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:246}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:247}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:247}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:248}), (end:Node {NodeID:247}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:248}), (end:Node {NodeID:101}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:249}), (end:Node {NodeID:247}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:249}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:250}), (end:Node {NodeID:247}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:250}), (end:Node {NodeID:36}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:251}), (end:Node {NodeID:2}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:251}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:252}), (end:Node {NodeID:251}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:252}), (end:Node {NodeID:90}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:253}), (end:Node {NodeID:251}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:253}), (end:Node {NodeID:37}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:254}), (end:Node {NodeID:251}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:254}), (end:Node {NodeID:35}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:255}), (end:Node {NodeID:2}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:255}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:256}), (end:Node {NodeID:255}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:256}), (end:Node {NodeID:89}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:257}), (end:Node {NodeID:255}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:257}), (end:Node {NodeID:15}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:258}), (end:Node {NodeID:255}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:258}), (end:Node {NodeID:40}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:259}), (end:Node {NodeID:255}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:259}), (end:Node {NodeID:55}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:260}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:260}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:261}), (end:Node {NodeID:260}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:261}), (end:Node {NodeID:93}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:262}), (end:Node {NodeID:260}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:262}), (end:Node {NodeID:43}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:263}), (end:Node {NodeID:260}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:263}), (end:Node {NodeID:47}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:264}), (end:Node {NodeID:260}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:264}), (end:Node {NodeID:57}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:265}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:265}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:266}), (end:Node {NodeID:265}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:266}), (end:Node {NodeID:94}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:267}), (end:Node {NodeID:265}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:267}), (end:Node {NodeID:44}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:268}), (end:Node {NodeID:265}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:268}), (end:Node {NodeID:42}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:269}), (end:Node {NodeID:265}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:269}), (end:Node {NodeID:43}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:270}), (end:Node {NodeID:3}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:270}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:271}), (end:Node {NodeID:270}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:271}), (end:Node {NodeID:95}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:272}), (end:Node {NodeID:270}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:272}), (end:Node {NodeID:44}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:273}), (end:Node {NodeID:270}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:273}), (end:Node {NodeID:41}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:274}), (end:Node {NodeID:270}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:274}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:275}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:275}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:276}), (end:Node {NodeID:275}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:276}), (end:Node {NodeID:106}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:277}), (end:Node {NodeID:275}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:277}), (end:Node {NodeID:29}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:278}), (end:Node {NodeID:275}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:278}), (end:Node {NodeID:30}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:279}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:279}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:280}), (end:Node {NodeID:279}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:280}), (end:Node {NodeID:109}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:281}), (end:Node {NodeID:279}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:281}), (end:Node {NodeID:108}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:282}), (end:Node {NodeID:279}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:282}), (end:Node {NodeID:34}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:283}), (end:Node {NodeID:279}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:283}), (end:Node {NodeID:28}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:284}), (end:Node {NodeID:279}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:284}), (end:Node {NodeID:73}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:285}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:285}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:286}), (end:Node {NodeID:285}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:286}), (end:Node {NodeID:109}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:287}), (end:Node {NodeID:285}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:287}), (end:Node {NodeID:33}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:288}), (end:Node {NodeID:285}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:288}), (end:Node {NodeID:26}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:289}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:289}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:290}), (end:Node {NodeID:289}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:290}), (end:Node {NodeID:107}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:291}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:291}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:292}), (end:Node {NodeID:291}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:292}), (end:Node {NodeID:105}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:293}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:293}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:294}), (end:Node {NodeID:293}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:294}), (end:Node {NodeID:112}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:295}), (end:Node {NodeID:293}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:295}), (end:Node {NodeID:112}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:296}), (end:Node {NodeID:293}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:296}), (end:Node {NodeID:112}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:297}), (end:Node {NodeID:293}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:297}), (end:Node {NodeID:60}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:298}), (end:Node {NodeID:293}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:298}), (end:Node {NodeID:68}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:299}), (end:Node {NodeID:293}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:299}), (end:Node {NodeID:69}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:300}), (end:Node {NodeID:9}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:300}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:301}), (end:Node {NodeID:300}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:301}), (end:Node {NodeID:122}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:302}), (end:Node {NodeID:300}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:302}), (end:Node {NodeID:121}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:303}), (end:Node {NodeID:300}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:303}), (end:Node {NodeID:71}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:304}), (end:Node {NodeID:300}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:304}), (end:Node {NodeID:20}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:305}), (end:Node {NodeID:8}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:305}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:306}), (end:Node {NodeID:305}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:306}), (end:Node {NodeID:118}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:307}), (end:Node {NodeID:305}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:307}), (end:Node {NodeID:80}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:308}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:308}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:309}), (end:Node {NodeID:308}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:309}), (end:Node {NodeID:113}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:310}), (end:Node {NodeID:308}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:310}), (end:Node {NodeID:48}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:311}), (end:Node {NodeID:308}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:311}), (end:Node {NodeID:60}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:312}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:312}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:313}), (end:Node {NodeID:312}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:313}), (end:Node {NodeID:114}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:314}), (end:Node {NodeID:312}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:314}), (end:Node {NodeID:59}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:315}), (end:Node {NodeID:312}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:315}), (end:Node {NodeID:66}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:316}), (end:Node {NodeID:312}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:316}), (end:Node {NodeID:74}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:317}), (end:Node {NodeID:8}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:317}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:318}), (end:Node {NodeID:317}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:318}), (end:Node {NodeID:117}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:319}), (end:Node {NodeID:317}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:319}), (end:Node {NodeID:66}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:320}), (end:Node {NodeID:317}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:320}), (end:Node {NodeID:74}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:321}), (end:Node {NodeID:317}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:321}), (end:Node {NodeID:76}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:322}), (end:Node {NodeID:317}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:322}), (end:Node {NodeID:77}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:323}), (end:Node {NodeID:317}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:323}), (end:Node {NodeID:20}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:324}), (end:Node {NodeID:8}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:324}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:325}), (end:Node {NodeID:324}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:325}), (end:Node {NodeID:119}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:326}), (end:Node {NodeID:324}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:326}), (end:Node {NodeID:74}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:327}), (end:Node {NodeID:324}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:327}), (end:Node {NodeID:59}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:328}), (end:Node {NodeID:9}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:328}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:329}), (end:Node {NodeID:328}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:329}), (end:Node {NodeID:122}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:330}), (end:Node {NodeID:328}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:330}), (end:Node {NodeID:71}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:331}), (end:Node {NodeID:328}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:331}), (end:Node {NodeID:76}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:332}), (end:Node {NodeID:9}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:332}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:333}), (end:Node {NodeID:332}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:333}), (end:Node {NodeID:123}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:334}), (end:Node {NodeID:332}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:334}), (end:Node {NodeID:71}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:335}), (end:Node {NodeID:332}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:335}), (end:Node {NodeID:72}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:336}), (end:Node {NodeID:332}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:336}), (end:Node {NodeID:73}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:337}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:337}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:338}), (end:Node {NodeID:337}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:338}), (end:Node {NodeID:116}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:339}), (end:Node {NodeID:337}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:339}), (end:Node {NodeID:78}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:340}), (end:Node {NodeID:337}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:340}), (end:Node {NodeID:81}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:341}), (end:Node {NodeID:337}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:341}), (end:Node {NodeID:63}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:342}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:342}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:343}), (end:Node {NodeID:342}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:343}), (end:Node {NodeID:115}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:344}), (end:Node {NodeID:342}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:344}), (end:Node {NodeID:66}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:345}), (end:Node {NodeID:1}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:345}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:346}), (end:Node {NodeID:345}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:346}), (end:Node {NodeID:111}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:347}), (end:Node {NodeID:345}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:347}), (end:Node {NodeID:110}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:348}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:348}), (end:Node {NodeID:20}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:349}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:349}), (end:Node {NodeID:78}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:350}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:350}), (end:Node {NodeID:65}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:351}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:351}), (end:Node {NodeID:67}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:352}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:352}), (end:Node {NodeID:63}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:353}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:353}), (end:Node {NodeID:62}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:354}), (end:Node {NodeID:345}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:354}), (end:Node {NodeID:66}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:355}), (end:Node {NodeID:1}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:355}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:356}), (end:Node {NodeID:355}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:356}), (end:Node {NodeID:87}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:357}), (end:Node {NodeID:355}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:357}), (end:Node {NodeID:15}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:358}), (end:Node {NodeID:355}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:358}), (end:Node {NodeID:82}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:359}), (end:Node {NodeID:8}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:359}), (end:Node {NodeID:12}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:360}), (end:Node {NodeID:359}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:360}), (end:Node {NodeID:120}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:361}), (end:Node {NodeID:359}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:361}), (end:Node {NodeID:75}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:362}), (end:Node {NodeID:359}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:362}), (end:Node {NodeID:76}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:363}), (end:Node {NodeID:359}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:363}), (end:Node {NodeID:77}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:364}), (end:Node {NodeID:6}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:364}), (end:Node {NodeID:10}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:365}), (end:Node {NodeID:364}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:365}), (end:Node {NodeID:107}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:366}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:366}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:367}), (end:Node {NodeID:366}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:367}), (end:Node {NodeID:116}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:368}), (end:Node {NodeID:366}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:368}), (end:Node {NodeID:78}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:369}), (end:Node {NodeID:7}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:369}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:370}), (end:Node {NodeID:369}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:370}), (end:Node {NodeID:114}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:371}), (end:Node {NodeID:369}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:371}), (end:Node {NodeID:67}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:372}), (end:Node {NodeID:369}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:372}), (end:Node {NodeID:62}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:373}), (end:Node {NodeID:369}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:373}), (end:Node {NodeID:63}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:374}), (end:Node {NodeID:369}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:374}), (end:Node {NodeID:78}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:375}), (end:Node {NodeID:369}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:375}), (end:Node {NodeID:79}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:376}), (end:Node {NodeID:8}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:376}), (end:Node {NodeID:13}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:377}), (end:Node {NodeID:376}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:377}), (end:Node {NodeID:119}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:378}), (end:Node {NodeID:376}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:378}), (end:Node {NodeID:65}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:379}), (end:Node {NodeID:376}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:379}), (end:Node {NodeID:67}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:380}), (end:Node {NodeID:376}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:380}), (end:Node {NodeID:63}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:381}), (end:Node {NodeID:376}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:381}), (end:Node {NodeID:62}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:382}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:382}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:383}), (end:Node {NodeID:382}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:383}), (end:Node {NodeID:101}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:384}), (end:Node {NodeID:382}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:384}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:385}), (end:Node {NodeID:382}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:385}), (end:Node {NodeID:39}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:386}), (end:Node {NodeID:382}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:386}), (end:Node {NodeID:37}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:387}), (end:Node {NodeID:5}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:387}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:388}), (end:Node {NodeID:387}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:388}), (end:Node {NodeID:100}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:389}), (end:Node {NodeID:387}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:389}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:390}), (end:Node {NodeID:387}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:390}), (end:Node {NodeID:37}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:391}), (end:Node {NodeID:387}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:391}), (end:Node {NodeID:36}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:392}), (end:Node {NodeID:387}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:392}), (end:Node {NodeID:39}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:393}), (end:Node {NodeID:2}) create (start)-[:DEPT_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:393}), (end:Node {NodeID:11}) create (start)-[:OFFICE_EMPLOYEE]->(end); |
|
match (start:Node {NodeID:394}), (end:Node {NodeID:393}) create (start)-[:EMP_EMPOSITION]->(end); |
|
match (start:Node {NodeID:394}), (end:Node {NodeID:90}) create (start)-[:JOB_EMPOSITION]->(end); |
|
match (start:Node {NodeID:395}), (end:Node {NodeID:393}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:395}), (end:Node {NodeID:38}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:396}), (end:Node {NodeID:393}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:396}), (end:Node {NodeID:39}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:397}), (end:Node {NodeID:393}) create (start)-[:EMP_EXPERTISE]->(end); |
|
match (start:Node {NodeID:397}), (end:Node {NodeID:55}) create (start)-[:SKILL_EXPERTISE]->(end); |
|
match (start:Node {NodeID:402}), (end:Node {NodeID:215}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:403}), (end:Node {NodeID:402}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:404}), (end:Node {NodeID:215}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:405}), (end:Node {NodeID:404}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:406}), (end:Node {NodeID:124}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:407}), (end:Node {NodeID:124}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:408}), (end:Node {NodeID:144}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:409}), (end:Node {NodeID:144}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:410}), (end:Node {NodeID:144}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:411}), (end:Node {NodeID:410}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:412}), (end:Node {NodeID:345}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:413}), (end:Node {NodeID:345}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:414}), (end:Node {NodeID:345}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:415}), (end:Node {NodeID:414}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:416}), (end:Node {NodeID:164}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:417}), (end:Node {NodeID:164}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:418}), (end:Node {NodeID:417}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:419}), (end:Node {NodeID:164}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:420}), (end:Node {NodeID:293}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:421}), (end:Node {NodeID:293}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:422}), (end:Node {NodeID:421}) create (start)-[:COVERAGE_CLAIMS]->(end); |
|
match (start:Node {NodeID:423}), (end:Node {NodeID:293}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:424}), (end:Node {NodeID:293}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:425}), (end:Node {NodeID:133}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:426}), (end:Node {NodeID:153}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:427}), (end:Node {NodeID:156}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:428}), (end:Node {NodeID:161}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:429}), (end:Node {NodeID:171}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:430}), (end:Node {NodeID:175}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:431}), (end:Node {NodeID:180}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:432}), (end:Node {NodeID:189}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:433}), (end:Node {NodeID:193}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:434}), (end:Node {NodeID:193}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:435}), (end:Node {NodeID:200}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:436}), (end:Node {NodeID:205}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:437}), (end:Node {NodeID:208}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:438}), (end:Node {NodeID:211}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:439}), (end:Node {NodeID:217}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:440}), (end:Node {NodeID:220}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:441}), (end:Node {NodeID:220}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:442}), (end:Node {NodeID:224}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:443}), (end:Node {NodeID:229}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:444}), (end:Node {NodeID:382}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:445}), (end:Node {NodeID:387}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:446}), (end:Node {NodeID:393}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:447}), (end:Node {NodeID:233}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:448}), (end:Node {NodeID:236}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:449}), (end:Node {NodeID:242}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:450}), (end:Node {NodeID:247}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:451}), (end:Node {NodeID:251}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:452}), (end:Node {NodeID:255}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:453}), (end:Node {NodeID:255}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:454}), (end:Node {NodeID:260}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:455}), (end:Node {NodeID:265}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:456}), (end:Node {NodeID:270}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:457}), (end:Node {NodeID:275}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:458}), (end:Node {NodeID:279}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:459}), (end:Node {NodeID:285}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:460}), (end:Node {NodeID:285}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:461}), (end:Node {NodeID:289}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:462}), (end:Node {NodeID:291}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:463}), (end:Node {NodeID:300}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:464}), (end:Node {NodeID:305}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:465}), (end:Node {NodeID:308}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:466}), (end:Node {NodeID:312}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:467}), (end:Node {NodeID:317}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:468}), (end:Node {NodeID:324}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:469}), (end:Node {NodeID:328}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:470}), (end:Node {NodeID:332}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:471}), (end:Node {NodeID:366}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:472}), (end:Node {NodeID:366}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:473}), (end:Node {NodeID:337}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:474}), (end:Node {NodeID:369}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:475}), (end:Node {NodeID:342}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:476}), (end:Node {NodeID:376}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:477}), (end:Node {NodeID:355}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:478}), (end:Node {NodeID:364}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:479}), (end:Node {NodeID:364}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:480}), (end:Node {NodeID:364}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:481}), (end:Node {NodeID:359}) create (start)-[:EMP_COVERAGE]->(end); |
|
match (start:Node {NodeID:482}), (end:Node {NodeID:124}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:482}), (end:Node {NodeID:133}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:483}), (end:Node {NodeID:124}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:483}), (end:Node {NodeID:144}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:484}), (end:Node {NodeID:124}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:484}), (end:Node {NodeID:156}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:485}), (end:Node {NodeID:124}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:485}), (end:Node {NodeID:161}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:486}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:486}), (end:Node {NodeID:175}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:487}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:487}), (end:Node {NodeID:180}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:488}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:488}), (end:Node {NodeID:189}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:489}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:489}), (end:Node {NodeID:193}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:490}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:490}), (end:Node {NodeID:200}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:491}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:491}), (end:Node {NodeID:205}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:492}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:492}), (end:Node {NodeID:208}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:493}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:493}), (end:Node {NodeID:211}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:494}), (end:Node {NodeID:133}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:494}), (end:Node {NodeID:224}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:495}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:495}), (end:Node {NodeID:171}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:496}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:496}), (end:Node {NodeID:217}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:497}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:497}), (end:Node {NodeID:220}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:498}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:498}), (end:Node {NodeID:229}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:499}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:499}), (end:Node {NodeID:382}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:500}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:500}), (end:Node {NodeID:387}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:501}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:501}), (end:Node {NodeID:233}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:502}), (end:Node {NodeID:144}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:502}), (end:Node {NodeID:247}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:503}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:503}), (end:Node {NodeID:275}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:504}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:504}), (end:Node {NodeID:279}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:505}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:505}), (end:Node {NodeID:285}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:506}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:506}), (end:Node {NodeID:289}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:507}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:507}), (end:Node {NodeID:291}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:508}), (end:Node {NodeID:153}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:508}), (end:Node {NodeID:364}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:509}), (end:Node {NodeID:156}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:509}), (end:Node {NodeID:236}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:510}), (end:Node {NodeID:156}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:510}), (end:Node {NodeID:242}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:511}), (end:Node {NodeID:156}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:511}), (end:Node {NodeID:260}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:512}), (end:Node {NodeID:156}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:512}), (end:Node {NodeID:265}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:513}), (end:Node {NodeID:156}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:513}), (end:Node {NodeID:270}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:514}), (end:Node {NodeID:161}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:514}), (end:Node {NodeID:393}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:515}), (end:Node {NodeID:161}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:515}), (end:Node {NodeID:251}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:516}), (end:Node {NodeID:161}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:516}), (end:Node {NodeID:255}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:517}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:517}), (end:Node {NodeID:293}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:518}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:518}), (end:Node {NodeID:308}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:519}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:519}), (end:Node {NodeID:312}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:520}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:520}), (end:Node {NodeID:366}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:521}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:521}), (end:Node {NodeID:337}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:522}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:522}), (end:Node {NodeID:369}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:523}), (end:Node {NodeID:164}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:523}), (end:Node {NodeID:342}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:524}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:524}), (end:Node {NodeID:124}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:525}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:525}), (end:Node {NodeID:345}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:526}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:526}), (end:Node {NodeID:355}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:527}), (end:Node {NodeID:300}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:527}), (end:Node {NodeID:328}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:528}), (end:Node {NodeID:300}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:528}), (end:Node {NodeID:332}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:529}), (end:Node {NodeID:317}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:529}), (end:Node {NodeID:305}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:530}), (end:Node {NodeID:317}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:530}), (end:Node {NodeID:324}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:531}), (end:Node {NodeID:317}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:531}), (end:Node {NodeID:376}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:532}), (end:Node {NodeID:317}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:532}), (end:Node {NodeID:359}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:533}), (end:Node {NodeID:345}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:533}), (end:Node {NodeID:164}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:534}), (end:Node {NodeID:345}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:534}), (end:Node {NodeID:300}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:535}), (end:Node {NodeID:345}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:535}), (end:Node {NodeID:317}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:536}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:536}), (end:Node {NodeID:153}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:537}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:537}), (end:Node {NodeID:193}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:538}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:538}), (end:Node {NodeID:229}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:539}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:539}), (end:Node {NodeID:289}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:540}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:540}), (end:Node {NodeID:332}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:541}), (end:Node {NodeID:355}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:541}), (end:Node {NodeID:345}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:542}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:542}), (end:Node {NodeID:133}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:543}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:543}), (end:Node {NodeID:161}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:544}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:544}), (end:Node {NodeID:175}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:545}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:545}), (end:Node {NodeID:300}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:546}), (end:Node {NodeID:215}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:546}), (end:Node {NodeID:317}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:547}), (end:Node {NodeID:275}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:547}), (end:Node {NodeID:153}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:548}), (end:Node {NodeID:275}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:548}), (end:Node {NodeID:215}) create (start)-[:REPORTS_TO]->(end); |
|
match (start:Node {NodeID:549}), (end:Node {NodeID:275}) create (start)-[:MANAGES]->(end); |
|
match (start:Node {NodeID:549}), (end:Node {NodeID:364}) create (start)-[:REPORTS_TO]->(end); |
|
|
|
//remove relationship setup |
|
match (n:Node) remove n:Node; |
|
drop index on :Node(NodeID); |