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.
Quick Links |
||
|
Information for: For the Media: |
Primary Links: |
General Information:
Online Services & Logins: |
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
