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