Name: PARCC and MSAA

Display Field: SCHOOL_NAME

Type: Table

Geometry Type: N/A

Description: This data contains the official 2016-17 assessment performance results for the Partnership for Assessment of Readiness for College (PARCC) and Multi-State Alternate Assessment (MSAA) assessments in ELA and mathematics. This also includes historical performance information from the 2015-16 and 2014-15 PARCC and MSAA administrations. The dataset contains detailed information, showing multiple levels of results for specific groups of students, for all grades within a school, and for individual grades. For more information, visit https://osse.dc.gov/assessments.

Copyright Text: https://dcps.dc.gov; https://osse.dc.gov

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SCHOOL_YEAR ( type: esriFieldTypeString, alias: SCHOOL_YEAR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SCHOOL_YEAR )
• SCHOOL_WARD ( type: esriFieldTypeString, alias: SCHOOL_WARD, editable: true, nullable: true, length: 7, defaultValue: null, modelName: SCHOOL_WARD )
• SCHOOL_CODE ( type: esriFieldTypeInteger, alias: SCHOOL_CODE, editable: true, nullable: true, defaultValue: null, modelName: SCHOOL_CODE )
• SCHOOL_NAME ( type: esriFieldTypeString, alias: SCHOOL_NAME, editable: true, nullable: true, length: 67, defaultValue: null, modelName: SCHOOL_NAME )
• LEA_CODE ( type: esriFieldTypeInteger, alias: LEA_CODE, editable: true, nullable: true, defaultValue: null, modelName: LEA_CODE )
• LEA_NAME ( type: esriFieldTypeString, alias: LEA_NAME, editable: true, nullable: true, length: 36, defaultValue: null, modelName: LEA_NAME )
• ASSESSMENT_TYPE ( type: esriFieldTypeString, alias: ASSESSMENT_TYPE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ASSESSMENT_TYPE )
• SUBJECT ( type: esriFieldTypeString, alias: SUBJECT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SUBJECT )
• TESTED_GRADE_SUBJECT ( type: esriFieldTypeString, alias: TESTED_GRADE_SUBJECT, editable: true, nullable: true, length: 12, defaultValue: null, modelName: TESTED_GRADE_SUBJECT )
• GRADE_OF_ENROLLMENT ( type: esriFieldTypeString, alias: GRADE_OF_ENROLLMENT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GRADE_OF_ENROLLMENT )
• SUBGROUP ( type: esriFieldTypeString, alias: SUBGROUP, editable: true, nullable: true, length: 17, defaultValue: null, modelName: SUBGROUP )
• SUBGROUP_VALUE ( type: esriFieldTypeString, alias: SUBGROUP_VALUE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SUBGROUP_VALUE )
• PERCENT_MEETING_OR_EXCEEDING_E ( type: esriFieldTypeString, alias: PERCENT_MEETING_OR_EXCEEDING_E, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_MEETING_OR_EXCEEDING_E )
• PERCENT_LEVEL_3_ ( type: esriFieldTypeString, alias: PERCENT_LEVEL_3_, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_3_ )
• PERCENT_LEVEL_1 ( type: esriFieldTypeString, alias: PERCENT_LEVEL_1, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_1 )
• PERCENT_LEVEL_2 ( type: esriFieldTypeString, alias: PERCENT_LEVEL_2, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_2 )
• PERCENT_LEVEL_3 ( type: esriFieldTypeString, alias: PERCENT_LEVEL_3, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_3 )
• PERCENT_LEVEL_4 ( type: esriFieldTypeString, alias: PERCENT_LEVEL_4, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_4 )
• PERCENT_LEVEL_5 ( type: esriFieldTypeString, alias: PERCENT_LEVEL_5, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PERCENT_LEVEL_5 )
• TOTAL_NUMBER_VALID_TEST_TAKERS ( type: esriFieldTypeString, alias: TOTAL_NUMBER_VALID_TEST_TAKERS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TOTAL_NUMBER_VALID_TEST_TAKERS )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: PARCC and MSAA
  Description:
  Prototype:
  CREATED_DATE: null
  LAST_EDITED_DATE: null
  SCHOOL_YEAR: null
  SCHOOL_WARD: null
  SCHOOL_CODE: null
  SCHOOL_NAME: null
  LEA_CODE: null
  LEA_NAME: null
  ASSESSMENT_TYPE: null
  SUBJECT: null
  TESTED_GRADE_SUBJECT: null
  GRADE_OF_ENROLLMENT: null
  SUBGROUP: null
  SUBGROUP_VALUE: null
  PERCENT_MEETING_OR_EXCEEDING_E: null
  PERCENT_LEVEL_3_: null
  PERCENT_LEVEL_1: null
  PERCENT_LEVEL_2: null
  PERCENT_LEVEL_3: null
  PERCENT_LEVEL_4: null
  PERCENT_LEVEL_5: null
  TOTAL_NUMBER_VALID_TEST_TAKERS: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata