M_CG_GBL_CATEGORIES_ASSETS. Query Name M_CG_GBL_CATEGORIES_ASSETS Description List of current Purchasing Category Codes which are associated with Asset Profile ID’s. Uses Identify Purchasing Category Codes that are linked to an Asset Profile ID. When these Purchase Category Codes are entered for a Purchase Order (PO) Line item, a default Asset Profile ID is automatically entered for the Line. When a Profile ID is entered, an asset will be created in the Asset Management module from the Receipt and Voucher records. Prompts This query does not have any prompts and will generate the complete list when run. Fields SetID (Share); Category Code (Purchasing), Asset Profile, Descript (Purchasing Category Description). Queries to Run Regularly to Manage your Assets M_AM_GENERAL_INF0 Query Name M_AM_GENERAL_INFO Description List of assets with summary (total) cost, summary (total) quantity, and Location. (To view detailed asset information, view the M_AM_GENUSER_INFO query.) Uses For assets with Status “In Service”, use the fields listed below to identify issues: Cost: Review assets with small costs and verify that they should be assets. Quantity: Normally, the asset Quantity should be “1”. Verify any other Quantity. Tag Numbers: If your agency requires Tag Numbers, review for missing Tag Numbers. Location: Review for invalid Locations. Profile ID’s: Profile ID’s should relate to the cost of the asset. You can select each Profile ID (or Group of Profile ID’s) and review the associated costs to find any anomalies. If you find issues, you will need to verify that the Asset Type, Category, Profile ID and Useful Life are correct for the asset. Refer to the “” topic for assistance. Blank Profile ID’s: All assets should have a Profile ID. When using the Wildcard (%) for the Profile ID, assets with blank Profile ID’s will be included in the list and will need to be verified. Please enter missing Profile ID’s. Prompts Business Unit, Profile ID or Wildcard (%), Asset Status or Wildcard (%).
Query Name M_AM_GBL_ASSET_STATUS_A Description List of assets with a Status of “A”, (Received not in Service). Uses This Status should only be applied to assets that are recently received and awaiting payment. If an asset record has not been updated to “In Service” after an appropriate period of time, Asset Managers need to review the records for issues. Refer to the “Resolving “Received (Not in Service)” topic in the for instructions. Prompts Prompt for Business Unit. Fields Many fields in this query can be found on the Basic Add page tabs (Refer to ” topic. General Info tab: Business Unit, Asset ID, Tag Number, Description, Short Description, Asset Status, Acq Date (Acquisition Date). Book page Link on General Info tab In Service Date Asset Acquisition Detail tab System Source, all Purchase Order, Receipt, and Vendor fields, Amount, Quantity and ChartFields. Notes Results only include assets with Status of “Received (Not in Service). M_AM_GENUSER_INFO_CAFR_NULL. Query Name M_AM_GENUSER_INFO_CAFR_NULL Description List of assets with Asset Status “In Service” that do not have a complete cost record. Assets not included in CAFR. Uses Identify assets with incomplete cost records. All assets in SWIFT should have cost records. When cost records are missing, the asset should be reviewed to determine the reason for the missing records. Refer to the “Resolving “Received (Not in Service)” topic for assistance. Prompts Prompt for Business Unit.