As part of the DOE Database Manual, districts can download the Appendices from DOE into tables within Focus so they can view the data contained in each appendix. These appendices are used in State Reporting to validate the district's data prior to the district sending the data to DOE at survey time. Depending on the time of year, the appendices may or may not be available to download from DOE.
1. From the Florida Reports menu, click View Background Tables.
2. This navigates to the View Background Tables screen where all possible tables are listed. Click the desired tab to view said table, such as Adult High School Co-enrolled Course List (WDIS Appendix D).
Adult High School Co-enrolled Course List (WDIS Appendix D)
The Adult High School Co-enrolled Course List (WDIS Appendix D) table displays the SYEAR, COURSE_NUMBER, COURSE_TITLE, SUBJECT_AREA, MAX_CREDIT, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Adult Test Reporting (WDIS Appendix Q)
The Adult Test Reporting (WDIS Appendix Q) table displays the SYEAR, TEST_SHORT_NAME, FORM, SUBJECT, LEVEL, MIN_SCORE, and MAX_SCORE.
Apprenticeship Sponsor Codes (WDIS Appendix O)
The Apprenticeship Sponsor Codes (WDIS Appendix O) table displays the SYEAR, SPONSOR_CODE, PROGRAM_NAME, PROGRAM_NUMBER, REGION, PROGRAM_ADDRESS, CONTACT_CITY, CONTACT_ZIP_CODE, COUNTY, PROGRAM_STATUS, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT, along with other program information.
CTE Dual Enrollment Courses
The CTE Dual Enrollment Courses table displays the ID, SYEAR, COURSE_NUMBER, and COURSE_TITLE.
CTE/AGE Program Edit File (F61730)
The CTE/AGE Program Edit File (F61730) table displays VOC_PROGRAM_NUMBER, PROG_ID, VOC_COURSE, OCC_PROGRAM_IND, JOB_PREP_IND, Z_TERMINATION_IND, SUPPLEMENTAL_IND, INTENT_IND, APPRENTICESHIP_IND, OCC_PROGRAM_AREA, CIP_PROGRAM_AREA, CIP_PROGRAM_LAST_EIGHT, CIP_PROGRAM_TITLE, PROGRAM_TITLE, COURSE_TITLE, OCC_COMPL_POINT_CD, VOC_YEAR, TERMINAL_OCP_CD, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Career Education Programs with Occupational Points (WDIS Appendix S)
The Career Education Programs with Occupational Points (WDIS Appendix S) table displays ID, SYEAR, CAREER_AREA, CIP_NUMBER, SOC_CODE, SOC_TITLE, PROGRAM_NUMBER, CIP_TITLE, OCP, OCC_TITLE, TERMINAL_OCP, CREDIT_TYPE, OCP_HOUR, CUMULATIVE_HOURS, TOTAL_PROGRAM_HOUR, NON_TRAD, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Career and Professional Academies Registered with FLDOE (Appendix Y)
The Career and Professional Academies Registered with FLDOE (Appendix Y) table displays SYEAR, DISTRICT, DISTRICT_NAME, SCHOOL, SCHOOL_NAME, ACADEMY_ID, ACADEMY_NAME, ACADEMY_LEVEL, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Cost Reporting Code-Postsecondary (WDIS Appendix G)
The Cost Reporting Code-Postsecondary (WDIS Appendix G) table displays SYEAR, PROGRAM_TITLE, VOCATIONAL_PROGRAM_CODE, COST_REPORTING_CODE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Country Codes (Appendix G)
The Country Codes (Appendix G) table displays SYEAR, COUNTRY_CODE, COUNTRY_TITLE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_ID.
Course Code Directory
The Course Code Directory table displays COURSE_NUMBER, COURSE_SYMBOL, VOC_GRADELEVELS, ABREV_COURSE_TITLE, COURSE_TITLE, COURSE_YEAR, CERT_LEVELS, SUBJECT_AREA, MAX_CREDIT, SUBJECT_CODE, SUBJECT_SUBFIELD, SORT_LEVEL, REQUIRED_COURSE, NEW_COURSE_NUMBER, ABREV_COURSE_TITLE2, NEW_COURSE_TITLE, ABREV_TITLE_SYMBOL, TITLE_SYMBOL, NEW_SHORT_SYMBOL, NEW_TITLE_F35_SYMBOL, NEW_TITLE_L35_SYMBOL, COURSE_LEVEL, CORE_COURSE, HIGHLY_QUALIFIED, COURSE_LENGTH, EOC_INDICATOR, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, UPDATED_AT, and COURSE_INDICATOR.
Courses Eligible for ELL Weighted FTE (Appendix DD)
The Courses Eligible for ELL Weighted FTE (Appendix DD) table displays SYEAR, LEVEL, SUBJECT, COURSE_NUM, COURSE_TITLE, CHANGE, DATE_CHANGE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Definitions for Incident Reporting (Appendix P)
The Definitions for Incident Reporting (Appendix P) table displays SYEAR, INCIDENT_CODE, INCIDENT_TYPE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
EOY Bonus FTE Test Crosswalk
The EOY Bonus FTE Test Crosswalk table displays ID, TEST_SHORT_NAME, TEST_SUBJECT_CODE, COURSE_NUM, RECORD_TYPE, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, UPDATED_ID, and DISTRICT_ID.
Florida Access Courses (F71538)
The Florida Access Courses table displays ID, SYEAR, COURSE, COURSE_TITLE, and COURSE_TITLE_LONG.
Florida FISH File
The Florida FISH File table displays FISH_YEAR, DISTRICT, FISH, FISH_FACILITY, FISH_FACILITY_SUFFIX, FISH_PARCEL, FISH_BUILDING, FISH_ROOM, DESIGN_CODE, DESIGN_DESCRPTION, ROOM_SQ_FOOTAGE, STUDENT_STATIONS, CONDITION_CODE, CONDITION_DESCRIPTION, FACILITY_USE, CAPITAL_OUTLAY, MSID1, FLAG1, MSID2, FLAG2, MSID3, FLAG3, MSID4, FLAG4, MSID5, FLAG5, MSID6, FLAG6, MSID7, FLAG7, MSID8, FLAG8, MSID9, FLAG9, MSID10, FLAG10, AS_OF, AS_OF_DATE, AS_OF_TIME, LAST_UPDATE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, UPDATED_AT, and DISTRICT_ID.
Florida Industry Certs
The Florida Industry Certs table displays ID, SYEAR, CERT_NUMBER, DESCRIPTION, CERT_TYPE, LONG_DESCRIPTION, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, UPDATED_AT, and IS_LOCAL.
In/Out Field Certification Groups
The In/Out Field Certification Groups table displays GROUP_CODE, CERT_GROUP, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
K12 Industry Certification Identifier (Appendix Z)
The K12 Industry Certification Identifier (Appendix Z) table displays SYEAR, CERT, TITLE, AGENCY, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, UPDATED_AT, DATE_CHANGED, SCH_GRADES_ELIGIBLE, TYPE, DIFFERENTIATED_WAIVER, FEFP_WEIGHT, and ADD_FTE_ELIGIBLE.
Language Codes (Appendix N)
The Language Codes (Appendix N) table displays the SYEAR, LANGUAGE_CATEGORY, LANGUAGE_CODE, LANGUAGE_DESCRIPTION, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Less Than 180 Days in School Year File (F71497)
The Less Than 180 Days in School Year File (F71497) table displays YEAR, DISTRICT, SURVEY_2_DAYS, SURVEY_3_DAYS, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
National School Lunch Program - Reference Table (F71447)
The National School Lunch Program - Reference Table (F71447) table displays FISCAL_YEAR, DISTRICT, DISTRICT_NAME, SCHOOL, SCHOOL_NAME, LUNCH_PROGRAM, SURVEY, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Non-Fundable Auto Service Tech Programs (F71340)
The Non-Fundable Auto Service Tech Programs (F71340) table displays the YEAR, SURVEY, DISTRICT, SCHOOL, DISTRICT_TITLE, SCHOOL_TITLE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Non-Fundable Courses (F71424)
The Non-Fundable Courses (F71424) table displays COURSE_YEAR, COURSE_NUMBER, COURSE_NAME, COMMENT, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Online Course Providers (Appendix GG)
The Online Course Providers (Appendix GG) table displays SYEAR, OCP_ID, OCP_DESCRIPTION, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Postsecondary School of Enrollment (WDIS Appendix H)
The Postsecondary School of Enrollment (WDIS Appendix H) table displays SYEAR, DISTRICT, DISTRICT_NAME, SCHOOL, SCHOOL_NAME, ACCREDITATION, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
State Codes (Appendix H)
The State Codes (Appendix H) table displays SYEAR, STATE_TITLE, STATE_CODE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Statewide Course Numbering System (F60922)
The Statewide Course Numbering System (F60922) table displays SYEAR, COURSE_TERM, COURSE_NUMBER, COURSE_NAME, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Test Name Table (Appendix I)
The Test Name Table (Appendix I) table displays SYEAR, TEST_CODE, TEST_NAME, LISTENING, SPEAKING, READING, WRITING, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Test Subject Content Codes (Appendix L)
The Test Subject Content Codes (Appendix L) table displays SYEAR, TEST_CODE, TEST_NAME, CONTENT_CODE, CONTENT_NAME, LISTENING, SPEAKING, READING, WRITING, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Virtual Instruction Providers (Appendix CC)
The Virtual Instruction Providers (Appendix CC) table displays SYEAR, VIP_ID, VIP_DESCRIPTION, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
Virtual Online Course Provider Reference File (F71485)
The Virtual Online Course Provider Reference File (F71485) table displays SYEAR, OCP_ID, COURSE_NUM, COURSE_TITLE, ID, CREATED_BY_CLASS, CREATED_BY_ID, CREATED_AT, UPDATED_BY_CLASS, UPDATED_BY_ID, and UPDATED_AT.
WDIS Industry Certs
The WDIS Industry Certs table displays the ID, SYEAR, CERT, TITLE, AGENCY, and ELIGIBLE_INCENTIVE_FUNDS.