| INCOME_FREQUENCY | The pay interval the income field refers to. | Frequency of Income | Taken from raw data |
| INCOME_AMOUNT | Income amount not including commission or bonuses. | Income Amount | Taken from raw data |
| START_DATE | Employee's hire date. | Start Date | Taken from raw data |
| LAST_MONTH_NET | The net income for the last full month of employment. | Net Income Last Month | We iterate through the paystubs and sum the net_pay_amount if the pay_period_end is during the previous full month |
| LAST_MONTH_GROSS | The gross income for the last full month of employment. | Gross Income Last Month | We iterate through the paystubs and sum the gross_pay_amount if the pay_period_end is during the previous full month |
| MONTHLY_NET | The average net income for the last 3 months. | Average Net Income (3 Months) | We iterate through the paystubs and sum the net_pay_amount if the pay_period_end is during the past 3 months, then we divide by 3 |
| MONTHLY_GROSS | The average gross income for the last 3 months. | Average Gross Income (3 Months) | We iterate through the paystubs and sum the gross_pay_amount if the pay_period_end is during the past 3 months, then we divide by 3 |
| LAST_MONTH_BONUS | Total bonus compensation from the last month. | Bonus Last Month | We iterate through the paystubs and the earnings to find any bonus earnings and sum them up if the pay_period_end is during the previous full month |
| LAST_MONTH_COMMISSION | Total commission compensation from the last month. | Commission Last Month | We iterate through the paystubs and the earnings to find any commission earnings and sum them up if the pay_period_end is during the previous full month |
| LAST_MONTH_OVERTIME | Total overtime compensation from the last month. | Overtime Last Month | We iterate through the paystubs and the earnings to find any overtime earnings and sum them up if the pay_period_end is during the previous full month |
| LAST_MONTH_OTHER_PAY | Total other pay compensation from the last month. | Other Pay Last Month | We iterate through the paystubs and the earnings to find any non-regular, bonus, commission or overtime earnings and sum them up if the pay_period_end is during the previous full month |
| COMPANY_NAME | Company name. | Company Name | Taken from raw data |
| PAY_FREQUENCY | Describes how often the employee is paid. | Pay Frequency | Taken from raw data |
| HOURS_RECENT_PAY_PERIOD | The hours worked the most recent pay period. | Hours Worked - Most Recent Paystub | Taken from raw data |
| DATES_RECENT_PAY_PERIOD | The start and end dates of the most recent pay period. | Pay Period - Most Recent Paystub | Taken from raw data |
| HOURS_2ND_RECENT_PAY_PERIOD | The hours worked the 2nd most recent pay period. | Hours Worked - 2nd Most Recent Paystub | Taken from raw data |
| DATES_2ND_RECENT_PAY_PERIOD | The start and end dates of the 2nd most recent pay period. | Pay Period - 2nd Most Recent Paystub | Taken from raw data |
| EMPLOYMENT_STATUS | Indicates if the employee is actively employed. | Employment Status | Taken from raw data |
| GROSS_INCOME_YTD | The cumulative year to date total earnings before any taxes or deductions are removed. | Gross Income YTD | Taken from raw data |
| NET_INCOME_YTD | The cumulative year to date total earnings after all taxes and deductions are removed. | Net Income YTD | Taken from raw data |
| GROSS_LAST_YEAR | Last year's total earnings before any taxes or deductions are removed. | Gross Income Last Year | Taken from raw data |
| NET_LAST_YEAR | Last year's total earnings after all taxes and deductions are removed. | Net Income Last Year | Taken from raw data |
| BONUS_YTD | Total bonus compensation year to date. | Bonus YTD | We iterate through the paystubs and the earnings to find any bonus earnings and sum them up if the pay_period_end is during the previous year |
| COMMISSION_YTD | Total commission compensation year to date. | Commission YTD | We iterate through the paystubs and the earnings to find any commission earnings and sum them up if the pay_period_end is during the previous year |
| OVERTIME_YTD | Total overtime compensation year to date. | Overtime YTD | We iterate through the paystubs and the earnings to find any overtime earnings and sum them up if the pay_period_end is during the previous year |
| OTHER_PAY_YTD | Total other pay compensation year to date. | Other Pay YTD | We iterate through the paystubs and the earnings to find any non-regular, bonus, commission or overtime earnings and sum them up if the pay_period_end is during the previous year |
| TWO_YEARS_AVG_NET | Average monthly net income for the last 2 years (or since start date). | Average Net Income (2 Years or Since Start Date) | We first determine the whether the start date is earlier than two years ago -- we use whichever is more recent. Then we iterate through the paystubs and sum the net_pay_amount if the pay_period_end is before the start of this month and after two years ago (or the start date). Lastly, we divide by 24 (or the number of months since start date) |
| TWO_YEARS_AVG_GROSS | Average monthly gross income for the last 2 years (or since start date). | Average Gross Income (2 Years or Since Start Date) | We first determine the whether the start date is earlier than two years ago -- we use whichever is more recent. Then we iterate through the paystubs and sum the gross_pay_amount if the pay_period_end is before the start of this month and after two years ago (or the start date). Lastly, we divide by 24 (or the number of months since start date) |