DokuWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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|
DokuWiki

User Tools

Site Tools

Page Tools
