hrms-sfis-upgrade:mod_plsql
PLSQL Modified Objects
| Schema | Object Name | User | Description | ||
|---|---|---|---|---|---|
| SYSADM | WES_GET_ETHNICITY | DAK | Changed ethnicity_code to ethnic_grp_cd | ||
| SYSADM | WES_GET_WESPO | DAK | Modified to use new xlat table | ||
| SYSADM | WES_GET_NAME_PARTS | DAK | Modified to use new xlat table/ GBROWN 3/9/2007 in Function valid_name_type changed to use ps_HCR_NM_TYP_I as cursor | ||
| SYSADM | WES_GET_XLAT | DAK | Modified to use new xlat table | ||
| SYSADM | WES_ETHNIC_GROUP_CODE | DAK | Modified to use new xlat table | ||
| SYSADM | WES_GET_ARTS_MATERIALS | DAK | Modified to use new xlat table | ||
| SYSADM | WES_GET_CREDIT_CAT | DAK | Modified to use new field ssr_component | ||
| REG | GET_SUBJ_CAT | DAK | Modified to use new field ssr_component | ||
| SYSADM | WRG_DROPADD_CREDITS | DAK | Modified to use new field ssr_component | ||
| SYSADM | WES_GET_EMPLOYEE_STATUS | AH | Modified to use new xlat table | ||
| SYSADM | WES_GET_EMPL_STAT_EFFDT | AH | Modified to use new xlat table | ||
| SYSADM | WES_GET_EMPL_STAT_90 | AH | Modified to use new xlat table | ||
| SYSADM | WES_GET_PROGRAM | RPL | Modified to use new xlat table | ||
| SYSADM | WES_GET_TITLE | DL | Modified to use new position data table(ps_whr_posn_data)to get descr254 | ||
| SYSADM | WES_GET_TITLE_EFFDT | DL | Modified to use new position data table(ps_whr_posn_data)to get descr254 | ||
| SYSADM | WES_GET_TITLE_90 | BAS | Modified to use new position data table(ps_whr_posn_data)to get descr254 | ||
| SYSADM | WES_GET_DEPT | DL | Modified to use table ps_addresses_sa | ||
| SYSADM | WES_NAME_EMPLID | GLB | FUNCTION modified to use new xlat tables (PSXLATITEM and ps_HCR_NM_TYP_I) | ||
| REG | Course_Schedule | GLB | PACKAGE Modified to use new xlat table (PSXLATITEM) | ||
| SYSADM | WES_CRSE_VW | GLB | VIEW replaced COMPONENT with SSR_COMPONENT, removed AP_BUDGET_PERIOD, removed WROF_BUDGET_PERIOD | ||
| SYSADM | wes_comm | DAK | replaced letter_cd with scc_letter_cd, used personal_data as replacement for personal_mc_vw | ||
| SYSADM | wes_adm_profile | DAK | replaced xlattable with psxlatitem and dynamic sql to get ethnic_group | ||
| SYSADM | OVERSUBSCRIPTION | GLB | PACKAGE replaced COMPONENT with SSR_COMPONENT | ||
| SYSADM | wes_get_title_90 | AMH | replaced PS_POSITION_DATA with PS_WHR_POSN_DATA | ||
| SYSADM | WHR_GET_STAFF_FTE | AMH | replaces std_hrs_default with std_hours | ||
| SYSADM | WES_EMERGENCY | GLB | PROCEDURE Removed @psprod from delete ps_wes_emergency@psprod e | ||
| SYSADM | WU_DATA.VW_PEOPLE_HR | BAS | remove ORIG_HIRE_DT, access new ps_whr_wess_addrvw | ||
| PUBLIC | PS.PSDBOWNER | RPL | Public synonym needs to be created | ||
| REG | WESMAPS_PAGE | RPL | xlattable change | ||
| REG | WESMAPS_LOOKUPS | RPL | xlattable change | ||
| REG | WESMAPS_DATA_LOAD | RPL | xlattable change | ||
| PUBLIC | PORTFOLIO_AUTH | RPL | Public db link needs to be created or copied from prod | ||
| REG | INSTR_MIN_CLASS_VW | RPL | Reg view component field → ssr_component | ||
| ADMIS_WEB | CHECKLIST | RPL | component field → ssr_component | ||
| ADMIS_WEB | WES_GET_ETHNIC_DTL | DAK | FUNCTION - fixed to reference ps_divers_ethnic | ||
| ADMIS_WEB | PREAPP | DAK | PACKAGE - multiple issues | ||
| SYSADM | WES_NEW_OR_UPDT_XLIST_CLASSES | DAK | modified to deal with all the new fields in CLASS_TBL | ||
| SYSADM | WES_POST_DEGREES | GLB | PROCEDURE modified for tables ps_names, ps_addresses, and ps_addresses_sa | ||
| SYSADM | WRG_MEETS_PREREQ | GLB | FUNCTION removed BULK COLLECT from cursor | ||
| REG | UTILITIES | GLB | PACKAGE removed BULK COLLECT from cursor in numerous places of package | ||
| SYSADM | WES_GET_ETHNICITY_PRIMARY | GLB | FUNCTION (new) created to return a student's primary ethnicity | ||
| SYSADM | WES_LOAD_APPLICANT | RPL | PACKAGE Updated create applicant functionality | ||
| SYSADM | WES_LOAD_PROSPECT | RPL | PACKAGE Updated create prospect functionality | ||
| SYSADM | WAD_PROCESS_QPAY_PREAPP | DAK | PROCEDURE - PS modified the name of Bank_ACCT_NUM in ADM_APPL_TENDER | ||
| SYSADM | WAD_UPDATE_COMM_CODES | DAK | PROCEDURE - Updated LETTER_CD to SCC_LETTER_CD | ||
| SYSADM | WES_ADR | GLB | PACKAGE - changed loc_addr from ps_addresses to ps_addresses_sa, commented out section that inserts into ps_pers_data_effdt, modified insert into ps_addresses, added insert into ps_addresses_sa | ||
| ATTRACK07 | UPD_LEAVE_BAL | BAS | STD_HOURS | ||
| ATTRACK07 | UPD_ALL_LEAVE_BAL | BAS | STD_HOURS | ||
| ATTRACK07 | UPD_LEAVE_BAL_1_PERSON | BAS | STD_HOURS | ||
| ATTRACK07 | LV_ACCRUAL_DAILY_PRC | BAS | STD_HOURS | ||
| WU_DATA | VW_PEOPLE_HR | BAS | ORIG_HIRE_DT, PS_WHR_WESS_ADDRVW | ||
| WU_DATA | VW_PEOPLE_HR_POSITION | BAS | |||
| WU_DATA | VW_PEOPLE_STUDENT | BAS | ORIG_HIRE_DT, PS_WHR_WESS_ADDRVW | ||
| WU_DATA | VW_PEOPLE_HR_PVT | BAS | NEW TO REPLACE SUPPL | ||
| SYSADM | WES_ROLLOVER_WHR_FRINGE | BAS | New in production | ||
| SYSADM | WES_ACCT_CD_TBL_UPDATE_PART1 | BAS | Replaces current update | ||
| SYSADM | WES_ACCT_CD_TBL_UPDATE_PART2 | BAS | Replaces current update | ||
| SYSADM | WRG_PREREQ | RPL | PACKAGE Removed bulk collect in cursor definitions | ||
| SYSADM | WES_DORM_ADDRESS | DAK | PROCEDURE - Added ps_addresses_sa to access LOC_ADDR | ||
| WU_DATA | WES_DEPENDENT_BENEFICIARY_VW | AMH | VIEW | ||
| WU_DATA | WHR_PAYROLL_DATA_VW | AMH | VIEW | ||
| OPEN_ENROLL | WES_DEPENDENT_BENEFICIARY_VW | AMH | VIEW | ||
| SYSADM | WAD_PROCESS_QPAY_PREAPP | DAK | Procedure - Moved Quickpay Trans_ID from Credit Card Nbr field to firstname field | ||
| SYSADM | WAD_PASTPRO | DAK | Procedure - Modified structure of Admissions Data Warehouse | ||
| SYSADM | WES_BATCH_SUMMER_REG | GLB | Package - Modified SQL replaced all “INs” with Unions | ||
| WES_FINDW | PS_WES_DIST_INQ_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | PS_WES_DIST_STU_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | PS_WES_DIST_TEM_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | PS_WES_STU_RPTD_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | PS_WES_STU_SEC_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | PS_WES_TEM_RPTD_VW | BAS | ACCT_CD tbl chgs | ||
| WES_FINDW | WES_BUDGET_VW | BAS | ACCT_CD tbl chgs | ||
| SYSADM | WES_PROCESS_CID | DAK | PACKAGE - Fixed to deal with new data structure of Crse_offer_tbl | ||
| SYSADM | WES_STUBILL | DAK | PACKAGE - Fixed to reference psxlatitem rather than xlattable | ||
| REG | ADVISOR_IAS | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| REG | FACULTY | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| REG | GRADE | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| REG | STUDENT | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| SYSADM | NIGHT_JOBS | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| SYSADM | WES_UPDATE_ENRL_BINS | DAK | PROCEDURE - Comment out the bulk collect in cursor definition | ||
| SYSADM | WES_GET_XLISTINGS | DAK | FUNCTION - Comment out the bulk collect in cursor definition | ||
| SYSADM | WES_DROPADD | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| SYSADM | WES_PROCESS_CID | DAK | PACKAGE - Comment out the bulk collect in cursor definition | ||
| SYSADM | WAD_CREATE_USA_CITIZENSHIP | DAK | PROCEDURE - Added 2 more fields for the change in data structure | ||
| SYSADM | WES_UPDATE_REQ_BINS | GLB | PROCEDURE - Removed bulk collect from cursor definition | ||
| SYSADM | wes_delete_address_type | GLB | PROCEDURE - in first delete changed to use field ADDRESS_TYPE and included condition for EFFDT ,commented out delete from ps_pers_addr_types - table ps_pers_addr_types no longer exists |
hrms-sfis-upgrade/mod_plsql.txt · Last modified: 2007/07/11 16:11 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
