asset management reporting
Download
Skip this Video
Download Presentation
Asset Management Reporting

Loading in 2 Seconds...

play fullscreen
1 / 26

Asset Management Reporting - PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on

Asset Management Reporting. Presented by: David Bonola Barbara Jacius. Asset Reporting. OSC oversight

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Asset Management Reporting' - charlee


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
asset management reporting

Asset Management Reporting

Presented by:

David Bonola

Barbara Jacius

asset reporting
Asset Reporting
  • OSC oversight
  • “Creating property control guidelines is the responsibility of the Fiscal Policy Division within the Office of the State Comptroller. All State agencies must have policies and procedures in place to ensure that all assets currently owned, purchased under a capital lease, or certain non-owned property in possession of the state where insurance is required be properly recorded and reported by each respective state agency.”
  • Mandated annual reporting requirements
reporting options for asset management
Public

Private

Audits

Fin Reporting Tools

Financial Reports

Physical Inventory

Charting

CO-59 GAAP

CO-648B Motor Vehicles

Page Download

Reporting Options for Asset Management

Note: Each color-coded section relates to a Reporting Option

EPM

OFF-LINE

ON-LINE

INQUIRY

epm database
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 know your terms
EPM-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.
asset reporting6
Asset Reporting
  • New Query Development
    • New CORE functionality
    • Agency requests
    • OSC Fiscal Policy Division Reporting requirements
asset reporting7
Asset Reporting
  • Core-CT Catalog of Reports and Queries
  • CT_CORE_FIN_AM
  • Folder-AM
  • CO-59-ASSET MANAGEMENT/INVENTORY REPORT/GAAP REPORTING FORM
on line reporting
On-Line Reporting
  • Fin Reporting Tools
      • CT_IDENTIFY_ASSETS_IN_PO
      • CT_IDENTIFY_CNTRL_IN_PO

NAVIGATION

on line reporting10
On-Line Reporting
  • Fin Reporting Tools

EXAMPLE

on line reporting11
On-Line Reporting
  • Financial Reports
      • AMAS2000

NAVIGATION

on line reporting12
On-Line Reporting
  • Financial Reports

EXAMPLE

on line reporting13
On-Line Reporting
  • Physical Inventory

AMPI2000 Extract

AMPI2100 Scan

AMPI2200 Inventory

AMPI2210 Unders

AMPI2220 Over

NAVIGATION

on line reporting15
On-Line Reporting
  • Charting

NAVIGATION

inquiry
Inquiry
  • Page Download

NAVIGATION

inquiry19
Inquiry

EXAMPLE

inquiry20
Inquiry

EXAMPLE

off line reporting
Off-Line Reporting
  • CO-59 GAAP
  • CO-648B Motor Vehicles

http://www.osc.state.ct.us/agencies/forms/

off line reporting23
Off-Line Reporting
  • Setting up Asset Classes

NAVIGATION

ad