Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
state_reporting:create_deletion_extract [2017/02/14 23:27] max created |
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. | ||
| - | The most common error the defects are causing is the SCSE0139-Student Course Section record must have a corresponding Course Section record. To complete this work around you must pull CRSE and SCSE records from the CALPADS ODS. | + | The most common error the defects are causing is the **SCSE0139-Student Course Section** record must have a corresponding Course Section record. To complete this work around you must pull **CRSE** and **SCSE** records from the CALPADS ODS. |
| ===== How to Pull an ODS Extract: ===== | ===== How to Pull an ODS Extract: ===== | ||
| - Log into CALPADS | - Log into CALPADS | ||
| - | - Go under Reports Extracts | + | - Go under Reports **Extracts** \\ {{:state_reporting:create_deletion_extract1.png?nolink&300|}} \\ |
| - | - Under Request CALPADS Files click on ODS Extracts | + | - Under **Request CALPADS Files** click on **ODS Extracts** \\ {{:state_reporting:create_deletion_extract2.png?nolink&400|}} \\ |
| - | - Select Course Section Enrollment ODS Download, then click Request File. After File has been requested click Return to Request Extract Files. | + | - Select **Course Section Enrollment ODS Download**, then click **Request File**. After File has been requested **click Return to Request Extract Files**. \\ {{:state_reporting:create_deletion_extract3.png?nolink&500|}} \\ |
| - | - Go to Retrieve CALPADS Files, click on ODS Extracts. | + | - Go to **Retrieve CALPADS Files**, click on **ODS Extracts**. \\ {{:state_reporting:create_deletion_extract4.png?nolink&500|}} \\ |
| - | - Select & Download Course Section Enrollment ODS Download. Click Apply Filter | + | - Select & Download **Course Section Enrollment ODS Download**. Click **Apply Filter** \\ {{:state_reporting:create_deletion_extract5.png?nolink&600|}} \\ |
| - | - File will show below after selection the Extract Type. Download & Save. | + | - File will show below after selection the Extract Type. **Download & Save**. \\ {{:state_reporting:create_deletion_extract6.png?nolink&700|}} \\ |
| * **__REPEAT Steps Above to Pull a Student Course Section Enrollment ODS Download__** | * **__REPEAT Steps Above to Pull a Student Course Section Enrollment ODS Download__** | ||
| Line 21: | Line 21: | ||
| When the file is pulled from CALPADS there are some __extra fields at the end of each line that need to be stripped away__ and the __deletion indicator needs to be entered__. The easiest way to this is through a “find-and-replace” on the txt file. | When the file is pulled from CALPADS there are some __extra fields at the end of each line that need to be stripped away__ and the __deletion indicator needs to be entered__. The easiest way to this is through a “find-and-replace” on the txt file. | ||
| ==== CRSE File ==== | ==== CRSE File ==== | ||
| - | Here is a sample line of a CRSE file. | + | Here is a sample line of a CRSE file. \\ {{:state_reporting:create_deletion_extract7.png?nolink&700|}} \\ |
| - To turn the file into a deletion file | - To turn the file into a deletion file | ||
| - | * Find - CRSE-R^^^ | + | * Find - **CRSE-R^^^** |
| - | * Replace with - CRSE^D^^ | + | * Replace with - **CRSE^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). | ||
| * **Example 1**: | * **Example 1**: | ||
| - | * Find - Y^^^^N^20170209^20170209 | + | * Find - **Y^^^^N^20170209^20170209** |
| - | * Replace with - Y^^^^ | + | * Replace with - **Y^^^^** |
| - | * Find - N^^^^N^20170209^20170209 | + | * Find - **N^^^^N^20170209^20170209** |
| - | * Replace with - N^^^^ | + | * Replace with - **N^^^^** |
| * **Example 2**: | * **Example 2**: | ||
| - | * Find - Y^^^^A^20170209^20170209 | + | * Find - **Y^^^^A^20170209^20170209** |
| - | * Replace with - Y^^^^A | + | * Replace with - **Y^^^^A** |
| - | * Find - N^^^^A^20170209^20170209 | + | * Find - **N^^^^A^20170209^20170209** |
| - | * Replace with - N^^^^A \\ <wrap important>**The two examples above may appear differently on your extract with different letters possibly G or B. Either way the line needs to be stripped back to the letter.** </wrap> | + | * Replace with - **N^^^^A** \\ <wrap important>**The two examples above may appear differently on your extract with different letters possibly G or B. Either way the line needs to be stripped back to the letter.** </wrap> |
| * **Example 3**: | * **Example 3**: | ||
| - | * Find - Y^^^2^^20170209^20170209 | + | * Find - **Y^^^2^^20170209^20170209** |
| - | * Replace with - Y^^^2^ | + | * Replace with - **Y^^^2^** |
| - | * 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 ==== | ||
| - | Here is a sample line of a SCSE file. | + | Here is a sample line of a SCSE file. \\ {{:state_reporting:create_deletion_extract8.png?nolink&700|}} \\ |
| - | SCSE-R^^^0220574^0220574^2016-2017^1123712963^166842^John^Student^20000216^F^2618-1^KCAL43I33P^S1^^^^^^20170209^20170209 | + | |
| - | + | ||
| - To turn the file into a deletion extract | - To turn the file into a deletion extract | ||
| - | * Find - SCSE-R^^^ | + | * Find - **SCSE-R^^^** |
| - | * 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** |
| <WRAP center round important 60%> | <WRAP center round important 60%> | ||