SLIDE 8 A Guide to Submitting Clean Data
(Highlighted fields are mandatory)
Field Name Description of Data Required
January 1, 20XX EE ID# ID number or unique identifier used each year for this employee DOB Date of Birth (mm/dd/yyyy) DOH Date of Hire (mm/dd/yyyy) Gender F=Female, M=Male Ethnicity H=Hispanic, W=White, B=Black/African American, NI=Native American, A=Asian, AI=American Indian, O=Other/Unknown Scheduled Hours Hours an employee is scheduled to work in an 80-hour two-week period Actual Hours Hours an employee worked in a one year period Total Gross Income Accumulated yearly pay – W2 Earnings Hrly Pay Base hourly rate of pay Org MHA Member Organization Name Facility Specific Facility Name within Organization Facility Type H=Hospital, C=Clinic, O=Other Your Job Type The job type as it is labeled in your organization MHA Job Type One of the 38 job types MHA tracks for the Workforce tool – Map your job type to one of them Degree H=HighSchool, A=Associates, B=Bachelors, G=Graduate, O=Other Union/Non-Union U=Union, N=Non-Union Hire Type N=New (to the job & org.), E=Experienced Staff Type F=Full-Time (>64), P=Part-Time (>16-<64), O=Casual (<16) in a two-week period
