View source for Proposals/Outcomes portfolio/Settings and database tables

<h2 id="outcomes-portfolio-setting-and-database-tables">Outcomes portfolio setting and database tables</h2>
<p>[https://bugs.launchpad.net/mahara/+bug/1991601 Wishlist item]</p>
<h3 id="high-level-overview">High level overview</h3>
<ul>
<li>Create the &#39;Outcomes portfolio&#39; option as institution setting so that it can be available for groups created in that institution</li>
<li>Create database tables for outcome types and subjects to record necessary details such as short names and colour code classes where appropriate.</li>
</ul>
<blockquote>
<p>The colours are defined via classes in the stylesheet in the code, not on the interface.</p>
</blockquote>
<h3 id="details">Details</h3>
<ol>
<li>Create the &#39;Outcomes portfolio&#39; option in the institution settings with rules as for portfolio completion and SmartEvidence, i.e. if somebody is in multiple institutions, they see it if at least one of their institutions has it turned on.<ul>
<li>It can be used in conjunction with portfolio completion and SmartEvidence.</li>
<li>It has characteristics of the portfolio completion page (rather than SmartEvidence), i.e. it should be possible in the future to add further blocks to that special first page.</li>
<li>It will be the very first page if portfolio completion and / or SmartEvidence are selected as well.</li>
<li>Initially, it is only available on the group level (group owned collections), but be open to future plans to have it available on personal, institution, and site level as well</li>
<li>Add a new field &#39;outcomes&#39; into the collection table</li>
</ul>
</li>
<li>New database tables for &#39;Outcome category&#39; (lang string &#39;Outcome category&#39;) and &#39;Outcome subject&#39; (lang string &#39;Subject&#39;). These are hard-coded / inserted into the DB for each institution. It is not possible (at this stage) to add or change them via the admin interface. The key value should be a number. The category is created to future proof the functionality for when different outcome portfolios are created that require different outcome types either within one institution or across different institutions.<ul>
<li>1 table for outcome categories (outcome_category): ID, outcome category title [up to 100 characters], institution ID; e.g. here the category would be &#39;Foundation&#39; (in the future, this could be displayed in the admin interface, but currently is out of scope)</li>
<li>1 table for outcome types (outcome_type): ID, outcome category ID as foreign key, title of the outcome type [up to 100 characters], abbreviation of the outcome type [up to 10 characters], outcome type background colour which refers to a class that is saved in here and defined in SCSS as a colour (background and border) in <code>theme/raw/sass/components/_outcomes.scss</code> where we will keep all the outcomes classes.</li>
<li>1 table for subject categories: ID, subject category name [up to 100 characters], institution ID, e.g. here the category would be &#39;Subject&#39; (in the future, this could be displayed in the admin interface, but currently is out of scope)</li>
<li>1 table for subjects: ID, subject category ID as foreign key, title of the subject [up to 100 characters], abbreviation of the subject [up to 10 characters]</li>
</ul>
</li>
</ol>