Loading CRDC – School Form

There are 13 available CUSTOM Data Sources files which may be loaded for answering 22 questions. 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, LEP, etc.) 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

See CRDC Instructions 2021.1.2 starting with page 9 for more details.

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.
• 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. BEST Practice: Do one upload at a time waiting for the current file to finish processing before loading the next one.
• If you need to clear previously loaded data or want the loaded check to be green in the data map, simply load a CSV file containing a single 0. See example below using Microsoft Excel.

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-A_law_enforce_referral.csv
5) Students who received a school related arrest	ARRS-B_school_arrest.csv
6) Students reported as harassed or bullied based on sex	HIBS2_student_harassed_sex.csv
7) Students reported as harassed or bullied based on race,  or color or national origin	HIBS2_student_harassed_race.csv
8) Students Reported as harassed or bullied based on disability	HIBS2_student_harassed_disability.csv
9) Students disciplined for harassment or bullying on basis of sex	HIBS3_disc_harass_sex.csv
10) Students disciplined for harassment or bullying on basis of race,  or color or national origin	HIBS3_disc_harass_race.csv
11) Students disciplined for harassment or bullying on basis of disability	HIBS3_disc_harass_disability.csv
12) Students subjected to mechanical restraint	RSTR-A_mech_restraint.csv
13) Students subjected to physical restraint	RSTR-B_physical_restraint.csv