2021-2022 Loading CRDC – School Form

There are 14 available custom CRDC files which may be loaded for answering 25 questions under the CUSTOM Data Sources section on the CRDC Report Center main page. The File Center uploads link the student or staff member to the PEIMS data to completely fill out all of the columns and rows (gender, ethnicity, EL, IDEA, Section 504) for particular questions that can’t be solely answered with PEIMS data.

Please note, these uploads are not designed for third party products, for example the SIS files, which have already formatted the OCR columns in their systems. We are calculating the columns in our system based on matching the ID to the PEIMS data and creating the same OCR columns in our CSV extract files.

Format for CUSTOM Data Sources CSV Files (No header!):

• Staff – SSN or TX Unique ID in column 1 and County District Campus # in column 2

• Student – TX Unique ID, SSN, or Local ID in column 1 and County District Campus # in column 2

EXAMPLE

To upload your custom data sources’ CSV files, navigate to the File Center.  All files can be loaded with the CRDC SCHOOL FORM tab.

1. Click the green “Click to upload SCHOOL FORM files” bar to first locate and open the file.
2. Choose the appropriate CRDC Section depending on the file being loaded.

3. Once the CRDC Section is chosen, the CRDC Data Type dropdown is populated with the corresponding questions. Choose the appropriate CRDC Data Type.
4. Click Start Upload

TIPS: 

• The user must select a CRDC Section and CRDC Data Type.
• We highly suggest naming the custom files suggested below. This aids with troubleshooting.
• If a file is reloaded for the same CRDC Section and Data Type, it will overwrite and replace the previous file except for the SECR section if it is edited at any point.
• You may edit and re-load each of the files as often as you like, but do not load multiple files for the same CRDC Section and Data Type at the same time.
• Use the trashcan delete button to completely remove a file.

Summary of File Uploads Checklist

1) Security Staff – Sworn Law Enforcement Officers	SECR1_sworn_law_enf.csv
2) Security Staff – Security Guards	SECR1_security_guards.csv
3) Corporal Punishment	DISC_corporal_pun.csv
4) Students referred to law enforcement agency or official	ARRS_law_enforce_referral.csv
5) Students who received a school related arrest	ARRS_school_arrest.csv
6) Students reported as harassed or bullied based on sex	HIBS_student_harassed_sex.csv
7) Students reported as harassed or bullied based on race,  or color or national origin	HIBS_student_harassed_race.csv
8) Students Reported as harassed or bullied based on disability	HIBS_student_harassed_disability.csv
9) Students disciplined for harassment or bullying on basis of sex	HIBS_disc_harass_sex.csv
10) Students disciplined for harassment or bullying on basis of race,  or color or national origin	HIBS_disc_harass_race.csv
11) Students disciplined for harassment or bullying on basis of disability	HIBS_disc_harass_disability.csv
12) Students subjected to mechanical restraint	RSTR_mech_restraint.csv
13) Students subjected to physical restraint	RSTR_physical_restraint.csv
14) Students subjected to seclusion	RSTR_seclusion.csv