The ROP Extract has the abillity to create two extract files. The ROP Extract file includes student demographic information and ROP class information. The ROP Extract: Minutes Per Class Per Day file includes the daily number of attendance minutes that the student completed while in the ROP class. It also includes an attendance code when appropriate.
Below is a listing of the fields in the ROP Extract file and the ROP Extract: Minutes Per Class Per Day file.
ROP Extract
Naming convention of the downloaded data file is: yyyy_mm_dd_ROP.csv where yyyy_mm_dd is the date that the file is created. For example 2020_6_25_ROP.csv
Field | Aeries Field | Additional Information |
ATT_ROW_ID | STU.ID - MST.SE | A combination of the student id and the section number of the class separated by a dash. (Ex. 123456-0001) |
DISTRICT_ID | LOC.CC+LOC.DC+LOC.SC for School 0 | District CDS Code |
AC_CODE | C | C |
CONC_HS_SITE_ID | LOC.SC or LOC.CC+LOC.DC+LOC.SC for the school being reported | If the option to "Extract Full CDS# Instead of School#" is not selected, the LOC.SC will be used. If it is selected the full CDS code LOC.CC+LOC.DC+LOC.SC is reported. |
CSIS_NUMBER | STU.CID | Student State ID |
HIGH_SCHOOL_STUDENT_NUMBER | STU.ID | |
LAST_NAME | STU.LN | |
FIRST_NAME | STU.FN | |
MIDDLE_NAME | STU.MN | |
BIRTHDATE | STU.BD | YYYYMMDD format |
BIRTHPLACE | STU.BCY, STU.BST, STU.BCU | Birth City, State and Country separated by commas. Field wrapped in quotes when there is a comma. (Ex. "Eagle Point, CA, US") |
GENDER | STU.GN | |
IS_HISPANIC | STU.ETH | Either 'YES' or blank |
RACE_CODES | STU.RC1, STU.RC2, STU.RC3, STU.RC4, STU.RC5 | When a student has multiple races, the codes will be separated by commas. Field wrapped in quotes when there is a comma. (Ex. "100,700") |
LANGUAGE_ID | STU.HL | |
STREET | STU.AD | |
CITY | STU.CY | |
STATE | STU.ST | |
ZIP | STU.ZC | |
HOME_PHONE | STU.TL | |
EMER_PHONE | CON.TL, CON.WP, or CON.CP | |
EMER_PHONE_EXT | CON.WX | |
EMER_CONTACT | CON.NM or CON.LN, CON.FN | The first Contact record for the student is selected based on Contact Order (CON.OR) |
GRADE_LEVEL | STU.GR | |
ENROLL_DATE | CAR.DS | YYYYMMDD format |
EXIT_DATE | CAR.DE | YYYYMMDD format |
GRADE_EARNED | GRD.MK | The most recent grade mark for the course. |
FISCAL_YEAR | 20xx where xx is the school year | Derived from the database year (Ex. 2019 from the 2019-2020 database) |
FY_TERM | MST.SM | |
COURSE_TITLE | CRS.CO | |
SECTION_ID_1 | TCH.TE | Teacher Name - of the primary teacher teaching the class |
SECTION_ID_2 | MST.PD | |
SECTION_ID_3 | CRS.CN | |
SECTION_ID_4 | MST.SE | |
DISABILITY_CODES | CSE.DI,CSE.DI2 | Only include codes for students that have active Special Ed records. Up to 2 disability codes separated by a comma. Field wrapped in quotes when there is a comma. (Ex. "240,200") |
STUDENT_EMAIL | STU.SEM | |
PARENT_NAME | CON.LN, CON.FN | One Contact record is selected where one of the following conditions is satisfied: Primary Contact (CON.PC = 'Y'), or Ed. Rights Holder (CON.ERH = 'Y'), or Lives With (CON.LW = 'Y'), or a Primary Contacts (CON.C1F > '' or CON.C2F > '') |
PARENT_EMAIL | CON.EM | |
ENGLISH_LANGUAGE_LEARNER | YES or blank | YES for EL students. Derived from STU.LF and CALPADS code translation mapping |
ATT_MINUTES | Calculated total instructional minutes for the class based on the "Date Range to Process" option | |
ATT_PERIOD_START | Start Date from "Date Range to Process" option | YYYYMMDD format |
ATT_PERIOD_END | End Date from "Date Range to Process" option | YYYYMMDD format |
ROP Extract: Minutes Per Class Per Day
Naming convention of the downloaded data file is: yyyy_mm_dd_ROP_Daily.csv where yyyy_mm_dd is the date that the file is created. For example 2020_6_25_ROP_Daily.csv
Field | Aeries Field | Additional Information |
---|---|---|
ATT_ROW_ID | STU.ID - MST.SE | A combination of the student id and the section number of the class separated by a dash. (Ex. 123456-0001) |
ATT_DATE | ATT.DT | YYYYMMDD format. Attendance dates are bound by the "Date Range to Process" option |
ATT_TYPE | A | A |
ATT_MINUTES | Calculated number of minutes for the class period or 0 if student was absent | |
ATT_CODE | ATT.A0 - ATT.A9 | Absence code for the class period the class is in. If the class is blocked (2 or more periods) and the student was absent for more than one period each code will be separated by a comma. Field wrapped in quotes when there is a comma. (Ex. "A,A") |