FL Staff Demographic Information
Overview
The Department of Education (DOE) conducts surveys of school district student and staff information at scheduled survey times during the reporting year. The Staff Demographic report includes all instructional staff members. Fields required to be reported are: District Number, Social Security Number, Survey Period Code, Fiscal Year, School Number, Primary Home, Employee Name, and Exempt from Public Records Law. Data may be sent for other fields, but the data is not required and default values will be loaded to the database for the non-required elements. Data for the Staff Number Identifier data element will be used if reported.
Report Frequency
Survey Periods | Survey Time |
1 | July |
2 | Oct |
3 | February |
4 | June |
5 | End of Year |
8 | July |
Selection Criteria
For each Survey Period, the Staff Demographic report will select all other employees with at least one pay assignment that is active during the “As of” Pay Period between the “As of” Start and the “As of” End date, with the Pay Assignment Calc Start Date on or before the “As of Date” on the report instance, and a Calc End Date on or after the “As of Date” on the report instance. Employees with a payroll status of “I” (Inactive) are not reported.
BusinessPLUS Setup
When establishing the employee ID, it is recommended the length be set at a maximum of 10 characters. The Staff Survey will pass back any ID that has issues. On the Addr Info tab of the HR Employee Information (HREMEN/HREEEM) page, set the Public/Private field to “PRIV” if the employee or the employee’s spouse is exempt from public record. Employees with all other values in the Public/Private field will be reported as “Not Applicable” for the Exempt from Public Record data item.
Setup
Before a report can be generated, the reporting interface must be accessed and necessary data setup completed. This configuration information is used by the Load and Submission processes.
Note: For detailed information about the report screens/tabs, see the “Overview of Regulatory Reporting” document. This document explains the items in common for all reports.
The following options need to be configured under Setup menu:
· Site Profile
· Crosswalk
· Code Value
· Additional Setup
Site Profile
Click Site Profile to define the entities and their details. This information is used by the Load and Submission processes for the defined entities. At least one Site Profile record is required. All of the Florida regulatory reports utilize this same table, so data will rarely need to be changed once it has been entered.
To add details about a site, enter data in the fields as described below.
Field | Description |
Entity* | ID of the entity/employer. The entity should be a valid entry as defined in BusinessPLUS. Once saved, the value cannot be changed. |
Employer Name* | Name of the employer for whom the entity is defined. |
Employer Address* | First line of the employer’s address. |
Employer Address (2) | Second line of the employer’s address. |
Employer City* | City in which the employer is located. |
Employer State* | State in which the employer is located. Click for the list of states. |
Employer Zip Code* | Numeric zip code of the employer’s location. This field accepts only five numeric characters and does not accept if all the five characters are zeroes. |
Employer Zip Code Extension | Numeric zip code extension of the employer’s location. This field accepts only numeric characters of 4 digits or less. |
Department of Education District Number* | Numeric District Number assigned by the Department of Education. |
Note: Columns marked with * are required fields.
Crosswalk
The Crosswalk page provides the ability to map code values between the finance system and the regulatory report requirements.
The predefined code items appear as a list when the crosswalk screen is loaded. For this report, the crosswalk is used to associate the BusinessPLUS location codes with the FL Department of Education school numbers. If the BusinessPLUS location codes are the Department of Education school numbers, there is no need to make an entry in this table.
Code Value
Click Code Value to define valid codes. Codes that are defined on this page can be used on the Maintenance page.
Additional Setup
Click Additional Setup to define the entity’s optional details. This information is used by the Load and Submission processes.
To add details about a site, enter data in the fields as described below.
Field | Description |
Entity* | ID of the entity/employer. The entity should be a valid entry as defined in BusinessPLUS. Once saved, the value cannot be changed. |
FLDOE Primary Pay Assignment Record Type(s) | Enter a comma-separated list of the record types that are used to identify primary pay assignments of employees to be reported. |
Include the Employee ID as local ID? | If this flag is set to “Y”, the Employee ID from BusinessPLUS will be included on the file as the local ID. This will allow FLDOE to use the Employee ID instead of the social security number on all error reports. |
Note: Columns marked with * are required fields.
Instance
Click Instance to configure the report instances for each report to be created. Report instances need to be configured for the extract process.
Enter data in the fields of this window as described below.
Field | Description |
Name* | User-defined name of the report instance. |
Survey Period* | Survey Period to which this report instance applies. Once the instance is created and saved, the Survey Period value cannot be changed. |
Fiscal Year* | Fiscal Year for which submission will occur – “YYYY-YYYY” format. |
‘As of’ Start Date* | Survey Start Date – “MM/DD/YYYY” format. This date will be used to select the primary pay assignments that are active on this date, in determining which employees to include on the report. Once the instance is created and saved, the “As of” Start Date value cannot be changed. |
‘As of’ End Date* | Survey End Date – “MM/DD/YYYY” format. Once the instance is created and saved, the “As of” End Date value cannot be changed. |
Note: Columns marked with * are required fields.
Load
Click Load to extract and load the Demographic records into the Maintenance table. See the Submission File Layout for the source of the reported data.
To load data for an instance of a report, enter data in the fields as described below.
Field / Button | Description |
Report Instance* | Click for the list of report instances. Select the desired report instance. |
Status | Displays the current status as assigned in the Report Instance screen. This is a display-only field. |
Notes | Enter a note related to report instance or load that is to be performed. |
Entity* | Click to select a specific entity for which the load will be performed. Select “ALL” to extract records of all entities. |
Employee ID(s) | If specific IDs are to be refreshed or reported on, enter on this line, separated by commas. |
Purge Existing Data | If all the existing Maintenance table data, for the selected Report Instance, needs to be deleted this checkbox should be checked. This action would also remove new Maintenance records added previously using the Maintenance screen. |
Load (Button) | Click to load records into Maintenance table. |
Note: Columns marked with * are required fields.
After clicking Load, the Information window appears to indicate that the Load Process has begun. Click the “OK” button to proceed.
The selected report instance details appear as described below.
Field | Description |
Report Instance Details | Details of the selected Report Instance. |
Last Load for the Selected Report Instance | The date (Last Load) and user (Created By) who performed the last load and any note entered for the selected Report Instance. If the report is loaded for the first time for the selected Report Instance, this information is blank. |
Maintenance
Click the Maintenance tab to view Load Process results by Survey Period. The load will include any generated errors. Data manipulation is allowed on the extracted employee data.
The following actions are available:
· Data changes (to data extracted from the report instance into the Maintenance table)
· Adding records
· Deleting records
Select Report or Specific Records
Field | Description |
Report Instance | Click to select a specific instance. |
Filter By Criteria | Filter the Maintenance records based on Employee ID or Employee Last Name. Clear fields to view all the results. |
Total Record Count | Indicates the total number of Maintenance records in the grid. |
Possible Error & Warning Messages
The grid at the bottom of the Maintenance page displays error messages logged during the load extract/submission package execution. The submission errors include invalid/missing mandatory field values. These values can be corrected by selecting the record from the error log grid and clicking on the “Filter Selected Record” checkbox although the long-term data fix would need to occur in BusinessPLUS or the report setup type screens. On clicking this option, only the invalid record is filtered in the Maintenance grid, which can then be corrected and saved. On click of “View All Records”, all the Maintenance records are displayed on the maintenance grid.
Error Log Viewer is the list of possible error/warning messages displayed on the “Error Log” section in the Maintenance window. How to resolve the errors is also provided. The Error/Warning Messages are described below.
Type | Error / Warning Message | Resolution |
---|---|---|
Load | <EMP ID>: has invalid(blank) Last Name | Correct/enter the employee’s Last Name. |
Load | <EMP ID>: Last Name has been truncated to 17 characters | Verify the employee’s Last Name; Submission file only supports 17 characters. |
Load | <EMP ID>: has invalid(blank) First Name | Correct/enter the employee’s First Name. |
Load | <EMP ID>: has invalid(blank) SSN | Correct/enter the employee’s SSN. |
Load | <EMP ID>: has invalid School Number - not in Crosswalk or Code Value table | Correct the employee’s primary location. |
Load | <EMP ID>: has invalid(blank) School Number | Correct/enter the employee’s primary location. |
Load | <EMP ID>: has invalid(blank) Staff Number Identifier |
|
Load | <EMP ID>: has invalid(blank) Transaction Code - setting to 'A' | Verify the Transaction Code. Valid entries are “A” - Add, “C”- Change or “D” - Delete. |
Load | <EMP ID>: has invalid(blank) Exempt from Public Records Flag - setting to ‘Z’ | Verify Exempt from Public Records Flag. Valid values are: “Z” - Not Applicable or “Y” - Exempt from Public Records Law. |
Load | EMP ID: has invalid Worksite XXX not in crosswalk or code value table | Correct the employee’s primary location in BusinessPLUS and reload the employee or update the School Number in Maintenance |
Notes:
· “Load” indicates the message appears during the Load Process, on the bottom of the Maintenance screen
· “Sub” indicates the message appears on the Submission report
· The report instances drop-down list is loaded only with report instances for which load has happened.
· Inserting and deleting records are not allowed if there are unsaved changes in the grid.
· If there are unsaved changes in the grid, sorting and filtering of the grid are disabled.
· If there are unsaved changes in the grid, a prompt to save the existing changes will be shown, if trying to navigate to another screen.
Submission
After verifying the Maintenance data, click Submission to create the file to be submitted to the reporting agency.
To create a report file for submission, data is entered in the fields as described below.
Field / Button | Description |
---|---|
Report Instance* | Click for the list of report instances. Choose the report instance which is to be submitted. |
Notes | Any notes applicable to the submission job. |
Filename* | System generated or user defined file name for the submission file. The filename should always end with the ‘.txt’ extension. The filename cannot contain these characters ‘\:/*?”<>|’ Note: The path where the file is saved is already configured in the application and should not be entered here. In some reports the report name is auto-generated and hence the text filename cannot be changes for such reports. Example: DPS18.GU.F61025.Y10118 |
Entity* | Click for the list of entities. If the maintenance records for all the entities are to be submitted, then “ALL” should be selected. |
Report Instance Details | Details for the selected Report Instance. |
Last Submission for the Selected Report Instance | The date (Last Submission) and user (Created By) who performed the last submission and the note that was entered for submitting the selected Report Instance. The first time the Submission Process is run for the selected Report Instance, this information is blank. |
Double Arrow (Button) | Regenerate the filename. |
Generate Report (Button) | Create report file with data from Maintenance table. |
View Report (Button) | View the submission file report. |
Notes:
· Columns marked with * are required fields. The user must enter data in these fields to proceed.
· Only if the Load is performed on the report instance, the report instance will appear in the Report Instance drop-down list.
· If the mandatory fields are empty or have an invalid value, an error is logged which can be corrected from the Maintenance screen.
Submission File Layout
The following table shows the field numbers, field names, and source within BusinessPLUS.
Position | Field | Req | Type | Size | Source Table | Source Column | Description/Business Logic |
---|---|---|---|---|---|---|---|
1-2 | District |
| N/R | 2 | rr_site_profile | district_no | |
3-12 | Social Security Number* |
| A/N/L | 10 | hr_empmstr | ssn | The number assigned to an individual by the Social Security Administration (left justified). |
13-13 | Survey Period Code* |
| N | 1 | rr_run_def_mstr | survey_period | The survey period defined for the report instance. |
14-17 | Fiscal Year* |
| N | 4 | rr_run_def_mstr | fiscal_year_extd | Fiscal Year from the report instance - abbreviated. |
18-21 | School Number, Primary/Home |
| N/R | 4 | hr_empmstr | worksite | The state assigned four-digit school number (0001-9899) which indicates the primary administrative reporting unit to which the individual is assigned. For staff members who operate out of the county office, the school number to be used in this field is 9001. A crosswalk can be set up to map the employee's primary location (hr_empmstr.worksite) in BusinessPLUS to the state assigned school number. The crosswalk uses Code ID FLDOESCHOOL. The state assigned school numbers are set up in the Code Values table. |
22-31 | Florida Educators Certificate Number |
| N/R | 10 | hr_cntycred_mstr | document | Certificate number is stored in hr_cntrycred_mstr where cred_term='DE' and cred_type='PROF'. The certificate number is limited to 10 digits |
32-48 | Employee Name, Legal: Last Name |
| A/N/L | 17 | hr_empmstr | lname | The employee's last name - truncated to 17 characters. |
49-51 | Employee Name, Legal: Appendage |
| A/N/L | 3 | hr_empmstr | suffix | The employee's name suffix |
52-63 | Employee Name, Legal: First Name |
| A/N/L | 12 | hr_empmstr | fname | The employee's first name - truncated to 12 characters. May not be blank. |
64-73 | Employee Name, Legal: Middle Name |
| A/N/L | 10 | hr_empmstr | mname | The employee's middle or maiden name |
74-74 | Reading Endorsement, Competency 1 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 Reading Endorsement is only reported for Instructional Staff. For non-instructional staff set reading_endors_comp_1 till reading_endors_comp_6 to ‘Z’.For Instructional Staff set reading_endorsement_comp_1=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L1' |
75-75 | Reading Endorsement, Competency 2 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 For Instructional Staff set reading_endorsement_comp_2=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L2' |
76-76 | Reading Endorsement, Competency 3 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 For Instructional Staff set reading_endorsement_comp_3=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L3' |
77-77 | Reading Endorsement, Competency 4 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 For Instructional Staff set reading_endorsement_comp_4=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L4' |
78-78 | Reading Endorsement, Competency 5 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 For Instructional Staff set reading_endorsement_comp_5=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L5' |
79-79 | Reading Endorsement, Competency 6 |
| A | 1 | hr_cntycred | ma_mi_code | Not required for Survey 8 For Instructional Staff set reading_endorsement_comp_6=ma_mi_code from hr_cntycred where ssn is current employee and cred_type='READ END' and table_tp='L6' |
80-80 | Gender |
| A | 1 | hr_empmstr | gender | Not required for Survey 8 M=Male, F=Female |
81-81 | Filler |
| A | 1 |
| ||
82-84 | Days Present |
| N | 3 | Not required for Survey 2,8 | ||
85-87 | Days Absent, Personal Leave |
| N | 3 | Not required for Survey 2,8 | ||
88-90 | Days Absent, Sick Leave |
| N | 3 | Not required for Survey 2,8 | ||
91-93 | Days Absent, Temporary Duty Elsewhere |
| N | 3 | Not required for Survey 2,8 | ||
94-96 | Days Absent, Other |
| N | 3 | Not required for Survey 2,8 | ||
97-97 | Ethnicity |
| A | 1 | hr_empmstr | ethnic_cd | Not required for Survey 8 A code to indicate whether the staff member is of Hispanic or Latino ethnicity as per the description below. Y - Yes, the staff member is of Hispanic/Latino origin. N - No, the staff member is not of Hispanic/Latino origin. |
98-98 | Race: American Indian or Alaska Native |
| A | 1 | hr_empmstr; hr_emp_race | ethnic; race_cd | Not required for Survey 8 If records exist in the crosswalk table (code_id='FLDOERACECODES'). Read each race_cd from the hr_emp_race table and use the crosswalk table (code_id='FLDOERACECODES') to determine which flag to set to 'Y'. Next read ethnic from hr_empmstr and if not null, use the crosswalk table to determine which race flag to set to Y. If records don't exist in the crosswalk table (code_id='FLDOERACECODES') but the race_cd or ethnic = "I" or "W" or "B" or "P" or "A" then set the appropriate flag to "Y". Set race flags: If race="I" then race_american_indian= "Y"; |
99-99 | Race: Asian |
| A | 1 | hr_empmstr; hr_emp_race | ethnic; race_cd | Not required for Survey 8 If race="A" then race_asian="Y"; |
100-100 | Race: Black or African American |
| A | 1 | hr_empmstr; hr_emp_race | ethnic; race_cd | Not required for Survey 8 if race = "B" then race_black="Y"; |
101-101 | Race: Native Hawaiian or Other Pacific Islander |
| A | 1 | hr_empmstr; hr_emp_race | ethnic; race_cd | Not required for Survey 8 if race = "H" then race_hawaiian = "Y"; |
102-102 | Race: White |
| A | 1 | hr_empmstr; hr_emp_race | ethnic; race_cd | Not required for Survey 8 if race ="W" then race_white="Y" |
103-105 | Filler |
| A/N | 3 |
| ||
106-106 | Separation Reason |
| A | 1 | Not required for Survey 2,8 | ||
107-111 | Job Code, Primary |
| N | 5 | hr_pcntble | jobcode | Not required for Survey 8 Select the employee's primary pay assignment based on the rec_type matching a primary pay rec type (rr_setup_fldoe.rec_type_primary_pay) and the latest calc start date which is <= report instance 'As of' End date. Next get the jobcode from the associated record from the hr_pcntble where the position, pcn and entity match. Validated against the FLDOEJOBCODE table. If the job_code is not found in the Code Value table (codeid=FLDOEJOBCODE), then look up the code in the crosswalk table. |
112-112 | Transaction Code |
| A | 1 | A code indicating the appropriate action to be taken with respect to the district data base reporting records. | ||
113-114 | Employee Type |
| A | 2 | hr_empmstr | type | Not required for Survey 8 A code to identify the type of employment with the school board. CODE DEFINITION RF Regular full-time employee RP Regular part-time employee TF Temporary full-time employee TP Temporary part-time employee ST Student employee. Use crosswalk FLDOEEMPTYPE. If the BP employee type is not found in the crosswalk table, set to ZZ. |
115-122 | Birth Date |
| N | 8 | hr_empmstr | bdt | Not required for Survey 8 |
123-123 | Degree/Credential Earned |
| A | 1 | Not required for Survey 8 Select the employee's primary pay assignment based on the rec_type matching a primary pay rec type (rr_setup_fldoe.rec_type_primary_pay) and the latest calc start date less than or equal to the report 'As of' End Date. If the leftmost 4 characters of the index key <> "INST" then report a "Z"; otherwise if the leftmost 4 characters of the index key = "INST" then get the range from the indx_key by selecting the code between the two "/". Use this code to crosswalk to the state code based on the crosswalk table 'FLDOEDEGREE' | ||
124-131 | Employment Date, Current Position |
| N | 8 | hr_emppay | calc_beg | Not required for Survey 8 Select job code associated with the pay assignment where the rec_type matches one of the record types entered on the setup screen to identify primary pay assignments (rr_setup_fldoe.rec_type_primary_pay) which is active for the 'As of' Date Range. Select the pay assignment with the earliest start date that is associated with the same job code as the employee's current assignment. Set the hire_date_cur_pos to the calc begin date from this pay assignment. |
132-139 | Employment Date, Continuous Employment |
| N | 8 | hr_empmstr | hdt | Not required for Survey 8 The date on which continuous employment with the school district began |
140-147 | Employment Date, Original Position |
| N | 8 | hr_empmstr | beg | Not required for Survey 8 The first date of employment with the school district, regardless of breaks in service. |
148-155 | Separation Date |
| N | 8 | hr_empmstr | enddt | Not required for Survey 8 |
156-156 | Exempt from Public Records Law, Employee |
| A | 1 | hr_empmstr | publ_priv | Not required for Survey 8 A one-digit code used to identify an employee or spouse of an employee who is exempt from the Florida Public Records Law (Section 119, Florida Statutes). |
157-157 | Highly Qualified Paraprofessional |
| A | 1 | hr_licncert | licntype | Not required for Survey 8 Select licntype from hr_licncert where entity_id=fl_stfsurv_demographic.entity_id and id=fl_stfsurv.emp_id order by issdate desc. Select licntype from the Code Value table codeid="FLDOEQUALPARA". If found, write the value to highly_qual_paraprofess. If not, found read the next hr_licncert record for the employee |
158-158 | School Principal Certification Program |
| A | 1 | TBD | Not required for Survey 8 Optional Survey 8 Required Survey 2,3,5 A one-character code to describe the status of a participant in a district approved School Principal Certification Program. This element applies only to employees who have been in an approved district School Principal Certification Program during the Fiscal Year being reported. A – Admitted (entered the program and not withdrawn during the fiscal year) B – Enrolled (previously entered, still in the program, and not completed or withdrawn) C – Completed (completed the program this year) D – Withdrawn (exited the program without completing the program) Z – Not applicable/none of the above | |
159-159 | Reading Endorsement Compentency R1 |
| A | 1 | hr_cntycred | ma_mi_code where cred_type = ‘Read End’ | Not required for Survey 8 A code to indicate the instructional staff member’s completion or non-completion of Competency 1 (Adopted 2011) required for a Reading Endorsement as adopted into State Board Rule 6A-4.0163 in September 2011. Following codes are valid C -- The instructional staff member is in the process of completing the practicum for content area reading professional development (CAR-PD) or has completed CAR-PD in its entirety. G -- The instructional staff member is in the process of completing Next Generation Content Area Reading – Professional Development (NGCAR-PD) or has completed NGCAR-PD in its entirety. N -- No, the instructional staff member did not complete Competency 1 (Adopted 2011). P -- The instructional staff member is currently working toward completion of K-12 Reading certification. R -- The instructional staff member has met the requirement through K-12 Reading certification. Y -- Yes, the instructional staff member completed Competency 1 (Adopted 2011). Z -- Not applicable – not an instructional employee or not required for/applicable to this instructional staff member. |
160-160 | Reading Endorsement Compentency R2 |
| A | 1 | hr_cntycred | ma_mi_code where cred_type = ‘Read End’ | Not required for Survey 8 A code to indicate the instructional staff member’s completion or non-completion of Competency 1 (Adopted 2011) required for a Reading Endorsement as adopted into State Board Rule 6A-4.0163 in September 2011. Following codes are valid C -- The instructional staff member is in the process of completing the practicum for content area reading professional development (CAR-PD) or has completed CAR-PD in its entirety. G -- The instructional staff member is in the process of completing Next Generation Content Area Reading – Professional Development (NGCAR-PD) or has completed NGCAR-PD in its entirety. N -- No, the instructional staff member did not complete Competency 1 (Adopted 2011). P -- The instructional staff member is currently working toward completion of K-12 Reading certification. R -- The instructional staff member has met the requirement through K-12 Reading certification. Y -- Yes, the instructional staff member completed Competency 1 (Adopted 2011). Z -- Not applicable – not an instructional employee or not required for/applicable to this instructional staff member. |
161-161 | Reading Endorsement Compentency R3 |
| A | 1 | hr_cntycred | ma_mi_code where cred_type = ‘Read End’ | Not required for Survey 8 A code to indicate the instructional staff member’s completion or non-completion of Competency 1 (Adopted 2011) required for a Reading Endorsement as adopted into State Board Rule 6A-4.0163 in September 2011. Following codes are valid C -- The instructional staff member is in the process of completing the practicum for content area reading professional development (CAR-PD) or has completed CAR-PD in its entirety. G -- The instructional staff member is in the process of completing Next Generation Content Area Reading – Professional Development (NGCAR-PD) or has completed NGCAR-PD in its entirety. N -- No, the instructional staff member did not complete Competency 1 (Adopted 2011). P -- The instructional staff member is currently working toward completion of K-12 Reading certification. R -- The instructional staff member has met the requirement through K-12 Reading certification. Y -- Yes, the instructional staff member completed Competency 1 (Adopted 2011). Z -- Not applicable – not an instructional employee or not required for/applicable to this instructional staff member. |
162-162 | Reading Endorsement Compentency R4 |
| A | 1 | hr_cntycred | ma_mi_code where cred_type = ‘Read End’ | Not required for Survey 8 A code to indicate the instructional staff member’s completion or non-completion of Competency 1 (Adopted 2011) required for a Reading Endorsement as adopted into State Board Rule 6A-4.0163 in September 2011. Following codes are valid C -- The instructional staff member is in the process of completing the practicum for content area reading professional development (CAR-PD) or has completed CAR-PD in its entirety. G -- The instructional staff member is in the process of completing Next Generation Content Area Reading – Professional Development (NGCAR-PD) or has completed NGCAR-PD in its entirety. N -- No, the instructional staff member did not complete Competency 1 (Adopted 2011). P -- The instructional staff member is currently working toward completion of K-12 Reading certification. R -- The instructional staff member has met the requirement through K-12 Reading certification. Y -- Yes, the instructional staff member completed Competency 1 (Adopted 2011). Z -- Not applicable – not an instructional employee or not required for/applicable to this instructional staff member. |
163-163 | Reading Endorsement Compentency R5 |
| A | 1 | hr_cntycred | ma_mi_code where cred_type = ‘Read End’ | Not required for Survey 8 A code to indicate the instructional staff member’s completion or non-completion of Competency 1 (Adopted 2011) required for a Reading Endorsement as adopted into State Board Rule 6A-4.0163 in September 2011. Following codes are valid C -- The instructional staff member is in the process of completing the practicum for content area reading professional development (CAR-PD) or has completed CAR-PD in its entirety. G -- The instructional staff member is in the process of completing Next Generation Content Area Reading – Professional Development (NGCAR-PD) or has completed NGCAR-PD in its entirety. N -- No, the instructional staff member did not complete Competency 1 (Adopted 2011). P -- The instructional staff member is currently working toward completion of K-12 Reading certification. R -- The instructional staff member has met the requirement through K-12 Reading certification. Y -- Yes, the instructional staff member completed Competency 1 (Adopted 2011). Z -- Not applicable – not an instructional employee or not required for/applicable to this instructional staff member. |
164-164 | Mentor/Supervising Educator |
| A | 1 | pd_course_mstr | course_name course name is checked against additional setup mentor course, if a match is found and course is active within current reporting period flag is marked true. | Not required for Survey 8 A code to indicate whether the staff member is a Mentor or Supervising Educator (A Mentor/Supervising Educator is an individual who supervises or directs teacher preparation candidates during field experiences or student internships, provides mentoring to a district alternative certification program participant, or supervises or directs principal leadership candidates.) Valid Code: N -- No, the staff member is not a mentor or supervising educator. Y -- Yes, the staff member is a mentor or supervising educator. Z -- Not Applicable (for reporting in Survey Period 5 only) |
165-165 | Personnel Evaluation |
| A | 1 | hr_evalinfo | eval_stat
Program has eval defaults in additional setup. Based upon eval_stat eval_type,survey type, and eeo_line_number eval stat is set. Survey 2 default is Z Survey 3 if eval is H set to Z Survey 5 Check for eval type entered in additional setup, and apply value if employee has eeo line between 1 and 43. Enter H for any null value. If employee has eeo line between 44 and 54 enter z Finally check jobcode override list and if jobcode is found set to z
| Not required for Survey 8 A code to indicate the level of performance on the evaluation of the instructional staff member or school administrator status in accordance with Section 1012.34, Florida Statutes. A code to indicate the level of performance on the evaluation of the instructional staff member or school administrator status in accordance with Section 1012.34, Florida Statutes. C – The instructional staff member or school administrator was determined to be highly effective on his or her evaluation D – The instructional staff member or school administrator was determined to be effective on his or her evaluation. E – The instructional staff member or school administrator was determined to need improvement on his or her evaluation. F – The instructional staff member in the first three years of employment needs improvement and was determined to be developing on his or her evaluation. G – The instructional staff member or school administrator was determined to be unsatisfactory on his or her evaluation. H – The instructional staff member or school administrator was not evaluated. Z - The staff member is not an instructional staff member or a school administrator. |
166-167 | Personnel Evaluation, Instructional Leadership Component |
| N | 2 | hr_evalinfo rr_setup_values | eval_stat Value where setup_id = FLDOELEADERSHIPEVAL
if employee has eeo line no between 21-54 enter 00. If employee has eeo line no between 01-20 use the default stat from additional setup If employee has eval stat of H enter 00 | Survey 5 Only A two-digit code (two decimal places are assumed) indicating the percent of a school administrator’s evaluation that is based on instructional leadership, as defined in Section 1012.34(3)(a)3, Florida Statutes. The percent reported for the Personnel Evaluation, Instructional Leadership Component must be greater than or equal to 33 or less than or equal to 67. |
168-169 | Personnel Evaluation, Instructional Practice Component |
|
|
| hr_evalinfo rr_setup_values | eval_stat Value employee has eeo line no between 01 – 20 or between 44-54 enter 00. If employee has eeo line no between 21-43 enter default value from additional setup. If employee has eval stat of H enter 00 | Survey 5 Only A two-digit code (two decimal places are assumed) indicating the percent of a school administrator’s evaluation that is based on instructional leadership, as defined in Section 1012.34(3)(a)3, Florida Statutes. The percent reported for the Personnel Evaluation, Instructional Leadership Component must be greater than or equal to 33 or less than or equal to 67. |
170-171 | Personnel Evaluation, Professional and Job Responsibilities Component |
| N | 2 | hr_evalinfo rr_setup_values | eval_stat Value employee has eeo line no between 44-54 enter 00 if employee has eeo line no between 01-43 use default entered in additional setup for eval professional | Survey 5 Only A two-digit code (two decimal places are assumed) indicating the percent of an instructional staff member or school administrator’s evaluation that is based on professional and job responsibilities, as defined by Section 1012.34(3)(a)4, Florida Statutes. The percent reported for the Personnel Evaluation, Professional and Job Responsibilities Component must be less than or equal to 33. |
172-173 | Personnel Evaluation, Student Performance Component(Growth) |
| N | 2 | hr_evalinfo rr_setup_values | eval_stat Value if employee has eeo line no between 44-54 enter 00 if employee has eeo line no between 01-43 use default entered in additional setup for eval professional
| Survey 5 Only A two-digit code (two decimal places are assumed) indicating the percent of an instructional staff member or school administrator’s evaluation that is based on performance of students, as defined in Section 1012.34(3)(a)1, Florida Statutes. The percent reported for the Personnel Evaluation, Student Performance Component must be greater than or equal to 33 or less than or equal to 67 |
174-174 | Personnel Evaluation, Measures of Student Performance |
| A | 1 | hr_evalinfo rr_setup_values | eval_stat value where setup_id = FLDOEMSTUDNTGROWEVAL if employee has eeo line no between 44-54 enter Z if employee has eeo line no between 01-43 use default entered in additional setup for eval professional
| Survey 5 only A code to indicate the measures of student performance, as defined by Section 1012.34(7)(a)-(b), Florida Statutes, is based in the personnel evaluation of a classroom teacher or school administrator. Valid Codes B Exclusively (100%) on district-developed or district-selected end-of-course assessments C Exclusively (100%) on other standardized assessments, including nationally recognized standardized assessments D Exclusively (100%) on industry certification examinations E Exclusively (100%) on measurable learning targets / student learning objectives F Combination of assessments, with the state assessments accounting for the largest component G Combination of assessments, with the state assessments not accounting for the largest component H The classroom teacher or school administrator was not evaluated. I Combination of assessments, no state assessments. J Exclusively (100%) statewide VAM models K Exclusively (100%) on statewide assessments without VAM models Z Not a classroom teacher or school administrator. |
175-208 | Filler |
| A/N | 64 |
|
| Blank |
209-222 | Florida Education Identifier |
| A/N | 14 | pya_assoc_dtl | pya_assoc_desc | A code issued by the Florida Department of Education used to uniquely identify a person in Florida’s education data system. Example: FL123456789012 Florida Education Identifier (FLEID) for an employee. Proposed automated process to retrieve and populate state IDs to BPlus database |
223-232 | Staff Number Identifier, Local |
| A/N/L | 10 | hr_empmstr |
| This field optionally reports the employee id. If the setup value for Use Employee ID for Local Id is "Y" then this field is set to the employee’s id truncated to 10 characters. |
233-240 | Filler/Error Codes |
| A/N | 8 |
|
| Blank |
Note: Columns marked with * are required fields.
Data Types
A/N: Alpha Numeric, left justified, and blank.
N: Numeric, right justified, zero, unsigned without decimal point, cents, and dollars.
Record Length: 240 bytes/characters plus one character for carriage return and one character for line feed
Submission Report
The submission file report can be obtained by clicking Generate Report or View Report Buttons on the Submission window.
About
The About screen displays system level information about the report such as the version, report name and database details.