Created by Corina C Larsen, last modified by Miki Yanagi on Jan 02, 2020
MaineStreet Finance Query
Recommended queries for account managers:
UMS_NSFA_GL_SUMMARY
UMS_NSFA_COMB_DETAIL_ALL
UMS_NSFA_HR_DETAIL
UMS_NSFA_GRANT_CONT
All Queries Available for NSFA:
| Query Name | Short Description | More Information |
|---|---|---|
| UMS_NSFA_ASSETS_DETAIL | ||
| UMS_NSFA_BALANCE_ALL_FUND | Snapshot of current fund balances for a given accounting period | UMS05 (UM) NSFA Balance for All Funds |
| UMS_NSFA_BALANCE_ALL_FUND_0OUT | ||
| UMS_NSFA_BASE_BUDGET | UMS05 (UM) NSFA Base Budget | |
| UMS_NSFA_BENEFITS_DETAIL | Journal detail for Account 54113 - 54999 and 55100 - 55300 only | |
| UMS_NSFA_BLENDED_MAFES_CALC | ||
| UMS_NSFA_COMB_DETAIL_ALL | Combination of UMS_NSFA_BENEFITS_DETAIL and UMS_NSFA_OPERATE_DETAIL | UMS05 (UM) NSFA Journal Detail |
| UMS_NSFA_COMB_DETAIL_DEANS | Same as UMS_NSFA_COMB_DETAIL_ALL, but only for Dean's office. | |
| UMS_NSFA_COMB_DETAIL_GRANTS | Same as UMS_NSFA_COMB_DETAIL_ALL, but only for grants. | |
| UMS_NSFA_COMB_DETAIL_NONGRANTS | Same as UMS_NSFA_COMB_DETAIL_ALL, but only for non-grants. | |
| UMS_NSFA_CURR_BUDGET | Shows current budget adjustments and reallocations | UMS05 (UM) NSFA Current Budget Detail |
| UMS_NSFA_FARM_DETAIL | For Farm accounts only | UMS05 (UM) NSFA Farm Reports |
| UMS_NSFA_FARM_GL_SUM | For Farm accounts only | UMS05 (UM) NSFA Farm Reports |
| UMS_NSFA_FARM_HR_DETAIL | For Farm accounts only | UMS05 (UM) NSFA Farm Reports |
| UMS_NSFA_GL_SUMMARY | GL output which includes revenue, compensation and operating expenses for a given accounting period | UMS05 (UM) NSFA GL Summary |
| UMS_NSFA_GL_SUMMARY_DEANS | For Dean's office only | |
| UMS_NSFA_GRANT_CONT | Grants and Contracts Balance Report | UMS05 (UM) NSFA Grants & Contracts |
| UMS_NSFA_GRANT_CONT_DB | For NSFA Grant Database | UMS05 (UM) NSFA Grants & Contracts |
| UMS_NSFA_GRANTS_DETAIL_ALLCR2 | ||
| UMS_NSFA_HR_DETAIL | Reconcile accounts for salary | UMS05 (UM) NSFA HR Detail - Journal Entries |
| UMS_NSFA_HR_DETAIL_ALL | Same as UMS_NSFA_HR_DETAIL | |
| UMS_NSFA_HR_DETAIL_BB | UMS05 (UM) NSFA Base Budget | |
| UMS_NSFA_HR_DETAIL_DEANS | For Dean's office only | |
| UMS_NSFA_HR_DETAIL_GRANTS | ||
| UMS_NSFA_HR_DETAIL_NONGRANTS | ||
| UMS_NSFA_HR_SUM_AD419 | ||
| UMS_NSFA_HR_SUM_AD419_OTHER | ||
| UMS_NSFA_HR_SUM_OTHER_AD419 | ||
| UMS_NSFA_JRNL_ACT_ID | Journal actvitity search by Emplid | UMS05 (UM) NSFA HR Detail - Journal Entries |
| UMS_NSFA_OPER_SUM_AD419 | ||
| UMS_NSFA_OPERATE_DETAIL_AD419X | ||
| UMS_NSFA_REVENUE_SUM_AD419 | ||
| UMS_NSFA_SALARY_VAR | UMS05 (UM) NSFA GL Summary |