Skip to content

Internships

Key Information

Collection Template

Position Column Name Required Format Description
0 Data Type True Text internships
1 LEA ID True Integer (Small)
2 LEA False Text
3 Campus ID True Integer (Small)
4 Campus False Text
5 School Year True Text YYYY-YYYY
6 USI True Integer (Big)
7 First Name False Text
8 Last Name False Text
9 Assessment Grade False Text
10 Completed Internship True Boolean (True/False)
11 Internship Organization False Text
12 Accountability Universe ID False Mapped ID This field denotes if a record is included in a school’s Accountability Measure or Charter Goals metric calculations.

Accepted Values:
  • EXCLUDED: ALTERNATIVE ACCOUNTABILITY CAMPUS
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN CURRENT YEAR
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN PRIOR YEAR
  • EXCLUDED: DID NOT MEET MINIMUM ENROLLMENT REQUIREMENTS
  • EXCLUDED: ENROLLED LESS THAN 30 DAYS AFTER 10TH DAY OF SCHOOL
  • EXCLUDED: INCOMPLETE TEST
  • EXCLUDED: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INELIGIBLE PARTICIPANT
  • EXCLUDED: INVALIDATED SCORE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: MISSING OR INSUFFICIENT SUPPORTING EVIDENCE
  • EXCLUDED: NEW TO US EXEMPTION
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT A CERTIFIED GRADUATE
  • EXCLUDED: NOT AUDITED AT LEA IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT ENROLLED ON ROSTERING DATE
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: OFF-GRADE TEST
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PENDING DC PCSB REVIEW
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PRIOR TO SY 2022-2023 DATA NOT COLLECTED
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • EXCLUDED: SCORE/OUTCOME DOES NOT MEET PASSING REQUIREMENT
  • EXCLUDED: STUDENT DECEASED
  • EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
  • EXCLUDED: STUDENT EXPELLED FOR FEDERALLY RECOGNIZED REASON
  • EXCLUDED: STUDENT IN NON-PUBLIC PLACEMENT
  • EXCLUDED: STUDENT RECEIVED CREDENTIAL IN PREVIOUS YEAR
  • EXCLUDED: STUDENT TRANSFERRED TO ANOTHER CAMPUS IN SAME LEA
  • EXCLUDED: STUDENT WITHOUT ENROLLMENT PERIOD, SCHEDULED TO BE DELETED
  • EXCLUDED: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: TEST NOT TAKEN
  • EXCLUDED: THREE-YEAR GRADUATE
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: CONDITIONAL/PROVISIONAL ACCEPTANCE
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: EVIDENCE/DOCUMENTATION NOT PROVIDED
  • INCLUDED: INSUFFIENCT EVIDENCE/DOCUMENTATION
  • INCLUDED: MIDDLE GRADES
  • INCLUDED: NOT IN SECTOR PARTICIPATION UNIVERSE
  • INCLUDED: NOT IN SECTOR REPORTING UNIVERSE

Shading Key
Primary Key Column Column(s) which uniquely define the row, and is required in all submissions
Expected Column Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank
Non-Loaded Column Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions

Common Errors

Click on the error type to get more information.

  • No common errors