0.Add New Fields

System Level Fields - Configuration Page

This table page should replace the "parameters" page and table with system level field values below:

Field Name	Description	Reference
Terms Per Year	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
Days Per Year	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
School Beginning Date	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
Back Years	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
Attrition Rate	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
Student Teacher Ratio	This is already column in the parameters table, convert to a field on the configuration page	https://cs.studianova.org/admin/parameters
Promotion Date	Date field when the students are promoted by grade level	https://bsa.lynops.com/link/99#bkmrk-academi-years-past-a
Lowest Grade Level	Menu select from K-12 list
Highest Grade Level	Menu select from K-12 list

Table Field Updates

Field Name	Description	Reference
StartTerm YearStarts	Term Label Table - menu select menu options: "in academic start year" and "in academic end year"	https://bsa.lynops.com/link/97#bkmrk-academic-years-generDefault Term Years
EndTerm YearEnds	Term Label Table - menu select menu options: "in academic start year" and "in academic end year"	https://bsa.lynops.com/link/97#bkmrk-academic-years-generDefault Term Years
Assessment Antecedent	Term Label table - integer value	https://bsa.lynops.com/link/114#bkmrk-note%3A-create-the-fieAssessment Module
Type - change menu options	Assessment Code  table - change menu options to "Level Equivalent", "Percentile Rank", "Competency"	https://bsa.lynops.com/link/114#bkmrk-note%3A-update-assessmAssessment Module
Subject field - make mandatory	Assessment Code  table	https://bsa.lynops.com/link/114#bkmrk-note%3A-the-subject-fiAssessment Module
Percentile Rank	Marks Matrix  table - add a decimal field, two places	https://bsa.lynops.com/link/114#bkmrk-note%3A-add-the-%22perceAssessment Module
Relationship - relate assessment results table to student term table	multiple assessment results per student term	https://bsa.lynops.com/link/114#bkmrk-this-result-should-aAssessment Module
Percentile Rank	Assessment Result table - integer value	https://bsa.lynops.com/link/114#bkmrk-for-example%2C-a-studeAssessment Module
Moodle Learning Plan	program of study table - text field	https://bsa.lynops.com/link/114#bkmrk-note%3A-we-need-to-creAssessment Module
Learning Plan Status	program of study table - text field	https://bsa.lynops.com/link/114#bkmrk-note%3A-we-need-to-creAssessment Module
Plan GPA	Student Plan Table - decimal value, two places	https://bsa.lynops.com/link/123#bkmrk-add-gpa-field-to-theStudent Plan Table
Expiry Date	authorizations table - date field	https://bsa.lynops.com/link/141#bkmrk-add-an-expiry-date-fAuthorizations

Relationship and Table Changes

Tables	Description	Reference
Relationship - relate assessment results table to student term table	multiple assessment results per student term	https://bsa.lynops.com/link/114#bkmrk-this-result-should-a
Delete CredAuthorizations table	replace with multi-select field in authorizations table (see below)	https://bsa.lynops.com/link/141#bkmrk-delete-the-credautho
For Authorizations, add a multi-select pick list that allows users to select from the credential table.	Authorizations	https://bsa.lynops.com/link/141#bkmrk-for-authorizations%2C-
templates are child records to subject requirements	many template to one subject requirement record	https://bsa.lynops.com/link/135#bkmrk-note%3A-templates-shou