SSS Technical Information

Student Fields in SIS Updated from SSS Event Triggers
Event Event Status Updated SIS Student Field/Value Form/Field Logic sets custom_xxx
IEP Event
 Event status becomes locked
 IEP Plan start date

iep_plandate

Demographics and Student Desired Outcomes_rev

true

setStudentField

custom_873

{this}
IEP Event
 Event status becomes locked
IEP Review/expire date

iep_reviewdate

Demographics and Student Desired Outcomes_rev

true

setStudentField

custom_940

{this}
IEP Event
 Event status becomes locked
 3 yr reeval date/due date

reeval_due

Demographics and Student Desired Outcomes_rev

true

setStudentField

custom_874

{this}
IEP Event
 Event status becomes locked
 Extended School Year Services to Yes

ESY_Q1

ESY Eligibility Review

$fieldInstance->getValue() == "0"

setStudentField

custom_256

Y
Amended IEP
 Event status becomes locked
 Extended School Year Services to Yes

ESY_Q1

ESY Eligibility Review

$fieldInstance->getValue() == "0"

setStudentField

custom_256

Y
IEP Event
 Event status becomes locked
 Extended School Year Services to No

ESY_Q1

ESY Eligibility Review

$fieldInstance->getValue() == "1"

setStudentField

custom_256

N
Amended IEP
 Event status becomes locked
 Extended School Year Services to No

ESY_Q1

ESY Eligibility Review

$fieldInstance->getValue() == "1"

setStudentField

custom_256

N
IEP Event
 Event status becomes locked
 Alternative Assessment Administered to Performance Tasks

FSAA_type

Participation in State District Assessments

$fieldInstance->getValue() == "0"

setStudentField

custom_791

P
Amended IEP
 Event status becomes locked
 Alternative Assessment Administered to Performance Tasks

FSAA_type

Participation in State District Assessments

$fieldInstance->getValue() == "0"

setStudentField

custom_791

P
IEP Event
 Event status becomes locked
 Alternative Assessment Administered to Datafolio

FSAA_type

Participation in State District Assessments

$fieldInstance->getValue() == "1"

setStudentField

custom_791

D
Amended IEP
 Event status becomes locked
 Alternative Assessment Administered to Datafolio

FSAA_type

Participation in State District Assessments

$fieldInstance->getValue() == "1"

setStudentField

custom_791

D
Amended IEP
 Event status becomes locked
 3 yr reeval date/due date if changed

reeval_due

Demographics and Student Desired Outcomes_rev

true

setStudentField

custom_874

{this}
EP for Gifted
 Event status becomes locked
 EP Plan start date

ep_plandate

Educational Plan (EP) for  Gifted Students

true

setStudentField

custom_873

{this}
EP for Gifted
 Event status becomes locked
 EP Plan review date

ep_reviewdate

Educational Plan (EP) for  Gifted Students

true

setStudentField

custom_940

{this}
504 Plan
 Event status becomes locked
 504 Current Entry/Annual Review Date

plan_date

Section 504 Student Accommodation Plan

true

setStudentField

custom_20009121

{this}
504 Plan
 Event status becomes locked
 504 Plan Annual Review/Annual Review Due date

plan_date

Section 504 Student Accommodation Plan

true

setStudentField

custom_20009351

date('m/d/Y', strtotime({this}) + (86400 * 365))

504 Initial Evaluation/

Periodic Reevaluation


 Event status becomes locked
 504 Initial Eligibility date

evaluation_type

Section 504 Eligibility: Initial and Periodic Re-Evaluation_new

{this} == '0'

setStudentField

custom_20009354

{date}
Dependencies Between SSS Forms/Screens

IEP/Amended IEP Events

Child Form/Step/Screen Is Dependent Upon Dependency
Demographics and Desired Outcomes
 IEP Notice of Meeting 
 IEP Plan Start date is dependent upon meeting date set on IEP Notice of Meeting
Transition Services
 Demographics and Desired Outcomes step
 Transition step is hidden unless one of the 2 Transition questions is answered YES
IEP Goals & Objectives screen
 Present Levels (PLAAFP) step
 No Domains will display unless a domain is checked YES for Area of Concern on PLAAFP; generates an error message
Matrix of Services 
 Present Levels (PLAAFP) step
 Domain Service Level locks at Level 1 if Area of Concern is NO; if Area of Concern is YES, the Domain Service Level can be edited. The exception is Domain D: Communication → it can be edited whether Area of Concern is YES or NO
Accommodations/Modification screen
 Schedule of Services
 Dropdown for selecting Schedule will be blank if no Schedule type was selected on the Schedule of Services; will not be able to save values on the row.
Accommodations/Modifications screen
 Demographics and Desired Outcomes
 Duration field auto-populates based on the IEP Plan Start/Review dates; unable to save values on row if missing.
LRE Considerations 
 Schedule of Services
 LRE button for Regular Class, Resource Room, Separate class auto-selected based upon calculation of Percent Time Gen Ed → calculated based on Total School Minutes - Calculated ESE minutes
Prior Written Notice 
 IEP Team Signatures

PWN step becomes required when the question on the signatures page is checked YES for IEP includes a change of placement or FAPE from previous IEP.
OTHER EVENTS Dependent On Dependency
Amended IEP
 Last locked IEP or Amended IEP
 Data copies from last locked IEP or Amended IEP (whichever has the most recent date; dates will be locked on Amended IEP); any changed data fields will highlight yellow and can be printed with highlighted fields (grayscale on B&W printers)
IEP Goals Progress Report

IEP Event and Goals & Objective start/end date


Amended IEP and Goals & Objectives if changed








Demographics and Desired Outcomes step in IEP or Amended IEP  > Frequency of Progress Reporting to Parents

Progress Report will not become available until an IEP has been locked. Goals will auto-display and will also update if additional goals added via a locked Amended IEP. 


Goals cannot be progress-monitored prior to the goal start date or after the goal end date. 


Progress Periods will populate based on selected frequency: Quarterly will show Quarter Marking Periods only (by short name); Every Marking Period will show all interim and quarter marking periods by short name; Monthly will show Progress Periods with editable titles to enter dates
Excused IEP Team Member Input
 IEP Notice of Meeting
 Step becomes required if “Is excusal being requested” is answered Yes and the notice of meeting is successfully saved & validated.
SSS Forms Field Programming

Documentation of major programming on each SSS form with the exception of enable/require

Green = STATE

Purple = VALIDATION

IEP EVENT & Related Forms

FORM NAME
 FIELD NAME
 PROGRAMMING
 PURPOSE
Demographics & Desired Outcomes_rev
 All demographic data fields at top
 Collections are used to populate the student fields
 Efficiency and reduction of user errors

iep_plandate
 Event trigger copies meetingdate from Notice of meeting to this field
 Efficiency and reduction of user errors

iep_reviewdate

var plan_date = $iep_plandate.getValue();

console.log('Plan Date: ', plan_date);

if (!plan_date) {

return;

}


var review_date = moment(plan_date)

.add(364, 'days')

.format('MM/DD/YYYY');


this.setValue(review_date);


 Looks at the plan start date and calculates the end date 1 year minus 1 day

services_startdate

var start_date    = new Date($iep_plandate.getValue());

var end_date      = new Date($iep_reviewdate.getValue());

var services_date = new Date(this.getValue());


// convert to milliseconds

start_date    = start_date.getTime();

end_date      = end_date.getTime();

services_date = services_date.getTime();


if (!(services_date >= start_date && services_date <= end_date)) {

return 'Service date must be between start and review date of the IEP';

}


return true;

Prevents the Services start date from being prior to the IEP Plan date or after the IEP Review date
FORM NAME
 FIELD NAME
 PROGRAMMING
 PURPOSE
Extended School Year Eligibility
 ESY_Q2 - Q7a
 All become enabled upon ESY_Q1 being answered Yes
 Efficiency - form not required to be completed if ESY_Q1 = No
Special Factors
 All fields
 Answering Yes makes text fields required
 Compliance check
Transition Services
 transfer_17
 Enabled/Required if TransferRights selected Applicable
 Compliance check
Participation in State/District Assessment
 AAE_Flag (= Yes)

Enables/Requires these fields:

  • cognitive_disability

  • req_mod

  • unable_master

  • FSAA_eligible

 Compliance check

FSAA_eligible (= Yes)
 Enables/Requires remaining fields on page 1 (FSAAQ1 - Q5, FSAA_type)
 Compliance check
Present Levels (PLAAFP)

fsa_recent

EOC_recent

FSAA_recent


 All populated by computed table queries
 Efficiency; compliance

domain_checklist

var indexes = [];


if ($domain_A_concern.isSelected(0)) {

indexes.push(0);

}


if ($domain_B_concern.isSelected(0)) {

indexes.push(1);

}


if ($domain_C_concern.isSelected(0)) {

indexes.push(2);

}


if ($domain_D_concern.isSelected(0)) {

indexes.push(3);

}


if ($domain_E_concern.isSelected(0)) {

indexes.push(4);

}


this.setValue(indexes);


 As a reminder to user, checks the box for each Domain that has Area of Concern selected as YES
LRE Considerations
 JustifyLRE

if (eventInstanceId && (this.getValue() === null || this.getValue().length === 0)) {

$.get('Modules.php?modname=api/sss/service_schedules&event_instance_id=' + eventInstanceId)

.success((response) => {

var percentLRE = calcPercentGE(response.schedules);

var value = null;


if (percentLRE >= 0.8) {

value = 0;

}

else if (percentLRE < 0.8 && percentLRE >= 0.4) {

value = 1;

}

else if (percentLRE < 0.4) {

value = 2;

}


if (value !== null) {

this.elem.find('input[type="radio"]').eq(value).click();

}

});


   function calcPercentGE(schedules) {

var num = calcESEMinutes(schedules);

var den = calcTotalMinutes(schedules);


return (den - num) / den;

}


    function calcESEMinutes(schedules) {

var sum = 0;


schedules.forEach(function(schedule) {

schedule.instructional.services.forEach(function(service) {

if (service.location === "ESE") {

sum += +service.duration;

}

});


schedule.related.services.forEach(function(service) {

if (service.location === "ESE") {

sum += +service.duration;

}

});

});


return sum;

}


function calcTotalMinutes(schedules) {

var sum = 0;

schedules.forEach(function(schedule) {

if (schedule.override_minutes) {

sum += +schedule.override_minutes;

} else {

sum += +schedule.total_minutes;

}

});


return sum;

}

}

Auto-selects the radio button for % of time student is serviced with nondisabled peers based on the Schedule of Services Total ESE Minutes calculation; 


Compliance check

EdAlt1 and EdAlt2

this.setEnabled($JustifyLRE.isSelected(2,3,4));


return Validator.oneSelected($EdAlt1, $EdAlt2);

Becomes required when the system auto-selects Separate Class and/or user selects Special Day School/ESE center or Other Separate Environment.


Compliance check
Matrix of Services

alvl1_radio


(this programming is repeated for each field below:


blvl1_radio

clvl1_radio

elvl1_radio)

var collection  = $$domain_a_concern;

var concern     = (collection.length !==0 && collection[0].VALUE === "0");

var iepEvent    = $$iep_controlled;


if (!iepEvent.length) {

return;

}


if (concern) {

this.setEnabled(false);

}

if (!concern) {

this.setValue(0);

$alvl2_radio.setEnabled(false);

$alvl3_radio.setEnabled(false);

$alvl4_radio.setEnabled(false);

$alvl5_radio.setEnabled(false);

}

If Area of Concern for Domain on PLAAFP is set to NO, the Matrix will auto-select and lock at Level 1.


This process is applicable to all Domains except Domain D - Health; Domain can be YES or NO for that Area of Concern and the Matrix will not be locked at Level 1


Compliance check to ensure services on Matrix match service level on IEP

domainARating


(this programming is repeated for each field below:


domainBRating

domainCRating

domainERating)

var lvls = [

$alvl1_radio.isSelected(),

$alvl2_radio.isSelected(),

$alvl3_radio.isSelected(),

$alvl4_radio.isSelected(),

$alvl5_radio.isSelected()

];


for (var i = 0; i < lvls.length; i++) {

if (lvls[i]) {

var controller = ComponentStore.findByName("alvl" + (i + 1) + "_radio");

var options    = controller.getOptions();

if (!options[controller.getValue()]) {


console.log('Migration 22926 496');

}


this.setValue(controller.getValue());

return;

}

}



this.setValue("0");

Calculates the Domain Rating based on the highest level radio button selected for that Domain


Used in calculation for Cost Factor

domainDRating

var lvls = [

$dlvl1_radio.isSelected(),

$dlvl2_radio.isSelected(),

$dlvl3_radio.isSelected(),

$dlvl4_radio.isSelected(),

$dlvl5_radio.isSelected()

];


for (var i = 0; i < lvls.length; i++) {

if (lvls[i]) {

var controller = ComponentStore.findByName("dlvl" + (i + 1) + "_radio");

var options    = controller.getOptions();

this.setValue(controller.getValue());

return;

}

}



this.setValue("0");


 Function is different in that if Area of Concern is YES or NO, users will manually select a rating level, including Level 1.

special_considerations_rating

var considerations = $considerations.getValue();

var sum            = 0;


considerations.forEach(function(i) {


if (i <= 1) {

sum += 13;

} else if (i === 2) {

sum += 4;

} else if (i <= 4) {

sum += 3;

} else {

sum++;

}


});


this.setValue(sum);


 Sums up the additional points for special circumstances and uses the sum in the calculation for the Total Ratings/Cost Factor

total_domain_rating

var values = [

Number($domainARating.getValue()),

Number($domainBRating.getValue()),

Number($domainCRating.getValue()),

Number($domainDRating.getValue()),

Number($domainERating.getValue())

];


var sum = 0;

for (var i = 0; i < values.length; i++) {

sum += values[i];

}


this.setValue(sum);


 Sums up the values of all Domain Ratings

Unnamed field for Special Considerations Rating
 this.setValue($special_considerations_rating.getValue());
 Adds the sum of special_considerations_rating to total_domain_rating

total_rating

var domain  = Number($total_domain_rating.getValue());

var special = Number($special_considerations_rating.getValue());


this.setValue(domain + special);

Sums the values of the above two fields; copies value to total_ratings2 field on first page of Matrix


Used to calculate Cost Factor

costfactor

var total = Number($total_rating.getValue());

var cost  = "NA";


if (total >= 6) {

if (total >= 22) {

cost = 255;

} else if (total >= 18) {

cost = 254;

} else if (total >= 14) {

cost = 253;

} else if (total >= 10) {

cost = 252;

} else {

cost = 251;

}

}


this.setValue(cost);


 Calculates the Matrix Cost Factor and sets this value on the costfactor2 field on first page of Matrix.
IEP Meeting Notice
 2ndNotice
 this.setEnabled($1stNotice.isSelected());

Requires the user to select and set date 2nd notice of meeting was prepared/sent.


Compliance check

noticedate2

if ($2ndNotice.isSelected()) {

  this.setEnabled(true);

} else {

  this.setEnabled(false);

}


if ($2ndNotice.isSelected()) {

this.setRequired(true);

} else {

this.setRequired(false);

}

noticetype2

if ($2ndNotice.isSelected() && !this.isSelected()) {

  return false;

}


return true;

 Compliance requires indicating the type of 2nd notice sent
Locked Meeting Notice
 newNotice Description

if($newnoticerequired.isSelected('New notice required') && !this.isSelected()) {

  return false;

}


return true;

Requires the user to select a reason for generating a new notice 

(New notice generated via form trigger)

EP for Gifted Student

FORM NAME FIELD NAME PROGRAMMING PURPOSE
Educational Plan (EP) for Gifted Students and Educational Plan (EP) for Gifted Students_rev
 ep_plandate

var plan_date = $ep_plandate.getValue();

var duration  =


 Looks at date with duration to set plan review date

ep_reviewdate

var plan_date = $ep_plandate.getValue();

var duration  = $ep_duration.getValue();


if (!plan_date || !duration.length) {

this.setValue(null);

return;

}


var duration_data = duration[0].text.split(" ");

var new_date      = moment(plan_date).add(+duration_data[0], duration_data[1]).format("MM/DD/YYYY");


this.setValue(new_date);


 Calculates review date based on plan start date and selected duration
EP Locked Meeting Notice

newNotice

Description

if($newnoticerequired.isSelected('New notice required') && !this.isSelected()) {

  return false;

}


return true;

Requires the user to select a reason for generating a new notice 

(New notice generated via form trigger)

ESE Staffing/Eligibility

FORM NAME FIELD NAME PROGRAMMING PURPOSE
ESE Eligibility Determination

eval_instr1


Programming is repeated for each:

eval_instr2

eval_instr3

eval_instr4

eval_instr5

eval_instr6

eval_instr7

eval_instr8

this.setEnabled($eval_cat1.isSelected());


var cat_val = $eval_cat1.getValue();

var options = [

{

"text"  : "Select One",

"value" : "" 

}

];


if (cat_val.length) {

cat_val = cat_val[0].value;

options = options.concat(this.model.options.filter(function(option) {

switch (cat_val) {

case "0"  : return (+option.value >= 0 && +option.value <= 6);

case "1"  : return (+option.value >= 7 && +option.value <= 8);

case "2"  : return (+option.value >= 9 && +option.value <= 12);

case "3"  : return (+option.value >= 13 && +option.value <= 18);

case "4"  : return (+option.value >= 19 && +option.value <= 22);

case "5"  : return (+option.value >= 23 && +option.value <= 23);

case "6"  : return (+option.value >= 24 && +option.value <= 34);

case "7"  : return (+option.value >= 35 && +option.value <= 65);

case "8"  : return (+option.value >= 66 && +option.value <= 66);

case "9"  : return (+option.value >= 67 && +option.value <= 69);

case "10" : return (+option.value >= 70 && +option.value <= 78);

case "11" : return (+option.value >= 79 && +option.value <= 83);

}

})

);

}


this.swiftbox.swiftbox("options", options);


if (!this.getValue().length) {

this.setValue();

}


this.setWidth(this.getWidth());

Limits the selection of evaluation instruments to the selected Evaluation category in field eval_cat1



Repeated for the eight eval_cat#  fields

Section 504 Initial and Periodic Re-evaluation

FORM NAME FIELD NAME PROGRAMMING PURPOSE
Section 504 Eligibility: Initial and Periodic Re-Evaluation_new
 committee_decision1
 this.setEnabled($evaluation_type.isSelected(0));

Users can only select placement options from this field for an Initial Evaluation for 504 eligibility.


Compliance check

committee_decision2
 this.setEnabled($evaluation_type.isSelected(1));

Users can only select placement options from this field for a 504 eligibility Reevaluation.


Compliance check

committee_decision3
 this.setEnabled($evaluation_type.isSelected(2));

Users can only select placement options from this field for a Temporary Impairment.


Compliance check
Default List of Event and Form Triggers on sss/florida

Event Triggers

* means there is a related Form Trigger

Event ID Primary Condition Order Action What it does
Amended IEP
Amended IEP w/Goal Bank
 66
103
 Event is created
 0
 Clone from existing event
 Looks at the last locked IEP or Amended IEP and copies all the steps/forms and completed data
Amended IEP
Amended IEP w/Goal Bank
 85
107
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets the 3yr reeval date on the ESE tab (custom_874)
Amended IEP
Amended IEP w/ Goal Bank

87, 89

123, 124
 Event status becomes locked
 0
 Run Form Trigger Action (2)
 Sets the ESY Services (custom_256)  to [Y] or [N]
Amended IEP
Amended IEP w/Goal Bank

93, 95

121, 122
 Event status becomes locked
 0
 Run Form Trigger Action (2)
 Sets the Alternative Assessment Administered (custom_791) to [P] or [D]
Amended IEP
Amended IEP w/Goal Bank
 100
120
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets Additional School Year (custom_699) to [F] or [Z]
Amended IEP
Amended IEP w/Goal Bank

 102
119
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets new system field for parent consent to medicaid billing
IEP Meeting Notice
 75
 User attempts to lock the event
 0
 Pre Lock Meeting Notice*
 Requires users to verify parent response, if meeting will take place as scheduled or new meeting is required/if so...why?
IEP Meeting Notice
 72
 Event status becomes locked
 1
 Set event field with form field
 Pushes the meeting date from the notice to the Scheduled Date field on the Create Event screen
IEP Event
IEP Event w/Goal Bank
 76
106
 Event is created
 1
 Copy field value from event
 Copies the meeting date from the locked notice to the IEP Plan (Start) date on Demographics and Desired Outcomes
IEP Event
IEP Event w/Goal Bank

 73
105
 Event status becomes locked
 0
 Set event field with form field
 Sets the Scheduled Date on the Locked Events log field from the IEP Plan (Start) date
IEP Event
IEP Event w/Goal Bank
 80
109
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets the IEP plan date on the ESE tab (custom_873)
IEP Event
IEP Event w/Goal Bank
 82
110
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets the IEP plan review date on the ESE tab (custom_940)
IEP Event
IEP Event w/Goal Bank
 84
111
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets the 3yr reeval date on the ESE tab (custom_874)
IEP Event
IEP Event w/Goal Bank


 86, 88

113, 114




 Event status becomes locked
 0
 Run Form Trigger Action (2)
 Sets the ESY Services (custom_256)  to [Y] or [N]
IEP Event
IEP Event w/Goal Bank

 86, 88

113, 114


 Event status becomes locked
 0
 Run Form Trigger Action (2)
 Sets the ESY Services (custom_256)  to [Y] or [N]
IEP Event
IEP Event w/Goal Bank

 99
117
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets Additional School Year (custom_699) to [F] or [Z]
IEP Event
IEP Event w/Goal Bank

 101
118
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets new system field for parent consent to medicaid billing
EP Meeting Notice
 78
 User attempts to lock the event
 1
 Pre Lock Meeting Notice*
 Requires users to verify parent response, if meeting will take place as scheduled or new meeting is required/if so...why?
EP for Gifted Students
 90
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets EP Plan date (custom_873)
EP for Gifted Students
 91
 Event status becomes locked
 0
 Run Form Trigger Action
 Sets EP Plan Review date (custom_940)
MTSS Modified PMP
 74
 Event is created
 0
 Clone from existing event
 Looks at the last locked Progress Monitoring Plan or Modified PMP and copies all the steps/forms and completed data
RTI Modified PMP
 68
 Event is created
 1
 Clone from existing event
 Looks at the last locked Progress Monitoring Plan or Modified PMP and copies all the steps/forms and completed data
504 Accommodation Plan
 96
 Event status becomes locked
 0
 Run form trigger action
 Sets the Accommodation Plan date (custom_20009121)
504 Accommodation Plan
 97
 Event status becomes locked
 0
 Run form trigger action

Sets the Accommodation Review date

(custom_20009351)
504 Initial Eval
 98
 Event status becomes locked
 0
 Run form trigger action
 Sets the initial eligibility date (custom_20009354)
Florida Standardized Behavioral Threat Assessment
 126
 Event status was locked or relocked
 0
 Push form to logging entry

Threat Overview/Report

838

Identifies the ID of the logging field to which the form’s entries will be pushed 
Florida Standardized Behavioral Threat Assessment
 127
 Event status was locked or relocked
 1
 Run form trigger action
 Pushes School where threat was reported (log_field1) by looking at school_id of school displaying in portal header school dropdown once a name is entered for person making the report
Florida Standardized Behavioral Threat Assessment
 128
 Event status was locked or relocked
 2
 Run form trigger action
 Pushes the Initial Classification date to (log_field3)
Florida Standardized Behavioral Threat Assessment
 129
 Event status was locked or relocked
 4
 Run form trigger action
 Pushes the value IN (Initial) for type of classification to log_field4
Florida Standardized Behavioral Threat Assessment
 130
 Event status was locked or relocked
 3
 Run form trigger action
 Pushes the Reclassification date to log_field3
Florida Standardized Behavioral Threat Assessment
 131
 Event status was locked or relocked
 5
 Run form trigger action
 Pushes value of CH for a reclassification to log_field4
Florida Standardized Behavioral Threat Assessment
 132
 Event status was locked or relocked
 6
 Run form trigger action
 Pushes the value selected for type of initial threat to log_field6
Florida Standardized Behavioral Threat Assessment
 133
 Event status was locked or relocked
 7
 Run form trigger action
 Pushes the value selected for type of reclassified threat to log_field6
Florida Standardized Behavioral Threat Assessment
 135
 Event status was locked or relocked
 8
 Run form trigger action
 Pushes the event instance ID # to log_field5

Form Triggers

 * means there is a related Event Trigger

The condition field on form triggers uses JavaScript 

Form ID Field_name Condition Order Action What it does
Demographics and Desired Outcomes_rev
 37
 transition1_yes
 {this} == "1" || {transition2_yes} == "1"
 2
 Add Step
 Adds the Transition services step/forms if either 1 of the 2 transition questions are answered “Y”
Demographics and Desired Outcomes_rev
 58
 transition1_yes
 {this} != "1" && {transition2_yes} != "1"
 3
 Hide Step
 Removes the Transition Step if answer changed from YES to NO and/or NA
IEP Meeting Notice
 56
 request_excusal
 {this} == “1”
 0
 Set Step Required
 Makes “Excused IEP Team Member Input” step/form required if user selects Yes
IEP Meeting Notice
 57
 request_excusal
 {this} == “0”
 0
 Set Step Not Required
 Makes “Excused IEP Team Member Input” step/form not required if user changes from Yes to No
IEP Meeting Participants
 51
 pwn
 {this} == “0”
 0
 Set Step  Required
 Makes “Prior Written Notice” step/form required if it user selects Yes
IEP Meeting Participants
 55
 pwn
 {this} == “1”
 0
 Set Step Not Required
 Makes “Prior Written Notice” step/form not required if it user changes from Yes to No

*Locked Meeting Notice 

(related to Event Trigger for IEP Meeting Notice)


 53
 newnoticerequired
 {this} == “2”
 0
 *Create Event
 Creates new IEP Notice of Meeting on Active Events tab if user selects “New meeting notice required”

*EP Locked Meeting Notice 

(related to Event Trigger for EP Meeting Notice)


 54
 newnoticerequired
 {this} == “2”
 0
 *Create Event
 Creates new EP Notice of Meeting on Active Events tab if user selects “New meeting notice required”
Threat Overview/Report
 59
 SubjectName
 true
 0
 Copy field value
 Copies the subject’s name to the subject name field on the Threat Subject Interview form
Threat Overview/Report
 60
 SubjectName
 true
 0
 Copy field value
 Copies the subject’s name to the subject name field on the Threat MHA Subject Interview form
Mental Wellness: Threat Assessment
 61
 Level_of_Threat
 $fieldInstance->getValue() == "2"
 0
 Add step
 Adds the Mental Health Referral step & form when the threat is substantive
Mental Wellness: Threat Assessment
 62
 Level_of_Threat
 $fieldInstance->getValue() == "2"
 1
 Add step
 Adds the Handle with Care step & form when the threat is substantive
Mental Wellness: Bullying/Harassment Report
 66
 reporter
 true
 0
 Copy field value
 Copies the name of the person reporting the bullying incident to the Investigation form
Mental Wellness: Bullying/Harassment Report
 73
 reporter_phone
 true
 0
 Copy field value
 Copies the phone number of the person reporting the bullying incident to the Investigation report
Mental Wellness: Bullying/Harassment Report
 74
 reporter_email
 true
 0
 Copy field value
 Copies the email address of the person reporting the bullying incident to the Investigation report
Mental Wellness: Bullying/Harassment Report
 75
 alleged_offender1
 true
 0
 Copy field value
 Copies the name of the first alleged bully to the offender field on the Investigation report
Mental Wellness: Bullying/Harassment Report
 76
 alleged_offender2
 true
 0
 Copy field value
 Copies the name of the second alleged bully to the second offender field on the Investigation report
Mental Wellness: Bullying/Harassment Report
 77
 victim_absent_days
 true
 0
 Copy field value
 Copies the victim’s number of absences to the Investigation report
Mental Wellness: Bullying/Harassment Investigation Summary
 63
 hope_YN
 $fieldInstance->getValue() == "0"
 1
 Add step
 Adds the Hope Scholarship Notification step & form when the answer is YES to question #13 on the Investigation report
Mental Wellness: Case Notes
 65
 Action_Steps
 $fieldInstance->getValue()[0] == "0"
 0
 Add step
 Adds the Mental Wellness Mental Health Referral step & form to the event when that option is checked
Mental Wellness: Case Notes
 71
 Action_Steps1
 $fieldInstance->getValue()[0] == "0"
 0
 Add step
 Adds the Mental Wellness Substance Abuse Referral step & form when that option is checked
Mental Wellness: Case Notes
 72
 Action_Steps2
 $fieldInstance->getValue()[0] == "2"
 0
 Add event
 Creates the Bullying/Harassment Event when that option is checked
Service Plan Demographics
 67
 transition1_yes
 {this} == "1" || {transition2_yes} == "1"
 2
 Add step
 Adds the Transition Services step & forms if either transition question is answered Yes
Service Plan Demographics
 68
 transition1_yes
 {this} != "1" && {transition2_yes} != "1"
 3
 Hide step
 Hides the Transition Services step & forms if the answer is changed to No
Service Plan Meeting Notice
 69
 request_excusal
 {this} == "1"

 0
 Set step required
 Makes the Excused SP Member step & form required if excusal is requested (yes)
Service Plan Meeting Notice
 70
 request_excusal
 {this} == "0"
 0
 Set step not required
 Returns the Excused SP Member step & form to not required if excusal changed to (no)
SSS Trigger Action Details

Form Trigger Actions

Action Name Comments
Set Field Value
 Sets the value of a field in a form belonging to this event
PARAMETER: [text] The name of the form that the field belongs to
PARAMETER: [text] The name of the field to change
PARAMETER: [anything] The value to assign to the field
PARAMETER: [text] The name of the target event
PARAMETER: [text] The name of the target step
Copy Field Value
 Copies the value of one field to another. If the source form and source are omitted, the value of the triggering field will be used when copying. If the target form is omitted, the target field will be assumed to be from the same form as the triggering field
PARAMETER: [text] The name of the target field to copy to
PARAMETER: [text] Optional. The name of the target form containing the field to copy to
PARAMETER: [text] Optional. The name of the source field to copy from.
PARAMETER: [text] Optional. The name of the source form containing the field to copy from.
Copy Field Value From Event
 Copies the value from a form field from a different event. The source parameters may be omitted if the triggering field is to be used as the source.
PARAMETER: [text] Target Event - Name of the event containing the field to set. If multiple events can contain the target field, multiple event names can be specified in a comma separated list. The first instance chronologically will be used.
PARAMETER: [text] Target Step - Name of the step in the above event containing the field to set
PARAMETER: [text] Target Form - Name of the form on the above step containing the field to set
PARAMETER: [text] Target Field - Name of the field to set
PARAMETER: [text] Source Event - Optional. Name of the event containing the field to pull the value from
PARAMETER: [text] Source Step - Optional. Name of the step in the above event containing the field to pull from
PARAMETER: [text] Source Form - Optional. Name of the form in the above step containing the field to pull from
PARAMETER: [text] Source Field - Optional. Name of the field to pull the value from
Set Field Value On Event
 Sets the value of a form field in a different event.
PARAMETER: [text] Target Event - Name of the event containing the field to set. If multiple events can contain the target field, multiple event names can be specified in a comma separated list. The first instance chronologically will be used.
PARAMETER: [text] Target Step - Name of the step in the above event containing the field to set
PARAMETER: [text] Target Form - Name of the form on the above step containing the field to set
PARAMETER: [text] Target Field - Name of the field to set
PARAMETER: [any] Value - The value to assign the given field. Condition syntax, such as {this} may be used.
Copy Field Value From Locked Event
 Copies the value from a form field from a locked event. The source parameters may be omitted if the triggering field is to be used as the source.
PARAMETER: [text] Target Event - Name of the event containing the field to set. If multiple events can contain the target field, multiple event names can be specified in a comma separated list. The first instance chronologically will be used.
PARAMETER: [text] Target Step - Name of the step in the above event containing the field to set
PARAMETER: [text] Target Form - Name of the form on the above step containing the field to set
PARAMETER: [text] Target Field - Name of the field to set
PARAMETER: [text] Source Event - Optional. Name of the event containing the field to pull the value from
PARAMETER: [text] Source Step - Optional. Name of the step in the above event containing the field to pull from
PARAMETER: [text] Source Form - Optional. Name of the form in the above step containing the field to pull from
PARAMETER: [text] Source Field - Optional. Name of the field to pull the value from
Set Step Required
 Changes an existing optional event step to be required.
PARAMETER: [text] The name, or list of names separated by commas, of the step(s) to become required.
Set Step Not Required
 Changes an existing required event step to be non-required.
PARAMETER: [text] The name, or list of names separated by commas, of the step(s) to make not required
Add Step
 Inserts the specified step(s) into the event. Repeat the set of 3 parameters for each step that must be added. If inserting more than one step, all 3 parameters are required for all steps.
PARAMETER: [text] The name of the step to insert. If the step does not have a custom handler, the form to attach to it must be explicitly stated. To do this, add the arrow symbol -> followed by the name of the form.
PARAMETER: [true/false]. Whether the step should be required. Defaults to false.
PARAMETER: [number]. Sort order of this step. Defaults to 65535.
Show Step
 Restores a step instance thats been hidden by hideStep.
PARAMETER: [text] The name of the step to show.
Hide Step
 Hides the specified step from the triggering event. The step is soft deleted and can be restored by showStep
PARAMETER: [text] The name of the step to remove.
Concatenate And Copy Fields
 Takes one or more fields, combines their values and places the result in another field
PARAMETER: [text] A list of comma-separated field names from the trigger fields form that should be concatenated
PARAMETER: [text] The name of the target field in which to place the final value
PARAMETER: [text] The name of the form where the target field can be found. Not needed if the target field is on the same form as the triggering field.
Set Scheduled Date
 Takes the value of this field and sets it to be the event instance scheduled date. For use on the Meeting Notice Date field.
PARAMETER: [text] The name of the event to set the schedule date of. If there are multiple instances of the event, the most recent non-locked instance will be used.
PARAMETER: [number] Offset. The number of school days past the given date
Load From Student Record
 Loads the given form field with a value from the students record
PARAMETER: [text] Name of the field to insert the value into.
PARAMETER: [text] Name of the field in the students table to get the value from.
PARAMETER: [text] Optional. Name of the form to look for the field on. If omitted, the triggering form is used.
Create Event
 Creates a followup event scheduled for the specified time. The set of 2 parameters may be repeated any number of times to instantiate multiple events simultaneously. An additional parameter of "no dependencies" can optionally be added once on the first line to bypass checks for the max concurrent and max total counts.
PARAMETER: [text] The name of the event to create
PARAMETER: [number] The number of days in the future to schedule the event
Create Event From Field Date
 Functions identically to createEvent with the exception of a third parameter representing the name of the field to base the projected date from. The field must contain a date value, to which the second parameter will be added. The name "this" may be used if the triggering field contains the desired value.
PARAMETER: [text] The name of the event to create
PARAMETER: [number] The number of days in the future to schedule the event
PARAMETER: [text] The name of the field that contains the base date for the event
Add Form To Step
 Inserts a new form instance into a step. This is mostly used for adding supplemental forms to supplement steps.
PARAMETER: [text] The name of the step to add the form to
PARAMETER: [text] The name of the form to add
Set Form Field Not Required
 Sets a form field to be required or non-required
PARAMETER: [text] Name of the event step containing the field to update
PARAMETER: [text] Name of the form containing the field to update
PARAMETER: [text] Name or id of the field to update
Set Parent Value
 Sets a value on the parents event instance record.
PARAMETER: [text] Target column - Which column in sss_event_instances will be updated
PARAMETER: [text] Value - the value to be placed in the target column. Conditions syntax may be used to get the value of other form field instances. Also, static values may be used if wrapped in quotation marks. Its evald as: eval("$value = {$code}")
PARAMETER: [text] Alternate Events - Optional. In the case where no parent event is found, this list of event names is used to locate an alternative. The most recently created among these is used.
Clear Data
 Clears user data from the given steps.
PARAMETER: [text] A comma-separated list of step names to clear
Set Student Field
 Sets a custom field for a student when a chechbox is checked. By default, the value Y is inserted into the field.
PARAMETER: [text] The name of the custom field to use (e.g. custom_123)
PARAMETER: [value] A custom value to insert into the field. If the field has a predefined set of options, the option with a code matching this value will be used. If this value is "{this}", the value of the triggering form field is used.
Set Student Log Field
 Sets a field on the most recent log entry for a particular field.
PARAMETER: [text] The name of the custom field to use (e.g. custom_123)
PARAMETER: [text] The log field column to use (e.g. log_field12)
PARAMETER: [value] A custom value to insert into the field. If the field has a predefined set of options, the option with a code matching this value will be used. If this value is "{this}", the value of the triggering form field is used. If no value is given, the field is assumed to be a checkbox that should become checked and is given the value Y
PARAMETER: [text] Optional. Whether to update the most recent log entry or to create a new one. Value of either "create" or "update". Defaults to "update". NOTE: When creating a new entry, only the one column set by this trigger will be applied. If multiple values need to be applied to this new entry, create a separate trigger for every other column with this parameter set to "update" and an order value higher than that of the trigger creating the entry.
PARAMETER: [field name] Optional. If a log entry is to be updated, an custom_field_log_entry id can be given to specify exactly which log entry to update. The id must be supplied by a named text-based form field. Only ids which belong to the given custom field and student are valid.
Sync Evaluation Tracking
 Syncs data from the Evaluation Tracking/Update ESE Logging Fields form to SIS
PARAMETER: [text] Optional. column name of the exceptionalities field in SIS (default: custom_890)
PARAMETER: [text] Optional. name of the tracking form (default: Evaluation Tracking/Update ESE Logging Fields)

Event Trigger Actions

Action Name Comment
Get Field Options
 Gets the select options for a custom student field
PARAMETER: $columnName Column name of the custom student field to check @return array Array of select options for the given field, indexed by their code
Change Student Status
 This changes the students status found on sss_students
PARAMETER: The program to change status for
PARAMETER: The new status type (all lowercase)
Determine 504Eligibility
 Sets the students status based on the conclusion made in the determination form
Determine IEPEligibility
 Sets the students status based on the conclusion made in the determination form
PARAMETER: If found not elgible, the status to use
Reject Or Activate Student
 Determines if parent gave consent and sets their sss status accordingly
Update Iep Records
 Deletes custom_field_log_entry records associated with this event instance and re-creates them using current data.
Generate Iep Records
 Generates IEP record(s) for the SIS state reporting module
Add Second Prior Written Notice
 Creates a second prior written notice event. If the first prior written notice is completed by the time this executes, the second will not be added.
Set Event To Inactive
 Changes the events status to "Inactive"
Set Event To Open
 Changes the events status to "Open"
Set Event To Completed
 Changes the events status to "Completed"
Set Event To Locked
 Changes the events status to "Locked"
Remove Step If Student Age Greater
 Removes the Transition Planning step is the student is more than 13 years old
Set Step As Required
 Sets the given step in this event to "required". If no step with this name is found, or the step is already required, nothing is done.
PARAMETER: The name of the event step to make required.
Annual Iep Review
 Creates an annual IEP review event for this student
Create Future Event
 Creates a followup event scheduled for the specified time. The set of 2 parameters may be repeated any number of times to instantiate multiple events simultaneously
PARAMETER: [text] The name of the event to create
PARAMETER: [number] The number of days in the future to schedule the event
PARAMETER: [text] Dependencies that must be met or the event will not be added
Set Step Required If Student Age Greater
 Sets the specified step to be required if the students age is greater than the given value
PARAMETER: [text] The name of the step to make required
PARAMETER: [number] The minimum age of the student
Create User Portal Alert With Link
 Sends a portal alert to the user that was added or removed from an event. Should only be used with the "user added" or "user removed" conditions. A link to this event instance is appended at the end of the message.
PARAMETER: [text] The message to display on the portal.
PARAMETER: [text] The text to display as the link.
PARAMETER: [list] A comma-separated list of user profiles who will receive this alert.
Prelock Form Completion Popup
 Displays a form for the user to complete before the event is locked.
PARAMETER: [number] Id of the form that must be completed
PARAMETER: [text] The title/prompt displayed at the top of the popup
Prelock Confirmation Popup
 Displays a confirmation prompt when attempting to lock the event. The result can optionally be stored in a form field
PARAMETER: [text] The message to display to the user
PARAMETER: [list] A list of options the user can select. Options are encoded as an array of JSON objects, e.g. [{"value": 1, "text":"Option 1"},{...}]
PARAMETER: [text] Optional. The name of the form containing the target field
PARAMETER: [text] Optional. The name of the field where the selected options value will be inserted
Pre Lock Meeting Notice
 Loads the Locked Meeting Notice form that must be completed prior to locking an IEP Meeting Notice.
PARAMETER: [Event] Optional. The name of the event containing the form with the field to populate the scheduled date field of the Locked Meeting Notice form. Defaults to "IEP Meeting Notice"
PARAMETER: [Step] Optional. The name of the step in the above event. Defaults to "IEP Team Meeting".
PARAMETER: [Form] The name of the form in the above event. Defaults to "IEP Meeting Notice"
PARAMETER: [FormField] The name of the field on the above form containing the data for the scheduled date field. Defaults to "meetingdate"
PARAMETER: [Form] Optional. The name of the form to use in place of Locked Meeting Notice.
PARAMETER: [text] Optional. The title/prompt displayed at the top of the popup
Alert On Form Date Trigger Setup
 Creates a user alert on the date in a form field. When triggered, the specified fields value will be taken and, if the value is a date, the action will be queued to run again on that date. The alert is created at that time.
PARAMETER: [text] The name of the form containing the field
PARAMETER: [text] The name of the field with the date value
PARAMETER: [text] The content of the alert
PARAMETER: [text] Optional. The text appearing as the link to the triggering event
Copy Event Prompt
 Displays a prompt to copy the event instance to another program before it is locked.
PARAMETER: [text] A list of the programs that the event may be copied to, separated by commas. Possible values are "sped", "504" and "rti"
Copy Field Value From Event
 Copies the value from a form field from a different event.
PARAMETER: [text] Target Event - Name of the event containing the field to set
PARAMETER: [text] Target Step - Name of the step in the above event containing the field to set
PARAMETER: [text] Target Form - Name of the form on the above step containing the field to set
PARAMETER: [text] Target Field - Name of the field to set
PARAMETER: [text] Source Event - Name of the event containing the field to pull the value from
PARAMETER: [text] Source Step - Name of the step in the above event containing the field to pull from
PARAMETER: [text] Source Form - Name of the form in the above step containing the field to pull from
PARAMETER: [text] Source Field - Name of the field to pull the value from
Remove Step
 Deletes the given step and all associated data. NOTE: This does not work with custom steps currently
PARAMETER: [text] Step Name - Name of the step to delete
Create Future IEP
 Creates a projected IEP event. If the student already has an initial IEP, an annual IEP will be created instead
PARAMETER: [number] The number of days in the future to project the IEP
Clone IEP
 Looks for the most recent Initial or Annual IEP event and makes the triggering event instance a clone of it
PARAMETER: [number list] A comma separated list of event ids to look for when choosing an event to clone (Initial IEP and Annual IEP ids)
Add Step
 Inserts the specified step(s) into the event. Repeat the set of 3 parameters for each step that must be added. If inserting more than one step, all three parameters are required for all steps.
PARAMETER: [text] The name of the step to insert. If the step does not have a custom handler, the forms to attach to it must be explicitly stated. To do this, add the arrow symbol -> followed by a comma-delimited list of form ids.
PARAMETER: [true/false]. Whether the step should be required. Defaults to false.
PARAMETER: [number]. Sort order of this step. Defaults to 65535.
Add No Forms Step
 Inserts the specified step(s) into the event. Repeat the set of 3 parameters for each step that must be added. If inserting more than one step, all three parameters are required for all steps.
PARAMETER: [text] The name of the step to insert. If the step does not have a custom handler, the forms to attach to it must be explicitly stated. To do this, add the arrow symbol -> followed by a comma-delimited list of form ids.
PARAMETER: [true/false]. Whether the step should be required. Defaults to false.
PARAMETER: [number]. Sort order of this step. Defaults to 65535.
Create Future Event With Consent
 Creates a followup event scheduled for the specified time ONLY if parent consent has been given. The set of 2 parameters may be repeated any number of times to instantiate multiple events simultaneously
PARAMETER: [text] The name of the event to create
PARAMETER: [number] The number of days in the future to schedule the event
Disable Uploads
 Removes the automatic uploads step on the event. No parameters.
Run Action With Consent
 Executes another event trigger action if the student has parent consent
PARAMETER: [function] The name of another event trigger action
PARAMETER: The parameters for the other action to be executed
Run Form Trigger Action
 Runs a form trigger action
PARAMETER: [text] Triggering field name - The name of the field thats activating this trigger
PARAMETER: [text] Triggering form - The name of the form the triggering field is found on
PARAMETER: [text] Condition - Form trigger condition to determine whether to fire
PARAMETER: [text] Action - The action to run if the trigger fires
PARAMETER: [array] Parameters - List of parameters to pass to the action. One parameter per line
Check Logging Field Complete
 Checks whether the sss_logging_fields record associated with this event instance to complete
Push Form To Logging Entry
 Pushes a forms data into a student log entry record. Form fields are linked to logging fields by their name. The name must match the column in student_log_entries (e.g. log_field3). If multiple fields have the same column name, the latter will be used.
PARAMETER: [text] Name of the form
PARAMETER: [number] Id of the logging field
Set Event Field With Form Field
 Sets a field of the given event instance.
PARAMETER: [text] Target event name. The name of the event to update. The event instance must match the student and scheduled date of the triggering event. Use "this" to indicate the triggering event should be updated
PARAMETER: [text] Source event name. The name of the event to pull the field value from. Use "this" for the triggering event
PARAMETER: [text] Name of the form containing the field with the desired value
PARAMETER: [text] Name of the field containing the value
PARAMETER: [text] Name of the field to update on the target event instance
Project Summary Report From Consent Date
 Projects an FIE Summary Report 45 school days after the date of parental consent.
Execute Code
 Executes arbitrary PHP code
PARAMETER: [text] PHP code to execute. Multiple lines may be used.
Push Held Log Entry
 Pushes the StudentLogEntry object serialized in sss_event_logs.hold_data to the student_log_entries table. If the triggering event isnt linked to an sss_event_logs record, or if hold_data is not a valid StudentLogEntry object, nothing is done.
Risd_medical Reason To Supplement
 Maps RISDs clinic visit reasons to supplements.
Clone From Existing Event
 Makes the triggering event instance a clone of another event
PARAMETER: [list] Comma separated list of event names that can be the source of the clone data. The events are checked in order and only the first instance found will be used as the source.
PARAMETER: [text] Optional. Status requirement. Restricts the source event to have a particular status (e.g. locked)
Initialize Form From Instance
 Looks for a form instance and populates the instance of that form in the current event with the same data, effectively cloning the form.
PARAMETER: [text] Name of the form that will be cloned. This form must exist on both the source and target events.
PARAMETER: [list] Comma-delimited list of names of the events potentially containing the source form
PARAMETER: [text] Optional. The required status of the source forms event
Sync Schedule Of Services
 Alias for Update ESE Minutes
Sync Transportation Code
Push Participation In State District Assessment
 Pushes data from the Participation in State District Assessment form to SIS fields
PARAMETER: [boolean] "true" or "false", whether the event is an amended IEP
PARAMETER: [text] Optional. Name of the form to use in place of Participation in State District Assessments_rev
PARAMETER: [text] Optional. Name of the form to use in place of Demographics and Student Desired Outcomes_rev
Vcs PSDAG
 VCS SSS/SIS Mapping CR #6 & #10. Implements field mapping requested by Volusia for the form VCS: Participation in State District Assessments. No parameters are needed
Vcs Copy Services
 VCS SSS/SIS Mapping CR #8 Sets logging fields related to transportation codes
PARAMETER: [text] The column name of the student logging field to transfer data to
PARAMETER: [true/false] Optional. Whether to delete existing records in the SIS student logging field. Defaults to true.
Vcs ESEGifted Tracking
Update ESEFields
 VCS SSS/SIS Mapping CR #9.
Vcs Spin Worksheet
 VCS SSS/SIS Mapping CR #11.
Vcs Update Matrix Cost Factor
Update Ese Minutes
 Updates the fields Total Student Week and Time With Non-Disabled Peers based on times specified in Schedule of Services. Takes no parameters.
Hide Step
 Hides the specified step from the triggering event. The step is soft deleted and can be restored by showStep
PARAMETER: [text] The name of the step to remove.
Show Step
 Restores a step instance thats been hidden by hideStep.
PARAMETER: [text] The name of the step to show.
Execute SQL
 Executes an arbitrary SQL query. Valid replacements are: {date}, {school_id}, {syear} {marking_period_id}, {current_staff_id}, {event_instance_id} and {student_id}
PARAMETER: Optional. The name of the form to associate with this query. Must begin with "form: ".
PARAMETER: [text] The text of the SQL query to execute. This parameter may span multiple lines.
SSS to SIS State Reportable Fields Crosswalk & the Process that Pushes this Info
Form or Custom Screen Field Name on Form Field Name Table Custom Field Number Default Extract Logic Focus Process


District Number
 SCHOOLS
 CUSTOM_100000001
If Distirct(Out of District) STUDENT_ENROLLMENT.CUSTOM_16 is not blank, use CUSTOM_16.


School Number
 SCHOOLS
 CUSTOM_327
If School(Out Of District) STUDENT_ENROLLMENT.CUSTOM_17 is not blank, use CUSTOM_17.
Participation in State District Assessments_rev
 FSAA_type
 Alternative Assessment Administered
 STUDENTS
 CUSTOM_791
 Student will take statewide FSA or other districtwide assessment, or in grade/course where assessment not administered
 If survey is not equal to 2 or 3, or student has primary exceptionality of L, output Z.
 Event Trigger Action:Push Participation In State District Assessment


Exceptional Student, 60-Day Exception
 STUDENTS
 CUSTOM_200000022
 There was no exception/extension beyond the 60-day timeline for completion of the initial evaluation. [N]
 If blank and syear is less than or equal to 2011-2012 output Z.


Florida Education Identifier
 STUDENTS
 CUSTOM_200000224
If blank, output FL000000000000.


Florida Student Number
 STUDENTS
 CUSTOM_159
If blank, output 0000000000.
ESE/Gifted Updating & Reporting
 gifted_elig
 Gifted Eligibility
 STUDENTS
 STUDENTS
 Student was not determined eligible or determined eligible before July 1, 2009
 If blank output default.
 Event Trigger on Event: ESE/Gifted Updating & Reporting
Demographics and Student Desired Outcomes_rev
 iep_plandate
 IEP/EP Plan Date
 STUDENTS
 CUSTOM_873
If blank, output 00000000.
 Event Trigger on Event: IEP Event


Local Student ID
 STUDENTS
 CUSTOM_53
If not turned on via config file, output blank.
Schedule of Services
IDEA Educational Environment
 STUDENTS
 CUSTOM_863
 Age 0-2, Gifted only, non above (deflt)[Z]
 If survey is not equal to 2, or student has primary exceptionality of L, output Z.
 Schedule Job - Synchronize Schedule of Services
Schedule of Services
Time, Total Student Week
 STUDENTS
 CUSTOM_878
If survey is not equal to 2, or student has primary exceptionality of L and student has no other exceptionalities, output 0000.
Schedule of Services
Time, With Non-Disabled
 STUDENTS
 CUSTOM_879
If survey is not equal to 2, or student has primary exceptionality of L and student has no other exceptionalities, output 0000.
ESE/Gifted Updating & Reporting
 log_field3
 Primary Exceptionality
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD3
If blank use field defaults, if no defaults, output Z.
 Event Trigger on Event: ESE/Gifted Updating & Reporting

dimissal_date
 Dismissal Date
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD12
If survey does not equal 5, or field is blank output 0000000.

log_field5
 Placement Status
 Placement Status
 LOG_FIELD5
If blank use field defaults, if no default is set, output Z.

request_purpose
 Referral Reason
 CUSTOM_FIELD_LOG_ENTRIES
 CUSTOM_FIELD_LOG_ENTRIES
If survey is not equal to 5, output Z. Otherwise, if blank use field defaults, if no default is set, output Z.

last_eval
 Completion Date
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD9
If field is blank, output 00000000.

log_field11
 Placement Date
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD11
If field is blank, output 00000000.

elig_date
 Eligibility Determination Date
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD10
If field is blank, output 00000000.

date_consent_received
 Date of Consent for Evaluation
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD8
If field is blank, output 00000000.
Matrix of Services- Student Information and Eligibility
 costfactor2
 FEFP code
 STUDENTS
 CUSTOM_698

Schedule Job - Update Cost Factor From Matrix of Services