OEWS Spreadsheet Template

202302-OEWS-template.xlsx

Report on Occupational Employment and Wages

OEWS Spreadsheet Template

OMB: 1220-0042

Document [xlsx]
Download: xlsx | pdf

Overview

OEWStemplate
# of employees column


Sheet 1: OEWStemplate


Occupational Employment and Wage Statistics (OEWS) Report











Instructions





1. Enter the total number of employees at this establishment in cell B19.












2. Report the job title and a brief description of duties for each employee who worked during the pay period that included <refer_date>.





Report an employee who works in two or more occupations in the job that requires the highest skill level. If there is no difference in skill,





report the employee in the occupation in which they spend the most time.












3. Report each employee's wage rate. For part-time employees, report an hourly wage rate only. For full-time employees, report an hourly wage





rate or annual salary. Please include tips and commissions. Department and worksite location are optional, but providing this information now





can reduce the need for follow up phone calls.












4. IMPORTANT: Verify that the sum of reported employees in cell B20 matches the number of employees entered in B19. If the numbers don’t





match, check that the values in the “# of employees” column are correct. See the tab labeled “# of employees column” for examples.












5. Save this file and go to HTTPS://IDCFOEWS.BLS.GOV. Provide the requested contact and establishment information, then upload the file.












TOTAL # OF EMPLOYEES =





SUM OF REPORTED EMPLOYEES = 0




Job title Description of duties Hourly wage rate (part-time or full-time employees) Annual salary (full-time employees only) # of employees in this job with this exact wage Department (optional) Worksite location (optional)
Example: Registered Nurse Care for ill and injured patients
$65,325 5 Clinic 123 Main St.
Example: Certified Nursing Assistant Provide basic patient care under direction of nursing staff $12.30
3 Clinic 700 Healthcare Blvd
Example: Certified Nursing Assistant Provide basic patient care under direction of nursing staff $15.15
2 Clinic 700 Healthcare Blvd

Sheet 2: # of employees column

Using the # of employees column








Let's say your establishment has three physical therapists, each earning $90,000 per year.








There are two different ways to report them correctly on this template.














DON'T report each employee on a separate row AND enter the


Option 1: Report each employee on a separate row




total # of employees in the # of employees column on each row


TOTAL # OF EMPLOYEES = 3



TOTAL # OF EMPLOYEES = 3

SUM OF REPORTED EMPLOYEES = 3



SUM OF REPORTED EMPLOYEES = 9

Job title Annual wage (full-time employees only) # of employees in this job with this exact wage YES

Job title Annual wage (full-time employees only) # of employees in this job with this exact wage NO
Physical therapist $90,000 1


Physical therapist $90,000 3
Physical therapist $90,000 1


Physical therapist $90,000 3
Physical therapist $90,000 1


Physical therapist $90,000 3




















Option 2: Report the employees on one row, using the # of employees column








TOTAL # OF EMPLOYEES = 3







SUM OF REPORTED EMPLOYEES = 3







Job title Annual wage (full-time employees only) # of employees in this job with this exact wage YES





Physical therapist $90,000 3






File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy