Grant_Deadlines¶
- 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 MATHDATASolutions_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=""