-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbackup.sql
138 lines (123 loc) · 32.6 KB
/
backup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
-- MySQL dump 10.13 Distrib 5.7.17, for Linux (x86_64)
--
-- Host: localhost Database: publication_database
-- ------------------------------------------------------
-- Server version 5.7.17-0ubuntu0.16.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `publication_data`
--
DROP TABLE IF EXISTS `publication_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `publication_data` (
`proposal_ID` int(11) NOT NULL,
`principle_investigator` varchar(45) NOT NULL,
`co-PI` varchar(45) DEFAULT NULL,
`additional_fund` decimal(6,2) DEFAULT NULL,
`start` date NOT NULL,
`close` date NOT NULL,
`noCostExtention_endDate` date DEFAULT NULL,
`agency_share` decimal(6,2) DEFAULT NULL,
`NJIT_share` decimal(6,2) DEFAULT NULL,
`F&A` decimal(6,2) DEFAULT NULL,
`title` varchar(50) NOT NULL,
`prime_contact` varchar(45) DEFAULT NULL,
`prime_agency` varchar(45) NOT NULL,
`subContracting_agency` varchar(45) DEFAULT NULL,
`subContract` varchar(45) DEFAULT NULL,
`department` varchar(45) NOT NULL,
`college` varchar(45) NOT NULL,
PRIMARY KEY (`proposal_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `publication_data`
--
LOCK TABLES `publication_data` WRITE;
/*!40000 ALTER TABLE `publication_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `publication_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `publication_login`
--
DROP TABLE IF EXISTS `publication_login`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `publication_login` (
`user_ID` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
PRIMARY KEY (`user_ID`),
UNIQUE KEY `user_name_UNIQUE` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `publication_login`
--
LOCK TABLES `publication_login` WRITE;
/*!40000 ALTER TABLE `publication_login` DISABLE KEYS */;
INSERT INTO `publication_login` VALUES (1,'admin','passwd');
/*!40000 ALTER TABLE `publication_login` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `publications`
--
DROP TABLE IF EXISTS `publications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `publications` (
`Yearpublished` varchar(45) NOT NULL,
`Proposal
#` text,
`PI` text,
`Co-PI_1` text,
`Co-PI_2` text,
`Co-PI_3` text,
`A/F` text,
`START` datetime DEFAULT NULL,
`CLOSE` datetime DEFAULT NULL,
`NO-COST EXTENSION
End Date` text,
`AGENCY
$` text,
`NJIT
$` text,
`F&A
$` text,
`Title` text,
`Prime Contact #` text,
`Prime Agency` text,
`SubContracting
Agency` text,
`Subcontract #` text,
`Dept` text,
`College` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `publications`
--
LOCK TABLES `publications` WRITE;
/*!40000 ALTER TABLE `publications` DISABLE KEYS */;
INSERT INTO `publications` VALUES ('','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','',' $279,814 ',' $- ',' $74,883 ','Wireless Communication Technologies for Train Coupling','Research Agreement','CSRZICL','','','ECE','NCE'),('','13-172','Mitra, S ','','','','','2004-08-13 00:00:00','2006-01-16 00:00:00','',' $150,791 ',' $- ',' $16,084 ','Carbon Nanotube Enhanced Membrane Distillation','University Agreement 00-10000461 dated 7/26/13','EPRI','','','CES','CSLA'),('','14-056','Spasovic, L','','','','','2007-03-13 00:00:00','2007-02-14 00:00:00','',' $120,364 ',' $42,743 ',' $10,177 ','Establishment of State Freight Advisory Committee to Guide Planning Investments and Other Policies in Support of MAP-21','Task Order 299','NJ DOT','Rutgers University','5048','CEE','NCE'),('','13-336','Boufadel, M','','','','','2008-12-13 00:00:00','2002-11-14 00:00:00','',' $145,000 ',' $55,364 ',' $13,182 ','Assessment of Economic, Ecological and Social Capital in Congruence with Design Studies for Reducing Storm Surge and Flooding Risks to New Jersey Coastal Communities','EC14-006','NJDEP','','','NRDP','R&D'),('','11-120','Jaffe, M','','','','','2001-04-11 00:00:00','2009-01-13 00:00:00','11/01/13',' $- ',' $- ',' $- ','Verification of Isosorbide Utility in Beverage & Food Packaging ','Agreement','Pepsico','','','BME','NCE'),('','12-220','Liu. R','','','','','2009-12-11 00:00:00','2009-12-13 00:00:00','02/28/14',' $- ',' $- ',' $- ','Hand Held Devices on Rail for Fare Collection and Communications','Task Order 274','NJDOT','Rutgers','4594','CEE','NCE'),('','12-138','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - MUA','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('','12-139','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - Core Funds','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('','12-134','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - Direct Funds','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('','12-084','Simeone, O','','','','X','2012-03-13 00:00:00','2012-05-14 00:00:00','',' $89,573 ',' $- ',' $26,298 ','Robust Compressed Interference Alignment for Cloud Radio Access Networks','Amendment No.2 Industrial Research Agreement 12-3-13','Interdigital','','','ECE','NCE'),('','10-290','Sebastian, D','','','','','2004-06-10 00:00:00','2004-05-14 00:00:00','04/05/15',' $- ',' $- ',' $- ','NJ-HITEC','90RC0037','US DHHS','','','R&D','R&D'),('','13-258','Mahgoub, M','','','',' ','2002-12-14 00:00:00','2002-12-17 00:00:00','',' $44,364 ',' $11,830 ',' $7,394 ','Structural Health Monitoring ','NPRP 6-150-2-059','Qatar National Research Fund','','','ET','NCE'),('','13-336','Boufadel, M','','','','X','2008-12-13 00:00:00','2002-11-14 00:00:00','09/01/14',' $36,500 ',' $13,936 ',' $3,318 ','Assessment of Economic, Ecological and Social Capital in Congruence with Design Studies for Reducing Storm Surge and Flooding Risks to New Jersey Coastal Communities\n\n','EC14-006 Amendment#1','NJ DEP','','','NRDP','R&D'),('','3-172','Mitra, S','','','','','2004-08-13 00:00:00','2006-01-16 00:00:00','',' $161,296 ',' $51,614 ',' $17,205 ','Water Treatment EPRI','00-10000461','EPRI','','','CES','CSLA'),('','14-325','Dallessio,T','','','','','2005-06-14 00:00:00','2009-05-14 00:00:00','',' $29,480 ',' $- ',' $2,680 ',' NJ Town Centers Distributed Energy Resource Microgrids Potential:Statewide Geographic Information Systems Assessment ','14-100-082-2003-004-3610','NJ Board of Public Utilities','','','CAD','CAD'),('','14-282','Dreizin, E','','','','','2005-01-14 00:00:00','2011-02-15 00:00:00','',' $25,780 ',' $- ',' $8,820 ','Reactive Metal Composite Materials with Enhanced Ignition/Deflagration Efficiencies','RMII-N-141-072-0790','US Navy','RMII','','CBPE',' NCE'),('','11-101','Yurchyshyn, V','Abramenko, V','Cao, W','','X','2005-07-14 00:00:00','2008-02-14 00:00:00','',' $37,498 ',' $- ',' $12,828 ','Linking Photospheric Dynamic Magnetic Fields to Chromospheric Jetting Activity','NNX11AO73G','NASA','','','DP','CSLA'),('','11-100','Wang, H','','','','X','2005-08-14 00:00:00','2008-02-14 00:00:00','',' $37,014 ',' $- ',' $12,663 ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','14-342','Armenante, P','','','','','2005-07-14 00:00:00','2005-07-15 00:00:00','',' $50,000 ',' $19,771 ',' $17,105 ','Hydrodynamic and Dissolution Characteristics of Mini Paddle Dissolution Apparatus ','Research Study Agreement dtd 5-7-14','Merck Sharp & Dohme Corp.','','','CBPE','NCE'),('','10-527','Marshall, W','','','','','2010-09-09 00:00:00','2009-01-13 00:00:00','06/30/14',' $- ',' $- ',' $- ','Campus Peer Review','Agreement Oct3, 2009','NJOHSP','','','R&D','R&D'),('','11-030','Dreizin, E','','','','X','2005-09-11 00:00:00','2005-08-16 00:00:00','',' $164,616 ',' $- ',' $47,356 ','Neutralization of Aerosolized Bio-agents by Filled Nanocomposite Materials through Thermal and Chemical Inactivation','HDTRA1-11-1-0017','DTRA','','','CBPE','NCE'),('','14-367','Garnier, S','','','','','2006-06-14 00:00:00','2006-05-17 00:00:00','',' $18,100 ',' $132,889 ',' $51,654 ','Risky Business: Using biological systems to mitigate risk in supply chains and transportation networks','DP140103643','Australian Research Council','','','FDB','CSLA'),('','13-209','Yan, Z ','','','','X','2001-03-13 00:00:00','2001-03-16 00:00:00','',' $150,000 ',' $78,000 ',' $- ','The Economic Risk Early Warning Management ','Research Cooperative Agreement','Shangai Lixin University of Commerce','','','SOM','SOM'),('','14-372','Meegoda, J','','','','','2007-08-14 00:00:00','2007-07-15 00:00:00','',' $120,256 ',' $- ',' $41,657 ','Numerical Analysis of geotechnical Problems','Agreement dated 7/8/2014','Oweis Engineering','','','CEE','NCE'),('','14-359','O\'Byrne, W','','','','','2004-06-14 00:00:00','2004-05-15 00:00:00','',' $120,000 ',' $- ',' $26,762 ','Gulf Coast REC','90RC0064/01','DHHS','University of Texas','7548','NJ-HITEC','R&D'),('','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','12/31/14',' $- ',' $- ',' $- ','Wireless Communication Technologies for Train Coupling','Research Agreement','CSRZICL','','','ECE','NCE'),('','14-056','Spasovic, L','','','','','2007-03-13 00:00:00','2007-02-14 00:00:00','12/31/14',' $- ',' $- ',' $- ','Establishment of State Freight Advisory Committee to Guide Planning Investments and Other Policies in Support of MAP-21','Task Order 299','NJDOT','Rutgers','5048','CEE','NCE'),('','11-100','Wang, H','','','','','2008-03-11 00:00:00','2008-02-14 00:00:00','08/02/15',' $- ',' $- ',' $- ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','11-101','Yurchyshyn, V','Abramenko, V','Cao, W','','','2008-03-11 00:00:00','2008-02-14 00:00:00','08/02/15',' $- ',' $- ',' $- ','Linking Photospheric Dynamic Magnetic Fields to Chromospheric Jetting Activity','NNX11AO73G','NASA','','','DP','CSLA'),('','14-372','Meegoda, J','','','','','2007-08-14 00:00:00','2007-07-15 00:00:00','09/15/15',' $- ',' $- ',' $- ','Numerical Analysis of geotechnical Problems','Agreement dated 7/8/2014','Oweis Engineering','','','CEE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','X','2008-03-14 00:00:00','2008-02-15 00:00:00','',' $49,914 ',' $- ',' $17,291 ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','15-019','Gogos, C','','','','','2008-06-14 00:00:00','2008-06-15 00:00:00','',' $248,523 ',' $- ',' $17,389 ','NC Nitration Model Development','W15QKN-10-D-0503-0009','US Army','','','CBPE','NCE'),('','14-218','Boufadel, M','','','','','2002-01-14 00:00:00','2008-01-14 00:00:00','',' $22,853 ',' $- ',' $7,818 ','Determine Mixing Energy in the Baffled Flasks','','EP-C-11-006, WA#3-05','Pegasus Technical Services','PO#NJIT-14-001','NRDP','R&D'),('','15-034','Rusinkiewicz, M','','','','','2009-02-14 00:00:00','2009-01-16 00:00:00','',' $296,600 ',' $- ',' $- ',' IPA ','Assignment Agreement 8-19-14','DOD-DARPA','','','CCS','CCS'),('','15-040','Federici, J','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $100,000 ',' $- ',' $34,640 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Tasks 6.1.2 and 6.1.3','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-040','Thomas, G','Farrow, R','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $50,000 ',' $- ',' $17,320 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.1','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-040','Mitra, S','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $25,000 ',' $- ',' $6,573 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.4','W15QKN-10-D-0503-0010','US Army','','','CES','CSLA'),('','15-040','Iqbal, Z','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $25,000 ',' $- ',' $8,660 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.5','W15QKN-10-D-0503-0010','US Army','','','CES','CSLA'),('','15-040','Marshall, W','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $24,000 ',' $- ',' $8,313 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Tasks 6.1.6 and 6.1.7','W15QKN-10-D-0503-0010','US Army','','','R&D','R&D'),('','15-040','Federici, J','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $1,500,000 ',' $- ',' $64,193 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase II - Task 6.2','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-052','Haimovich, A','','','','','2009-04-14 00:00:00','2005-12-15 00:00:00','',' $116,000 ',' $- ',' $31,018 ','MIMO SIGNAL CLASSIFICATION MODELS ','PO 1022','Aspen Consulting','','','ECE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','X','2008-03-14 00:00:00','2008-02-15 00:00:00','',' $50,000 ',' $- ',' $17,320 ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','14-325','Dallessio, T','','','','','2005-06-14 00:00:00','2009-05-14 00:00:00','10/31/14',' $- ',' $- ',' $- ','NJ Town Centers Distributed Energy Resource Microgrids Potential:Statewide Geographic Information Systems Assessment','14-100-082-2003-004-3610','NJBPU','','','CAD','CAD'),('','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','06/31/15',' $- ',' $- ',' $- ','Wireless Communication Technologies for Train Coupling','Email','CSRZICL','','','ECE','NCE'),('','13-255','Simeone, O','','','','','2001-01-13 00:00:00','2001-01-16 00:00:00','',' $27,443 ',' $- ',' $4,342 ','The Information Bottleneck Principle in Multiterminal Communications and Inference','Cooperation Agreement dtd 6-12-14','Vienna University','','','ECE','NCE'),('','13-336','Boufadel, M','','','','','2008-12-13 00:00:00','2009-01-14 00:00:00','3/31/2015',' $- ',' $- ',' $- ','','EC14-006 Amendment#2','NJDEP','','','NRDP','NRDP'),('','12-296','Gary, D','Fleishman, G','','','X','2003-05-15 00:00:00','2001-10-16 00:00:00','',' $18,062 ',' $- ',' $6,179 ','Energy Release, Acceleration, and Escape of Solar Energetic Particles','NNX13AE41G','NASA','','','DP','CSLA'),('','13-255','Simeone, O','','','','X','2001-01-13 00:00:00','2007-01-16 00:00:00','',' $9,272 ',' $ - ',' $3,172 ','The Information Bottleneck Method in Multiterminal Communications and Inference','Cooperating Agreement 6-12-14','Vienna Science Technology Fund (TINCOIN)','','','ECE','NCE'),('','15-275','Berliner Heyman, S ','','','','','2002-02-15 00:00:00','2002-02-16 00:00:00','',' $80,000 ',' $48,032 ',' $- ','Exxon Mobil/Bernard Harris Summer Science Camp 2015','ck#2000332124','ExxonMobil Foundation/Harris Foundation','','','CPCP','CPCP'),('','14-282','Dreizin, E','','','','','2005-01-14 00:00:00','2011-02-15 00:00:00','',' $23,189 ',' $- ',' $7,933 ','Reactive Metal Composite Materials with Enhanced Ignition/Deflagration Efficiencies','RMII-N-141-072-0790','US Dept. of Navy','','','CBPE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','','2008-03-11 00:00:00','2008-02-15 00:00:00','08/02/16',' $- ',' $- ',' $- ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','15-330','Dreizin, E','','','','','2005-12-15 00:00:00','2010-11-15 00:00:00','',' $24,682.00 ',' $- ',' $8,550.00 ','CHARACTERIZATION OF REACTIVITY OF MAGNESIUM POWDERS WITH DIFFERENT PARTICLE SHAPES AND COATINGS','Email confirmation & Check payment','Advanced Powder Solutions','','','CBPE','NCE'),('','15-332','Berliner-Heyman, S','Carpinelli, J','','','','2005-01-15 00:00:00','2005-01-15 00:00:00','',' $35,284 ',' $18,082 ',' $ - ','Unite 2015 Summer Program','Award ltr email 2/10/15','USArmy/Unite Foundation','','','CPCP','CPCP'),('','14-372','Meegoda, J','','','','','2007-08-14 00:00:00','2007-07-15 00:00:00','',' $120,256 ',' $- ',' $41,657 ','Numerical Analysis of geotechnical Problems','Agreement dated 7/8/2014','Oweis Engineering','','','CEE','NCE'),('','14-359','O\'Byrne, W','','','','','2004-06-14 00:00:00','2004-05-15 00:00:00','',' $120,000 ',' $- ',' $26,762 ','Gulf Coast REC','90RC0064/01','DHHS','University of Texas','7548','NJ-HITEC','R&D'),('','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','12/31/14',' $- ',' $- ',' $- ','Wireless Communication Technologies for Train Coupling','Research Agreement','CSRZICL','','','ECE','NCE'),('','14-056','Spasovic, L','','','','','2007-03-13 00:00:00','2007-02-14 00:00:00','12/31/14',' $- ',' $- ',' $- ','Establishment of State Freight Advisory Committee to Guide Planning Investments and Other Policies in Support of MAP-21','Task Order 299','NJDOT','Rutgers','5048','CEE','NCE'),('','11-100','Wang, H','','','','','2008-03-11 00:00:00','2008-02-14 00:00:00','08/02/15',' $- ',' $- ',' $- ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','11-101','Yurchyshyn, V','Abramenko, V','Cao, W','','','2008-03-11 00:00:00','2008-02-14 00:00:00','08/02/15',' $- ',' $- ',' $- ','Linking Photospheric Dynamic Magnetic Fields to Chromospheric Jetting Activity','NNX11AO73G','NASA','','','DP','CSLA'),('','14-372','Meegoda, J','','','','','2007-08-14 00:00:00','2007-07-15 00:00:00','09/15/15',' $- ',' $- ',' $- ','Numerical Analysis of geotechnical Problems','Agreement dated 7/8/2014','Oweis Engineering','','','CEE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','X','2008-03-14 00:00:00','2008-02-15 00:00:00','',' $49,914 ',' $- ',' $17,291 ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','15-019','Gogos, C','','','','','2008-06-14 00:00:00','2008-06-15 00:00:00','',' $248,523 ',' $- ',' $17,389 ','NC Nitration Model Development','W15QKN-10-D-0503-0009','US Army','','','CBPE','NCE'),('','14-218','Boufadel, M','','','','','2002-01-14 00:00:00','2008-01-14 00:00:00','',' $22,853 ',' $- ',' $7,818 ','Determine Mixing Energy in the Baffled Flasks','','EP-C-11-006, WA#3-05','Pegasus Technical Services','PO#NJIT-14-001','NRDP','R&D'),('','15-034','Rusinkiewicz, M','','','','','2009-02-14 00:00:00','2009-01-16 00:00:00','',' $296,600 ',' $- ',' $- ',' IPA ','Assignment Agreement 8-19-14','DOD-DARPA','','','CCS','CCS'),('','15-040','Federici, J','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $100,000 ',' $- ',' $34,640 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Tasks 6.1.2 and 6.1.3','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-040','Thomas, G','Farrow, R','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $50,000 ',' $- ',' $17,320 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.1','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-040','Mitra, S','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $25,000 ',' $- ',' $6,573 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.4','W15QKN-10-D-0503-0010','US Army','','','CES','CSLA'),('','15-040','Iqbal, Z','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $25,000 ',' $- ',' $8,660 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Task 6.1.5','W15QKN-10-D-0503-0010','US Army','','','CES','CSLA'),('','15-040','Marshall, W','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $24,000 ',' $- ',' $8,313 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase I - Tasks 6.1.6 and 6.1.7','W15QKN-10-D-0503-0010','US Army','','','R&D','R&D'),('','15-040','Federici, J','','','','','2009-09-14 00:00:00','2003-10-16 00:00:00','',' $1,500,000 ',' $- ',' $64,193 ','Advanced Materials & Technology Assessment of Additive Manufacturing - Phase II - Task 6.2','W15QKN-10-D-0503-0010','US Army','','','DP','CSLA'),('','15-052','Haimovich, A','','','','','2009-04-14 00:00:00','2005-12-15 00:00:00','',' $116,000 ',' $- ',' $31,018 ','MIMO SIGNAL CLASSIFICATION MODELS ','PO 1022','Aspen Consulting','','','ECE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','X','2008-03-14 00:00:00','2008-02-15 00:00:00','',' $50,000 ',' $- ',' $17,320 ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','14-325','Dallessio, T','','','','','2005-06-14 00:00:00','2009-05-14 00:00:00','10/31/14',' $- ',' $- ',' $- ','NJ Town Centers Distributed Energy Resource Microgrids Potential:Statewide Geographic Information Systems Assessment','14-100-082-2003-004-3610','NJBPU','','','CAD','CAD'),('','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','06/31/15',' $- ',' $- ',' $- ','Wireless Communication Technologies for Train Coupling','Email','CSRZICL','','','ECE','NCE'),('','13-255','Simeone, O','','','','','2001-01-13 00:00:00','2001-01-16 00:00:00','',' $27,443 ',' $- ',' $4,342 ','The Information Bottleneck Principle in Multiterminal Communications and Inference','Cooperation Agreement dtd 6-12-14','Vienna University','','','ECE','NCE'),('','13-336','Boufadel, M','','','','','2008-12-13 00:00:00','2009-01-14 00:00:00','3/31/2015',' $- ',' $- ',' $- ','','EC14-006 Amendment#2','NJDEP','','','NRDP','NRDP'),('','12-296','Gary, D','Fleishman, G','','','X','2003-05-15 00:00:00','2001-10-16 00:00:00','',' $18,062 ',' $- ',' $6,179 ','Energy Release, Acceleration, and Escape of Solar Energetic Particles','NNX13AE41G','NASA','','','DP','CSLA'),('','13-255','Simeone, O','','','','X','2001-01-13 00:00:00','2007-01-16 00:00:00','',' $9,272 ',' $ - ',' $3,172 ','The Information Bottleneck Method in Multiterminal Communications and Inference','Cooperating Agreement 6-12-14','Vienna Science Technology Fund (TINCOIN)','','','ECE','NCE'),('','15-275','Berliner Heyman, S ','','','','','2002-02-15 00:00:00','2002-02-16 00:00:00','',' $80,000 ',' $48,032 ',' $- ','Exxon Mobil/Bernard Harris Summer Science Camp 2015','ck#2000332124','ExxonMobil Foundation/Harris Foundation','','','CPCP','CPCP'),('','14-282','Dreizin, E','','','','','2005-01-14 00:00:00','2011-02-15 00:00:00','',' $23,189 ',' $- ',' $7,933 ','Reactive Metal Composite Materials with Enhanced Ignition/Deflagration Efficiencies','RMII-N-141-072-0790','US Dept. of Navy','','','CBPE','NCE'),('','11-100','Wang, H','Deng, N','Liu, Chang','','','2008-03-11 00:00:00','2008-02-15 00:00:00','08/02/16',' $- ',' $- ',' $- ','High-Spatial and High-Spectral Resolution Study of Small-Scale Jets','NNX11AO70G','NASA','','','DP','CSLA'),('','15-330','Dreizin, E','','','','','2005-12-15 00:00:00','2010-11-15 00:00:00','',' $24,682.00 ',' $- ',' $8,550.00 ','CHARACTERIZATION OF REACTIVITY OF MAGNESIUM POWDERS WITH DIFFERENT PARTICLE SHAPES AND COATINGS','Email confirmation & Check payment','Advanced Powder Solutions','','','CBPE','NCE'),('','15-332','Berliner-Heyman, S','Carpinelli, J','','','','2005-01-15 00:00:00','2005-01-15 00:00:00','',' $35,284 ',' $18,082 ',' $ - ','Unite 2015 Summer Program','Award ltr email 2/10/15','USArmy/Unite Foundation','','','CPCP','CPCP'),('2013','12-155','Muratov, C','','','','','2002-10-12 00:00:00','2002-09-13 00:00:00','',' $95,000 ',' $ - ',' $32,500 ','Strongly non equlibrium phase change','','NASA','','','MS','CSLA'),('2016','11-030','Dreizin, E','','','','X','2005-09-11 00:00:00','2005-08-16 00:00:00','',' $160,056 ',' $ - ',' $46,573 ','Neutralization of Aerosolized Bio-agents by Filled Nanocomposite Materials through Thermal and Chemical Inactivation','','DTRA','','','CBPE','NCE'),('2013','11-048','Daniel, J','','','','X','2007-01-11 00:00:00','2007-01-13 00:00:00','',' $107,069 ',' $17,256 ',' $4,108 ','Feasibility and Efficacy of Public Transportation Partnerships','','NJDOT','','','CEE','NCE'),('2012','10-111','Meegoda, J','','','','','2001-01-10 00:00:00','2007-01-12 00:00:00','10/30/12',' $ - ',' $ - ',' $ - ','Drainage Information Analysis and Mapping Project','','NJDOT','','','CEE','NCE'),('2014','11-101','Yurchyshyn, V','Abramenko, V','Cao, W','','X','2008-03-11 00:00:00','2008-02-14 00:00:00','',' $36,539 ',' $ - ',' $12,500 ','Linking Photospheric Dynamic Magnetic Fields to Chromospheric Jetting Activity','','NASA','','','DP','CSLA'),('2012','11-235','Liaukus, C','','','','','2012-01-10 00:00:00','2006-01-12 00:00:00','06/30/13',' $ - ',' $ - ',' $ - ',' No-Cost Extension: Essex Rehab Collaborative','','HCDNNJ','','','CBK','SOA'),('2012','11-139','Chien, S','','','','','2005-01-11 00:00:00','2011-01-12 00:00:00','06/30/13',' $ - ',' $ - ',' $ - ','Snow Model analysis','','NJDOT','','','CEE','NCE'),('2012','11-316','Dreizin, E','','','','X','2008-11-11 00:00:00','2002-10-12 00:00:00','',' $1,000 ',' $ - ',' $342 ','Fully Dense Nanocomposite Reactive Powders for Carbon-based Heat Sources','','Philip Morris International','','','CBPE','NCE'),('2013','12-084','Simeone, O','','','','X','2012-05-12 00:00:00','2012-05-13 00:00:00','',' $87,096 ',' $ - ',' $29,796 ','Delay Tolerant Robust Coding','','Interdigital','','','ECE','NCE'),('2014','13-190','Carpinelli, J','Kimmel, H','','','','2012-10-12 00:00:00','2001-05-14 00:00:00','',' $50,000 ',' $54,222 ',' $ - ','Pre-College Algebra Program','','AT&T','','','CPCP','CPCP'),('2014','13-199','Evans, D','','','','','2001-10-13 00:00:00','2001-10-14 00:00:00','',' $95,000 ',' $ - ',' $32,500 ','Building America Task Order 4','','US DoE','Building Media, Inc.','','CBK','SOA'),('2014','13-185','Burgermaster, M','Garber, R','','','','2001-01-13 00:00:00','2005-01-14 00:00:00','',' $42,000 ',' $ - ',' $ - ','The PCI Architectural Design Studio at NJIT','','','','','SOA','SOA'),('2016','13-209','Yan, Z (Alan)','','','','','2001-03-13 00:00:00','2001-03-16 00:00:00','',' $450,000 ',' $ - ',' $ - ','The Economic Risk Early Warning Management ','','Shangai Lixin University of Commerce','','','SOM','SOM'),('2016','12-266','Goode, P','Cao, W','Yurchyshyn, V','','','2002-04-13 00:00:00','2002-03-16 00:00:00','',' $350,000 ',' $254,856 ',' $119,737 ','Studies of the Solar Atmosphere Using Coordinated Observations with NASA Solar Missions and the 1.6 m Solar Telescope at Big Bear','','NASA','','','DP','CSLA'),('2016','12-296','Gary, D','Fleishman, G','','','','2001-11-13 00:00:00','2001-10-16 00:00:00','',' $17,388 ',' $ - ',' $5,948 ','Energy Release, Acceleration, and Escape of Solar Energetic Particles','','NASA','','','DP','CSLA'),('2013','12-138','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','',' $125,000 ',' $ - ',' $ - ','NJ Medicaid - MUA','','NJDHS','','','R&D','R&D'),('2013','12-139','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','',' $175,000 ',' $ - ',' $ - ','NJ Medicaid - Core Funds','','NJDHS','','','R&D','R&D'),('2013','12-140','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','',' $1,250,000 ',' $817,154 ','','NJ Medicaid - Direct Funds','','DHHS','','','R&D','R&D'),('2016','10-385','Chaudhry, H','','','','X','2007-01-10 00:00:00','2007-01-16 00:00:00','',' $27,500 ',' $ - ',' $ - ','Development of the Anatomic Torsion Monitor','','Mayhill Medical Group','','','BME','NCE'),('2013','11-120','Jaffe, M','','','','','2003-01-13 00:00:00','2009-01-13 00:00:00','',' $50,100 ',' $ - ',' $17,139 ','Verification of Isosorbide TA/PET for Bottle Applications','','Pepsico','','','BME','NCE'),('2013','11-120','Jaffe, M','','','','','2001-04-11 00:00:00','2003-01-13 00:00:00','09/01/13',' $ - ',' $ - ',' $ - ','Verification of Isosorbide Utility in Beverage & Food Packaging ','','Pepsico','','','BME','NCE'),('2013','11-048','Daniel, J','','','','','2007-01-11 00:00:00','2007-01-13 00:00:00','04/30/14',' $ - ',' $ - ',' $ - ','Feasibility and Efficacy of Public Transportation Partnerships','','NJDOT','','','CEE','NCE'),('2014','14-015','Zhou, M','Simeone, O','Haimovich, A','','','2007-08-13 00:00:00','2011-07-14 00:00:00','',' $279,814 ',' $- ',' $74,883 ','Wireless Communication Technologies for Train Coupling','Research Agreement','CSRZICL','','','ECE','NCE'),('2016','13-172','Mitra, S ','','','','','2004-08-13 00:00:00','2006-01-16 00:00:00','',' $150,791 ',' $- ',' $16,084 ','Carbon Nanotube Enhanced Membrane Distillation','University Agreement 00-10000461 dated 7/26/13','EPRI','','','CES','CSLA'),('2014','14-056','Spasovic, L','','','','','2007-03-13 00:00:00','2007-02-14 00:00:00','',' $120,364 ',' $42,743 ',' $10,177 ','Establishment of State Freight Advisory Committee to Guide Planning Investments and Other Policies in Support of MAP-21','Task Order 299','NJ DOT','Rutgers University','5048','CEE','NCE'),('2014','13-336','Boufadel, M','','','','','2008-12-13 00:00:00','2002-11-14 00:00:00','',' $145,000 ',' $55,364 ',' $13,182 ','Assessment of Economic, Ecological and Social Capital in Congruence with Design Studies for Reducing Storm Surge and Flooding Risks to New Jersey Coastal Communities','EC14-006','NJDEP','','','NRDP','R&D'),('2013','11-120','Jaffe, M','','','','','2001-04-11 00:00:00','2009-01-13 00:00:00','11/01/13',' $- ',' $- ',' $- ','Verification of Isosorbide Utility in Beverage & Food Packaging ','Agreement','Pepsico','','','BME','NCE'),('2013','12-220','Liu. R','','','','','2009-12-11 00:00:00','2009-12-13 00:00:00','02/28/14',' $- ',' $- ',' $- ','Hand Held Devices on Rail for Fare Collection and Communications','Task Order 274','NJDOT','Rutgers','4594','CEE','NCE'),('2013','12-138','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - MUA','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('2013','12-139','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - Core Funds','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('2013','12-134','Sebastian, D','','','','','2012-12-11 00:00:00','2012-11-13 00:00:00','09/30/14',' $- ',' $- ',' $- ','NJ Medicaid Specialist Program - Direct Funds','05-1305NJIMPL','DHHS','NJ DHS','MOA','R&D','R&D'),('2014','12-084','Simeone, O','','','','X','2012-03-13 00:00:00','2012-05-14 00:00:00','',' $89,573 ',' $- ',' $26,298 ','Robust Compressed Interference Alignment for Cloud Radio Access Networks','Amendment No.2 Industrial Research Agreement 12-3-13','Interdigital','','','ECE','NCE');
/*!40000 ALTER TABLE `publications` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-04-19 13:44:19