OEWS Spreadsheet Template - AAMC

202302-OEWS-template-AAMC.xlsx

Report on Occupational Employment and Wages

OEWS Spreadsheet Template - AAMC

OMB: 1220-0042

Document [xlsx]
Download: xlsx | pdf

Overview

OEWS report
Reporting FAQs


Sheet 1: OEWS report


Occupational Employment and Wage Statistics (OEWS) Report



















Instructions









1. Please review the detailed instructions on the second tab before you begin entering your data on this spreadsheet. You can also create or export your own file with the requested information.




















2. We are requesting data for every employee who worked during the pay period that included November 12, 2022. Report each employee on a separate row, but do not include names









or Social Security numbers. Do not report contract workers.




















3. Report each employee's job title, a brief description of duties, part-time/full-time status, hourly wage rate or annual salary, weekly hours, hire date, gender, birth year, department, and









worksite location in columns A through K. Department and worksite location are optional, but providing this information now can reduce the need for follow-up phone calls.









(You may need to scroll to the right to see all of the columns.)




















4. Report hourly wage rates for all part-time employees. Report hourly wage rates or annual salaries for full-time employees. Please include tips and commissions.




















5. Save your file with your IDCF number in the file name, then go to our secure data collection site.








Log in with your IDCF number, provide the requested contact and establishment information, then upload the file. The state office will contact you if they have questions about your data.




















Thank you for your participation - we can't do this without you!




















Job title Description of duties Part-time or full-time Hourly wage rate (part-time or full-time employees) Annual salary (full-time employees only) Weekly Hours Hire date (MM/DD/YYYY) Gender Birth year (YYYY) Department (optional) Worksite location (optional)
Example: Registered Nurse Care for ill and injured patients Full-time
$65,325 40.00 3/15/2022 Female 1985 Clinic 123 Main St.
Example: Certified Nursing Assistant Provide basic patient care under direction of nursing staff Full-time $15.15
37.00 11/30/2020 Male 1994 Clinic 700 Healthcare Blvd
Example: Certified Nursing Assistant Provide basic patient care under direction of nursing staff Part-time $16.30
20.50 1/7/2018 Male 1999 Clinic 700 Healthcare Blvd

Sheet 2: Reporting FAQs

OEWS Reporting Instructions

Which employees should I report?
Report employees who worked during the pay period that included November 12, 2022.
Report employees working at, or reporting to, the location specified after “Report for” in the mailing address in your letter or email.
Report employees who are on paid leave or assigned temporarily to other work locations, including employees who are working remotely or off-site.
Report paid owners and officers of incorporated firms.

What information should I report?
For each of these employees, please report the following information:
Job title
Brief description of duties
Part-time or full-time status
Hourly wage rate (for part-time or full-time employees) or annual salary (for full-time employees only)
Weekly hours
Hire date
Gender
Birth year
Department (optional)

What information should not be reported?
Do not report any of the following employees or information:
Do not report contract workers
Do not report owners or partners of unincorporated firms.
Do not report employee names or Social Security numbers
Do not report annual wages for part-time employees

How should I report job titles?
Report employee job titles according to the work they are doing, not their training.
Example: Report an employee working as a drafter, but trained as an engineer, as a drafter.
Report an employee as a supervisor if they spend at least 80 percent of their time supervising other employees.
Example: Report a head cashier as a supervisor of cashiers if they spend more than 80 percent of their time supervising other cashiers, but
report them as a cashier if they spend less than 80 percent of their time supervising other cashiers.
Report apprentices separately from helpers.
Example: Report an apprentice carpenter as a carpenter but report an employee who helps them as a carpenter’s helper.

How should I report wage rates?
Report hourly wage rates or annual salaries for full-time employees. Report hourly wage rates for part-time employees.
If wage rates are recorded differently, such as by the month, convert them to an hourly wage rate.
Report each employee’s actual wage rate, not an approximation.
For employees who earn tips, commissions, or piece-rate payments, calculate their hourly wage rate or annual salary including their base pay plus tips, commissions, or piece rates.
If you are reporting for a school, please see the additional reporting instructions at www.bls.gov/respondents/oes/MI.htm#school.

What should I include when reporting wages? (Definitions of pay terms)
·       Base rate
·       Commissions
·       Tips
·       Cost-of-living allowance
·       Deadheading pay
·       Guaranteed pay
·       Hazard pay
·       Incentive pay
·       Longevity pay
·       Piece rate
·       Portal-to-portal rate
·       Production bonus

What should I exclude when reporting wages? (Definitions of pay terms)
·       Attendance bonus
·       Back pay
·       Draw
·       Holiday bonus
·       Holiday premium pay
·       Jury duty pay
·       Lodging payments
·       Meal payments
·       Merchandise discounts
·       Nonproduction bonus
·       On-call pay
·       Overtime pay
·       Perquisites
·       Profit-sharing payment
·       Relocation allowance
·       Tuition repayments
·       Severance pay
·       Shift differential
·       Stock bonuses
·       Tool allowance
·       Uniform allowance

What if I need more help?
Email [email protected]
or call 866-637-1920
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy