# "HRSWORKORG" and "EARNWEEK" for salaried employees? **URL:** \ **Category:** CPS\ **Created:** [May 28, 2015, 10:11pm UTC](https://forum.ipums.org/t/hrsworkorg-and-earnweek-for-salaried-employees/904 "2015-05-28T22:11:00Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ccrawford511](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@ccrawford511](https://forum.ipums.org/u/ccrawford511)\ **Post date:** [May 28, 2015, 10:11pm UTC](https://forum.ipums.org/t/hrsworkorg-and-earnweek-for-salaried-employees/904/1 "2015-05-28T22:11:00Z")
This question is directed to Tim Moreland as a clarification to a response to “Veterans Supplement Income Information:” As I explore the outgoing rotation group variables (hrsworkorg or earnweek), I am struggling to use this data to acquire information for not only employees that are paid hourly. You mentioned in your response to my previous inquiry, that one “could also use EARNWEEK in combination with [hours worked per week](https://cps.ipums.org/cps-action/variables/HRSWORKORG#description_section) and [weeks worked per year](https://cps.ipums.org/cps-action/variables/WKSWORKORG#description_section) to estimate hourly wages and annual salaries for non-hourly workers,” yet when I tabulate what data is available for each month/year’s outgoing rotation group, there is an unnaturally high number of “0” values for hrsworkorg, and an unnaturally high number of “9999.99”'s for earnweek, beyond what would make sense given the variable empstat. This makes me think that the “0” or “9999.99” values include both unemployed AND salaried employed respondents. In short, how can I access information re: work / salary / PT vs FT status, for both hourly-paid AND salaried employees, for the outgoing rotation groups? As a reminder, I am using the ORGs to link up earnings responses with the Vet Supplement respondents, so accesing the March ASEC survey is not a possibility. It’s seeming like the above mentioned data is only available for hourly-paid employees, unless I am missing something… Please advise! Thank you in advance, Tim-- Your responses are always appreciated. ---
**Author:** ![Tim\_Moreland](https://avatars.discourse-cdn.com/v4/letter/t/f1d935/32.png) [@Tim\_Moreland](https://forum.ipums.org/u/Tim_Moreland)\ **Post date:** [May 30, 2015, 6:31pm UTC](https://forum.ipums.org/t/hrsworkorg-and-earnweek-for-salaried-employees/904/2 "2015-05-30T18:31:00Z")
In the [Outgoing Rotation/Earner Study](https://cps.ipums.org/cps/outgoing_rotation_notes.shtml) series of questions, respondents are asked the periodicity in which they are paid. Those who initially report being paid hourly ([PAIDHOUR](https://cps.ipums.org/cps-action/variables/PAIDHOUR#codes_section)=NIU) provide both an hourly wage ([HOURWAGE](https://cps.ipums.org/cps-action/variables/HOURWAGE#description_section)) and a usual number of hours worked ([HRSWORKORG](https://cps.ipums.org/cps-action/variables/HRSWORKORG#description_section)). Those who do not report being paid hourly are still given the option to provide an hourly wage. If they choose to provide an hourly wage ([PAIDHOUR](https://cps.ipums.org/cps-action/variables/PAIDHOUR#description_section)=YES), they do not also provide a value for usual hours worked. Ultimately, hourly wages are only available for those that explicitly provide an hourly wage (about 55% of your sample that can also be linked to an ORG month and work for an employer). As for the usual number of weeks worked per year ([WKSWORKORG](https://cps.ipums.org/cps-action/variables/WKSWORKORG#description_section)), only those respondents that report being paid annually provide a usual number of weeks worked. As a result, annual salaries can only be estimated for those that are paid annually (about 25% of your sample that can also be linked to an ORG month and work for an employer). It is not possible to estimate annual salaries for those respondents that report being paid hourly, weekly, bi-weekly, twice monthly, or monthly (about 75% of your relevant sample). You mentioned an unnaturally high number of "9999.99"s for the variable [EARNWEEK](https://cps.ipums.org/cps-action/variables/EARNWEEK#description_section). Keep in mind that unemployed respondents, self-employed respondents and unpaid family workers do not report weekly earnings. Once these groups are excluded, over 99% of your sample that can be linked to an ORG month has a valid EARNWEEK value. I apologize for not being sufficiently clear in my previous answer, and I hope this helps. ---
**Author:** ![Keunwon\_Song](https://avatars.discourse-cdn.com/v4/letter/k/919ad9/32.png) [@Keunwon\_Song](https://forum.ipums.org/u/Keunwon_Song)\ **Post date:** [April 29, 2019, 2:36pm UTC](https://forum.ipums.org/t/hrsworkorg-and-earnweek-for-salaried-employees/904/3 "2019-04-29T14:36:40Z")
Hi, I have a follow up question to what Tim Moreland says here: “Keep in mind that unemployed respondents, self-employed respondents and unpaid family workers do not report weekly earnings.” Based on my understanding the monthly IPUMS CPS does not have an income variable for self-employed individuals as the ASEC does (e.g. INCTOT). As both EARNWEEK and HOURWAGE are not reported for the self-employed. I see that I may be able to use FAMINC (“Income includes money from jobs; net income from business, farm or rent; pensions; dividends; interest; Social Security payments; and any other monetary income received by family members.”). But is there a person-level, not household-level, variable to measure self-employed income in the monthly CPS? ---
**Author:** ![JeffBloem](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/jeffbloem/32/40_2.png) [@JeffBloem](https://forum.ipums.org/u/JeffBloem)\ **Post date:** [April 29, 2019, 4:40pm UTC](https://forum.ipums.org/t/hrsworkorg-and-earnweek-for-salaried-employees/904/4 "2019-04-29T16:40:39Z")
Your understanding is correct. In the basic monthly samples, the [outgoing rotation group (e.g. “Earner Study”) questions](https://cps.ipums.org/cps/outgoing_rotation_notes.shtml) are the only variables that collect information on earnings or income. However, as Tim notes, these variables exclude self-employed workers. Unfortunately, there are not other person level variables that capture self-employed income in the CPS. This sort of analysis is really only feasible using annual data from the ASEC or the US decennial or ACS (available via [IPUMS USA](https://usa.ipums.org/usa/)).