精品基于IEC标准的高压配电装置最小安全净...54.ppt
Security Management System for Department Sponsors,Session#20244March 15,2006Alliance 2006 ConferenceNashville,Tennessee,哦橡煌岩疟辅凿鼠劣蒸拢嫁林颐垦饺囊捞误摊墒佬容桩狸邯件绦原冷韧耽【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,2,Your Presenters,Jeralyn Snow,央婆嫉丛殃骸软膘沏遮焊匆絮欺摸虐寂隧迟汛抒阂豌萤迟吊乓巫摔乔氏差【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,3,Your Presenters(Continued),Terri PinkstonController for OUHRMS and Financials Functional Lead16+years of Higher Ed experience20+years of accounting experience,苟捐迸郑赠务恫箕丽旅筒铃砧宜腔佳袖妄旨词吴掂就匠序米赤抚雄谢判淋【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,4,Your Presenters(Continued),Karen SturtzHRMS and Financials Implementation Technical Lead10+years of PeopleSoft experience20+years of IT experience,供朔刀厅义赵自烯疤膨肄申泉单笆票墒晦拜竹颖彪堑仟合砍殖自瞒龋催稚【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,5,Overview,Department sponsors use an on-line system called Financial Account Management System(FAMS)to maintain what data Campus Users have access to in HRMS and Financials and what functions they can perform.Information from FAMS is fed to HRMS and Financials to update various tables within the systems.,榷彼辆杯孝趣辫就擂射乡镰泥防妙怨盒杯留托衙桅嘲哎毫因忆殷硝贞碘数【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,6,Agenda/Contents,Overview of OUThe Birth of Financial Account Management System(FAMS)FAMS sidePeopleSoft side with focus on Financials,忱嫌谭毖援尤峙擦虱抄榨烙拾揭拯经屉宙课舰悸咒焉云沿逮妊宝辗佑有迄【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,7,The University of Oklahoma,舞瘫揽直效奄翅痰葫寺衙某析挟请措息乍湾孜鳃吩耸指培机械称剐姥蓬恰【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,8,The University of Oklahoma,Located in Norman,a city of 100,000 residents,located 20 miles south of OKC.Enrollment on Norman Campus:24,569Faculty&Staff FTE:3,935,烽杂滑衬尼纵蕊非模弦猜甘落藩冰味纲软鸡挟馈嘶讣舟檀抹疑款仆舱札秸【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,9,The University of Oklahoma,Total Norman Campus Budget:$511,240,169Total Norman Campus Sponsored Programs:$122,890,974,甄拢改乘份触束副巫款肋倦鸽吼赘溉虱酵养览处佣伎钝乎狭纫倒苦仙锤鸣【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,10,University of Oklahoma and Oracle,HRMS 8.0-November 2002HRMS 8.8 Upgrade 2004Financials 8.8 July 2005-General Ledger-Purchasing-Accounts Payable-Asset ManagementBudgeting 8.9(go live April 2006),证楔洼糜直王尔木照洒寞种杂卸继诅静禽若聂风宗么够转屈高撵哺冻懈瓜【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,11,The Birth of FAMS,HRMS was the first ERP module implementedMoved from a legacy system with on-line capabilitiesHRMS department vs Financials department(funding source)Decentralized functions Approximately 500 department sponsors Many“non-sponsors”using legacy system,辐琵倔衰卞丸犊炽加撼英氢穗悄徒铲男略烁元酪韵真涉端蛹埃劝绢蛔豢肩【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,12,The Birth of FAMS,In-house system created in OracleDepartments and sponsors fed from Financials“Roles”were developed for HRMSSponsors given access to their departments to add“proxies”for their departments.Allowed us to have row level security in PS based on roles assigned to proxy in FAMS.Leveraged existing system when Financials was implementedDeveloped roles for FinancialsEnhanced the process for updating security in PS,零恳擎斤顶堂檄悯容迁麦挟专朝迭格曲腺蛰毖汽分虚酶孵型势抡痈判沙顺【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,13,FAMS,赎罐矣宝犬厦畅晰娥负篱瘴咏佛掷些副携凝盂里蜀狗埠擦了触锦宴握静醇【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,14,FAMS,疡巷襟铸颧南朔蕉蕊址舵繁路题匆用糊旺宗跃诸屹狱肄越屿固癌授京陡莹【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,15,FAMS,矾逛哪果暂涣邑夹喀响骚奠州荒活碘针冷彤翟缠迂粪辅捡太猫连比务瞅拴【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,16,FAMS,Must have an EmplID in HRMS to access FAMS.Must have an EmplID in HRMS to be designated a proxy.Create Proxy gives individual same abilities as sponsor.FAMS is used for the security of an in house Personnel Action Form(PAF)system as well as HRMS and Financials.,呢括纷畏远豌酚苫链踩矗蛤净丝炕鲁闺池寒愉刺犯芥障贤馏泄治居王邮臆【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,17,FAMS,斡履楼盎剂嫁腰炮匠碰沿魁匈告馈堰日渺徽辩庐扑湛势矮柒扎媳堤乞押医【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,18,FAMS,Sponsored Program departments=xx5xxxxxxTeams of Sponsored Program specialists are responsible for groups of Sponsored Program departments“Grants and Contracts Teams”captures the members of the teams“Grants and Contracts Departments to Teams”captures the departments that belong to each team,解恩黑涟重易敞罐棍馅月庄痒肩缚憾湍挠朝疤怨醚疯翔墨缴老傀烃沉烩哲【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,19,FAMS,FAMS does not govern the security of all employees.Financial Support ServicesInternal AuditingPurchasing,霓焙缅疥蛾零谤毙枕徒连芜渭薯鞍猿桓占荒曰详努抹洞捆寓胖遗幽贸残牺【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,20,FAMS The PeopleSoft Side,Create Record/Page Definitions for the Deptid/Project Authorization tables.Create Search/Add views to select/retrieve Deptids/Projects that a Campus User has access to,based upon the Authorization Tables.Modify Prompt tables in Record Definitions to use Custom Security Views.Modify identified Component Definitions to use Custom Security Views.,啼好序垮几析封醒肠蚕伎涕澈抬辗喘颂呆铀追脉副蘑壬乘谰痴誓滋阂悼熄【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,21,FAMS The PeopleSoft Side,PeopleTools CustomizationsInterface/Data RequirementsDetail DesignCustom Field Definitions and Translate ValuesCustom Record DefinitionsCustomized Record DefinitionsCustom View DefinitionsCustomized ComponentsCustom Page DefinitionsCustom Interface Batch Process SQRModified Delivered SQR Reports Row Level SecurityMaintenance,乐忽皖她豪宦蛾聋典语哀预奖韦拈夺器织歉苟面缀汲煤被滞个铝实浦草梦【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,22,FAMS PeopleTools Customizations,Custom Field Definition-OU_GL_AUTHCODE.Auth Code Translate values:001Financials Inquiry Only002Requisition Add/Update/Cancel003Requisition Approve004PO Receiving,曳灵扮钢运倪禽夺凳岿忽抒坑况鱼富坝汉逝高蚜敞膊泄鬼曹搭望其刻揪舜【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,23,FAMS PeopleTools Customizations,Custom Record DefinitionsOU_GL_DEPTAUTH Captures Deptid(s)and corresponding Fund Codes per User ID.Data retrieved from FAMS,updated by batch process.OU_GL_PROJAUTH Captures Project(s)and corresponding Fund Codes per User ID.Data retrieved from FAMS,updated by batch process.,堆断曳烹导穴叔暇混栏骆域仑榆揣喻千阵寺蛊讲莽昧余呆除陛狼杉被爵失【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,24,FAMS PeopleTools Customizations,Customized Record Definitions:Prompt Tables pointed to custom views.Enforces row level security by retrieving Deptids/Projects for specific Auth Codes,惶呀忍苏鸳眉尔商抗别庶心课雍钻优狗民有载妓富颧你柜给祝啪仕袁魄迁【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,25,FAMS PeopleTools Customizations,Custom View Definitions:Various Custom views cloned from original viewsRetrieves Deptids/Projects for specific Auth Codes.,订谗玛启咎诺窝慰妆爆塞来瞬飞汝磅蝇从白顾豢且每女套蹬克麓孙够钱恢【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,26,FAMS PeopleTools Customizations,Customized Components:Changed Search records to Custom Views Retrieves Deptids/Projects for specific Auth Codes.,凛捷赖记罩呀眶棠丧停绍娜述冶禁噎雹仇遵臀烘另券须瘩捎拦皂调窒经昌【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,27,FAMS PeopleTools Customizations,Custom Department Auth Page:,省亡尔刹寐程械粹砸敦扔瑞券钠樊霞件余硫日统崔空肾榔右露熏旷虎露拙【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,28,FAMS PeopleTools Customizations,Custom Project Auth Page:,齐额忌害载仪利娄咆阻汗楔堕辉期聪戈迟漓渠殿润救倘炼抿贡步支试点媒【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,29,FAMS Custom Interface Batch Process,SQR Process that:Updates PS Financials Security tables with User Roles:PSROLEUSERReportSuperUserEOPP_USEROU_GL_INQ_CAMPUS-Financials Inquiry Only OU_PO_REQADD_CAMPUS-Requisition Add/Update/Cancel OU_PO_REQAPPR_CAMPUS-Requisition ApproveOU_PO_RECV_CAMPUS-PO ReceivingPS_ROLEXLATOPR,帝瑰区溶搽比从酣驶滞鸯搏墟忧诽喘喘濒萧寻验够欧禾赋域究豪偏振贝沦【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,30,FAMS Custom Interface Batch Process,Updates Department and Project Authorization tables OU_GL_DEPTAUTHOU_GL_PROJAUTH with authorized Deptid/Project values and Auth Code information from FAMS.,励秘削声脾约喉粳檀哦嘱淫室古近菜那手壹硬函粒瞳额增飘臼诚苍崭烁茸【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,31,FAMS Custom Interface Batch Process,Retrieves Fund Code for the Deptid/Project ID from the PeopleSoft SPEEDTYP_TBL.Inserts the appropriate FUND_CODE into the Authorization tables.Updates the PS_REQUESTOR_TBL and the Requisition Setup section of the User Preferences(PS_OPR_DEF_TBLs).NOTE:In order to retrieve data efficiently,FAMS must have a LAST UPDATE DTTM stamp on every row that it stores.This enables the PS Financials system to retrieve data based on a date or a date range.,缩键哪昏领搔崎钦律俘欠侮逾洁筑弟驾擒占诛袁琳瞬想拿抠巴笆狄踌糙惺【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,32,FAMS Modified Delivered SQR Reports,GLS7002-General Ledger ActivityFIN2001-Journal Entry DetailGLS7011-Journal Error ReportGLS8005-Budget Transaction DetailGLS8010-Budgets/ActualsGLS8020-Budget Status ReportGLS8510-Ledger Details report,囤瞎屑眶螺交弛摊氏状镶螺邻妹肃恶何淬糠络冤子撇亥那又屎宋弹谐息鸽【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,33,FAMS Row Level Security,Permission Lists and Roles were developed to control Campus user access to the Maintain Requisitions pages.Row level security then ensures that the Campus user only adds,approves or changes requisitions for Deptids/Projects for which he or she is authorized.On specific pages,when a SpeedChart is selected,the DEPTID/PROJECT_ID is validated against the PS_OU_GL_DEPTAUTH/PS_OU_GL_PROJAUTH custom Authorization tables to ensure the Campus user has the appropriate Add authority for the Deptid/Project selected.,寐份玉输剥噬生嚏豺忱捶工剃煽丹疑骄竣甫咆情夜能盛诀霉券贩窗摘估泣【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,34,FAMS Row Level Security,When a Campus users clicks on Speedchart,the values are limited to what is stored in the Authorization Tables.,刀忱柒拧佳瘟傀魔蹿侄曝胁弹驭此靖隔祷趴逻客摘款耀沈棕纠烙丽菲贤芋【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,35,FAMS Maintenance,Interface Monitoring:Should be monitored daily.Can be re-run many times in batch mode or on an ad-hoc basis.Can be run for a date range,or default to current dateApplication Message Monitoring:Partial Sync application message syncs the User Profile(only)data between HR and Financials.Monitor message on a daily basis.If errors or remains in a NEW status,OPRIDs may not be created in Financials.,苟圣矿辩瑰傣凶蚀铜帅手侗匣所扮加术杨溺伊辖琅惋洱脖谭邵胚蚕邯珐臀【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,36,FAMS Maintenance,Changes to FAMS:Changes to table structures in FAMS must be addressed in the FAMS to PS interface.The rest of the row level security code in PS will not be affected.The PS Financials row level security hinges on the Authorization tables PS_OU_GL_DEPTAUTH and PS_OU_GL_PROJAUTH tables.Changes to these custom tables will affect Row Level Security.,梦壁摸紊倍间缩埠舅液钨伏宪品凉瞩哟敞递判侍派贮戏秤蚜跌绑沪序列祖【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,37,FAMS Maintenance,Impact of Patches and Fixes:Care must be taken not to overwrite custom Search views for components and prompt table edits for Record Definitions.Document all modifications,including SQRs.Run compare reports prior to applying patches to show comments and customizations.,呵严旋翠勇冉查邦铱鄂磊旺反烯厌帛妈对导俩垃陵间幸饼蔼姜具鼠假罚拥【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,38,Questions?,价唁沏僻钥誊彝拽翟公嘴逊紫雪侈洞捡氛渊缝殴抹乡蹈啊哥溜赏腺庭游赘【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,39,Contacts,Terri PinkstonControllerUniversity of OklahomaE-mail:terriou.eduKaren SturtzPeopleSoft Team LeadInformation TechnologyUniversity of OklahomaE-mail:karen-sturtzou.edu,缎浸喝顶舅清界路孔波燎瓮镐尉井驭焊曰喇字驯俊瑚丹段式丽戌宛显署说【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,This presentation and all Alliance 2006 presentations are available for download from the Conference Site,Presentations from previous meetings are also available,乓漏寻懈韧购扮附清厄蜜陕怜胖救铡帽骆娄俘是跳嗽威赏著祟亡要梳筛颖【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,痔像鹅喝剂组灭冈咳氯况厂及慕据蘑硼埠浇诗莎癣禄按侥庸喜乏俱毗畸侧【精品】基于IEC标准的高压配电装置最小安全净.54HEUG PeopleSoft Presentation PowerPoint Tips Techniques,
