| Task ID | Task Start Date |
Task | Description | Responsible Area/Person |
| LAST UPDATED: | 6/27/2007 11:25 AM | |||
| LB0001 | Complete | Portal Entry Page servers | Install and setup the new portal entry page servers. | Don |
| O0001 | Complete | CreateMaster Project | Create a master project using application desisgner with all of the Northridge Modifications. | George |
| M0001 | WIP | Load Balancers | Set up the new portal infrastructure. | ITR |
| O0002 | Complete | Export Master Project to file | Using application desinger, export file | George |
| LB0002 | Complete | Install Software | Install the Apache web server and pep applications onto the pep servers | Ryan |
| V0001 | Complete | Disable student self-service. | change the end date and times for availability of student self service to 6/22/07 at 5:00pm. | Daveen |
| V0002 | Complete | Clone HNRPRD | Clone HNRPRD to a non-production instance (H8NRTST) for backup. | Collin |
| O0003 | Complete | Create Roles Project, Recurrance Definitions, Messages, and tree project. | Using application designer, create files with all roles, permissions trees, Recurrence Definitions because roles can not be saved to a file. Copy the file from database to database | George |
| M0005 | Complete | View Only Environment | Set up the view-only environment for HRSA using non-production. | ITR |
| M0007 | Complete | WebCT programs | Move WebCT perl programs into the /var/apache/cgi-bin from /var/apache/cgi-bin/dvl | Ron, Kate |
| V0004 | Complete | Clone DARSPRD | Clone DARSPRD to DARSDVL | Michele |
| V0005 | Complete | Stop PANRPRD processes | Stop all processes running in PANRPRD. Configure PANRPRD to not point to Starling. | Michele |
| V0006 | Complete | Clone PANRPRD | Clone PANRPRD to a non-production instance (PANRCNV). | Michele |
| V0003 | Complete | Turn off Ad Astra | Disable the interface between CMS and Ad Astra. | Sean |
| V0007 | Complete | Configure Process Scheduler | Configure PANRCNV to point to the process scheduler on Starling. | Michael |
| M0002 | Complete | Stop Scheduled Processes | Turn off scheduled processes in HNRPRD prior to 5pm 6/21. | Campus |
| M0003 | Complete | LDAP/HRSA interfaces | Turn off scheduled LDAP/HRSA processes in the Directory environment prior to 5pm 6/21. | Ryan |
| M0004 | Complete | SOLAR HR/SA down message | Create a message published on the portal entry page regarding SOLAR HR and SA environments being unavailable. | Ryan |
| SA0001 | Complete | External Org Part 1 | In HNRPRD run CC0009 in extract mode before the clone for 8.9 production. | Julia |
| V0008 | Complete | Turn off QuickAdmit | Turn off the quickadmit process. | Ping |
| V0009 | Cancelled | Disable access to PEP components | Disable access to specific administrative menu items for PEP in PANRCNV. | Sean |
| V0011 | Complete | Turn off Application Messaging | Turn off Application Messaging in the HNRPRD environment | Michael |
| V0012 | Complete | Disable Alert MViews | Refresh Alter materialized views in PANRPRD then disable using supplied script. | Michele |
| V0013 | Complete | Shutdown HNRPRD | Shutdown the HNRPRD instance and start backup. | CMS |
| P0001 | Complete | Backup Production | Backup the production portal environment. | Michele |
| V0014 | Complete | Restore Prod Backup | Restore (clone?) the production environment into H8NRCNV for view-only. | CMS |
| V0017 | Complete | Permissions project | Apply a project containing permission lists that can not be view-only i.e. DARS-related to HRSA. | Collin |
| V0015 | Complete | Student setup | Configure the student self-service setup to limit access. | Daveen |
| V0016 | Complete | Run View-Only scripts | Run the sql scripts to set components to display only. | Ron/Collin |
| V0010 | Complete | Clear Process Scheduler | Clear out the process scheduler so that no processes are scheduled. | Ron/Collin |
| V0020 | Complete | Set up DARS | Configure the non-production HRSA environment to integrate to the non-production DARS environment. | Lily |
| V0018 | Complete | ERPPRD HRSA dblink | the HRSA dblink in erpprd needs to be changed to point to the HRSA view only database. | Michele |
| V0019 | Complete | Set up SSO to HRSA | Configure the non-production portal to SSO to the non-production HRSA environment. | Michele |
| V0021 | Complete | Validate | Validate the environment. Test SSO to ERP, Finance, HRSA, etc. | |
| M0006 | Complete | SOLAR HR/SA view only message | Create a message published on the portal entry page regarding SOLAR HR and SA environments being available but as view-only. | Ryan |
| LB0003 | Complete | Raven httpd restart | Install ocaml compiler onto raven and restart the httpd process. | Ryan |
| LB0004 | Complete | MyNorthridge DNS | Change the MyNorthridge.csun.edu to point to the production servers. | Will |
| V0022 | Complete | Portal Entry Page | Switch the portal entry page to point to the non-production portal environment. | Michael |
| P0002 | Complete | Portal Enhancements | Install the portal enhancements to the production environment. | Collin |
| P0006 | Cancelled | Portal Sync SQR | run the CSUN portal security synchronization SQR to sync the security. | Michele |
| P0009 | Complete | Portal Registry Search | Run the portal registry search process to build the search database. | Collin |
| P0005 | Complete | Registry Structures | Run a sqr to fix registry structures. | Dan |
| P0011 | Complete | Recycle Web/App Servers | Recycle the portal web, process scheduler and app servers. | Michael/ Michele |
| P0007 | Complete | Portal Security Sync | Run the delivered portal security sync process. | Michele |
| P0008 | Complete | HRSA/Solar Link | Modify the generic HR/SOLAR link to come up in a separate window. | Michele |
| P0010 | Complete | Run DDD/SYS Audits | Run the DDD and SYS Audit reports and review. | Michele |
| P0012 | Complete | Validate Environment | Review environment. | ITR |
| P0013 | WIP | Address Issues | Fix any issues. | ITR |
| M0008 | WIP | Portal Enhancements | Apply the Portal Enhancement projects. | |
| M0010 | Complete | Object Migration | Extract all objects from HNRGLD and apply to the production environment. | George |
| O0004 | Complete | Import Master Project into production database. | Log into production database and import the master project from file. | George |
| M0011 | Complete | Configure Integration Broker | Configure all Integration Broker setups including Portal, Financials and Report Manager. Set up Finance to point the node to the new HCM using the connector that is not v8.1. Set up IB so that Report Manager publishes correctly. | Michael |
| M0009 | Complete | DB Links | Review all DB links to verify that they connect. | Michele |
| O0005 | Complete | Move Queries from PRJ | Move all queries from HNRPRJ | George |
| O0006 | Complete | Move Queries from GLD | Move all queries from HNRGLD | George |
| M0013 | Complete | Installation Table Updates | Update Installation Table with all necessary updates. : Modules checkboxes checked, including T&Labor, Absence Management; Update PS_INSTALLATION.EMPLID_LAST_EMPL with PS_INSTALLATION_SA.EMPLID_LAST_CS | Anu |
| M0012 | Complete | Update Fileshare | Apply all NR objects to the fileshare i.e. sqr's, crystals, etc. | Collin |
| O0007 | Complete | Build Records | Using Application Designer Build all records if they don't exist. Alter all records if they exist. | George |
| M0014 | Complete | Security | Process the security tasks. | Allen/Ron |
| O0008 | Complete | Build Views | Using Application designer, build all views. | George |
| O0009 | Complete | Apply NR89_SECURITY project | Move NR89_SECURITY project to target instance to migrate roles and permission lists. | George |
| O0010 | Complete | Validate/Fix objects | Review any errors applying the project and repair. | AdminSys |
| S0008 | Complete | SEC-28 | Clean up the PSAUTHITEM table due to SYSAUDIT errors. | AdminSys |
| S0001 | Complete | Validate roles and permission lists | Review roles and permission lists from the security project have copied ok | Allen |
| S0002 | Complete | Add permission list to role | Add NRPT_QUERY_CREATOR permission list to role | Allen |
| S0003 | Complete | Add permission list to role | Add NRCC Student Service Center permission list to role | Allen |
| S0004 | Complete | Table Set Control tree access | Add tree access to Table Set Control for SetId NRCMP | Allen |
| S0006 | Complete | Validate Shared role change | Run common query to validate NHSHARED not in any role and Spot check user profiles have new role and don't have delivered roles. | Allen |
| S0005 | Complete | Apply Shared role | Run script to grant NRPT SHARED role to user profile, remove PeopleSoft User and PAPP_USER role for user profile and remove NHSHARED permission list from all roles. | Ron |
| S0007 | Complete | Test ID Access | Grant access to Test ID to all members in NRAR ANR PROD and NRAR ANR SYSTEMS. Plus ARPRCS user id | Sean |
| S0010 | Complete | Query Access List Cache | Run the Query Access List Cache process. Ensure that it is enabled and scheduled nightly. | AdminSys |
| S0009 | Complete | Review Query trees | Validate query access trees converted ok | Allen |
| S0011 | Complete | Secure Search/Match and Results Codes | Secure delivered Search/Match parameters and Results Codes | Allen |
| S0013 | Complete | Review/Setup Core Row Level Security | Review/setup Core Row Level Security: Security Installation Settings, Security Sets, Security Access Type | Allen |
| S0014 | Complete | SJT Process | Run Refresh_SJT_CLASS_ALL and RefresH_SJT_OPR_CLS | Allen |
| S0015 | Complete | Remove My Profile | Remove Maintain_Security>My Profile access from NRPT_SHARED permission list. LDAP will manage password. Task only for go-live. | Allen |
| S0016 | Complete | U&F Security Project | Apply a project for access to new components delivered via Updates and Fixes. | George |
| S0012 | Complete | Setup Search/Match and Results Codes | Setup new Search/Match parameters and Results Codes values | Sean |
| M0015 | Complete | VERSIONS | Run the VERSION AE process to clear up SYSAUDIT errors. | AdminSys |
| O0011 | Cancelled | Menu Import (optional) | Run the Menu Import process for CSUN, CSUN SA and CSUN SA Self Service. | AdminSys |
| S0018 | Complete | Portal Security Sync | Run the Portal Security Synchronization process. | AdminSys |
| S0019 | Complete | Registry search index | Build the registry search for Verity. | AdminSys |
| S0021 | Complete | SYSAUDIT | Run the SYSAUDIT and review. | AdminSys |
| S0022 | Complete | DDDAUDIT | Run the DDDAUDIT and review. | AdminSys |
| S0020 | Complete | App/Web clear cache | Request for the app and web servers to be recycled and have the cache cleared. | CMS |
| M0016 | Complete | Data Validation | Review all steps in the validation directories (see notes). Include record counts, record comparison, orphan records and cleanup scripts | ITR (?) |
| S0017 | Complete | Schedule SJT | Schedule Nightly_SJT_Refresh_Process | |
| S0023 | Complete | Validate Security | Do high level testing | Allen |
| P0003 | Complete | project NR89_USER_ROLE_SYNC | Apply this User/Role project to address new messaging thru IB. | Sean |
| P0004 | Complete | PEP project | Apply the PEP project to the portal to address changes with the HCM89 environment. | Sean |
| M0017 | Complete | SYSAUDIT | Run the SYSAUDIT and review. | AdminSys |
| M0018 | Complete | DDDAUDIT | Run the DDDAUDIT and review. | AdminSys |
| M0019 | WIP | Fix AUDIT errors | Fix any significant errors reported in the audits. | ITR |
| H0001 | Complete | Turn Off Workflow | for all delivered business proceeses run 'disable_events.sql' ; This disables all but a small set of events | Anu |
| H0002 | Complete | Tax_Location_Cd | Required for Payroll for North America. Execute SQL update of all rows in ps_dept_tbl to set tax_location_cd = 'CA' | Anu |
| M0020 | Complete | HR Setup | Setup and implement HR environment | Anu |
| H0004 | Complete | Data Validation | Review all steps in the validation directories (see notes). Include record counts, record comparison, orphan records and cleanup scripts | Anu & Janice |
| SA0003 | Complete | Equation Engine DMS | Retain and load the setup for the equation engines for financial aid. | Collin |
| SA0007 | Complete | ECOUTMAP.SQC | Repliweb ecoutmap.sqc into production | Collin |
| SA0011 | Complete | SQL store statements | Apply the COBOL sql statements with the new tuning hints (HD89891). | Collin |
| M0021 | Complete | SA Setup | Setup and implement SA environment | Daveen |
| SA0002 | Complete | Rebuild missing objects | Rebuild missing indexes lost in the upgrade. These are indexes and audit flags that have to be set manually. | Daveen |
| SA0006 | Complete | Configure QuickAdmit | Run scripts to configure the Quick Admit process. | Daveen |
| SA0008 | Complete | Configure Self Service | Run scripts to configure the Self Service process. | Daveen |
| SA0010 | Complete | Configure Student Center | Run scripts to configure the Student Center. | Daveen |
| SA0012 | Complete | URL Maintenance | Setup CMS URL's maintenance. | Daveen |
| SA0014 | Complete | Address type OTR | Consolidate address types of other to OTHR. | Daveen |
| SA0015 | Complete | Gradebook icon | Remove Gradebook icon from the Faculty Center: Setup HRMS > Install > Installation Table under the Products tab uncheck “Gradebook”. | Daveen |
| SA0016 | Complete | SR0205 | SR0205 in the CSUN SA > Student Records > Reports menu – make sure it’s there. | Daveen |
| SA0017 | Complete | NR_SSS_QKADMIT_CMP | Make sure NR_SSS_QKADMIT_CMP is on the NR_SSS_LAUNCH_MENU “Use” option. | Daveen |
| SA0005 | Complete | Configure Cashnet | George | |
| H0003 | Complete | IB for HR Self Service | Ping the local gateway to make sure it works. | Janice Flynn |
| SA0013 | Complete | External Org Part 2 | After 8.9 conversion run CC0009 in upgrade mode to apply short descriptions (our abbreviations) back into external org table. | Julia |
| SA0018 | Complete | Test Scores conversion | Convert test scores from 8.0.to 8.9. | Julia |
| SA0004 | Complete | Configure DARS | Lily | |
| SA0019 | Complete | Student Center | Copy the student center project to pro | Ping |
| SA0020 | Complete | Grade Roster | Copy the grade roster project to produ | Ping |
| SA0009 | Complete | Recompile Packages | Recompile PL/SQL packages that have been modified for 89. | Sean |
| SA0021 | Complete | QuickAdmit Search/Match | Set up the quick admit search/match parameter to “Quick Admit” – CSU SA Baseline > CSU Student Records > Self Service Quick Admit > Setup > Quick Admit Installation. | Daveen |
| SA0022 | Complete | Inquire Enrollment Request | Add menu item Home > CSUN SA > Student Records > Inquire Enrollment Request (CSUN) for NR_SR_ENRL_REQ_INQ to the NR_SR_STUDENT_RECORDS menu. | Daveen |
| SA0023 | Complete | NR_SSS_WEKLY_SCHED | Add Component NR_SSS_WEKLY_SCHED to Menu NR_SSS_LUANCH_MENU under Bar Name Acad/Fin. Make sure structure and content also there. | Daveen |
| SA0024 | Complete | SA Enrollment security | go into Set Up SACR > Security > Secure Student Administration > Permission List > Enrollment Security. Find Primary Permission List NRSA_SELF_SERVICE_STUDENT and update the Enrollment Security record with Academic Institution: NRCMP and Enrollment Access ID: STDT. | Daveen |
| SA0025 | Complete | Student Access Control Table | it gives us access to a CSUN setup screen “Student Access Control Table”. | Lily |
| SA0026 | Complete | VISA PERMIT TYPE | The script will fix the data in VISA PERMIT TYPE table for blank duration type field. | Sean |
| H0005 | Complete | Convert Benefit Program | Check 8.9 Benefit Program Conversion (Is AY valid ??) | Anu & Janice |
| H0006 | Complete | Primary Perms Lists | Security | Janice Flynn |
| H0007 | Complete | Configure Time & Labor | Time & Labor modifications. | Janice Flynn |
| H0008 | Complete | GP_INSTALLATION | For Student Hire Check GP_INSTALLATION table settings. | Janice Flynn |
| H0009 | Complete | LCD configuration | Configure the Labor Cost Distribution module. | Janice Flynn |
| S0024 | Complete | Portal Sync SQR | run the CSUN portal security synchronization SQR to sync the security. | Michele |
| H0017 | Complete | Enable Access Type 009 for Security Set PPLPOI | Modify Security Set PPLPOI to be able to view access type 009 for student hires. | Janice |
| H0018 | Complete | Add Security Type Access to 2 Permission Lists | Security Type Access needs to added for 2 permission lists for Recruiting Needs. | Janice |
| H0012 | Complete | Set up Name Format | Update PS_OPR_DEF_TBL_HR and set COUNTRY_NM_FORMAT = "001". | Anu |
| H0013 | Complete | Check Installation settings |
Recruit Workforce Installation settings: Check Installation settings for: Recruit Workforce,Resume Processing, Candidate Gateway, Talent Acquisition Mgmt | Janice Flynn |
| H0014 | Complete | Recruiting Administor security | Update Permission Lists to grant privileges of Recruiting Administor. | Janice Flynn |
| H0015 | Complete | PS_HRS_JO_ALL_I | Modify PS_HRS_JO_ALL_I view according to Oracle Issue 1574361001 with code from Bundle #10. | Janice Flynn |
| H0016 | Complete | Update Task Profile Page to have NRCMP. | For Time and Labor Configuration. Under Setup HRMS -> Product Related -> Time and Labor -> Task Profile -> Value CSU. Under HR/TL Fields tab Add Business Unit NRCMP. | Nels |
| H0010 | Complete | LCD dblinks/views | Check dblinks for LCD and LCD Views | |
| H0011 | Complete | LCD Suspense Combo | Added SUSPENSE combo code for LCD/run Load Suspense Combination Code process for each fiscal year | |
| M0022 | Complete | Web server recycle | Request CMS to recycle and clear cache for the web servers. | AdminSys |
| M0023 | Complete | App server recycle | Request CMS to recycle and clear cache for the app servers. | AdminSys |
| LB0005 | WIP | Validate Load-Balancing Environment | Verify that the load-balancing environment is working. | Will |
| M0024 | Complete | SYSAUDIT | Run the SYSAUDIT and review. | AdminSys |
| M0025 | Complete | DDDAUDIT | Run the DDDAUDIT and review. | AdminSys |
| M0027 | Complete | Clone HNRPRD | Clone upgraded HNRPRD for functional tesing of update processes to HNRCNV | Collin |
| M0026 | WIP | ITR Functional test | Validate both the HCM and Portal environments. | |
| M0028 | Cancelled | Open HNRPRD | Run DMS script to set common password for functional users to log in directly. | Collin |
| M0029 | WIP | Campus Functional test | Review both the HCM and Portal environments. | |
| M0030 | WIP | Address issues | Diagnose and resolve issues. | |
| M0032 | 06/27, 05 PM | ERPPRD sqr migration | Data Warehouse sqr migration that are 8.9 compatible (nrauxdw1, nrhrdw1, nrhrdw8, nrocextr, nrpersyn, and nrf84syn). | Joe |
| M0031 | 06/27, 05 PM | ERPPRD HRSA dblink | the HRSA dblink in erpprd needs to be pointed back to HRSA production. | Michele |
| M0033 | 06/28, 08 AM | SOLAR HR/SA available message | Create a message published on the portal entry page regarding SOLAR HR and SA environments being available. | Ryan |
| M0034 | 06/28, 08 AM | Switch to production env. | Change the portal entry page to point to the new production environment. | Ryan |