1 / 10

EPM Intermediate 2010

EPM Intermediate 2010. PeopleSoft HRMS. PeopleSoft Financials. EPM Database. Data Sources. Enterprise Warehouse. Staging. Transactional Reports (SQR’s ). Ascential (ETL). Data Loader (App Engine). PS Query/. Reporting. Metadata. PeopleTools. EPM Overview.

cbrunner
Download Presentation

EPM Intermediate 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. EPM Intermediate 2010

  2. PeopleSoft HRMS PeopleSoft Financials EPM Database Data Sources Enterprise Warehouse Staging Transactional Reports (SQR’s) Ascential (ETL) Data Loader (App Engine) PS Query/ Reporting Metadata PeopleTools

  3. EPM Overview • Reporting Tables – Financials • 200 Staging Tables -> 84 Reporting Tables • General Ledger, Commitment Control • Accounts Receivable and Billing • Accounts Payable • Supply Chain & Inventory • Asset Management • Projects and Contracts

  4. EPM Overview • Reporting Tables - HRMS • 160 Staging Tables -> 49 Reporting Tables • Human Resources • Benefits • Workers Comp • Time and Labor • Payroll Financials:

  5. Know your Terms • Field: Single piece of data • Table: Collection of data fields arranged in columns and rows • Staging Tables: Copies of the HRMS and Financial transactional tables • Reporting Tables:Denormalized Tables • Denormalize: The process of pulling information stored in separate tables together into one table.

  6. Purchase Order Vendor Information Item Information Item # Item Description Item Cost Credit Analyst Address Seq Num Vendor ID Vendor Name Vendor Persistence VAT flag In Process Flag Purchase Order ID Vendor ID Item # CP Template ID Descr 254 Mixed EPM PO Reporting Record Denormalized Reporting Table Purchase Order ID Vendor ID Vendor Name Item # Item Description Item Cost

  7. EPM Table Joins CTW_VCHR_TRANS CTW_PO_TRANS BUSINESS_UNIT PO_ID LINE_NBR SCHED_NBR PO_DISTRIB_LINE_NUM BUSINESS_UNIT PO_ID LINE_NBR SCHED_NBR DISTRIB_LINE_NUM

  8. EPM Security • EPM Security Mirrors User Functional Access • Job Duties determine roles • Segregation of Duties • Financial Segregation of Duties grid maintained by Office of the State Comptroller • EPM Only Roles • New approach • Cross module access

  9. EPM Security Reporting Table Security • Reporting tables are grouped under EPM access groups on the Query Tree in EPM • User Roles are tied to permissions to EPM Access Groups

  10. EPM General Information EPM Job Aids http://www.core-ct.state.ct.us/epm/ Help Desk 860-622-2300 core.support@ct.gov

More Related