Documentation for Administrators

Import Peer Data

Updated on

The Import Peer Data screen allows users to test out the importation of PEER data before, during, and after scheduling the "Florida Peer Nightly import" scheduled job.

The PEER Integration process takes what is at the state level, imports that data into Focus background tables, and populates this data for the appropriate fields in a given student’s profile. This data is supplied to the district by being placed in your district’s PEER/OUT folder by FLDOE.

It is important to ensure that Focus is up to date on this information so that the district is providing the appropriate accommodations to their students in need of accommodations, as well as accurate data for state reporting.

It is important that the district review the following settings in Florida Reports > Florida Reports Setup > District Options:

1. PEER Import - Allow PEER import to update the Focus database when the PEER file contains a zero or NULL. (Does NOT apply to date fields)

2. PEER Import - Exclude Expired Accommodations on Active IEPs

3. PEER Import - Select which elements Peer Nightly Job will import, left blank ALL elements will import

Expand or collapse content Peer Integration Information

There are a total of 15 PEER related fields that are populated in Focus based on the PEER data supplied by FLDOE during this import process.

  • Students should be currently active and not primarily enrolled at one of the following schools: 3518, 3900, 9997, YYYY, WWWW, 9995, TRAN.
  • The import for the logging fields below will insert any new records, and if the log record in Focus is no longer present in the PEER file, that log record will be deleted.

Non-State Reportable Fields:

  • Touched during PEER Import but not used in State Reporting.
  • 11 fields total, 6 which are logging fields

State Reportable Fields:

  • Imported from PEER and used in FLDOE State Reporting survey periods.
  • 4 total fields
  • The only other restriction on importing is for custom_878, custom_879, custom_863 to import; ‘Time, With Non-Disabled’ (custom_879) must NOT be blank.
FOCUS | PEER Integration Overview - Google Docs

Student Field Imports:

Students should be currently active and not primarily enrolled at one of the following schools: 3518, 3900, 9997, ZZZZ, YYYY, WWWW, 9995, TRAN. For a successful import including Time, With Non-Disabled, the last three fields from the list below must not be blank:

  • IEP/EP Plan Date (STUDENTS.CUSTOM_873)
  • IEP/EP Expiration Date (STUDENTS.CUSTOM_940)
  • Time, Total Student Week (STUDENTS.CUSTOM_878)
  • Time, With Non-Disabled (STUDENTS.CUSTOM_879)
  • IDEA Educational Environment (STUDENTS.CUSTOM_863)
Expand or collapse content Peer Integration Set Up

1. In the Setup menu, click Manage Integrations.

This integration sends reporting format data (Student Demographic Information, Student Course Schedule, Teacher Course Schedule, Staff Demographic Information) to FLDOE, as this data is needed for them to create and process the PEER file that is provided back to the district in their PEER/OUT folder.

2. If this integration has not yet been installed you will need to click *Install, then click Install next to PEER.

Manage Integrations

3. Ensure that you go through the full process of setting up this integration as the upcoming steps depend on this integration.

See Manage Integrations for more information.

Expand or collapse content Import Peer Data

Running the job from this screen is virtually identical to running it from Setup > Scheduled Jobs.

1. From the Florida Reports menu, click Import Peer Data.

Import Peer Data

Focus requires the district’s DOE SSO SFTP credentials and must whitelist IP addresses with PEER to enable this process.

Click Show Logs; if there happens to be an issue, like missing the SFTP username and/or password, running the process from this screen will help identify the issue.

Files will not be available if they have not been requested through emailing PEER at [email protected] .

2. Select the Don't Fetch Files From SFTP check box so files from the SFTP are not pulled upon running the test which will speed up the process as it will run the import against the data that was last downloaded.

Leave the Don't Fetch Files From SFTP check box cleared (unselected) to download the latest files on the FTP site, load the peer tables, and update the student fields. If the files have already been retrieved from the PEER server they are locally stored on the Focus server and can be “reused.”

Import Peer Data

3. Click Import Data if the Don't Fetch Files From SFTP check box is selected. Click Download & Import Data if the check box is not selected.

Import Peer Data

Once tested, the screen displays the Table along with the Rows Imported and the Seconds Took.

Peer Integration Overview.pdf

The integration pulls the latest files from the SFTP site, if the Don't Fetch Files From SFTP check box isn't selected. Then, the data is imported into the background tables referenced in the screenshot. The job then imports the data into Focus.

Peer Integration Overview.pdf

There are 4 separate accommodation log fields, one for assessment and one for classroom for both 504 & ESE. They are located on the ESE tab by default. When the data is imported, the process does check that the same accommodation doesn't exist in the log field currently before importing.

Expand or collapse content Setting the "Florida Peer Nightly Import" Scheduled Job

1. In the Setup menu, click Scheduled Jobs.

2. Select Florida Peer Nightly Import from the provided pull-down.

Scheduled Jobs

3. Click Create Job.

4. Complete the applicable fields needed to create the scheduled job, and click Save.

Scheduled Jobs

The Execution History tab shows logs of when the scheduled job ran and whether it was successful or not.

FOCUS | PEER Integration Overview - Google Docs

See Scheduled Jobs for more information.

Expand or collapse content PEER Mapping
Expand or collapse content FL_PEER_ACTIVE_EPS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
ActiveEPs.csv
ammendment_date
No UI Field - stored in fl_peer_active_eps only

district_id
No UI Field - value is set during import

ep_end_date
STUDENTS.CUSTOM_940

ep_start_date
STUDENTS.CUSTOM_873

initiation_date
No UI Field - stored in fl_peer_active_eps only

local_id
STUDENTS.CUSTOM_53

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_ACTIVE_IEPS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
ActiveIEPs.csv
aice
No UI Field - stored in fl_peer_active_ieps only

ammendment_date
No UI Field - stored in fl_peer_active_ieps only

assessment_type
No UI Field - stored in fl_peer_active_ieps only

diploma_designation
No UI Field - stored in fl_peer_active_ieps only

district_id
No UI Field - value is set during import

esy_services
STUDENTS.CUSTOM_256

graduation_option
No UI Field - stored in fl_peer_active_ieps only

ib
No UI Field - stored in fl_peer_active_ieps only

iep_end_date
STUDENTS.CUSTOM_940

iep_start_date
STUDENTS.CUSTOM_873

initiation_date
No UI Field - stored in fl_peer_active_ieps only

local_id
STUDENTS.CUSTOM_53

other_exceptionalities
No UI Field - stored in fl_peer_active_ieps only

primary_exceptionality
No UI Field - stored in fl_peer_active_ieps only

reeval_due_date
No UI Field - stored in fl_peer_active_ieps only

review_due_date
No UI Field - stored in fl_peer_active_ieps only

special_diploma_type
No UI Field - stored in fl_peer_active_ieps only

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_ACTIVE_SERVICE_PLANS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
ActiveSPs.csv
ammendment_date
No UI Field - stored in fl_peer_active_service_plans only

district_id
No UI Field - value is set during import

duration_date
STUDENTS.CUSTOM_940

initiation_date
No UI Field - stored in fl_peer_active_service_plans only

local_id
STUDENTS.CUSTOM_53

meeting_date
STUDENTS.CUSTOM_873

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_ACTIVE_504_PLANS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
ActiveSec504Plans.csv
district_id
No UI Field - value is set during import

local_id
STUDENTS.CUSTOM_53

meeting_date
No UI Field - value stored in fl_peer_active_504_plans only

original_meeting_date
No UI Field - value stored in fl_peer_active_504_plans only

syear
No UI Field - value is set during import

temp_plan_start_date
No UI Field - value stored in fl_peer_active_504_plans only

temp_plan_end_date
No UI Field - value stored in fl_peer_active_504_plans only

Expand or collapse content FL_PEER_ASSESSMENT_ACCOMMODATIONS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
IEPAssessmentAccommodations.csv
accommodation
STUDENTS.CUSTOM_200000262_LOG_FIELD3

accommodation_type
STUDENTS.CUSTOM_200000262_LOG_FIELD1

district_id
No UI Field - value is set during import

iep_end_date
STUDENTS.CUSTOM_200000262_LOG_FIELD2

initiation_date
No UI Field - stored in fl_peer_assessment_accommodations only

local_id
STUDENTS.CUSTOM_53

primary_exceptionality
No UI Field - stored in fl_peer_assessment_accommodations only

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_CLASSROOM_ACCOMMODATIONS
Database FieldUser Interface (UI) FieldPEER File
idNo UI Field - value is set during import
IEPClassroomAccommodations.csv
accommodation
STUDENTS.CUSTOM_200000261, LOG_FIELD2

accommodation_type
STUDENTS.CUSTOM_200000261, LOG_FIELD1

district_id
No UI Field - value is set during import

duration_date
STUDENTS.CUSTOM_200000261, LOG_FIELD3

frequency
STUDENTS.CUSTOM_200000261, LOG_FIELD4

initiation_date
STUDENTS.CUSTOM_200000261, LOG_FIELD6

local_id
STUDENTS.CUSTOM_53

location
STUDENTS.CUSTOM_200000261, LOG_FIELD5

primary_exceptionality
No UI Field - stored in fl_peer_classroom_accommodations only

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_IEP_LRE
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
IEPLRE.csv
district_id
No UI Field - value is set during import

duration_date
STUDENTS.CUSTOM_200000261, LOG_FIELD3

early_childhood_program
No UI Field - stored in fl_peer_iep_lre only

initiation_date
No UI Field - stored in fl_peer_iep_lre only

local_id
STUDENTS.CUSTOM_53

setting
STUDENTS.CUSTOM_863

syear
No UI Field - value is set during import

time_non_disabled_peers
STUDENTS.CUSTOM_879

total_time
STUDENTS.CUSTOM_878

Expand or collapse content FL_PEER_MATRIX_SERVICES
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
MatrixOfServices.csv
cost_factor
STUDENTS.CUSTOM_200000273

date_completed
STUDENTS.CUSTOM_200000274

district_id
No UI Field - value is set during import

domain_a
No UI Field - Stored in fl_peer_matrix_services only

domain_b
No UI Field - Stored in fl_peer_matrix_services only

domain_c
No UI Field - Stored in fl_peer_matrix_services only

domain_d
No UI Field - Stored in fl_peer_matrix_services only

domain_e
No UI Field - Stored in fl_peer_matrix_services only

fefp_number
STUDENTS.CUSTOM_200000293

local_id
STUDENTS.CUSTOM_53

other_exceptionalities
No UI Field - Stored in fl_peer_matrix_services only

primary_exceptionality
No UI Field - Stored in fl_peer_matrix_services only

review_dates
No UI Field - Stored in fl_peer_matrix_services only

special_considerations
No UI Field - Stored in fl_peer_matrix_services only

syear
No UI Field - value is set during import

total_ratings
STUDENTS.CUSTOM_200000272

Expand or collapse content FL_PEER_504_ASSESSMENT_ACCOMMODATIONS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
Sec504AssessmentAccommodations.csv
accommodation
STUDENTS.CUSTOM_200000264_LOG_FIELD3

accommodation_type
STUDENTS.CUSTOM_200000264, LOG_FIELD1

district_id
No UI Field - value is set during import

local_id
STUDENTS.CUSTOM_53

primary_exceptionality
No UI Field - Only used in TEMP table, not imported into actual table

start_date
No UI Field - stored in fl_peer_504_assessment_accommodations only

syear
No UI Field - value is set during import

temp_plan_end_date
STUDENTS.CUSTOM_200000264, LOG_FIELD2

Expand or collapse content FL_PEER_504_CLASSROOM_ACCOMMODATIONS
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
Sec504PlansGeneralClassroomAcc-Services.csv
accommodation
STUDENTS.CUSTOM_200000263, LOG_FIELD4

area_of_concern
STUDENTS.CUSTOM_200000263, LOG_FIELD1

district_id
No UI Field - value is set during import

local_id
STUDENTS.CUSTOM_53

persons_responsible
STUDENTS.CUSTOM_200000263, LOG_FIELD2

start_date
No UI Field - stored in fl_peer_504_classroom_accommodations only

syear
No UI Field - value is set during import

temp_plan_end_date
STUDENTS.CUSTOM_200000263, LOG_FIELD3

Expand or collapse content FL_PEER_IEP_ESY_SERVICE
Database FieldUser Interface (UI) FieldPEER File
duration_date
STUDENTS.CUSTOM_200000275, LOG_FIELD2
IEPESYService.csv
esy_service
STUDENTS.CUSTOM_200000275, LOG_FIELD5

frequency
STUDENTS.CUSTOM_200000275, LOG_FIELD3

initiation_date
STUDENTS.CUSTOM_200000275, LOG_FIELD1

local_id
STUDENTS.CUSTOM_53

location
STUDENTS.CUSTOM_200000275, LOG_FIELD4

primary_exceptionality
No UI Field - stored in fl_peer_iep_esy_service only

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_IEP_TRANSPORTATION_FTE
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
IEPTransportationFTE.csv
description
STUDENTS.CUSTOM_200000305, LOG_FIELD4

district_id
No UI Field - value is set during import

end_date
STUDENTS.CUSTOM_200000305, LOG_FIELD2

local_id
STUDENTS.CUSTOM_53

start_date
STUDENTS.CUSTOM_200000305, LOG_FIELD1

syear
No UI Field - value is set during import

transportation_code
STUDENTS.CUSTOM_200000305, LOG_FIELD3

Expand or collapse content FL_PEER_IEP_SUPP_AIDS_SERVICES
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
IEPSuppAidsServices.csv
district_id
No UI Field - value is set during import

duration_date
No UI Field - stored in fl_peer_iep_supp_aids_services only

frequency
No UI Field - stored in fl_peer_iep_supp_aids_services only

initiation_date
No UI Field - stored in fl_peer_iep_supp_aids_services only

local_id
STUDENTS.CUSTOM_53

location
No UI Field - stored in fl_peer_iep_supp_aids_services only

primary_exceptionality
No UI Field - stored in fl_peer_iep_supp_aids_services only

service
No UI Field - stored in fl_peer_iep_supp_aids_services only

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_IEP_ESE_SERVICE
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
IEPESEService.csv
district_id
No UI Field - value is set during import

duration_date
STUDENTS.CUSTOM_200000311, LOG_FIELD2

frequency
STUDENTS.CUSTOM_200000311, LOG_FIELD3

initiation_date
STUDENTS.CUSTOM_200000311, LOG_FIELD1

local_id
STUDENTS.CUSTOM_53

location
STUDENTS.CUSTOM_200000311, LOG_FIELD4

primary_exceptionality
No UI Field - stored in fl_peer_iep_ese_service only

service
STUDENTS.CUSTOM_200000311, LOG_FIELD5

syear
No UI Field - value is set during import

Expand or collapse content FL_PEER_STUDENT_INFO
Database FieldUser Interface (UI) FieldPEER File
id
No UI Field - value is set during import
PEERStudentInfo.csv
district_id
No UI Field - value is set during import

grade
No UI Field - stored in fl_peer_student_info only

local_id
STUDENTS.CUSTOM_53

school_num
No UI Field - stored in fl_peer_student_info only

school_title
No UI Field - stored in fl_peer_student_info only

syear
No UI Field - value is set during import

url
No UI Field - stored in fl_peer_student_info only

Previous Article EOY Processing
Next Article FES Enrollment/Scheduling Process