Overview
This job aid shows campus users how to clear the L15 staging tables.
Background
- Clearing the staging tables removes selected history rows from the staging tables for the current date loaded.
- Sometimes data is loaded to the staging tables that requires only campus review (example: Prob-to-Perm data passing validations and loading straight to Job).
- Even if there was nothing else for you to do with the current file, you must clear the staging tables to allow the next file to load.
Before you start
Do not clear the staging table until you are absolutely sure all work has been completed.
Clear the L15 Staging Tables
Step 1: Open the Navbar button.
Step 2: Navigate to Menu > Workforce Administration > CSU Workforce Admin Process > CSU SSI/GSI, Prob-To-Perm > CSU Clear Staging Tables.
Step 3: Search for your Run Control ID.
Step 4: Verify your Business Unit and Current Date Loaded are correct. The run control requires a business unit to be selected.
If no date exists, then there is nothing to close, and no action is needed.
Step 5: Select the Completed check box.
Step 6: Click Run.
The following tables will have their values deleted/updated by Business Unit, Date Loaded, and Completed Flag = Yes:
- PS_CSU_SAL_PLN_AUD Delete: SSI/GSI audit table
- PS_CSU_SAL_EXCPTN Delete: SSI/GSI exception table
- PS_CSU_SALARY_PLAN Delete: SSI/GSI staging table
- PS_CSU_PRB_PRM_EXC Delete: Prob-to-Perm exception tbl
- PS_CSU_PRB_PRM_AUD Delete: Prob-to-Perm audit table
- PS_CSU_L15_TRACK Update: Track file processing
Step 7: Return to SSI/GSI, Prob-to-Perm (L15) Checklist to check the Clear Staging Table check box and finish the process.
End of Article
0 Comments
Add your comment