Running Queries

   Overview   

 

The Queries section in the Business Management Workcenter provides convenient links to the queries that you need to monitor the financial activity of your department or unit, listed in the order of how work flows from entry through completion. Instructions to use each query are found in the sections below.

The queries in this section provide the following information:

Transaction Type Name of Query Description
Travel Authorizations

Entry - Pending User Submission

UGA_TE_TA_PENDING_SUBMISSION

Finds pending travel authorizations that are not yet submitted
Travel Authorizations

Workflow - Approval in Process

UGA_TE_TA_WORKKFLOW_PENDING

Finds travel authorizations that have been submitted but have not received final approval
Expense Reports

Entry - Pending User Submission

UGA_TE_PENDING_SUBMISSION

 

Finds pending expense reports that are not yet submitted
Expense Reports

Workflow - Approval in Process

UGA_TE_ER_WORKKFLOW_PENDING

 

Finds expense reports that have been submitted but have not received final approval
Expense Reports

Budget Check - Not Budget Chk'd

UGA_TE_ER_BUDGET_NOT_CHKD

 

Finds expense reports that have not been budget checked
Expense Reports

Budget Check - Exceptions/Errors

UGA_TE_ER_BUDGET_ERRORS

 

Finds expense reports that have not processed due to budget check errors
Expense Reports

Complete - Waiting for Payment

UGA_TE_ER_WAITING_PAYMENT

 

Finds expense reports that have been completed, but payment has not yet been made
Payment Requests

Entry - Pending User Submission

UGA_AP_PR_PENDING_SUBMIT

Finds pending payment requests that are not yet submitted
Payment Requests

Workflow - Approvals in Process

UGA_AP_PR_WORKFLOW_PENDING

Finds payment requests that have been submitted but have not received final approval
Payment Requests

Budget Check - Exceptions/Errors

UGA_AP_PR_BUDGET_ERRORS

Finds payment requests that have not processed due to budget check errors
Payment Requests

Approved - Waiting Payment

UGA_AP_PR_WAITING_PAYMENT

Finds payment requests that have been completed, but payment has not yet been made
Payment Requests

Review - Pymt Request Data

UGA_AP_PR_DETAIL_LOOKUP

Provides data on payment requests including status information and chartstring details
GL Journals

Entry - Journals Pending

UGA_GL_JRNL_PENDING_POST

Finds GL journals that are have a posting status of pending
GL Journals

Workflow - Approvals in Process

UGA_GL_JRNL_WORKFLOW_PENDING

Finds GL journals that have been submitted but have not received final approval
GL Journals

Budget Check - Exceptions/Errors

UGA_GL_JRNL_BUDGET_ERRORS

Finds GL journals that have not processed due to budget check errors
Budget Journals

Entry - Pending Budget Journals

UGA_KK_JRNL_PENDING_POST

Finds budget journals that are have a posting status of pending
Budget Journals

Workflow - Approvals in Process

UGA_KK_JRNL_XFR_WF_PENDING

Finds budget journals that have been submitted but have not received final approval
Budget Journals

Budget Check - Exceptions/Errors

UGA_KK_JRNL_BUDGET_ERRORS

Finds budget journals that have not processed due to budget check errors
Budget Transfers

Entry - Pending Budget Transfers

UGA_KK_JRNL_XFR_PENDING_POST

Finds budget transfers that are have a posting status of pending
Budget Transfers

Workflow - Approvals in Process

UGA_KK_JRNL_XFR_WF_PENDING

Finds budget transfers that have been submitted but have not received final approval
Budget Transfers

Budget Check - Exceptions/Errors

UGA_KK_JRNL_XFR_BUDGET_ERRORS

Finds budget transfers that have not processed due to budget check errors
Journal Vouchers (JVs)

Entry - Pending Submission 

UGA_AP_JV_PENDING_SUBMIT

Finds pending journal vouchers that are not yet submitted
Journal Vouchers (JVs)

Workflow - Approvals in Process

UGA_AP_JV_WORKFLOW_PENDING

Finds journal vouchers that have been submitted but have not received final approval
Journal Vouchers (JVs)

Budget Check - Exceptions/Errors

UGA_AP_JV_BUDGET_ERRORS

Finds journal vouchers that have not processed due to budget check errors