.. index::
   Grant_Deadlines

===============
Grant_Deadlines
===============

.. default-role:: doc

:Description:

   This table holds the grant deadline data used in the GrandDeadlinesDashboard.accdb program.  The program imports data from cornerstone report output,
   and reformatts for staff use of this utility.  See MATHDATA\Solutions_Sample_Import_Formats for specification of import data



Columns
=======


**ID** ``int(11) NOT NULL AUTO_INCREMENT``

   :Options:

      ``display="true", null="true", search="false", type=""``


**Selected** ``tinyint(1) DEFAULT 0``

   :Description:

      checkbox alongside the data rows

   :Options:

      ``display="true", null="true", search="false", type=""``


**award_number** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**project_number** ``varchar(255) DEFAULT NULL``

   :Description:

       the program will filter out all project numbers that maint doesn't care about (ask Cornelia)

   :Options:

      ``display="true", null="true", search="false", type=""``


**award_name** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**project_organization** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**award_start_date** ``datetime DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**true_sponsor_end_date** ``datetime DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**award_end_date** ``datetime DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**principal_investigator** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**project_manager** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**project_funding_amount** ``double DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**pi_email** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**notified_date** ``datetime DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**date_imported** ``datetime DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**pm_email** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()``

   :Options:

      ``display="true", null="true", search="false", type=""``