When reviewing these tables, it is important to keep in mind that they only store the latest set of data that was generated and/or pulled into the system. These tables do not store historical data.
The '_inital' tables are the last generated extract for a given reporting format.
Each time the district utilizes the 'Generate Extract(s)' button, Focus considers that an 'initial' in the backend. This is why in 'Extract History' you will see the 'Mode' column reflect 'INITIAL' no matter if the district set the 'Mode' to 'Initial' or 'Magic Batch' on the Generate DOE Extracts screen. Focus does not store any of the 'Magic Batch' nor 'Change Log' data in the backend; the extract is generated on the fly, and then the data being batched via 'Magic Batch' is displayed for review and then sent via FTP when the district is ready.
- florida_staffaddlcomp_initial
- florida_staffaddljobassn_initial
- florida_staffbenefits_initial
- florida_staffdemographicinfo_initial
- florida_staffemail_initial
- florida_staffexperience_initial
- florida_stafffybenefits_initial
- florida_stafffysalaries_initial
- florida_staffmultidistempl_initial
- florida_staffpayrollinfo_initial
- florida_staffprofdev_initial
The '_dfile', '_edit_dq2', and '_validation_dq2' tables store the latest d-file, edit, or validation file that was pulled in via Florida Reports > Generate DOE Extracts ('Enable DQ2 Preflight' check box selected in the upper- right-hand corner).
- florida_staffaddlcomp_dfile
- florida_staffaddlcomp_edit_dq2
- florida_staffaddlcomp_validation_dq2
- florida_staffaddljobassn_dfile
- florida_staffaddljobassn_edit_dq2
- florida_staffaddljobassn_validation_dq2
- florida_staffbenefits_dfile
- florida_staffbenefits_edit_dq2
- florida_staffbenefits_validation_dq2
- florida_staffdemographicinfo_dfile
- florida_staffdemographicinfo_edit_dq2
- florida_staffdemographicinfo_validation_dq2
- florida_staffemail_dfile
- florida_staffemail_edit_dq2
- florida_staffemail_validation_dq2
- florida_staffexperience_dfile
- florida_staffexperience_edit_dq2
- florida_staffexperience_validation_dq2
- florida_stafffybenefits_dfile
- florida_stafffybenefits_edit_dq2
- florida_stafffybenefits_validation_dq2
- florida_stafffysalaries_dfile
- florida_stafffysalaries_edit_dq2
- florida_stafffysalaries_validation_dq2
- florida_staffmultidistempl_dfile
- florida_staffmultidistempl_edit_dq2
- florida_staffmultidistempl_validation_dq2
- florida_staffpayrollinfo_dfile
- florida_staffpayrollinfo_edit_dq2
- florida_staffpayrollinfo_validation_dq2
- florida_staffprofdev_dfile
- florida_staffprofdev_edit_dq2
- florida_staffprofdev_validation_dq2
The '_dfile_prod', '_edit_dq2_prod', and '_validation_dq2_prod' tables store the latest d-file, edit, or validation file that was pulled in via Florida Reports > Generate DOE Extracts (no check box selected in the upper- right-hand corner).
- florida_staffaddlcomp_dfile_prod
- florida_staffaddlcomp_edit_dq2_prod
- florida_staffaddlcomp_validation_dq2_prod
- florida_staffaddljobassn_dfile_prod
- florida_staffaddljobassn_edit_dq2_prod
- florida_staffaddljobassn_validation_dq2_prod
- florida_staffbenefits_dfile_prod
- florida_staffbenefits_edit_dq2_prod
- florida_staffbenefits_validation_dq2_prod
- florida_staffdemographicinfo_dfile_prod
- florida_staffdemographicinfo_edit_dq2_prod
- florida_staffdemographicinfo_validation_dq2_prod
- florida_staffemail_dfile_prod
- florida_staffemail_edit_dq2_prod
- florida_staffemail_validation_dq2_prod
- florida_staffexperience_dfile_prod
- florida_staffexperience_edit_dq2_prod
- florida_staffexperience_validation_dq2_prod
- florida_stafffybenefits_dfile_prod
- florida_stafffybenefits_edit_dq2_prod
- florida_stafffybenefits_validation_dq2_prod
- florida_stafffysalaries_dfile_prod
- florida_stafffysalaries_edit_dq2_prod
- florida_stafffysalaries_validation_dq2_prod
- florida_staffmultidistempl_dfile_prod
- florida_staffmultidistempl_edit_dq2_prod
- florida_staffmultidistempl_validation_dq2_prod
- florida_staffpayrollinfo_dfile_prod
- florida_staffpayrollinfo_edit_dq2_prod
- florida_staffpayrollinfo_validation_prod
- florida_staffprofdev_dfile_prod
- florida_staffprofdev_edit_dq2_prod
- florida_staffprofdev_validation_dq2_prod