YourMoney Agency Payroll

data.nj.gov | Last Updated 25 Jul 2019

This dataset contains data for State employees paid through the Centralized Payroll System. The data reflects payroll payments made to the employee for the calendar year through the date indicated. There are two types of records: MASTER and DETAIL. There is at least one MASTER and one DETAIL record per employee. Multiple DETAIL records for an employee will appear in the file for a specific year if the employee is paid by more than one department/agency or by more than one section during that calendar year. The sums for all of the departments/agencies appear in the columns with prefix “MASTER”. Additional information is in the attached dataset summary PDF (available on the [About] tab under "Attachments").

This dataset has the following 32 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
CALENDAR_YEARcalendar_yearnumberFour digit year representing the twelve month period starting with January and ending with December. Indicates the calendar year in which payments were actually made to the employee. Calendar year and calendar quarter together represent the end of the reporting period.
CALENDAR_QUARTERcalendar_quarternumberPayroll data will be published quarterly. The single digit calendar quarter represents the end of the period that the data spans and not the actual quarter that the payment was made. For example, when calendar quarter is set to ‘2’, the data would include payments made from January through June for the given calendar year. Calendar year and calendar quarter together represent the end of the reporting period.
AS_OF_DATEas_of_datecalendar_dateThe last day of the quarter of data represented in this dataset.
PAYROLL_IDpayroll_idtextRandomly generated number that helps pair a master record with its detail record(s).
LAST_NAMElast_nametextLast name of the employee at the end of the reporting period.
FIRST_NAMEfirst_nametextFirst name of the employee at the end of the reporting period. The literal ‘none’ has been used when there is no first name on record.
MIDDLE_INITIALmiddle_initialtextMiddle initial of the employee at the end of the reporting period.
FULL_NAMEfull_nametextFull name of the employee at the end of the reporting period.
ORIGINAL_EMPLOYMENT_DTEoriginal_employment_dtetextORIGINAL EMPLOYMENT DATE
SALARY_HOURLY_RATEsalary_hourly_ratenumberDepending on the value in the column Compensation Method, the value in this column is either the annual salary, hourly rate or a daily rate for the employee at the end of the reporting period. When the compensation method is ‘Part Time’ the salary listed has been adjusted to represent the part time percentage.
MASTER_DEPARTMENT_AGENCY_DESCmaster_department_agency_desctextDiscrete organization within the State of New Jersey associated with the employee at the end of the reporting period.
MASTER_SECTION_DESCmaster_section_desctextThe area of the department to which the employee is assigned at the end of the reporting period.
MASTER_TITLE_DESCmaster_title_desctextThe title is a descriptive name that identifies a position or group of positions with similar duties, responsibilities and qualifications. This is the title associated with the employee at the end of the reporting period.
EMPLOYEE_RELATIONS_GROUPemployee_relations_grouptextClassification indicating whether employee is aligned or not aligned with a union and what type of work that unit performs. This grouping determines what salary and benefits the employee receives. This is the employee relations group associated with the employee at the end of the reporting period.
COMPENSATION_METHODcompensation_methodtextIdentifies the basis by which an employee’s regular pay will be calculated. This is the compensation method associated with the employee at the end of the reporting period.
MASTER_YTD_REGULAR_PAYmaster_ytd_regular_paynumberThe sum of wages for one or more departments/agencies that are earned by an employee for working a predetermined number of hours or days in a week as dictated by the employee’s title during the reporting period.
MASTER_YTD_OVERTIME_PAYMENTSmaster_ytd_overtime_paymentsnumberThe sum of overtime wages for one or more departments/agencies by an employee during the reporting period.
MASTER_YTD_ALL_OTHER_PAYMENTSmaster_ytd_all_other_paymentsnumberThe sum of wages for one or more departments/agencies that are earned by an employee not listed under regular pay or overtime payments during the reporting period.
MASTER_YTD_EARNINGSmaster_ytd_earningsnumberSum of all payments for the employee during the reporting period; that is, the sum of the previous three columns.
PAID_DEPARTMENT_AGENCY_DESCpaid_department_agency_desctextDiscrete organization within the State of New Jersey that made payments to the employee.
PAID_SECTION_DESCpaid_section_desctextThe area of the paid department that made payment to the employee.
REGULAR_PAYregular_paynumberWages earned by an employee for working a predetermined number of hours or days in a week as dictated by the employee’s title.
SUPPLEMENTAL_PAYsupplemental_paynumberWages paid to an employee that were not included in regular pay. In some existing state contracts, supplemental payments for overtime are required. Includes lump sum payments of unused vacation leave, compensatory time, and personal leave bank time.
ONE_TIME_PAYMENTSone_time_paymentsnumberWages paid as bonus and one-time payments or shift differential for employees working night or evening shifts.
LEGISLATOR_OR_BACK_PAYlegislator_or_back_paynumberWages paid to an employee as determined by the Merit System Board or other legal decision. Also used for Legislators and Legislative Aides pay.
OVERTIME_PAYMENTSovertime_paymentsnumberOvertime wages.
CLOTHING_UNIFORM_PAYMENTSclothing_uniform_paymentsnumberWages paid to eligible employees for clothing and uniform purchase and maintenance.
RETROACTIVE_PAYretroactive_paynumberWages paid to an employee for a salary adjustment with a prior effective date.
LUMP_SUM_PAYlump_sum_paynumberWages paid to an employee upon retirement for any unused sick leave accrued. The maximum payout is $15,000 per employee.
CASH_IN_LIEU_MAINTENANCEcash_in_lieu_maintenancenumberContractual biweekly payment for State Police Employee Relations Groups.
YTD_EARNINGSytd_earningsnumberSum of all payments for the employee by paid_department_agency_desc and paid_section_desc during the reporting period.
RECORD_TYPErecord_typetextIdentifies master or detail record for an employee.