Skip navigation
Page Description

The following page is a blank template with a header that contains a quicklinks jump menu and the search UHD function. Page sections are identified with headers. The footer contains all required links, contact and emergency information.

Viewing Your Asset Information in PeopleSoft


The following PS Public Query was developed to enable users to extract data from the PSAM database:

PSAM_DEPT_ASSET_QUERY – this query was designed to provide users with a means of either extracting information for a particular capital or controlled asset, or extracting a listing of all capital and controlled assets for any given Location Department Code.

Navigation is: Reporting Tools > Query > Query Viewer

Search by Name– Begins With: PSAM_DEPT_ASSET_QUERY
Click Search
Click Run (to HTML or Excel)
Type in Business Unit (Ex. 00784)
Type in % sign in Tag Nbr field to get all tags for a department
Select Asset Status in the Drop-down menu (Ex. In Service will provide all current assets)
Type in location department (Ex. D0154)
Click View Results


Last updated or reviewed on 7/26/11

   Click here to print this page

Find us on Facebook   Follow us on Twitter   Read Skyline   Join us on LinkedIn   News RSS   Events RSS