Tool Search: DCV Extract
The DCV Extract satisfies state reporting requirements for Behavior. It collects data on incidence of discipline, crime and violence for the year following the first day of the previous school year.
DCV Extract Editor
Report Preparation
This report requires local school divisions to complete the following steps:
- Collect and appropriately code DCV data at the school level.
- Report DCV school data to the school division (LEA).
- Submit division-level data to the Virginia DOE.
Report Logic
This extract reports by students and includes both Offenders and Participants. One record will report per student.
If any of the following are marked, the Event will not report:
- Events in a Calendar marked State Exclude
- During an enrollment marked State Exclude or No Show or
- In a Grade Level marked as Exclude from State Reporting.
Events and Resolutions must be mapped to a State Code to report.
For incidents with an Offense Code of A1T (Attendance), an event record will report if the Resolution is 01 or 04 and Offense Code 1 is populated or if the Resolution is 02 or 03 and Offense Code 1 or 2 is populated.
Records will report the following Event codes when the assigned Resolution is 01, 02, 03, 04, 05 or 06. These state codes will not report a record if the Resolution is 99. If multiple Resolutions are assigned, including a Resolution of 99, a record will report for events with a reportable Resolution.
Code | Description | Code | Description | Code | Description |
|---|---|---|---|---|---|
AR1 | Arson | AS1 | Arson: Actual | ||
AS2 | Arson: Attempted | AS3 | Firecrackers/Cherry Bombs | BK1 | Burglary/Actual |
BK2 | Burglary/Attempted | BR1 | Breaking and Entering | C1M | Beepers |
C2M | Cellular Phones | C3M | Electronic Devices | D1C | Disrespect |
D2C | Defiance | D3C | Disruptive Demonstration | D4C | Obscene/Disruptive Literature |
D4G | Over the Counter Med/Use | D5C | Classroom Disruption | D5G | Possession of over the Counter Medicine |
D6C | Obscene language/gestures | D6G | Sale/Distribution of over the Counter Medicine | D8C | Minor Insubordination |
ET1 | Extortion | ET2 | Attempted Extortion | EX1 | Extortion |
F1T | Altercation | G1B | Gambling | GA1 | Gang Activity |
H1Z | Hazing | RG1 | Inciting a Riot | RG2 | Attempting to Incite a Riot |
RT1 | Inciting a Riot | S1V | Inappropriate Personal Property | S2V | Misrepresentation |
S3V | Other School Violations | T1C | Unauthorized Use of Technology | T2C | Causing Damage to Computer |
T3C | Violation of Acceptable Use Policy | T4B | Bringing Tobacco Paraphernalia to School | T4C | Violation of Internet Policy |
TF1 | Theft/School Property | TF2 | Theft/Staff Property | TF3 | Theft/Student Property |
TF4 | Possession/Stolen Property | TF6 | Attempted Theft or Theft of Motor Vehicle | TH1 | Theft Offenses |
TH2 | Theft of a Motor Vehicle | TR1 | Trespassing | VA1 | Vandalism |
VN1 | Vandalism of School Property | VN2 | Vandalism of Private Property | VN3 | Graffiti |
W3P | Possession of a Toy or Look-alike Gun | W8P | Possession of Razor Blades, Box Cutters, knife (3 less than 3 inches) | W9P | Possession of Fireworks |
W1P | Possession of Ammunition |
The following Events will report regardless of the Resolution assigned (except Null):
Code | Description | Code | Description | Code | Description |
|---|---|---|---|---|---|
| AL1 | Alcohol | AC1 | Alcohol Use | AC2 | Alcohol Poss. |
| AC3 | Alcohol Sale/Dist. | BA1 | Battery Against Staff with Weapon | BA2 | Battery Against Self |
| BA3 | Battery Against Student with Weapon | BA4 | Batter Against Student | BA5 | Malicious Wounding |
| BA6 | Assault and Battery w/o Injury | BB1 | School Threat | BO1 | Bomb Threat |
| BO2 | Chemical/Biological Threat | BO3 | Terrorist Threat | BO4 | Setting off False Fire Alarm |
| BU1 | Bullying | BU2 | Cyber Bullying | ||
| D10 | Other Drug Use/Overdose | D11 | Other Drug Poss. | D12 | Other Drug Sale/Dist. |
| D15 | Possession of Inhalants | D16 | Use of Inhalants | D17 | Substance (look-alikes) |
| D19 | Anabolic Steroid Sale/Dist. | DG1 | Schedule 1&2 Drug Use | DG2 | Schedule 1&2 Poss. |
| DG3 | Schedule 1&2 Drug Sale/Dist. | DG5 | Use and Possession of Synthetic Marijuana | DG6 | Distribution of sale of Synthetic Marijuana |
| DG7 | Marijuana Use | DG8 | Marijuana Poss. | DG9 | Marijuana Sale/Dist. |
| DG20 | Anabolic Steroid Use/Poss. | DR1 | Possession and Use of Schedule 1 & 2 Drugs | DR2 | Possession and Use of Look-alike Drugs |
| DR3 | Theft and Attempted Theft of Prescription Drugs | DR4 | Sale and Distribution of Schedule 1&2 Drugs, Steroid and Marijuana | DR5 | Use, Possession and Distribution of Drug Paraphernalia |
| FA2 | Fighting w/o Injury | HO1 | Homicide Against Staff w/ Firearm | HO2 | Homicide Against Student w/Firearm |
| HO3 | Homicide Against Staff w/Weapon | HO4 | Homicide Against Student w/Weapon | ||
| HR1 | Harassment | KI1 | Kidnapping | RB1 | Actual Robbery |
| RB2 | Attempted Robbery | RO1 | Robbery Using Force | SB1 | Sexual Battery/Staff |
| SB2 | Sexual Battery/Student | ST1 | Stalking | SX0 | Sexual Harassment |
| SX1 | Offensive Sexual Touching/Staff | SX2 | Offensive Sexual Touching/Student | SX3 | Sexual Assault Staff |
| SX4 | Sexual Assault Student | SX5 | Attempted Sexual Assault Staff | SX6 | Attempted Sexual Assault Student |
| SX7 | Sexual Offense without Force | SX8 | Aggravated Sexual Battery | ||
| TB1 | Tobacco Products | TB2 | Electronic Cigarette | ||
| TC1 | Tobacco Use | TC2 | Tobacco Possession | TC3 | Tobacco Sales/Distribution |
| TI1 | Threat of Staff | TI2 | Threat of Student | W2P | Possession of Chemical Substances |
| WP0 | Possession of a BB Gun | WP1 | Possession of a Handgun | WP2 | Possession of a Shotgun/Rifle |
| WP4 | Possession of Weapon that Expels a Projectile | WP5 | Possession of Knife More that Three Inches | WP6 | Possession of Explosive Device |
| WP7 | Use of a Bomb | WP8 | Possession of Other Firearm | WP9 | Possession of Other Weapon |
| WS1 | Possession of Stun Gun | WT1 | Possession of Taser |
Extract Fields
Field | Description |
|---|---|
Date Range | Identifies the date range within which events must occur to be included in the report. |
| Which Students would you like to include in the report? |
|
Format | The format in which the report will generate. Options are CSV, Tab Delimited and HTML. |
| Display Student's Name | Indicates whether the report should display the student's name for data review and verification. |
Calendar(s) | The calendars from which student and behavior information will be pulled. |
| Generate Extract | The report appears in a separate window in the designated format. |
| Submit to Batch | This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Extract Layout
Header
Element Name | Description |
|---|---|
SenderID | The State District Number. |
CreateDate | The current date in mm/dd/yyyy format. |
CreateTime | The current time in hh.mm.ss |
The email address of the individual submitting the report. | |
Tildes | System generated ~ marks. |
DataCollectionName | System generated - DATATYPE=DISCIPLN |
Tilde | System generated ~ mark. |
Data Collection Name | System generated, reports as follows:
|
Report Layout
Element Name | Description | Location | |
|---|---|---|---|
| 1 | Record Type | System generated, always reports as B. Alphanumeric, 1 character | Not dynamically stored |
| 2 | Student Identifier | The unique identifier for the student within the school. For non-students or unknown participants, this field will report the value set in the Relationship to School field on the Participant Editor as follows:
Numeric, 12 characters | Demographics > Person Identifiers > Local Student Number OR Behavior Management > Incident Information > Participant Details > Relationship to School person.studentNumber |
| 3 | Enrolled Division Number | The District Number where the student is enrolled. When Offender is NS or UN, reports as blank. Otherwise reports the Serving Division-School value following the dash. Reports as blank for non-student or unknown person participants. Numeric, 3 digits | Enrollments > State Reporting Fields > Serving Division-School AND District Information > State District Number AND Behavior Management > Incident Information > Participant Details > Relationship to School enrollment.serving DivisionSchool |
| 4 | Enrolled School Number | The School Number where the student is enrolled. When Offender is NS or UN, reports as blank. Otherwise reports the Serving Division-School value preceding the dash. Reports as blank for non-student or unknown person participants. Numeric, 4 digits | Enrollments > State Reporting Fields > Serving Division-School AND School Information > State School Number AND Behavior Management > Incident Information > Participant Details > Relationship to School enrollment.serving DivisionSchool |
| 5 | Incident Division Number | The District Number where the behavior event took place. Reports the number before the dash. When the Localized Incident Location field is blank, the Serving Division-School reports. If the Localized Incident Location and the Serving Division-School fields are blank, the State District Number reports. Numeric, 3 digits | Behavior Management > Incident Information > Localized Incident Location BehaviorIncident |
| 6 | Incident School Number | The School Number where the behavior event took place. Reports the number after the dash. When the Localized Incident Location field is blank, the Serving Division-School reports. If the Localized Incident Location and the Serving Division-School fields are blank, the State District Number reports. Numeric, 4 digits | Behavior Management > Incident Information > Localized Incident Location BehaviorIncident |
| 7 | Grade | The grade level of the student's current enrollment. If the Relationship to School field is null or 1-4, reports the grade level of the enrollment active on the Date of Incident. Otherwise, reports from the last enrollment in the school year being reported. Otherwise, reports as null. Alphanumeric, 2 characters | Enrollments > Grade enrollment.grade |
| 8 | Disability | The Primary Disability of a special education student, as indicated on a locked IEP. If the Primary Disability is blank or the End Date is before the report generation date, Campus checks the Section 504 tab for a record. 15: Section 504 reports when the Start Date is populated and the End Date is blank or after the report generation Effective Date. See the following Disability Options table for values. Numeric, 2 digits | Special Ed Documents > IEP > Enrollment Status > Primary Disability planState.disability1 |
| 9 | Date of Birth | The student's birth date. Date field, 10 characters mm/dd/yyyy | Demographics > Birth Date identity.birthDate |
| 10 | Hispanic | Indicates if the student is of Hispanic/Latino descent. Alphanumeric, 1 character Y or N | Demographics > Hispanic/Ethnicity identity.hispanicEthnicity |
| 11 | Race | Identifies the Race/Ethnicity of the student. See the following Race/Ethnicity Options table for values. Numeric, 2 digits | Demographics > Race/Ethnicity identity.raceEthnicity |
| 12 | Gender | Indicates if the student is (M)ale or (F)emale. Information reports from the Demographics tool unless the Report Protected Identities checkbox is marked. When the Report Protected Identities checkbox is marked on the extract editor, information reports from Identities > Protected Identity Information. If the gender field is blank, information reports from the Demographics tool. Alphanumeric, 1 character | Demographics > Gender identity.gender Identities > Protected Identity Information > Gender legal.Gender |
| 13 | Incident Date | Identifies the date on which the behavior event occurred. Date field, 10 characters mm/dd/yyyy | Behavior Management > Incident Information > Time of Incident BehaviorIncident. timestamp |
| 14 | Incident Code | The code identifying the behavior incident. Numeric, 10 digits | Behavior Management > Incident > Incident ID BehaviorIncident. incidentID |
| 15 | Primary Code | Reports the State Event Code of the event indicated as Primary. If more than one event is marked as Primary for the same student, reports the event with the lowest event ID. Reports as blank if no events have Primary selected. Alphanumeric, 5 characters | Behavior Management > Incident > Event > Participant > Offense Type > Primary BehaviorRole. violationlevel1 |
| 16 | Offense Code 2 | Reports the State Event Code of the event indicated as Secondary. If more than one event is marked as Secondary for the same student, reports the event with the lowest event ID. Reports as blank if no events have Secondary selected. Alphanumeric, 5 characters | Behavior Management > Incident > Event > Participant > Offense Type > Secondary BehaviorRole. violationlevel2 |
| 17 | Offense Code 3 | Reports the State Event Code of the event indicated as Tertiary. If more than one event is marked as Tertiary for the same student, reports the event with the lowest event ID. Reports as blank if no events have Tertiary selected. Alphanumeric, 5 characters | Behavior Management > Incident > Event > Participant > Offense Type > Tertiary BehaviorRole. violationlevel3 |
| 18 | Firearms Confiscated | The number of confiscated weapons associated with the student that are considered Firearms. The Weapon Type field only displays on the Event if the State Code and Classification is Weapon. The Weapons Mapping below explains whether a weapon is considered a firearm. Numeric, 5 digits | Behavior Management > Incident Information > Event > Participant Details > Weapon Type BehaviorWeapon.Type |
| 19 | NonFirearms Confiscated | The number of non-firearm objects confiscated for all events in an incident. The Weapon Type field only displays on the Event if the State Code and Classification is Weapon. The Weapons Mapping below explains whether a weapon is considered a firearm. Numeric, 5 digits | Behavior Management > Incident Information > Event > Participant Details > Weapon Type BehaviorWeapon.Type |
| 20 | Final Discipline | The discipline resolution of the behavior event. See the following Resolution Options for values. Numeric, 2 digits | Behavior Management > Incident Information > Resolution > Resolution Type behaviorResolution.code |
| 21 | No. Days Suspended Expelled | The number of days for which the student was suspended or expelled. Reports the value entered in the Suspended or Expulsion Days field on the Resolution editor, or calculates the instructional days from the Resolution Start Date to the End Date. When the Final Discipline Resolution code is 99, this element reports 0. Numeric, 3 digits | Behavior Management > Incident Information > Resolution |
| 22 | No. of Victims | The number of participants in the incident with a Role of Victim. Individuals will report only once. Numeric, 2 digits | Behavior Management > Incident Information > Participant Details > Role: Victim behaviorEvent. numOfStuVictims |
| 23 | Alternate Placement | Indicates if the student was placed in an alternative education program as a result of this behavior event. Alphanumeric, 1 character Y or N | Behavior Management > Incident Information > Resolution > Alternate Placement behavior.altPlacement |
| 24 | Permanent Expulsion | Indicates if the student was expelled permanently as a result of the behavior event. Reports as Y of the Behavior Resolution was 04, otherwise reports N. Alphanumeric, 1 character | Behavior Management > Incident Information > Resolution Details > Resolution Type Determined from behaviorResolution.code |
| 25 | Time of Incident | The time of day in which the incident occurred. See the following Time of Incident Options table for values. Numeric, 2 digits | Behavior Management > Incident Information > Time of Incident BehaviorIncident. timestamp |
| 26 | LEP | Indicates if the student is participating in an English Learners (EL) Program. Reports as Y if the student has an EL record with an Identified Date that on or before to the Incident Date and the Program Exit Date is null or after the Incident date. Otherwise, reports as N. Alphanumeric, 1 character Y or N | English Learners (EL) > Identified Date, Program Exit Date Calculated, not dynamically stored |
| 27 | Reported to Law Enforcement | Indicates if law enforcement was contacted as a result of the behavior event. The following State Event Codes report Y even if Event > Law Enforcement Notified is not marked: AL1, AC1, AC2, AC3, BO1, BO2, BO3, BA1, BA2, BA3, BA4, BA5, BB1, BU2, DR1, DR2, DR3, DR4, DR5, DG1, DG2, DG7, DG8, D20, DG5, D17, DG3, DG9, D19, DG6, D10, D11, D12, HO1, HO2, HO3, HO4, SB1, SB2, ST1, SX3, SX4, SX5, SX6, SX7, SX8, TI1, WP0, WP1, WP2, WP4, WP6 WP7, WP8, WP9, and W2P. All other state events report N, even if Event > Law Enforcement Notified is marked. Alphanumeric, 1 character Y or N | Behavior Management > Incident Information > Event Details > Law Enforcement Notified behaviorEvent. policeReport |
| 28 | Permanent Change in Placement | Indicates whether the student's alternate placement is permanent. Alphanumeric, 1 character Y or N | Behavior Management > Incident Information > Resolution Details > Permanent Change in Placement BehaviorResolution. |
| 29 | Providing Education Services | Indicates whether services were provided during the student's removal. Alphanumeric, 1 character Y or N | Behavior Management > Incident Information > Resolution Details > Services Provided During Removal BehaviorResolution. servicesProvided |
| 30 | Law Enforcement Charges Filed | The code from the Charges Filed field. If that field is empty, N reports. The following State Event Codes report Y when the Reported to Law checkbox is marked and the Resolution > Charges Filed is Y: Charges Filed: AL1, AC1, AC2, AC3, BO1, BO2, BO3, BA1, BA2, BA3, BA4, BA5, BB1, BU2, DR1, DR2, DR3, DR4, DR5, DG1, DG2, DG7, DG8, D20, DG5, D17, DG3, DG9, D19, DG6, D10, D11, D12, HO1, HO2, HO3, HO4, SB1, SB2, ST1, SX3, SX4, SX5, SX6, SX7, SX8, TI1, WP0, WP1, WP2, WP4, WP6 WP7, WP8, WP9, and W2P. N reports when the state coded events above are selected and the Resolution > Charges Filed = N: No charges Filed or blank. N also reports when the event is not one of the state coded events listed above even if the Resolution > Charges Filed = Y, N or blank. Alphanumeric, 1 character | Behavior Management > Incident Information > Resolution Details > Charges Filed Behavior.charges |
| 31 | Aggravating Circumstances | Indicates whether the offense involved physical harm or credible threat of physical harm to others. Grades KG- 12
Grade PK
All others report N. Alphanumeric, 1 character | Behavior Management > Incident Information > Resolution Details > State Code |
| 32 | State Testing Identifier | This field reports the number provided by the state that uniquely identifies the student. Alphanumeric, 10 digits | Demographics > Student State ID Person.stateID |
| 33 | Graded Work Provided | This field reports whether Yes or No is selected on the Behavior Resolution. Y reports when Graded Work Provided is Yes. Otherwise, N reports when No is selected or the field is blank. Alphanumeric, 1 character | Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Graded Work Provided BehaviorResolution.workProvided |
Disability Options
Numeric Code | Code | Description |
|---|---|---|
01 | MR | Mental Retardation |
03 | MD | Multiple Disabilities |
04 | OI | Orthopedic Impairment |
05 | VI | Visual Impairment |
06 | HI | Hearing Impairment |
07 | SLD | Specific Learning Disability |
08 | ED | Emotional Disturbance |
09 | SLI | Speech or Language Impairment |
10 | OHI | Other Health Impairment |
12 | DB | Deaf-blindness |
13 | AUT | Autism |
14 | TBI | Traumatic Brain Injury |
15 | 504 | |
16 | DD | Developmental Delay |
19 | ID | Intellectual Disabilities |
Race/Ethnicity Options
Code | Description |
|---|---|
| One Race | |
01 | American Indian/Alaska Native |
02 | Asian |
03 | Black or African American |
05 | White |
06 | Native Hawaiian/Other Pacific Islander |
| Combination of Two Races | |
07 | American Indian/Alaska Native and Asian |
08 | American Indian/Alaska Native and Black or African American |
09 | American Indian/Alaska Native and White |
10 | American Indian/Alaska Native and Native Hawaiian |
11 | Asian and Black or African American |
12 | Asian and White |
13 | Asian and Native Hawaiian |
14 | Black or African American and White |
15 | Black or African American and Native Hawaiian |
16 | Native Hawaiian and White |
| Combination of Three Races | |
17 | American Indian/Alaska Native, Asian and Black or African American |
18 | American Indian/Alaska Native, Asian and White |
19 | American Indian/Alaska Native, Asian and Native Hawaiian |
20 | Asian, Black or African American and White |
21 | Asian, Black or African American and Native Hawaiian |
22 | Black or African American, White and Native Hawaiian |
23 | Black or African American, Native Hawaiian and American Indian/Alaska Native |
24 | White, Black or African American and American Indian/Alaska Native |
25 | White, Native Hawaiian and American Indian/Alaska Native |
26 | White, Native Hawaiian and Asian |
| Combination of Four Races | |
27 | American Indian/Alaska Native, Asian, Black or African American and White |
28 | Asian, Black or African American, White and Native Hawaiian |
29 | Black or African American, White, Native Hawaiian and American Indian/Alaska Native |
30 | White, Native Hawaiian, American Indian/Alaska Native and Asian |
31 | Native Hawaiian, American Indian/Alaska Native, Asian and Black or African American |
| Combination of Five Races | |
32 | American Indian, Asian, Black or African American, White and Native Hawaiian |
Resolution Options
Code | Description |
|---|---|
01 | In-School Suspension |
02 | Short Term Suspension |
03 | Long Term Suspension |
04 | Expulsion |
05 | Spec Ed - Placement, LEA decision |
06 | Spec Ed - Placement, officer decision |
07 | Modified expulsion by LEA |
08 | Sped Students only - IEP Permanent change in placement |
99 | None of the above |
Time of Incident Options
Code | Description |
|---|---|
01 | During regular school day |
02 | During school activity - outside regular day |
03 | During non-school activity - outside school day |
04 | In transit to or from school |
Weapons Mapping
The Weapons Mapping below explains whether a weapon is considered a firearm.
Code | Description | Firearm? |
|---|---|---|
01 | Handgun | Y |
02 | Shotgun/Rifle | Y |
03 | Pellet/BB/Air Gun | Y |
04 | Paintball Gun | N |
05 | Replica/Toy Gun | N |
06 | Other firearm | Y |
07 | Stun Gun/Taser Gun | N |
08 | Knife: blade length less than 2.5 inches | N |
09 | Knife: blade length 2.5 inches or greater | N |
10 | Other sharp object | N |
11 | Blunt object | N |
12 | Other object | N |
13 | Noxious substance | N |
14 | Substance used as weapon | N |
15 | Explosive device (e.g., bomb) | N |
16 | Other weapon | N |
17 | Unknown weapon | N |
18 | None | N |
