brla-gov/legacy-cityparish-employees-gyhq-w3h3
Icon for Socrata external plugin
 
Preview
  • legacy_cityparish_employees
     
 
Readme
Updated over 2 years ago
Indexed 6 hours ago

Legacy City-Parish Employees

THIS DATASET IS NO LONGER UPDATED

In November 2018, the City-Parish switched to a new payroll system. We are in the final stages of adding employee data from the new system into Open Data BR. This data can be used to see employees as of the last day in the former payroll system.

City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
RACEraceraceText
SEXsexsexText
LAST NAMElast_namelast_nameText
EMPLOYMENT STATUSpm_statuspm_statusNumberEmployee status with City-Parish: 0 - Active, 1 - Temporary Leave (no arrears), 2 - Temporary Leave with Arrears, 3 - Inactive, 4 - Terminated Last Pay Period, 5 - No longer with City-Parish.
ANNUAL SALARYpm_annual_salarypm_annual_salaryNumberAnnual salary based on paygrade and step, does not include any additional earnings
OVERTIME HOURLY RATExtr_ot_hr_ratextr_ot_hr_rateNumberTotal hourly rate times 1.5
TOTAL HOURLY RATExtr_tot_hr_ratextr_tot_hr_rateNumberBase hourly rate plus any additional earnings
HOURLY RATEhourly_ratehourly_rateNumber
LONGEVITY PERCENTAGElong_percentlong_percentNumber
SCHEDULED HOURSscheduled_hoursscheduled_hoursNumberScheduled hours per pay period
YEARS SERVICEyears_serviceyears_serviceNumberYears of service with City-Parish based on current hire date
EMPLOYMENT END DATEterm_dateterm_dateCalendar dateEnd of service date. The employee may have retired, resigned or was terminated.
CURRENT HIRE DATEhire_datehire_dateCalendar dateMost current date employee hired (Does not include broken service with the City-Parish)
PAY STEPpay_steppay_stepNumber
JOB TITLEjob_code_descrjob_code_descrText
JOB CODEjob_codejob_codeText
DIVISION NUMdivision_numdivision_numTextDivision Number
MIDDLE INITIALmiddle_initialmiddle_initialText
FIRST NAMEfirst_namefirst_nameText
EMPLOYEE NUMemployee_numemployee_numTextEmployee Number
DEPARTMENT NAMEdepartment_namedepartment_nameText
DIVISION NAMEdivision_namedivision_nameText
PAY RANGEpay_rangepay_rangeText
DEPARTMENT NUMdepartment_numdepartment_numText
Upstream Metadata