JIRA Reference:
BI-42
-
Finance Descr Tables for Chartfield Components
Done
Report Purpose
The finance ChartFields include the following field components: BUSINESS_UNIT, DEPTID, FUND CODE, ACCOUNT, OPERATING UNIT,
PROGRAM, PROJECT_ID, CLASS_FLD
Each of these components has a DESCR definition.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
There are eight public FNPRD queries, one for each of the components:
- UMS_DTS_BUS_UNIT_TBL_FS
- UMS_DTS_DEPT_TBL
- UMS_DTS_FUND_TBL
- UMS_DTS_ACCOUNT_DESCR
- UMS_DTS_OPER_UNIT_TBL
- UMS_DTS_PROGRAM_TBL
- UMS_DTS_PROJECT
- UMS_DTS_CLASS_FIELD
Report Type
Queries
Prompts Required
None
Data Fields Generated
1.
| BUSINESS_UNIT | DESCR |
2.
| BUSINESS_UNIT | DEPTID | DESCR | EFFDT | EFF_STATUS |
3.
| FUND_CODE | DESCR | EFFDT | STATUS |
4.
| ACCOUNT_TYPE | ACCOUNT | DESCR | EFFDT | STATUS |
5.
| OPERATING_UNIT | DESCR | EFFDT | STATUS |
6.
| BUSINESS_UNIT | PROGRAM_CODE | DESCR | EFFDT | STATUS |
7.
| BUSINESS_UNIT | PROJECT_ID | DESCR | EFF_STATUS | START_DT | END_DT |
8.
| SETID | CLASS_FLD | DESCR | EFFDT | STATUS |
Tables Used (For DARTS users only)
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a report?
Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustments. Please see Security Questions (PS Query/Discoverer).
HELP IS AT HAND!
Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.