Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
state_reporting:create_deletion_extract [2017/02/15 18:56] max [SCSE File] |
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 49: | Line 52: | ||
| - 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** | ||