Details
-
Type:
Task
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: TMF-1
-
Fix Version/s: TMF-1
-
Component/s: None
-
Labels:None
Description
Create xml/TMF directory and populate needed xml files to cover schema requirements as derived from the Application and Nomination prototypes.. Copy and paste from Quest schema as appropriate.
Notes on Tables and Columns
========================
Student.xml: In addition to fields shown in prototypes, we will need the following columns for controlling workflow:
- is_prescreen TINYINT DEFAULT 0 Set to 1 when student has completed and submitted the Prescreen form.
- scholarship_type_id INT - Indicates which program student is applying for (Vista or Scholars). Link this to a civicrm_option_value (civicrm_option_group.name = 'scholarship_type')
Use Essay / essay_type to store all essays (as w/ Quest)