DARTS : Finance Prompt Tables

Click on the table headers to change how the table is sorted.

Accounting Period

UM_FY_PERIODS

Business Unit

BUS_UNIT_TBL_FS - PS/Financials Business Units

Note: In June 2018, a new business unit, MCV09, was added to our financials system (e.g., general ledger, AP, etc.) for use in FY19 and beyond. This new business unit is NOT a part of the University of Maine System (UMS) legal entity or reporting unit; therefore you should not include it in data pulled for the UMS. Creation of this new business unit requires you to make one or both of the following changes to the queries/reports that you run to ensure that data for MCV09 is not included.

Calendar Date Prompt

To run a prompt on a date field that uses a clickable calendar, change the *Format drop-down to Century.

Department ID

UM_DEPT1_VW

This prompt table is extremely large and will not display all at once.  Start typing as much of your department id number as you know. Department IDs start with Institution code number. Below is a sample if entering 3 for UMFK (UMS03)

Fund Code

UM_FUND_VW1

Program Code

There is no Prompt Table for Program Code. You can create an expression to prompt by entering the First Number in the Program Code

Create this Expression

Add the following information in the Prompt Properties dialogue box:

Project ID

UM_PROJECTID_VW

This prompt table is extremely large and will not display all at once.  Start typing as much of your project id number as you know. Project Ids start with Institution code number. Below is a sample if entering 3 for UMFK (UMS03)

Operating Unit

UM_OPER_EFF_VW

Class Field

UM_CLASS_FLD_VW

This prompt table is extremely large and will not display all at once.  Start typing as much of your class field as you know. Class Field is not well-described.

The description will alert the user to check with the Department for more information.