Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

Wondering if you knew of Is there a report that we could pull that would have a lot of will give us the information that we need for the Annual Survey of Public Employment and Payroll (ASPEP) for Municipalities, Counties and Townships. Information needed is number of full time and part time employees and the gross payroll for that through March 12, 202112th. 


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext

Payroll

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

There is no canned reporting program in Munis that is specific to this survey because participation is voluntary.

EERP doesn't currently have a canned option available for this report because it is a voluntary submission, as opposed to a federal requirement. 

Please reference https://www.census.gov/programs-surveys/apes/about/faq.html#par_textimage_1081486844 -

"2. Is this survey mandatory?
This is a voluntary survey. However, our report is the only source of nationwide, comprehensive information on state and local government employment and payroll. This survey is authorized by Title 13, United States Code (U.S.C.), Sections 161 and 182. Also, the U.S. Congress, federal agencies, state, and other local governments, educational and research organizations, and the general public use the results of our data collection."

There are also 10 different survey forms that the EERP client base could potentially be asked to complete for a report that is requested every 5 years. For instance, the form a police protection agency would complete would be different than the form a municipality would create, which would be different from the form an elementary and secondary education entity.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

The Options:

  • Payroll Detail History Report program
in Munis will provide the information needed. 
  • - Search for the Warrant(s) for the pay period that includes March 12th of the reporting year, export to Excel and use a pivot table to sum counts and amounts by Personnel Status (Status column). 
Munis
  • Location, Job, Group B/U, Org and/or Position codes are also available to categorize employees based on the "Include" criteria in the survey.
  • Employee Cube - Gives you access to Employee Master information as well as Earnings History so you can pull payroll details for the warrant that crossed March 12th. 


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

Additional Information from US Census Bureau: 

www2/2021/e4_2021.pdf