# 0.Add New Fields - Completed

##### System Level Fields - Configuration Page

*<span style="color: #e03e2d;">This table page should replace the "parameters" page and table with system level field values below:</span>*

<table border="1" id="bkmrk-field-name-descripti" style="border-collapse: collapse; width: 100%; height: 502.062px;"><tbody><tr style="height: 57.75px;"><td style="width: 33.3745%; height: 57.75px;">**Field Name**</td><td style="width: 33.3745%; height: 57.75px;">**Description**</td><td style="width: 33.3745%; height: 57.75px;">**Reference**</td></tr><tr style="height: 63.3906px;"><td style="width: 33.3745%; height: 63.3906px;">Terms Per Year</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr style="height: 63.3906px;"><td style="width: 33.3745%; height: 63.3906px;">Days Per Year</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr style="height: 63.3906px;"><td style="width: 33.3745%; height: 63.3906px;">School Beginning Date</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr style="height: 63.3906px;"><td style="width: 33.3745%; height: 63.3906px;">Back Years</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr><td style="width: 33.3745%;">Attrition Rate</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr><td style="width: 33.3745%;">Student Teacher Ratio</td><td style="width: 33.3745%; height: 63.3906px;">This is already column in the parameters table, convert to a field on the configuration page </td><td style="width: 33.3745%; height: 63.3906px;">[https://cs.studianova.org/admin/parameters](https://bsa.lynops.com/parameters)</td></tr><tr style="height: 67.7812px;"><td style="width: 33.3745%; height: 67.7812px;">Promotion Date </td><td style="width: 33.3745%; height: 67.7812px;">Date field when the students are promoted by grade level</td><td style="width: 33.3745%; height: 67.7812px;">[1.Calendar Functions](https://bsa.lynops.com/books/personal-education-management-system/page/1-calendar-functions-ready)</td></tr><tr style="height: 63.375px;"><td style="width: 33.3745%; height: 63.375px;">Lowest Grade Level </td><td style="width: 33.3745%; height: 63.375px;">Menu select from K-12 list</td><td style="width: 33.3745%; height: 63.375px;">  
</td></tr><tr style="height: 29.7969px;"><td style="width: 33.3745%; height: 29.7969px;">Highest Grade Level</td><td style="width: 33.3745%; height: 29.7969px;">Menu select from K-12 list</td><td style="width: 33.3745%; height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td></tr></tbody></table>

##### Table Field Updates

<table border="1" id="bkmrk-field-name-descripti-0" style="border-collapse: collapse; width: 100%; height: 835.739px;"><tbody><tr style="height: 29.7017px;"><td style="width: 33.3745%; height: 29.7017px;">**Field Name**</td><td style="width: 33.3745%; height: 29.7017px;">**Description**</td><td style="width: 33.3745%; height: 29.7017px;">**Reference**</td></tr><tr style="height: 80.0994px;"><td style="width: 33.3745%; height: 80.0994px;">Term Starts</td><td style="width: 33.3745%; height: 80.0994px;">**Term Label Table** - menu select

menu options: "i*n academic start year*" and "in academic end year"

</td><td style="width: 33.3745%; height: 80.0994px;">[Default Term Years](https://bsa.lynops.com/books/personal-education-management-system/page/4-create-set-of-school-terms-ready)  
</td></tr><tr style="height: 80.0994px;"><td style="width: 33.3745%; height: 80.0994px;">Term Ends</td><td style="width: 33.3745%; height: 80.0994px;">**Term Label Table -** menu select

menu options: "in academic start year" and "*in academic end year*"

</td><td style="width: 33.3745%; height: 80.0994px;">[Default Term Years](https://bsa.lynops.com/books/personal-education-management-system/page/4-create-set-of-school-terms-ready)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Assessment Window</td><td style="width: 33.3745%; height: 57.7699px;">Term Label table - integer value </td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 66.3636px;"><td style="width: 33.3745%; height: 66.3636px;">Type - change menu options</td><td style="width: 33.3745%; height: 66.3636px;">Assessment Code table - change menu options to "Level Equivalent", "Percentile Rank", "Competency" </td><td style="width: 33.3745%; height: 66.3636px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Subject field - make mandatory</td><td style="width: 33.3745%; height: 57.7699px;">Assessment Code table</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Percentile Rank</td><td style="width: 33.3745%; height: 57.7699px;">Marks Matrix table - add a decimal field, two places</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Relationship - relate assessment results table to student term table</td><td style="width: 33.3745%; height: 57.7699px;">multiple assessment results per student term</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Percentile Rank</td><td style="width: 33.3745%; height: 57.7699px;">Assessment Result table - integer value</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Moodle Learning Plan</td><td style="width: 33.3745%; height: 57.7699px;">program of study table - text field</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Learning Plan Status</td><td style="width: 33.3745%; height: 57.7699px;">program of study table - text field</td><td style="width: 33.3745%; height: 57.7699px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Plan GPA</td><td style="width: 33.3745%; height: 57.7699px;">Student Plan Table - decimal value, two places</td><td style="width: 33.3745%; height: 57.7699px;">[Student Plan Table](https://bsa.lynops.com/books/personal-education-management-system/page/student-plan-table)</td></tr><tr style="height: 57.7699px;"><td style="width: 33.3745%; height: 57.7699px;">Expiry Date</td><td style="width: 33.3745%; height: 57.7699px;">authorizations table - date field</td><td style="width: 33.3745%; height: 57.7699px;">[Authorizations](https://bsa.lynops.com/books/personal-education-management-system/page/authorizations)</td></tr><tr style="height: 29.7727px;"><td style="width: 33.3745%; height: 29.7727px;">  
</td><td style="width: 33.3745%; height: 29.7727px;">  
</td><td style="width: 33.3745%; height: 29.7727px;">  
</td></tr><tr style="height: 29.7727px;"><td style="width: 33.3745%; height: 29.7727px;">  
</td><td style="width: 33.3745%; height: 29.7727px;">  
</td><td style="width: 33.3745%; height: 29.7727px;">  
</td></tr></tbody></table>

##### Relationship and Table Changes

<table border="1" id="bkmrk-tables-description-r" style="border-collapse: collapse; width: 100%; height: 304.938px;"><tbody><tr style="height: 29.7969px;"><td style="width: 33.3745%; height: 29.7969px;">**Tables**</td><td style="width: 33.3745%; height: 29.7969px;">**Description**</td><td style="width: 33.3745%; height: 29.7969px;">**Reference**</td></tr><tr style="height: 57.7812px;"><td style="width: 33.3745%; height: 57.7812px;">Relationship - relate assessment results table to student term table</td><td style="width: 33.3745%; height: 57.7812px;">multiple assessment results per student term</td><td style="width: 33.3745%; height: 57.7812px;">[Assessment Module](https://bsa.lynops.com/books/personal-education-management-system/page/assessment-module)</td></tr><tr style="height: 57.7812px;"><td style="width: 33.3745%; height: 57.7812px;">Delete CredAuthorizations table</td><td style="width: 33.3745%; height: 57.7812px;">replace with multi-select field in authorizations table (see below)</td><td style="width: 33.3745%; height: 57.7812px;">[Authorizations](https://bsa.lynops.com/books/personal-education-management-system/page/authorizations)</td></tr><tr style="height: 66.3906px;"><td style="width: 33.3745%; height: 66.3906px;">For Authorizations, add a multi-select pick list that allows users to select from the credential table.</td><td style="width: 33.3745%; height: 66.3906px;">Authorizations</td><td style="width: 33.3745%; height: 66.3906px;">[Authorizations](https://bsa.lynops.com/books/personal-education-management-system/page/authorizations)</td></tr><tr style="height: 33.5938px;"><td style="width: 33.3745%; height: 33.5938px;">templates are child records to subject requirements</td><td style="width: 33.3745%; height: 33.5938px;">many template to one subject requirement record</td><td style="width: 33.3745%; height: 33.5938px;">[3.Programs of Study and Subject Requirements](https://bsa.lynops.com/books/personal-education-management-system/page/4-programs-of-study-and-subject-requirements)</td></tr><tr style="height: 29.7969px;"><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td></tr><tr style="height: 29.7969px;"><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td><td style="width: 33.3745%; height: 29.7969px;">  
</td></tr></tbody></table>