This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Asset Management
- Asset comments by BU (DOCX): Query returns the most recent comment for in-service assets by business unit.
- Comments by Asset (DOCX): Query returns all comments (historical) for a specified asset.
- Assets w/ description by location (DOCX): Query returns all in service assets with description information such as manufacturer, model and serial number by location. Prompts for business unit and location. The location prompt will accept the wildcard %.
- Asset Inventory Information (DOCX): This query is used to create a list of agency assets with cost that shows the last time they were inventoried, the inventory ID, and who performed the inventory. Each asset is given one row of information. It prompts for Department ID using the LIKE parameter. It sorts by Location, Tag Number, Inventory Date, and Physical Inventory ID.
- In service asset net book value (DOCX):Query returns current net book value, depreciation values, and coding string for in service assets by business unit. User must enter prompt values for business unit and last day of the prior month to retrieve the accurate depreciation values. The asset depreciation process is updated the day the asset management module closes for the month, usually the 10th of the following month.
- Asset Inventory History (DOCX): This query is used to create a list of agency assets that were accounted for during physical inventory. It prompts for Business Unit and Physical Inventory ID (PI Occurrence) and displays results by Asset ID.
- In service assets by location (DOCX): Query returns all in service assets by location. Prompts for business unit and location. The location prompt will accept the wildcard %.
- AM CO-59 - All Cost NEG Detail (DOCX): This Query returns the detail information supporting the query CT_CORE_FIN_AM_COST_NEG used by agencies to calculate the negative cost of items in Asset Management for CO-59 required reporting.
- AM CO-59 - All Cost POS Detail (DOCX): This Query is used for the CO-59 by agency to calculate the negative cost of items in Asset Management. This report is displayed by Business Unit, Category and Transaction Type.
- AM CO-59 - All Assets Cost NEG (DOCX): Calculates the negative cost of items in Asset Management. Displayed by Business Unit, Category, and Transaction Type.
- AM CO-59 - All Assets Cost POS (DOCX): This Query is used for the CO-59 by agency to calculate the positive cost of items in Asset Management. This report is displayed by Business Unit, Category, and Transaction Type.
- AM CO-59 - All Assets Depreciation NEG (DOCX): This Query is used for the CO-59 by agency to calculate the negavtive depreciation of items in Asset Management. This report is displayed by Business Unit and Category.
- AM CO-59 - All Assets Depreciation POS (DOCX): This Query is used for the CO-59 by agency to calculate the positive depreciation of items in Asset Management. This report is displayed by Business Unit and Category.
- Assets with Duplicate Serial Numbers (DOCX): Query returns asset ID's with duplicate serial numbers by business Unit.
- In service assets w/cost (DOCX): Query provides list of all in-service assets, current location and cost by business unit.
- Non Capitalized Assets (DOCX): Lists assets by business unit and transaction date which do not meet the state capitalization threshold of $1,000.
- Non-cap Asset Expenditures (DOCX): List of assets by business unit and transaction date which do not meet the state capitalization threshold of $1,000.
- In service assets by FY/Acct Per (DOCX): Query displays all in service assets in a fiscal year and an accounting period. Query provides detailed asset information corresponding to the FIN production report AMAS2000. The Accounting Period displayed needs to be closed for accurate reporting. Asset Management Accounting Periods typically close after the 10th of each month (for the preceding month).
- Category/Profile Mismatch (DOCX): Query provides list of all in-service assets where the category and profile do not match.
- Controllable Additions (DOCX): Query returns all controllable asset additions for a specified date range. Reflects 9.1 upgrade AM functionality.
- Controllable Retirements (DOCX): Query returns controllable disposals/transfers for a specified date range. Reflects 9.1 upgrade AM functionality.
- Audit Description field symbol “ (DOCX): Locate Description field symbol '' or ' - Query provides an audit tool for in-service asset descriptions containing the symbols ' or ''. These descriptions require updating to either remove the symbols or replace them with words.
- Reconcile Voucher/Asset (DOCX): Query Reconciles AP Asset Vouchers with AM asset detail transaction information. Query prompts for AP Business Unit and Acctg Date. Voucher lines posted in AM will display Asset ID. Voucher lines not posted in AM will display "NO ASSET_ID".
- Non-cap Asset Expidentures (DOCX): Non-Capitalized Asset Expenditures, by Account (54150). Reflects 9.1 upgrade Asset Management functionality
More resources