(11.17.2021) MARKET ADJUSTMENT ATTACHMENT.XLSX
Extracted text (via pymupdf)
14139 characters
MRT Department Dept Name Fund Accountant D160 Clerk of the Court 100 Accountant D180 Office of Budget and Finance 100 Accountant D190 County Attorney 100 Accountant D260 Correctional Health 255 Accountant D410 Office of Enterprise Technology 100 Accountant D500 Sheriff 100 Accountant D700 Facilities 100 Accountant D800 Superior Court 100 Accountant D860 Public Health 100 Clinical Supervisor D260 Correctional Health 255 Clinical Supervisor D270 Juvenile Probation 255 Clinician (Licensed) D110 Adult Probation 100 Clinician (Licensed) D260 Correctional Health 255 Clinician (Licensed) D270 Juvenile Probation 255 Clinician Associate D110 Adult Probation 100 Clinician Associate D260 Correctional Health 255 Clinician Associate D800 Superior Court 100 Conference Officer D800 Superior Court 100 Counseling Supervisor D270 Juvenile Probation 100 Court Conciliator D800 Superior Court 100 Court Conciliator Supervisor D800 Superior Court 100 Court Probate Investigator D800 Superior Court 100 Court Reporter D800 Superior Court 100 Court Reporter Lead D800 Superior Court 100 Epidemiologist D860 Public Health 100 Epidemiologist Associate D860 Public Health 100 Epidemiologist Senior D860 Public Health 100 Epidemiology Supervisor D860 Public Health 100 Fiduciary D340 Public Fiduciary 100 Fiduciary Senior D340 Public Fiduciary 100 Fiduciary Supervisor D340 Public Fiduciary 100 Finance Business Analyst D800 Superior Court 100 Human Resources Analyst D310 Human Resources 100 Human Resources Associate D310 Human Resources 100 Inmate Classification Spec D500 Sheriff 255 Inmate Classification Supv D500 Sheriff 255 Interpreter D800 Superior Court 100 Interpreter Certified D190 County Attorney 100 Interpreter Certified D560 Public Defense Services 100 Interpreter Certified D800 Superior Court 100 Interpreter Supervisor D800 Superior Court 100 Laboratory Supervisor D880 Environmental Services 100 Laboratory Technician D880 Environmental Services 100 Laboratory Technologist D880 Environmental Services 100 Management Analyst D060 Clerk of the Board 100 Management Analyst D270 Juvenile Probation 100 Management Analyst D430 Treasurer 100 Management Analyst D500 Sheriff 100 Management Analyst D500 Sheriff 100 Management Analyst D800 Superior Court 100 Mitigation Spec Capital Supv D520 Public Defender 100 Mitigation Spec Capital Supv D540 Legal Defender 100 Mitigation Specialist D520 Public Defender 100 Mitigation Specialist D540 Legal Defender 100 Mitigation Specialist D550 Legal Advocate 100 Mitigation Specialist D570 Public Advocate 100 Mitigation Specialist Capital D520 Public Defender 100 Mitigation Specialist Capital D540 Legal Defender 100 Mitigation Specialist Capital D550 Legal Advocate 100 Payroll Specialist D310 Human Resources 100 Payroll/Time and Labor Spec D310 Human Resources 100 Program Coordinator D110 Adult Probation 100 Program Coordinator D190 County Attorney 100 Program Coordinator D220 Human Services 100 Program Coordinator D270 Juvenile Probation 100 Program Coordinator D270 Juvenile Probation 255 Program Coordinator D500 Sheriff 100 Program Coordinator D730 Procurement Services 100 Program Coordinator D800 Superior Court 100 Recruiter D310 Human Resources 100 Social Worker D190 County Attorney 100 Social Worker D220 Human Services 100 Social Worker D260 Correctional Health 255 Social Worker D260 Correctional Health 255 Social Worker D270 Juvenile Probation 100 Social Worker D290 Medical Examiner 100 Social Worker D550 Legal Advocate 100 Social Worker D800 Superior Court 100 Social Worker D800 Superior Court 100 Social Worker D860 Public Health 100 Social Worker Supervisor D190 County Attorney 100 Social Worker Supervisor D220 Human Services 100 Social Worker Supervisor D800 Superior Court 100 Contingency D470 Non Dept Comp Cont 100 Contingency D470 Non Dept Above Base MOE 100 Contingency D980 Eliminations 900 Grand Total AU Group FY 22 Adjustment FY 23 Target FY 23 Recommended OPER 7,860 (7,860) 12,509 OPER 4,804 (4,804) 7,645 OPER 1,092 (1,092) 1,738 OPER 2,426 (2,426) 3,861 OPER 2,158 (2,158) 3,435 OPER 4,804 (4,804) 7,645 OPER 2,961 (2,961) 4,712 OPER 4,395 (4,395) 6,995 OPER 3,711 (3,711) 5,906 OPER 9,963 (9,963) 15,855 OPER 4,092 (4,092) 6,512 OPER 7,584 (7,584) 12,070 OPER 31,392 (31,392) 49,960 OPER 15,681 (15,681) 24,956 OPER 3,961 (3,961) 6,304 OPER 81,304 (81,304) 129,393 OPER 15,263 (15,263) 24,290 OPER 24,782 (24,782) 39,439 OPER 5,215 (5,215) 8,300 OPER 56,307 (56,307) 89,610 OPER 10,070 (10,070) 16,026 OPER 12,644 (12,644) 20,122 OPER 51,771 (51,771) 82,391 OPER 6,392 (6,392) 10,173 OPER 10,980 (10,980) 17,474 OPER 22,021 (22,021) 35,046 OPER 15,130 (15,130) 24,079 OPER 5,342 (5,342) 8,502 OPER 61,993 (61,993) 98,659 OPER 16,678 (16,678) 26,542 OPER 17,161 (17,161) 27,311 OPER 2,099 (2,099) 3,340 OPER 5,944 (5,944) 9,459 OPER 27,511 (27,511) 43,783 OPER 164,802 (164,802) 262,277 OPER 34,970 (34,970) 55,654 OPER 5,210 (5,210) 8,291 OPER 1,391 (1,391) 2,213 OPER 2,649 (2,649) 4,215 OPER 48,178 (48,178) 76,673 OPER 7,264 (7,264) 11,560 OPER 2,340 (2,340) 3,724 OPER 2,639 (2,639) 4,200 OPER 1,902 (1,902) 3,027 OPER 4,379 (4,379) 6,969 OPER 6,223 (6,223) 9,903 OPER 4,442 (4,442) 7,069 MEL0 36,247 (36,247) 57,686 OPER 2,867 (2,867) 4,562 OPER 15,547 (15,547) 24,743 OPER 2,949 (2,949) 4,693 OPER 2,017 (2,017) 3,210 OPER 24,014 (24,014) 38,218 OPER 5,616 (5,616) 8,937 OPER 4,198 (4,198) 6,681 OPER 1,496 (1,496) 2,381 OPER 29,878 (29,878) 47,550 OPER 16,139 (16,139) 25,684 OPER 12,664 (12,664) 20,154 OPER 8,978 (8,978) 14,288 OPER 1,197 (1,197) 1,905 OPER 12,979 (12,979) 20,655 OPER 1,979 (1,979) 3,149 OPER 1,812 (1,812) 2,883 OPER 10,698 (10,698) 17,026 OPER 2,410 (2,410) 3,836 OPER 2,138 (2,138) 3,403 OPER 4,127 (4,127) 6,568 OPER 12,164 (12,164) 19,359 OPER 8,678 (8,678) 13,811 OPER 121,414 (121,414) 193,227 OPER 20,234 (20,234) 32,202 GRV0 14,042 (14,042) 22,347 OPER 50,472 (50,472) 80,325 OPER 11,033 (11,033) 17,559 OPER 3,970 (3,970) 6,318 OPER 40,719 (40,719) 64,803 MHT0 4,852 (4,852) 7,722 OPER 26,628 (26,628) 42,377 OPER 3,847 (3,847) 6,122 OPER 10,155 (10,155) 16,161 OPER 1,561 (1,561) 2,485 OPER 17,594 (17,594) 28,001 OPER (1,389,193) 1,389,193 (2,210,848) OPER 411,554 (411,554) 654,976 OPER (411,554) 411,554 (654,976) 0 0 0 Department Fund AU Group Sum of FY 22 Sum of FY 23 Target D260 255 GRV0 14042 -14042 D260 255 OPER 175557 -175557 D270 255 OPER 22183 -22183 D500 255 OPER 199772 -199772 Grand Total 411554 -411554 Fund Department AU Group Sum of FY23 REC Adj D470 and D980 filtered out 100 D060 OPER 6969 100 D110 OPER 39029 100 D160 OPER 12509 100 D180 OPER 7645 100 D190 OPER 216488 100 D220 OPER 37570 100 D270 OPER 52788 100 D290 OPER 6318 100 D310 OPER 83246 100 D340 OPER 152512 100 D410 OPER 3435 100 D430 OPER 7069 100 D500 MEL0 57686 100 D500 OPER 15610 100 D520 OPER 90461 100 D540 OPER 37831 100 D550 OPER 91638 100 D560 OPER 4215 100 D570 OPER 2381 100 D700 OPER 4712 100 D730 OPER 6568 100 D800 MHT0 7722 100 D800 OPER 503390 100 D860 OPER 97129 100 D880 OPER 10951 255 D260 GRV0 22347 255 D260 OPER 279394 255 D270 OPER 35304 255 D500 OPER 317931 Grand Total 2210848 MRT DepartmenDept Name Fund AU Group Social Worker D190 County Attorney 100 OPER Social Worker Supervisor D190 County Attorney 100 OPER Inmate Classification Spec D500 Sheriff 255 OPER Inmate Classification Supv D500 Sheriff 255 OPER Accountant D160 Clerk of the Court 100 OPER Accountant D180 Office of Budget and Finance 100 OPER Accountant D190 County Attorney 100 OPER Accountant D260 Correctional Health 255 OPER Accountant D410 Office of Enterprise Technology 100 OPER Accountant D500 Sheriff 100 OPER Accountant D700 Facilities 100 OPER Accountant D800 Superior Court 100 OPER Accountant D860 Public Health 100 OPER Finance Business Analyst D800 Superior Court 100 OPER Clinical Supervisor D270 Juvenile Probation 255 OPER Clinician (Licensed) D110 Adult Probation 100 OPER Clinician (Licensed) D270 Juvenile Probation 255 OPER Clinician Associate D110 Adult Probation 100 OPER Clinician Associate D800 Superior Court 100 OPER Conference Officer D800 Superior Court 100 OPER Counseling Supervisor D270 Juvenile Probation 100 OPER Court Conciliator D800 Superior Court 100 OPER Court Conciliator Supervisor D800 Superior Court 100 OPER Court Probate Investigator D800 Superior Court 100 OPER Social Worker D270 Juvenile Probation 100 OPER Social Worker D800 Superior Court 100 OPER Social Worker D800 Superior Court 100 MHT0 Social Worker Supervisor D800 Superior Court 100 OPER Social Worker D220 Human Services 100 OPER Social Worker Supervisor D220 Human Services 100 OPER Clinical Supervisor D260 Correctional Health 255 OPER Clinician (Licensed) D260 Correctional Health 255 OPER Clinician Associate D260 Correctional Health 255 OPER Social Worker D260 Correctional Health 255 OPER Social Worker D260 Correctional Health 255 GRV0 Social Worker D290 Medical Examiner 100 OPER Court Reporter D800 Superior Court 100 OPER Court Reporter Lead D800 Superior Court 100 OPER Social Worker D860 Public Health 100 OPER Laboratory Supervisor D880 Environmental Services 100 OPER Laboratory Technician D880 Environmental Services 100 OPER Laboratory Technologist D880 Environmental Services 100 OPER Fiduciary Senior D340 Public Fiduciary 100 OPER Fiduciary Supervisor D340 Public Fiduciary 100 OPER Fiduciary D340 Public Fiduciary 100 OPER Human Resources Analyst D310 Human Resources 100 OPER Human Resources Associate D310 Human Resources 100 OPER Recruiter D310 Human Resources 100 OPER Interpreter D800 Superior Court 100 OPER Interpreter Certified D190 County Attorney 100 OPER Interpreter Certified D560 Public Defense Services 100 OPER Interpreter Certified D800 Superior Court 100 OPER Interpreter Supervisor D800 Superior Court 100 OPER Management Analyst D060 Clerk of the Board 100 OPER Management Analyst D270 Juvenile Probation 100 OPER Management Analyst D430 Treasurer 100 OPER Management Analyst D500 Sheriff 100 OPER Management Analyst D500 Sheriff 100 MEL0 Management Analyst D800 Superior Court 100 OPER Payroll Specialist D310 Human Resources 100 OPER Payroll/Time and Labor Spec D310 Human Resources 100 OPER Mitigation Spec Capital Supv D520 Public Defender 100 OPER Mitigation Spec Capital Supv D540 Legal Defender 100 OPER Mitigation Specialist D520 Public Defender 100 OPER Mitigation Specialist D540 Legal Defender 100 OPER Mitigation Specialist D550 Legal Advocate 100 OPER Mitigation Specialist D570 Public Advocate 100 OPER Mitigation Specialist Capital D520 Public Defender 100 OPER Mitigation Specialist Capital D540 Legal Defender 100 OPER Mitigation Specialist Capital D550 Legal Advocate 100 OPER Social Worker D550 Legal Advocate 100 OPER Program Coordinator D110 Adult Probation 100 OPER Program Coordinator D190 County Attorney 100 OPER Program Coordinator D220 Human Services 100 OPER Program Coordinator D270 Juvenile Probation 100 OPER Program Coordinator D270 Juvenile Probation 255 OPER Program Coordinator D500 Sheriff 100 OPER Program Coordinator D730 Procurement Services 100 OPER Program Coordinator D800 Superior Court 100 OPER Epidemiologist Associate D860 Public Health 100 OPER Epidemiologist D860 Public Health 100 OPER Epidemiologist Senior D860 Public Health 100 OPER Epidemiology Supervisor D860 Public Health 100 OPER Contingency D470 Non Dept Comp Cont 100 OPER Contingency D470 Non Dept Above Base MOE 100 OPER Contingency D980 Eliminations 900 OPER AU FY 22 FY 23 Target FY23 REC Adj 1000 121,414 (121,414) 193,227 1000 10,155 (10,155) 16,161 1000 164,802 (164,802) 262,277 1000 34,970 (34,970) 55,654 1000 7,860 (7,860) 12,509 1000 4,804 (4,804) 7,645 1000 1,092 (1,092) 1,738 1000 2,426 (2,426) 3,861 1000 2,158 (2,158) 3,435 1000 4,804 (4,804) 7,645 1000 2,961 (2,961) 4,712 1000 4,395 (4,395) 6,995 1000 3,711 (3,711) 5,906 1000 2,099 (2,099) 3,340 1000 4,092 (4,092) 6,512 1000 7,584 (7,584) 12,070 1000 15,681 (15,681) 24,956 1000 3,961 (3,961) 6,304 1000 15,263 (15,263) 24,290 1000 24,782 (24,782) 39,439 1000 5,215 (5,215) 8,300 1000 56,307 (56,307) 89,610 1000 10,070 (10,070) 16,026 1000 12,644 (12,644) 20,122 1000 11,033 (11,033) 17,559 1000 26,628 (26,628) 42,377 MHT0 4,852 (4,852) 7,722 1000 17,594 (17,594) 28,001 1000 20,234 (20,234) 32,202 1000 1,561 (1,561) 2,485 1000 9,963 (9,963) 15,855 1000 31,392 (31,392) 49,960 1000 81,304 (81,304) 129,393 1000 50,472 (50,472) 80,325 654,976 GRV0 14,042 (14,042) 22,347 1000 3,970 (3,970) 6,318 1000 51,771 (51,771) 82,391 1000 6,392 (6,392) 10,173 1000 3,847 (3,847) 6,122 1000 2,340 (2,340) 3,724 1000 2,639 (2,639) 4,200 1000 1,902 (1,902) 3,027 1000 16,678 (16,678) 26,542 1000 17,161 (17,161) 27,311 1000 61,993 (61,993) 98,659 1000 5,944 (5,944) 9,459 1000 27,511 (27,511) 43,783 1000 8,678 (8,678) 13,811 1000 5,210 (5,210) 8,291 D DD800 1000 1,391 (1,391) 2,213 D DD190 1000 2,649 (2,649) 4,215 D DD560 1000 48,178 (48,178) 76,673 D DD800 1000 7,264 (7,264) 11,560 D DD800 1000 4,379 (4,379) 6,969 D DD060 1000 6,223 (6,223) 9,903 D DD270 1000 4,442 (4,442) 7,069 D DD430 1000 2,867 (2,867) 4,562 D DD500 MEL0 36,247 (36,247) 57,686 D DD500 1000 15,547 (15,547) 24,743 D DD800 1000 8,978 (8,978) 14,288 D DD310 1000 1,197 (1,197) 1,905 D DD310 1000 2,949 (2,949) 4,693 D DD520 1000 2,017 (2,017) 3,210 D DD540 1000 24,014 (24,014) 38,218 D DD520 1000 5,616 (5,616) 8,937 D DD540 1000 4,198 (4,198) 6,681 D DD550 1000 1,496 (1,496) 2,381 D DD570 1000 29,878 (29,878) 47,550 D DD520 1000 16,139 (16,139) 25,684 D DD540 1000 12,664 (12,664) 20,154 D DD550 1000 40,719 (40,719) 64,803 D DD550 1000 12,979 (12,979) 20,655 D DD110 1000 1,979 (1,979) 3,149 D DD190 1000 1,812 (1,812) 2,883 D DD220 1000 10,698 (10,698) 17,026 D DD270 1000 2,410 (2,410) 3,836 D DD270 1000 2,138 (2,138) 3,403 D DD500 1000 4,127 (4,127) 6,568 D DD730 1000 12,164 (12,164) 19,359 D DD800 1000 22,021 (22,021) 35,046 1000 10,980 (10,980) 17,474 1000 15,130 (15,130) 24,079 1000 5,342 (5,342) 8,502 (1,389,193) 1,389,193 (2,210,848) 411,554 (411,554) 654,976 total FY 23 RE (411,554) 411,554 (654,976) 24 idemiologist Associate 14 idemiologist 21 idemiologist Senior 23 idemiology Supervisor 11 ntingency EC Fund 255