JIRA Reference:
REPORT-545
-
Please Document HRPRD Public Query UMS_DTS_UM_F_EMP_CENSVW
Closed
Report Purpose
This public query documents the actual census date runs for the UM_F_EMP_CENSVW view, and includes STRM and Fiscal Year fields for reference. In order to use the census dates in queries, the actual date is required, and on occasion the date may differ from the targeted dates of October 31, December 31, March 31 and June 30.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Human Resources - Production > NavBar (compass icon, top right) > Navigator > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_UM_F_EMP_CENSVW
Report Type
Query
Prompts Required
None
Data Fields Generated
| CENSUS_DT | STERM | FISCAL_YEAR |
|---|
Tables Used
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.