Skip to content

AE Accountability Roster

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type True Text AE Accountability Roster
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 Audited True Boolean (True/False) Whether the student was included in the enrolled audit. This column is set by DC PCSB and cannot be modified by the LEA.
10 Twelve Hours True Boolean (True/False) Whether the student meets the business rules for inclusion based on the twelve-school hours rule.
11 Fifteen Days True Boolean (True/False) Whether the student meets the business rules for inclusion based on the fifteen-calendar day rule.
12 Last Exit True Date The student's Last Exit Date known to DC PCSB. In the event that the student is continuing at the LEA, this column is set to the last day of the program year.
13 Exit Quarter True Mapped Text The student's Last Exit Quarter is derived from their last exit date, and is based on the LEA's chosen program year. For students continuing at the school in the next program year, use Quarter 4 as the Last Exit for this column.

Accepted Values:
  • PRIOR Q1
  • PRIOR Q2
  • PRIOR Q3
  • PRIOR Q4
  • PRIOR QUARTER 1
  • PRIOR QUARTER 2
  • PRIOR QUARTER 3
  • PRIOR QUARTER 4
  • Q1
  • Q2
  • Q3
  • Q4
  • QUARTER 1
  • QUARTER 2
  • QUARTER 3
  • QUARTER 4
14 Programs False Text A semicolon (;) separated list of programs in which the student is enrolled. The available programs are listed below:
  • ABE
  • APEX
  • Academic Enhancement
  • Alfabetizacion
  • Barbering
  • Bilingual Teaching
  • Child Development Associate
  • Citizenship
  • Coding
  • College Entry
  • College Pathway
  • College Readiness
  • Communications Cabling
  • CompTIA A+
  • CompTIA Network+
  • CompTIA Security+
  • Computer Literacy
  • Construction
  • Cosmetology
  • Culinary Arts
  • Customer Service
  • Dup
  • ESL
  • Family Reading Journal Rubric
  • Financial Literacy and Marketing
  • Foundations of Literacy
  • GED (English)
  • GED (Spanish)
  • Gateway
  • Google Data Analytics Certificate
  • HBI PACT
  • HVAC 608
  • HVAC 609
  • Health Academy
  • IET
  • IT Fundamentals
  • Information Technology
  • Internet Core Competency
  • Math
  • Medical Assistant
  • Microsoft Office Specialist
  • NEDP
  • Nurse Aide
  • OSHA
  • Phlebotomy
  • Pre-GED
  • Pre-Pathway
  • SEEDS for Success
  • Study Session
  • Technology Skills
  • Two Generation Program
  • Vocab
15 Diploma at Entry True Boolean (True/False)
16 Employed at Entry True Boolean (True/False)
17 Employed at First Follow Up True Boolean (True/False) First Follow Up refers to the student's employement status at the first follow up window. The timeline for these follow up determinations is determined by the LEA's follow up schedule.
18 Labor Force Status True Mapped Text Accepted Values:
  • FULL-TIME PARENTING
  • FULL-TIME STUDENT
  • ILL HEALTH OR DISABILITY
  • IN LABOR FORCE
  • INSTITUTIONALIZED OR INCARCERATED
  • NOT IN LABOR FORCE
  • RETIRED
  • UNKNOWN

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.

  • No common errors