Documentation for Administrators

View Background Tables

Updated on

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.

View Background Tables

1. From the Florida Reports menu, click View Background Tables.

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).

View Background Tables

Adult High School Co-enrolled Course List (WDIS Appendix D)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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

View Background Tables

The CTE Dual Enrollment Courses table displays the ID, SYEAR, COURSE_NUMBER, and COURSE_TITLE.

CTE/AGE Program Edit File (F61730)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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

View Background Tables

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)

View Background Tables

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)

View Background Tables

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

View Background Tables

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)

View Background Tables

The Florida Access Courses table displays ID, SYEAR, COURSE, COURSE_TITLE, and COURSE_TITLE_LONG.

Florida FISH File

View Background Tables

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

View Background Tables

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

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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)

View Background Tables

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

View Background Tables

The WDIS Industry Certs table displays the ID, SYEAR, CERT, TITLE, AGENCY, and ELIGIBLE_INCENTIVE_FUNDS.

Previous Article WDIS Extract Field Defaults
Next Article FES Import Exceptions