Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
state_reporting:create_deletion_extract [2017/02/14 23:52]
max added screenshots
state_reporting:create_deletion_extract [2017/02/16 21:10] (current)
max [Fall 2: Creating a Deletion Extract from CALPADS ODS Extract]
Line 2: Line 2:
  
 ====== Fall 2: Creating a Deletion Extract from CALPADS ODS Extract ====== ====== Fall 2: Creating a Deletion Extract from CALPADS ODS Extract ======
-The purpose of this manual is to assist in removing Course Section Enrollments and Students Course Section Enrollment records from the state system. This is a work around due to the **CALPADS known issues**;+The purpose of this manual is to assist in removing Course Section Enrollments and Students Course Section Enrollment records from the state system. This is a work around due to the **CALPADS known issues**:
   * #2899-CRSE file is not overwriting Course Section data correctly and    * #2899-CRSE file is not overwriting Course Section data correctly and 
   * #2879-SCSE file is not overwriting Student Course Section data correctly. ​   * #2879-SCSE file is not overwriting Student Course Section data correctly. ​
Line 41: Line 41:
       * Find - **N^^^2^^20170209^20170209**       * Find - **N^^^2^^20170209^20170209**
       * Replace with - **N^^^2^**       * Replace with - **N^^^2^**
 +    * **Example 4**:
 +      * Find- **Y^N^1^^^N^20170203^20170203**
 +      * Replace with- **Y^N^1^^^**
  
 ==== SCSE File ==== ==== SCSE File ====
Line 48: Line 51:
     * Replace with - **SCSE^D^^**     * Replace with - **SCSE^D^^**
   - Stripping away extra fields at the end of each line. **__(When you have completed this task you should see no years at the end of each line)__**   - Stripping away extra fields at the end of each line. **__(When you have completed this task you should see no years at the end of each line)__**
-    * Find - **S1^^^^^^20170209^20170209** +    * Find - **S1^^^^^20170209^20170209** 
-    * Replace with - **S1**+    * Replace with - **S1^^^^^**
     * Find - **S1^^^^C^^20170209^20170209**     * Find - **S1^^^^C^^20170209^20170209**
     * Replace with - **S1^^^^C**     * Replace with - **S1^^^^C**
  • state_reporting/create_deletion_extract.1487116349.txt.gz
  • Last modified: 2017/02/14 23:52
  • by max