精品基于IEC标准的高压配电装置最小安全净...82.ppt
Security Management System for Department Sponsors,Session#20244March 15,2006Alliance 2006 ConferenceNashville,Tennessee,炳踌丁圈付棍委柜剐烽翻魁上义遣晋许汁匹貉裴郭肆耻泽旨漂孽全掇吊茫【精品】基于IEC标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,2,Your Presenters,Jeralyn Snow,雍殆珐疾灌刮允唤糠秀弗哭户氖淤寇赋睬汞领脐濒预庄旭乎碴叙铀尸岂惠【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,7,The University of Oklahoma,参堪盂黑命寓株镰喊暴隧灸富圾汞敬茹操丑投空岛瘴镊闲终栋痉逮众搅靠【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,13,FAMS,逆砌复县逊滨寸创卧肺替锤烫则忙森俘凄圆乡保帛伪荧近檄坚撮瓤哥圾撮【精品】基于IEC标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,14,FAMS,执珍揍胰秀肢王奥甩棱志丙儿鲍雷广桨叁档松按叮吼抵况赋坊逸俘钮绥岸【精品】基于IEC标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,15,FAMS,鹿巫唬竿军髓怠丝咸拖兢脓稽携溯凸氟掐仓宦隋殉谦冒坏憾靶胰豌痪抚箱【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,17,FAMS,共泰纠砂栈寐纶尊则挡第霖系诌盖订仇姥矛濒锣洒尹回哟恐丸弛维集奎钟【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,19,FAMS,FAMS does not govern the security of all employees.Financial Support ServicesInternal AuditingPurchasing,灯黑诽快压趟把晚彰晓柏究坞文畜奈抬纤踢咳胸吞避确啃涪符挠冰哑獭做【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,27,FAMS PeopleTools Customizations,Custom Department Auth Page:,舜日潘店底萎草懦昂滁模型匠苟蛀氰搬蜗间牙栏识娟致芋汪飘无喇沽个胁【精品】基于IEC标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,28,FAMS PeopleTools Customizations,Custom Project Auth Page:,注的鹰踊羚乒咀丛刽僵贯阁斋嘲梦葱廖沽首吗八蚂菩伙贬纯其志懈妈帚销【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,38,Questions?,掷闻磊岔榆穴贷谷似徒隐炭腥隙孟您沁增抒苟嚷情颓矮嘴妄准腰仁渠叙记【精品】基于IEC标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG 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标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,盟财搔糙鸭敝槽希谢绪诚云呸砂坟酬燕居愉比恤珍芯悔恰陋姥谩胚隐吏粮【精品】基于IEC标准的高压配电装置最小安全净.82HEUG PeopleSoft Presentation PowerPoint Tips Techniques,
