Skip to content

College Acceptance

Key Information

Collection Template

Position Column Name Required Format Description
0 Data Type True Text College Acceptance
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 Postsecondary Institution ID False Mapped ID The Integrated Postsecondary Education Data System (IPEDS) institution name *or* ID. Search for institution name and ID here: https://nces.ed.gov/ipeds/datacenter/InstitutionByName.aspx?goToReportId=6

Accepted Values:
  • -8
  • ACCEPTED
  • AMERICAN UNIVERSITY OF ROME
  • CAMBRIDGE UNIVERITY
  • JIREH PREPARATORY ACADEMY
  • KING'S COLLEGE LONDON
  • MEDTECH
  • THE AMERICAN UNIVERSITY OF ROME
  • THE UNIVERSITY OF BRITISH COLUMBIA
  • UNIVERITY COLLEGE LONDON
  • UNIVERSITY OF NAVARRA
11 PMF Numerator False Integer (Small) 0 (Negative Outcome) or 1 (Positive Outcome) DC PCSB updates the outcome column after reviewing the supporting documentation.
12 PMF Denominator False Integer (Small) 0 (Excluded from Rates) or 1 (Included in Rates)
13 Review Status ID False Mapped ID Accepted Values:
  • 0
  • 1
  • -1
  • 2
  • -2
  • EXCLUDED: CONDITIONAL ADMISSION
  • EXCLUDED: PENDING DC PCSB STAFF REVIEW
  • EXCLUDED: RESULT DOES NOT MEET BENCHMARK
  • EXCLUDED: SUPPORTING DOCUMENTATION DOES NOT MATCH RESULTS
  • EXCLUDED: SUPPORTING DOCUMENTATION REQUIRED
  • INCLUDED: RESULTS PROVIDED BY PUBLISHER
  • INCLUDED: VERIFIED BY DC PCSB STAFF
14 PMF Framework True Mapped ID Accepted Values:
  • ACCOUNTABILITY PLAN
  • ALTERNATIVE ACCOUNTABILITY
  • ELEMENTARY AND MIDDLE SCHOOL
  • ELEMENTARY SCHOOL
  • HIGH SCHOOL
  • MIDDLE SCHOOL
  • NONE
  • PK-8
15 PMF Universe True Mapped ID Accepted Values:
  • -53
  • -54
  • -55
  • 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: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT INCLUDED IN CERTIFIED GRADUATE LIST
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • EXCLUDED: STUDENT DECEASED
  • EXCLUDED: STUDENT EXPELLED FOR FEDERALLY RECOGNIZED REASON
  • EXCLUDED: STUDENT INELIGIBLE (ALTERNATE STATE ASSESSMENT)
  • EXCLUDED: STUDENT INELIGIBLE (IEP STUDENT)
  • EXCLUDED: STUDENT IN NON-PUBLIC PLACEMENT
  • EXCLUDED: STUDENT RECEIVED CREDENTIAL IN PREVIOUS YEAR
  • EXCLUDED: STUDENT TRANSFERRED TO ANOTHER CAMPUS IN SAME LEA
  • EXCLUDED: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: MIDDLE GRADES
  • INCLUDED: NOT IN SECTOR REPORTING UNIVERSE
16 STAR Framework False Mapped ID Accepted Values:
  • ALTERNATIVE FRAMEWORK
  • ELEMENTARY SCHOOL WITHOUT PRE-KINDERGARTEN
  • ELEMENTARY SCHOOL WITH PRE-KINDERGARTEN
  • MIDDLE SCHOOL
  • NONE
17 STAR Universe False Mapped ID 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: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • 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: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: MIDDLE GRADES

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
Calculated Column Column which is calculated based on other data (provided in submission or otherwise); these columns can 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.