Import CALPADS Student EL Acquisition Records

Student ELA history can be tracked as students may have more than one ELA record. You can create an import template, and import ELA records which are stored in the [ S_CA_STU_ELA_C] database extension.

• [Students]DCID is used to match the imported record with the student.
• To update or modify an existing record, the [S_CA_STU_ELA_C]ID should be populated.
• If you are creating a new record, the [S_CA_STU_ELA_C]ID should be blank.
• The S_CA_STU_ELA_C.StudentsDCID field associates the record with the student.
• Make sure that School: District Office is selected.

Create an Import Template

1. Select School: District Office.
2. Select a student who has at least one record under Start Page > Student Selection > California State Information > CALPADS English Learners and Immigrant Information > CALPADS ELA Status History.
3. Go to Start Page > System Administrator > Page and Data Management > Data Export Manager.
4. Select Category > Database Extensions.
5. Select Export from S_CA_STU_ELA_C.
6. Select the "STUDENTS.S_CA_STU_ELA_C" checkbox so that all the seven fields are exported.
   1. ID
   2. StudentsDCID
   3. ELAStatus
   4. ELAStatusEndDate
   5. ELAStatusStartDate
   6. ExcludeFromStateReporting
   7. PrimaryLanguage
7. By default, the 'Use current student selection: 1' is selected. Click Next.
8. Click Export. A file is generated. This file can be used as an Import template to import Student ELA records.

If you want to export the student's name, scroll down and select the option LastFirst and then click Next.

Import CALPADS Student EL Acquisition Records

1. Go to Start Page > System Administrator > Page and Data Management > Data Import Manager.
   1. Click Source and select the file to be imported.

   2. Import the file into S_CA_STU_ELA_C and then click Next. The fields should automatically map.

      

      If "STUDENTS.LastFirst" is included in the exported file, do not map this field.

2. Select the option Exclude the first row (contains headers).
3. Set the other options depending on the import requirement.
4. Click Import.