{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Overall Audit Results","Sheet1","Administrative Data - OPTIONAL","References","DVOP-LVER-CP Common R&R Audit","Sheet5","Sheet4","Sheet2","Sheet3","DVOP-CP R&R Audit","LVER-CP R&R Audit","Manager's Report","Half-Time R&R Audit","Svc to Nonveterans Audit","FY22-24_Participant File Review","On-Site Review"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overall Audit Results","index":0,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[[30,2,30,4],[29,0,29,1],[29,2,29,4],[41,0,41,1],[48,1,48,4],[44,2,44,3],[37,2,38,3],[33,2,33,3],[32,1,32,3],[35,0,35,1],[34,0,34,4],[40,0,40,4],[41,3,41,4],[42,3,42,4],[42,0,42,2],[35,2,35,4],[39,0,39,4],[47,0,47,4],[7,0,7,1],[12,0,12,1],[17,0,17,1],[23,0,23,1],[7,2,7,4],[12,2,12,4],[17,2,17,4],[23,2,23,4],[20,2,21,3],[18,2,18,4],[11,0,11,4],[16,0,16,4],[22,0,22,4],[28,0,28,4],[9,2,10,3],[14,2,15,3],[26,2,27,3],[24,2,24,4],[0,0,0,4],[2,0,3,4],[1,0,1,4],[5,0,5,4],[6,0,6,1]]}
["Accessibility key: Only cells that can be edited may be selected. Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["Jobs for Veterans State Grants Audit Tool "]
["Updated: June 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No","FY 2022",null,"Select # of Resolved Findings"]
[]
["Key For Cell Colors:","Input Required","Auto-populated ","Area of Concern!","Finding*"]
[0]
["Audit Results",null,"Resolved Findings","Explanation of Resolved Findings","Additional Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finding","Area of Concern","FY 2023",null,0]
["DVOP-LVER-CP Common Roles and Responsibilities",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY 2024",null,1]
["Findings",{"$f":"'DVOP-LVER-CP Common R&R Audit'!C82","v":0},"Select # of Resolved Findings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Areas of Concern",{"$f":"'DVOP-LVER-CP Common R&R Audit'!C83","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes/finding (red or green)",null,null,null,3]
["Promising Practices",{"$f":"'DVOP-LVER-CP Common R&R Audit'!C84","v":"Selection Required"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes/area of concern (yellow or green)",null,null,null,4]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Proper Roles and Responsibilities for DVOP-CP",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Findings",{"$f":"'DVOP-CP R&R Audit'!C64","v":0},"Select # of Resolved Findings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[{"$f":"+A10","v":"Areas of Concern"},{"$f":"'DVOP-CP R&R Audit'!C65","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["Promising Practices",{"$f":"'DVOP-CP R&R Audit'!C66","v":"Selection Required"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Proper Roles and Responsibilities for LVER-CP",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
["Does the state have any staff that conduct LVER duties, including Consolidated Positions? ",{"$f":"'LVER-CP R&R Audit'!B40","v":"Selection Required"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
["Findings",{"$f":"'LVER-CP R&R Audit'!B42","v":0},"Select # of Resolved Findings"]
[{"$f":"+A15","v":"Areas of Concern"},{"$f":"'LVER-CP R&R Audit'!B43","v":0},0]
["Promising Practices",{"$f":"'LVER-CP R&R Audit'!B44","v":"Selection Required"}]
[0]
["Manager's Report",null,0]
["Does the state have any staff that conduct LVER duties, including Consolidated Positions? ",{"$f":"'Manager''s Report'!B52","v":"Selection Required"},0]
["Findings",{"$f":"'Manager''s Report'!B53","v":0},"Select # of Resolved Findings"]
[{"$f":"+A21","v":"Areas of Concern"},0,0]
["Promising Practices",{"$f":"'Manager''s Report'!B54","v":"Selection Required"}]
[0]
["Proper Roles and Responsibilities for Half-Time staff",null,0]
["Does the state have Half-Time JVSG-funded staff assigned?",{"$f":"'Half-Time R&R Audit'!B68","v":"Selection Required"},0]
["Findings",{"$f":"'Half-Time R&R Audit'!B69","v":0},"Select # of Resolved Findings"]
[{"$f":"+A21","v":"Areas of Concern"},0]
["Promising Practices",{"$f":"'Half-Time R&R Audit'!B70","v":"Selection Required"},0]
[0]
["Services to Nonveterans",null,0]
["Findings",{"$f":"'Svc to Nonveterans Audit'!B79","v":0},"Select # of Resolved Findings"]
[{"$f":"+A27","v":"Areas of Concern"},{"$f":"'Svc to Nonveterans Audit'!B80","v":0},0]
["Promising Practices",{"$f":"'Svc to Nonveterans Audit'!B82","v":"Selection Required"}]
[0]
[0]
["Select Fiscal Year Audit Conducted:",null,"FY 2022",0]
[{"$f":"IF($C$42=\"FY 2022\",'FY22-24_Participant File Review'!A2,IF($C$42=\"FY 2023\",'FY22-24_Participant File Review'!A2,IF($C$42=\"FY 2024\",'FY22-24_Participant File Review'!A2)))","v":"FY 2022-2024 Participant File Review (Review of Historical Files during Preparatory Phase)"},null,null,0]
["Findings",{"$f":"IF($C$42=\"FY 2022\", 'FY22-24_Participant File Review'!AI5, IF('Overall Audit Results'!$C$42=\"FY 2023\",'FY22-24_Participant File Review'!AI5, IF( 'Overall Audit Results'!$C$42=\"FY 2024\",'FY22-24_Participant File Review'!AI5, \"Error\")))","v":0},"Select # of Resolved Findings"]
["Areas of Concern",{"$f":"IF($C$42=\"FY 2022\", 'FY22-24_Participant File Review'!AI6, IF('Overall Audit Results'!$C$42=\"FY 2023\",'FY22-24_Participant File Review'!AI6, IF( 'Overall Audit Results'!$C$42=\"FY 2024\",'FY22-24_Participant File Review'!AI6, \"Error\")))","v":0},0]
[null,"# Per Matrix","# of Files Reviewed","Explanation if Variance between Matrix and Files Reviewed"]
["Number of Case Files Reviewed"]
[0]
["On-site Review ",0]
["Findings",{"$f":"IF($C$42=\"FY 2022\", 'On-Site Review'!AI5, IF('Overall Audit Results'!$C$42=\"FY 2023\",'On-Site Review'!AI5, IF( 'Overall Audit Results'!$C$42=\"FY 2024\",'On-Site Review'!AI5, \"Error\")))","v":0},0]
["Areas of Concern",{"$f":"IF($C$42=\"FY 2022\", 'On-Site Review'!AI6, IF('Overall Audit Results'!$C$42=\"FY 2023\",'On-Site Review'!AI6, IF( 'Overall Audit Results'!$C$42=\"FY 2024\",'On-Site Review'!AI6, \"Error\")))","v":0}]
[null,null,"# of Files Reviewed","Explanation if minimum of 2 files were not available for review"]
["Number of Case Files Reviewed",0]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Administrative Data - OPTIONAL","index":2,"n_rows":104,"n_cols":17,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,1],[2,2,2,10]]}
["JVSG Audit and Data Report Administrative Information"]
[0]
["*Auditors have the option to complete this page or to record administrative data from interviews in a separate document.  Documentation of the administrative information is required (auditor's name, date and location of the interview, name and title of persons interviewed, etc.) and should be retained with Audit documents.",null,0]
["#","State Workforce Agency / AJC Name","Name of SWA/AJC Representative Interviewed","Title/Position","Email","Phone","Interviewed by\n(VETS staff Name and Title)","Date of Interview","Location of Interview","Type of Interview (select from dropdown)","Comments",null,null,null,null,null,"In-person"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virtual"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"References","index":3,"n_rows":82,"n_cols":2,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,3,0],[7,0,7,1],[11,0,11,1],[15,0,15,1],[79,0,79,1],[30,0,30,1],[35,0,35,1],[49,0,49,1],[51,0,51,1],[56,0,56,1],[73,0,73,1]]}
[0,"Master Reference List: JVSG Audit Guidance"]
[null,0]
[null,"Required Federal References"]
[null,"Legislation"]
[1,"Jobs for Veterans Act, Chapter Title 41: Job Counseling, Training, and Placement Service For Veterans Title 38, Chapter 41 §4102A, §4103A, §4104, and §4107, as amended"]
[2,"Workforce Innovation and Opportunity Act (P.L.  113-128)"]
[3,"Federal Records Act, 44 USC, Chapter 33"]
[0]
[0,"Grant Provisions"]
[1,"JVSG Terms and Conditions: Access current document via E-Grants"]
[2,"Special Grant Provisions: Access current document via E-Grants"]
[0]
[0,"Grant Officer's Memorandums"]
[1,"GO Memo 03-20  Jobs for Veterans State Grants Program Years 2020-2021 Guidance to Establish Performance Targets (October 30, 2020)"]
[2,"GO Memo 01-20, Jobs for Veterans State Grants (JVSG) State Plan Submission under WIOA Combined and Unified State Plans (March 4, 2020)"]
[0]
[0,"Veterans' Program Letters"]
[1,"VPL 02-21, Jobs for Veterans State Grants Triennial Audit Program, Fiscal Years 2022–2024 (September 15, 2021)"]
[2,"VPL 01-20, Consolidated Disabled Veterans' Outreach Program (DVOP) Specialists and Local Veterans' Employment Representative (LVER) Staff Positions (January 16, 2020)"]
[3,"VPL 07-19, JVSG Recurring Report Requirements (August 14, 2019)"]
[4,"VPL 03-19, Designation of Additional Populations Eligible for Services from Disabled Veteran's Outreach Program Specialist (February 7, 2019)"]
[5,"VPL 01-19, Training Requirements and Reference Tool for Newly Hired Jobs for Veterans State Grant (JVSG) Staff (January 03, 2019)"]
[6,"VPL 01-19 Att.1, JVSG Primer (May 26, 2019)"]
[7,"VPL 05-18, Redesigned National Veterans' Training Institute (NVTI) Core Courses (March 05, 2018)"]
[8,"VPL 03-16, Enrollment of Homeless Veterans Program Participants into a Workforce Innovation and Opportunity Act (WIOA) Workforce Program at an American Job Center (AJC) (July 15, 2016)"]
[9,"VPL 07-14, American Job Center (AJC) participation in Capstone Activities and other Outreach to Transition Service Members (September 26, 2014)"]
[10,"VPL 03-14, Jobs for Veterans’ State Grants (JVSG) Program Reforms and Roles and Responsibilities of American Job Center (AJC) Staff Serving Veterans (April 10, 2014)"]
[11,"VPL 03-14, Change 1 Expansion and Clarification of Definition of Significant Barriers to Employment for Determining Eligibility for the Disabled Veterans' Outreach Program (DVOP) (February 11, 2015)"]
[12,"VPL 03-14, Change 2 Expansion and Clarification of Homeless Definition as a Significant Barrier to Employment (SBE) (October 14, 2015)"]
[13,"VPL 07-10, Refocused Roles and Responsibilities of Jobs for Veterans State Grant Funded Staff (June 29, 2010)"]
[0]
[0,"Director’s Memorandums"]
[1,"DM 03-21, Jobs for Veterans State Grant Triennial Audit Program, FY22 – FY24 (August 11, 2021)"]
[2,"DM 04-19, Reviewing request for Consolidated Disabled Veterans' Outreach (DVOP) Specialist and Local Veterans' Employment Representative (LVER) Staff Positions (July 25, 2019)"]
[3,"DM 05-18, JVSG Recurring Report Guidance (or most current DM on this subject) (May 10, 2018)"]
[0]
[0,"Required State / Local References (The list below is an example and not all inclusive)"]
[1,"Approved JVSG State Plan with approved Modifications"]
[2,"Approved State Plan (Note: JVSG State Plans submitted within a Combined Plan will not have a separate State Plan)"]
[3,"Position Descriptions for all JVSG-funded positions (if applicable)"]
[4,"All state- and local-level policies governing the DVOP/LVER/CP program"]
[5,"Most recent State Performance Outcome Reports (as available)"]
[6,"Local Customer Flow Process"]
[7,"Promotional and/or outreach materials, to include electronic promotions, web content, social media, banners, etc., utilized at the state or local level"]
[8,"Report identifying all veterans served by the DVOP that were provided an Individualized Career Service (ICS) during the previous PY"]
[9,"Quarterly Manager’s Report on Services to Veterans for the previous four (4) completed calendar quarters"]
[10,"Work schedules for all Half-Time DVOP Specialists and LVER staff (if applicable)"]
[11,"Timesheets for Half-Time DVOP Specialists and/or LVERs, or other evidence of effort reporting to verify hours charged to the JVSG grant (if applicable)"]
[null,"**NOTE: Auditor(s) will require \"Read Only\" access to the State's Management Information System (MIS)"]
[0]
[0,"Additional Federal References"]
[0]
[0,"Legislation"]
[1,"Jobs for Veterans Act, Chapter 42: Employment and Training of Veterans\nTitle 38, Chapter 42, as amended"]
[2,"P.L. 115-141, Division H, Title V, Section 505:  Consolidated Appropriations Act, 2018; Stevens Amendment"]
[3,"The Workforce Innovation and Opportunity Act (WIOA) of 2014 (Public Law (Pub. L.113-128)) Title I and III, enacted July 22, 2014"]
[0]
[0,"Employment and Training Administration (ETA) Training and Employment \nGuidance Letters (TEGL) and Training Employment Notices (TEN)"]
[1,"TEGL 07-20, Effective Implementation of Priority of Service Provisions for Most in Need Individuals in the Workforce Innovation and Opportunity Act (WIOA) Adult Program (November, 24, 2020)"]
[2,"TEN 07-20, Resources for Serving Youth and Adults Involved with the Justice System (November 23, 2020)"]
[3,"TEGL 23-19, Guidance for Validating Required Performance Data Submitted by Grant Recipients of U.S. Department of Labor (DOL) Workforce Programs  (June 18, 2020)"]
[4,"TEGL 16-16, One-Stop Operations Guidance for the American Job Center Network  (January 18, 2017) "]
[5,"TEGL 16-16 Change 1, One-Stop Operations Guidance for the American Job Center Network (June 16, 2017)"]
[6,"TEGL 19-16, Guidance on Services provided through the Adult and Dislocated Worker Programs under the Workforce Innovation and Opportunity Act (WIOA) and the Wagner-Peyser Act (WP) Employment Service, as amended by WIOA (March 1, 2017)"]
[7,"TEN 08-16, Implementation of an Integrated Performance Reporting System for Multiple Employment and Training Administration (ETA) and Veterans' Employment and Training Service (VETS) Administered Programs (August 24, 2016) "]
[8,"TEGL 04-16, Enrollment of Homeless Veterans Program Participants into a Workforce Innovation and Opportunity Act (WIOA) Workforce Program at an American Job Center (AJC) (August 4, 2016)"]
[9,"TEN 42-15, Announcing the Release of the Workforce Innovation and Opportunity Act (WIOA) Final Rules and Information Collections for WIOA and Additional DOL Administered Programs  (June 30, 2016)"]
[10,"TEN 42-15 Change 1, Announcing the Release of the Workforce Innovation and Opportunity Act (WIOA) Final Rules and Information Collections for WIOA and Additional DOL Administered Programs  (August 19, 2016)"]
[11,"TEGL 04-15, Vision for the One-Stop Delivery System under the Workforce Innovation and Opportunity Act (WIOA) (August 13, 2015)"]
[12,"TEGL 20-13 Change 2n Designation of Additional Population of Veterans and Other Populations (February 07, 2019)"]
[13,"TEGL 19-13, Jobs for Veterans' State Grant (JVSG) Program Reforms and Roles and Responsibilities of American Job Center (AJC) Staff Serving Veterans (April 10, 2014)"]
[14,"TEGL 19-13 Change 1, Jobs for Veterans' State Grant (JVSG) Program Reforms and Roles and Responsibilities of American Job Center (AJC) Staff Serving Veterans (February 11, 2015)"]
[15,"TEGL 19-13 Change 2, Jobs for Veterans' State Grant (JVSG) Program Reforms and Roles and Responsibilities of American Job Center (AJC) Staff Serving Veterans (October 30, 2015)"]
[0]
[0,"Government Accountability Office (GAO) Reports "]
[1,"GAO-07-594, Veterans’ Employment and Training Service: Labor Could Improve Information on Reemployment Services, Outcomes, and Program Impact (May, 2007)"]
[2,"GAO-06-176, Veterans’ Employment and Training Service: Labor Actions  Needed to Improve Accountability and Help States Implement Reforms to Veterans’ Employment Services (December, 2005)"]
[3,"GAO-13-29, Veterans' Employment and Training Service: Better Targeting, Coordinating, and Reporting Needed to Enhance Program Effectiveness (December, 2012)"]
[4,"GAO-19-282, Grants Management: Agency Action Required to Ensure Grantees Identify Federal Contribution Amounts (March, 2019)"]
[0]
[0,"U.S. Department of Labor, Office of Inspector General (OIG), Office of Audit Report"]
[1,"OIG Report 06-14-001-02-001, VETS' Oversight of Florida's Jobs For Veterans State Grants Program Needs To Be Strengthened (March, 2014)"]

{"sheet":"DVOP-LVER-CP Common R&R Audit","index":4,"n_rows":84,"n_cols":5,"rows_kept":84,"cut":false,"hidden":false,"merged":[[44,0,44,4],[48,0,48,3],[16,1,18,4],[1,0,1,4],[0,0,0,4],[2,0,2,4],[3,1,7,4],[25,1,27,4],[30,1,32,4],[37,1,39,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["DVOP, LVER, and Consolidated Position (CP) Common Roles and \nResponsibilities Audit Checklist"]
[0]
["EXPECTATION: Proper Roles and Responsibilities for DVOP Specialists, LVER staff, and Consolidated Positions: SWA organization has developed a strategic approach to ensure that Disabled Veterans' Outreach Program Specialists (DVOPs), Local Veterans' Employment Representatives (LVERs), and Consolidated Positions (CPs) are only performing duties as described in 38 U.S.C. §§ 4103A(1), 4104(b), 4102A(h), and current VPLs.",0]
["References required for this step:\nApproved JVSG State Plan with approved Modifications\nApproved State Plan \nApproved State Position Descriptions for all JVSG-funded positions\nState- and local-level policies governing the DVOP/LVER/CP program\n38 U.S.C. §§ 4103A(1), 4104(b), and 4102A(h)\nWorkforce Innovation and Opportunity Act (WIOA), Public Law 113-128\nMost recent State Performance Outcome Report\nLocal Customer Flow Process\nPromotional and/or outreach material, to include electronic promotions, web content, social media, banners, etc., utilized at the State or local level\nDOL VPL 03-14 w/ changes (or the most current guidance on this subject)\nAccess to the State's MIS\nGO Memo 01-20\nVPL 01-20 \nTEGL 10-19\nTEGL 19-16"]
[0]
["Indicator 1: The SWA and JVSG-funded staff are familiar with the statutorily defined roles and responsibilities. The JVSG-funded position descriptions contain the statutorily defined responsibilities and do not contain any duties, functions or responsibilities that appear to be outside of the scope. (Title 38, §§ 4103A, 4103A(d)(1), 4104(b), 4104(e)(1), 4102A(h); VPL 03-14 with changes or most current VPL)"]
["Auditor Guidance: Request the JVSG-funded position descriptions (PD) and interview leadership and JVSG-funded staff."]
["Indicator 1","Yes","No","NA","Comments"]
["a. Does the SWA have PD (or any written documentation instructing JVSG staff of their duties) for each JVSG-funded position?",null,null,"N/A"]
["b. Has the SWA outlined in the PD appropriate roles and responsibilities for each JVSG-funded position? "]
["c. Are the JVSG-funded staff familiar with their statutorily defined roles and responsibilities?  If yes, please explain how in the Comments section.",null,null,"N/A"]
["d. Are the local AJC staff, including management, familiar with the roles and responsibilities of JVSG staff?  If yes, please explain how in the Comments section.",null,null,"N/A"]
["e. Has the state JVSG program management provided training to the DVOP specialist/LVER staff pertaining to their roles and responsibilities?",null,null,"N/A"]
["f. Has the state JVSG program management provided adequate training to the AJC staff pertaining to the roles and responsibilities of the JVSG staff?",null,null,"N/A"]
["g. Is the JVSG-funded position(s) performing any duties outside the scope of their roles and responsibilities?",null,null,"N/A"]
[0,0]
["Indicator 2: The SWA has ensured that the Jobs for Veterans State Grants (JVSG) Annual Plan/WIOA Combined Plan, and state- and local-level policies governing the JVSG program have incorporated proper utilization in their overall service delivery strategy. (ETA TEGL 03-15 or most current TEGL)"]
["Auditor Guidance: Review the SWA’s approved WIOA Plans (special attention to section III.b.7) and JVSG Annual plans. This should include the statewide and local level plans.  Review state- and local-level policy letters.  Interview key leadership at the state and local levels to ensure familiarity.  "]
["Indicator 2","Yes","No","NA","Comments"]
["a. Do the state and local WIOA plans (Unified Plan or Combined Plan without JVSG included) and/or the Jobs for Veterans State Grants (JVSG) State Plan/WIOA Combined Plan with JVSG included contain an explanation on how JVSG-funded staff will be integrated into the overall service delivery strategy?",null,null,"N/A"]
["b. Do the state and local WIOA plans, the Jobs for Veterans State Grants (JVSG) State Plan, or state- and local-level policies governing the JVSG program contain language consistent with the statutorily defined responsibilities?",null,null,"N/A"]
["c. Based on interviews with key AJC leadership, are there strategies in place to familiarize AJC staff with the proper roles of the JVSG-funded staff and integration within the state workforce delivery system?  If yes, list these in the Comments section.",null,null,"N/A"]
["d. Based on interviews with key SWA leadership, are there strategies in place to familiarize SWA staff with the proper roles of the JVSG-funded staff and integration within the larger state workforce delivery system?  If yes, list these in the Comments section.",null,null,"N/A"]
["e. Based on interviews with DVOP specialists and/or LVER staff, does the DVOP/LVER staff receive any training regarding the workforce system structure (including WIBs), roles and interaction of mandated partners, or levels of service provision?  If yes, list any training opportunities in the Comments section.",null,null,"N/A"]
[0,0]
["Indicator 3: A review of signage and promotional materials utilized by the American Job Center (AJC) indicates the proper utilization of DVOP specialist and/or LVER staff. (Title 38 §4103A(a)(1) and §4104(b)(1-2))"]
["Auditor Guidance: Observe any signage posted in the lobby area, resource room or any other common area in the AJC that would indicate improper utilization of DVOP specialist and/or LVER staff; request to see any promotional and/or outreach material, to include electronic promotions, banners, web content, social media, etc., utilized at the state or local level."]
["Indicator 3","Yes","No","NA","Comments"]
["Is there any signage, promotional and/or outreach material, to include electronic promotions, banners, web content, social media, etc., indicating veterans should ask to speak with a DVOP specialist or other JVSG-funded staff person?",null,null,"N/A"]
[0,0]
["Indicator 4: When issuing statements, press releases, requests for proposals, bid solicitations and other documents describing projects or programs funded in whole or in part with federal money, does the grant recipient (and its subrecipients) clearly state the following? (P.L. 115-141, Division H, Title V, Section 505)"]
["Auditor Guidance: Review documents describing projects or programs funded in whole or in part with Federal money, promotional and/or outreach material, to include electronic promotions, banners, web content, social media, etc., utilized at the state or local level."]
["Indicator 4","Yes","No","NA","Comments"]
["a.  The percentage of the total costs of the program or project which will be financed with federal money.",null,null,"N/A"]
["b.  The dollar amount of federal funds for the project or program.",null,null,"N/A"]
["c.  The percentage and dollar amount of the total costs of the project or program that will be financed by non-governmental sources.",null,null,"N/A"]
[0,0]
["Indicator 5: A review of any applicable performance plans, individual performance standards, individual goals, or other measures used to evaluate the actual performance and/or productivity of DVOP specialists and/or LVER staff indicate that such plans, standards, or other measures are not in contravention to any of the statutorily defined responsibilities of the DVOP specialist and/or LVER staff. (38 USC 4102A(b)(7))"]
["Auditor Guidance: Review performance plans, individual performance standards, individual goals, or other measures used to evaluate the DVOP specialist and/or LVER staff. No such plans, standards, or other measures should be used to evaluate any duties, functions, or responsibilities that appear to be outside of the scope of the of the DVOP specialist and/or LVER staff. Further, any such plans, standards, or other measures used should facilitate and not be counterproductive to the SWA’s attainment of any Negotiated Targets for Services to Veterans."]
["Indicator 5","Yes","No","NA","Comments"]
["a. Does the SWA have any performance plans, individual performance standards, individual goals, or other measures used to evaluate the actual performance and/or productivity of DVOP specialist and/or LVER staff?  \nIf no, please explain how performance is assessed in the Comments section.  \n\n",null,null,"N/A"]
["b. Are such plans, standards, or other measures in contravention to any of the statutorily defined responsibilities of the DVOP specialist and/or LVER staff?  ",null,null,"N/A"]
["c. If applicable, are such plans, standards, or other measures counterproductive to the SWA’s attainment of any Negotiated Targets for Services to Veterans?",null,null,"N/A"]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,"N/A"]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A","N/A","N/A"]
[0,null,null,null,"You can only enter an \"X\" in the Yes block, or the No block.  You cannot enter an \"X\" in both the Yes and No blocks."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DVOP-LVER-CP Common Roles and Responsibilities",null,"Yes"]
[]
[null,"Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"B16\",\"C22\",\"B30\",\"B43\"}), \"x\"))","v":0}]
[null,"Areas of Concern",{"$f":"SUM(COUNTIF(INDIRECT({\"C11:C15\",\"C21\",\"C23:C25\",\"B44\",\"C35:C37\"}), \"x\"))","v":0}]
[null,"Promising Practices",{"$f":"IF(B47=\"x\",\"Yes\",IF(C47=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]

{"sheet":"Sheet5","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet4","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DVOP-CP R&R Audit","index":9,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[17,1,19,4],[24,0,24,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,1,7,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["DVOP Specialist and Consolidated Positions Roles and\nResponsibilities Audit Checklist"]
[0]
["EXPECTATION: Proper Roles and Responsibilities for DVOP Specialist and Consolidated Positions: SWA organization has developed a strategic approach to ensure that Disabled Veterans' Outreach Program Specialists are only performing duties related to meeting the employment needs of eligible veterans as described in 38 U.S.C. §4103A(1), 4102A(h), and current VPLs.",0]
["References required for this step:\nApproved JVSG State Plan with approved Modifications\nApproved State Plan\nApproved State Position Descriptions for all JVSG-funded positions\nState- and local-level policies governing the DVOP program\n38 U.S.C. §§ 4103A(1) and 4102A(h)\nWorkforce Innovation and Opportunity Act (WIOA), Public Law 113-128\nMost recent State Performance Outcome Report\nLocal Customer Flow Process\nPromotional and/or outreach material, to include electronic promotions, web content, social media, banners, etc., utilized at the State or local level\nDOL VPL 03-14 w/ changes (or the most current guidance on this subject)\nAccess to the State's MIS                                                                                                                                          \nVPL 01-20\nTPAR \n"]
[0]
["Indicator 1: Interviews with AJC staff indicate there are processes in place to ensure that only appropriate veterans are referred to the DVOP specialists. \n(VPL 03-14 with changes and Title 38, § 4103A) "]
["Auditor Guidance: Select appropriate audit protocol(s) to determine the customer flow process."]
["Indicator 1","Yes","No","NA","Comments"]
["a. Is there a question or option to ask to see a DVOP specialist or other JVSG grant-funded staff? ",null,null,"N/A"]
["b. Is there an initial assessment/screening done prior to referring a veteran to a DVOP specialist?",null,null,"N/A"]
["c. Is there any indication that customers are referred directly to the DVOP specialist upon entry into the AJC? (attained through interviews, observation, and/or testing)",null,null,"N/A"]
["d. Explain the intake process in the Comments section.  If there is an intake form, please include with the Audit results.","N/A","N/A","N/A"]
["e. How are veterans identified?  Please explain in the Comments section. ","N/A","N/A","N/A"]
["f. Determine how veterans are referred to DVOP specialists.  Please explain in the Comments section. ","N/A","N/A","N/A"]
["g. Is the intake process consistent with state and local WIOA and JVSG State Plans? ",null,null,"N/A"]
["h. Are AJC staff familiar with this process?",null,null,"N/A"]
[0,0]
["Indicator 2: The review should indicate that the DVOP specialist's outreach efforts, if necessary, are effective in locating veterans seeking employment who have significant barriers to employment."]
["Auditor Guidance: Select appropriate audit protocol(s) to determine if and when the DVOP specialist performs outreach and the effectiveness of the outreach efforts."]
["Indicator 2","Yes","No","NA","Comments"]
["a. Does the DVOP specialist perform outreach activity?  If no, please explain the reason(s) outreach is not conducted in the Comments section.",null,null,0]
["b. Does the outreach activity detract from the primary duty of providing Individualized Career Services?  Please explain in the Comments section.",null,null,0]
["c. Are outreach strategies used by DVOP specialist staff effective in reaching an appropriate target audience, i.e., candidates who are most in need and can benefit from their services? ",null,null,0]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,0]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A",0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DVOP-CP R&R Audit",null,"Yes"]
[null,"Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"B10\",\"B12\",\"C11\"}), \"x\"))","v":0}]
[null,"Areas of Concern",{"$f":"SUM(COUNTIF(INDIRECT({\"C16\",\"C17\",\"B23\",\"C24\"}), \"x\"))","v":0}]
[null,"Promising Practices",{"$f":"IF(B27=\"x\",\"Yes\",IF(C27=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]

{"sheet":"LVER-CP R&R Audit","index":10,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[15,1,17,4],[24,0,24,4],[0,0,0,4],[1,0,1,4],[2,1,5,4],[8,0,9,4],[10,1,11,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["LVER Roles and Responsibilities Audit Checklist"]
[0,0]
["EXPECTATION: Proper Roles and Responsibilities for LVER and Consolidated Positions:  SWA has developed a strategic approach to ensure that Local Veterans' Employment Representatives are only performing duties as described in 38 U.S.C. §4104(b), 4102A(h), and current VPLs."]
["References required for this step:\nApproved JVSG State Plan with approved Modifications                                                                                   \nApproved WIOA State Plan\nApproved State Position Descriptions for all JVSG-funded positions\nState- and local-level policies governing the LVER program\n38 U.S.C. §§ 4104 and 4102A(h)\nWorkforce Innovation and Opportunity Act (WIOA), Public Law 113-128\nMost recent State Performance Outcome Report\nLocal Customer Flow Process\nPromotional and/or outreach material, to include electronic promotions, web content, social media, banners, etc., utilized at the State or local level\nDOL VPL 03-14 w/ changes (or the most current guidance on this subject)\nAccess to the State's MIS                                                                                                                                                                     \nVPL 01-20"]
[0]
["LVER Staff","Yes","No ","NA","Comments"]
["Does the state have any staff that conduct LVER duties, including Consolidated Positions? \nIf yes, please select the appropriate protocols to complete this tab.\nIf no, proceed to the next tab.",null,null,"N/A"]
[0]
[]
["Indicator 1: Does the LVER advocate for all veterans served by the AJC with business, industry, and other community-based organizations by participating in appropriate activities. (Title 38, §4104(b) and VPL 03-14 with changes or current guidance)",0]
["Auditor Guidance: Select appropriate audit protocol(s) to determine how the LVER is integrated within the AJC or specifically the Business Service Team (BST).   "]
["Indicator 1","Yes","No","NA","Comments"]
["a. Is the LVER integrated with the Business Service Team or equivalent?  Please explain in the Comments section how the LVER is integrated.",null,null,"N/A"]
["b. Does the LVER advocate for all veterans served by the AJC with business, industry, and other community-based organizations by participating in appropriate activities?",null,null,"N/A"]
[0,0]
["Indicator 2: Does the LVER facilitate the provision of employment, training, and placement services furnished to veterans in the AJC?  \n(Title 38, § 4104(b)(2) and VPL 03-14 or most current VPL)"]
["Auditor Guidance: Review quarterly Manager’s Report on Services to Veterans for the last four (4) completed calendar quarters, and interview AJC staff, including the LVER."]
["Indicator 2","Yes","No","NA","Comments"]
["a. Does the LVER build the capacity of AJC staff to more effectively serve veteran customers?  Please explain in the Comments section.",null,null,"N/A"]
["b. Does the LVER provide information on veterans’ employment, training, and placement services to AJC staff in order to facilitate the provision of employment, training, and placement services furnished to veterans in the AJC?  ",null,null,"N/A"]
["c. Does the LVER provide updates to AJC staff on initiatives such as tax incentives, apprenticeship programs, OJTs, etc.?  ",null,null,"N/A"]
["d. Does the LVER participate in AJC staff meetings or cross-training opportunities?",null,null,"N/A"]
["e. Are Elements 2a, 2b, 2c, and 2d all \"no\"?",{"$f":"IF(COUNTIF(C20:C23,\"x\")=4,\"x\",\"\")","v":""},{"$f":"IF(COUNTIF(B20:B23,\"x\")>0,\"x\",\"\")","v":""},"N/A"]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,"N/A"]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overall Audit Results"]
[null,{"$f":"IF(B8=\"x\",\"Yes\",IF(C8=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]
["Proper Roles and Responsibilities for LVER"]
["Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"c15\",\"c14\",\"b24\"}),\"x\"))","v":0}]
["Areas of Concern",{"$f":"IF($B$24=\"x\",0,COUNTIF(INDIRECT({\"c20:c23\"}),\"x\"))","v":0}]
["Promising Practices",{"$f":"IF(B27=\"x\",\"Yes\",IF(C27=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]
[" "]

{"sheet":"Manager's Report","index":11,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[10,1,11,4],[16,0,16,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,1,5,4],[8,0,9,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["Manager's Report Audit Checklist"]
[0]
["EXPECTATION: A review of quarterly Manager’s Report on Services to Veterans indicates the data reported is complete and accurate. \n(38 U.S.C. §4104(f), VPL 07-19, or current VPL)",0]
["References required for this step:\nVPL 07-19\nVPL 03-14 or current VPL  \nTitle 38 4104f"]
[0]
["LVER Staff","Yes","No ","NA","Comments"]
["Per VPL 07-19, only AJCs with assigned LVERs are required to submit a Manager's Report. Does the state have any staff that conduct LVER duties, including Consolidated Positions? \nIf yes, please select the appropriate protocols to complete this tab.\nIf no, proceed to the next tab.",null,null,"N/A"]
[0]
[]
["Indicator 1: A review of quarterly Manager’s Report on Services to Veterans indicates the report contains all elements as outlined in VPL 07-19 or current VPL.\n(Title 38, §4104f, VPL 07-19, VPL 03-14, or current VPL)",0]
["Auditor Guidance: Review quarterly Manager’s Report on Services to Veterans for the previous four (4) completed calendar quarters.  Interview the manager of the employment service delivery system and appropriate supervisory staff for clarification of any information contained in report. "]
["Indicator 1","Yes","No","NA","Comments"]
["a. Are the Manager's Reports being submitted for each AJC with assigned LVERs/CP positions?  ",null,null,"N/A"]
["b. Are the Manager's Reports submitted timely?  ",null,null,"N/A"]
["c. Do the Manager's Reports contain data required by current guidance? ",null,null,"N/A"]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,"N/A"]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Manager's Report",{"$f":"IF($B$8=\"x\",\"Yes\",IF($C$8=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]
["Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"c14:c16\"}),\"x\"))","v":0}]
["Promising Practices",{"$f":"IF(B19=\"x\",\"Yes\",IF(C19=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]
[]
[" "]

{"sheet":"Half-Time R&R Audit","index":12,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[[18,1,19,4],[23,0,23,4],[24,1,25,4],[28,0,28,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,1,5,4],[8,0,9,4],[10,1,11,4],[17,0,17,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["Half-Time Roles and Responsibilities Audit Checklist"]
[0]
["EXPECTATION: Proper Roles and Responsibilities for Half-Time JVSG-funded staff: SWA has developed a strategic approach to ensuring that Half-Time Disabled Veterans' Outreach Program specialists and Local Veterans’ Employment Representatives are only performing duties related to meeting the employment needs of eligible veterans as described in 38 U.S.C. §4103A(1) and §4104 (b).",0]
["References required for this step:\nWork schedules for all Half-Time DVOP Specialists and/or LVERS\nTimesheets or other evidence of effort reporting to verify hours charged to the JVSG grant\nAll references required for DVOP R&R and LVER R&R Audit sheets"]
[0]
["Half Time Staff","Yes","No","NA","Comments"]
["Does the state have Half-Time JVSG-funded staff assigned?\nIf yes, select the appropriate protocols to complete this tab.\nIf no, please proceed to the next tab. ",null,null,"N/A"]
[0]
[]
["Indicator 1: Determine if Half-Time JVSG-funded staff are scheduled appropriately. \n(38 U.S.C.  §§4103A(c), 4104(d), Special Grant Provisions, and VPL 07-10, or most current VPL)",0]
["Auditor Guidance: Select appropriate audit protocol(s) to determine work schedules and how Half-Time staff are scheduled to ensure that 50% of their time is devoted to performing statutory functions of their respective roles."]
["Indicator 1","Yes","No","NA","Comments"]
["a. How is a Half-Time JVSG-funded staff scheduled?  Please explain in the Comments section.","N/A","N/A","N/A"]
["b. Does the schedule reflect that Half-Time JVSG-funded staff devote at least 50% of their time performing statutorily required functions of their respective roles?",null,null,"N/A"]
["c. Do interviews with the Half-time staff indicate they spend at least 50% of their time fulfilling the appropriate role?",null,null,"N/A"]
["d. Determine how Half-Time JVSG-funded staff ensure that at least 50% of their time is devoted to performing statutorily required functions of their respective roles.  Please explain in the Comments section.","N/A","N/A","N/A"]
[0]
["Indicator 2: A review of time charge records for each Half-Time JVSG-funded staff indicates the time charged to JVSG is equal to at least 50%. \n(38 U.S.C. §§4103A(c), 4104(d), VPL 07-10, or most current VPL.)",0]
["Auditor Guidance: Review time charge records to determine if time charged to JVSG is equal to at least 50% and reflects proper utilization of the Half-Time JVSG-funded staff."]
["Indicator 2","Yes","No","NA","Comments"]
["a. Does a review of the time charge records indicate that the Half-Time JVSG-funded staff spend at least 50% of their time performing statutory functions of their respective role?",null,null,"N/A"]
["b. Are Half-Time staff separately identified and is their time charged to the appropriate project and activity code?",null,null,"N/A"]
[0]
["Indicator 3: Review the appropriate tabs in this workbook to ensure adherence to the statutorily required role of the specific Half-Time JVSG-funded staff.",0]
["Auditor Guidance: Review and complete all other tabs as appropriate."]
["Indicator 3","Yes","No","NA","Comments"]
["Does a review of the appropriate tabs illustrate adherence to the statutorily required role of the specific Half-Time JVSG-funded staff?",null,null,"N/A"]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,"N/A"]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overall Audit Results"]
[]
["Proper Roles and Responsibilities for Half-Time Staff",{"$f":"IF($B$8=\"x\",\"Yes\",IF($C$8=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]
["Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"c15:c16\",\"c22:c23\",\"c28\"}),\"x\"))","v":0}]
["Promising Practices",{"$f":"IF(B31=\"x\",\"Yes\",IF(C31=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]

{"sheet":"Svc to Nonveterans Audit","index":13,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[[25,0,25,4],[8,2,8,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,1,7,4],[14,1,15,4],[19,0,19,4],[20,1,21,4]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["Services to Nonveterans Audit Checklist"]
[0]
["EXPECTATION: SWA has developed a strategic approach to ensure that JVSG-funded staff are only providing services to eligible veterans, eligible persons, and authorized special populations. ",0]
["References required for this step:\nTitle 38, §4103A\nTitle 38, §4104\nVPL 03-19\nMost recent State Performance Outcome Report\nInternal schedules indicating common area work assignments to AJC staff\nState- and local-level policies governing the JVSG program\nTPAR"]
[0]
["Indicator 1: Review service to nonveterans on the quarterly TPAR to indicate if there are services to nonveterans being provided.  \n(Title 38, §§ 4103A and 4104)"]
["Auditor Guidance: Review service to nonveterans on the quarterly TPAR to indicate if there are services to nonveterans being provided. "]
["From the most recently submitted quarterly TPAR, enter the Services to Nonveterans Rate found in the Performance Analysis Section. ---->",null,0]
["Indicator 1","Yes","No","NA","Comments"]
["Does the rate indicate that there are services to nonveterans being provided by the DVOP?  Please explain in the Comments section.","N/A","N/A","N/A"]
["Is the percentage listed in block B9 equal to or less than 3%?",{"$f":"IF(B9=\"\",\"\",IF(B9<=0.03,\"x\",\"\"))","v":""},null,"N/A"]
["Is the percentage listed in block B9 greater than 3% but less than 10%?",{"$f":"IF(B9=\"\",\"\",IF(AND(B9>0.03,B9<0.1),\"x!\",\"\"))","v":""},null,0]
["Is the percentage listed in block B9 10% or greater?",{"$f":"IF(B9=\"\",\"\",IF(AND(B9>=0.1),\"x*\",\"\"))","v":""},null,"N/A"]
[0,0]
["Auditor Guidance: Review the information received from the state on mapping service to eligible TSMs and spouses to the PIRL to be counted as an eligible veteran."]
["PIRL","Yes","No","NA","Comments"]
["Does the state currently map eligible TSMs to the eligible veteran category within the PIRL?",null,null,"N/A"]
["Does the state currently map eligible spouses to the eligible veteran category within the PIRL?",null,null,"N/A"]
[0]
["Indicator 2: Through observation and interviewing of AJC staff, ensure that JVSG-funded staff are not scheduled to work in common areas of the AJC. (Title 38, §§ 4103A and 4104)",0]
["Auditor Guidance: Select appropriate audit protocol(s) to determine DVOP specialist and LVER staff activities within the AJC. "]
["Indicator 2","Yes","No","NA","Comments"]
["a. Through observation and interviews, are the DVOP specialists and/or LVER staff  scheduled to work on the reception desk or in other common areas of the AJC where they would be subject to providing services to nonveteran customers?",null,null,"N/A"]
["b. If available, review logs or schedules for AJC common area duty assignments, specifically at the point of entry/reception desk, in the resource room, or conducting orientations. Do the schedules show that JVSG-funded staff are scheduled to perform duties outside of the scope of their roles and responsibilities?",null,null,"N/A"]
[0]
["Promising Practices","Yes","No","NA","Comments"]
["Promising Practices: Identify an innovative office or staff process, recognized by the SWA or observed by the auditor, that facilitates positive outcomes for the veteran population served at the AJC.",null,null,"N/A"]
["Auditor Guidance: Provide comments on observed promising practice(s).","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overall Audit Results"]
[]
["Services to Nonveterans","Yes"]
["Findings",{"$f":"SUM(COUNTIF(INDIRECT({\"b14\",\"B24\",\"b25\"}),\"*x*\"))","v":0}]
["Areas of Concern",{"$f":"SUM(COUNTIF(INDIRECT({\"b13\",\"c18\",\"c19\"}),\"*x*\"))","v":0}]
["Compliant",{"$f":"SUM(COUNTIF(INDIRECT({\"b28\"}),\"*x*\"))","v":0}]
["Promising Practices",{"$f":"IF(B28=\"x\",\"Yes\",IF(C28=\"x\",\"No\",\"Selection Required\"))","v":"Selection Required"}]

{"sheet":"FY22-24_Participant File Review","index":14,"n_rows":1013,"n_cols":35,"rows_kept":1013,"cut":false,"hidden":false,"merged":[[0,0,0,13],[8,0,8,2],[4,7,8,7],[1,0,1,13],[2,0,3,13],[5,9,5,10],[4,9,4,10],[4,11,4,12],[5,11,5,12],[5,0,7,2],[4,13,8,13]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["FY 2022-2024 Participant File Review (Review of Historical Files during Preparatory Phase)"]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E5","F5","G5","I5","J5","K5","L5","M5","Totals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E9","v":{"$error":"#DIV/0!"}},{"$f":"F9","v":{"$error":"#DIV/0!"}},{"$f":"G9","v":{"$error":"#DIV/0!"}},{"$f":"I9","v":{"$error":"#DIV/0!"}},{"$f":"J9","v":{"$error":"#DIV/0!"}},{"$f":"K9","v":{"$error":"#DIV/0!"}},{"$f":"L9","v":{"$error":"#DIV/0!"}},{"$f":"M9","v":{"$error":"#DIV/0!"}}]
["Expectation:  \n\nProper Roles and Responsibilities for DVOP Specialist and Consolidated Positions (CP):  \nCase management continues to be an appropriate service delivery strategy or framework to ensure the deliberate delivery of Individualized Career Services, and other appropriate services, designed to assist the veteran in overcoming barriers and gaining employment.  Services should be delivered following the case management framework as taught by the National Veterans’ Training Institute (NVTI) in the delivery of Individualized Career Services.  Participant files should include a comprehensive assessment, documented plans of action, and consistent contact with the participant in support of the employment goal.  \nEligibility in accordance with statute, regulation, and current VETS policies must be determined prior to the provision of JVSG services.  DVOP specialists will provide services only to eligible veterans and eligible persons who meet the definition of an individual with a Significant Barrier to Employment (SBE) as defined in VPL 03-14, as amended, or the most current VPL/guidance on the subject, and to any other categories of veterans and eligible persons set forth in VPL 03-19 and/or current VPLs/guidance on these or related subjects or as otherwise required by federal law.\n\n",null,"References required for this step:\n\nApproved State Plan\nState- and local-level policies governing the DVOP program\n38 U.S.C. §§ 4103A(1) and 4102A(h)\nVPL 03-14 w/ changes (or the most current guidance on this subject)\nParticipant Files (may require access to the State's MIS)\nVPL 03-19\nVPL 01-20\nVPL 02-21\nTEGL 19-16                                                                                                                                                                                                                                                                                                                                                                        \nJVSG Special Grant Provisions F(1)\nTEGL 23-19",null,"Indicator 1:\n\nIs the SBE or special population for DVOP/CP eligibility documented? \n\nCriteria for compliance: \n90.0% and above = Acceptable\n80% – 89.9% = Area of Concern  \nAnything below 80% = Finding\n\nThe required standard for column E is 90%.  \nAn outcome below 80% in column E would result in a Finding.","Indicator 2:\n\nAre the services documented in the MIS consistent with the services documented in the case file? \n\nNote: Case files may be separate from or part of MIS.\n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a Finding.","Indicator 3:\n\nDo the case files include the following elements: \n \n1. A comprehensive assessment to determine realistic employment goals and barriers to achieving those goals; \n2. A documented plan of actions and services designed to overcome the barriers; and \n3. Consistent contact, which is defined as the documented interaction between the DVOP/CP and eligible veteran, including contacts, meetings, updates, and any post-employment contact following completion of the written plan.  Consistent contact also includes documented attempted contact.  \n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a Finding.","If auditor selects Yes for Indicator 3, the auditor \nwill complete columns I through M.","Indicator 4: \n\nIs there a documented comprehensive assessment that identifies barriers to employment?\n\n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a Finding.","Indicator 5:\n\nIs there a documented employment plan which identifies employment barrier(s) and the steps to overcome the barrier(s) and achieve the employment goal?\n\nThe required standard for columns J and K is 85%.  \nAn outcome below 70% in these columns would result in a Finding.",null,"Indicator 6:\n\nAre the services appropriate and was consistent contact provided?\n\n\nThe required standard for columns L and M is 85%.  \nAn outcome below 70% in these columns would result in a Finding.",null,0,null,null,null,null,null,null,null,null,null,null,null,"Finding",{"$f":"COUNTIF(AA4,\"<=.799\")","v":0},{"$f":"COUNTIF(AB4,\"<=.699\")","v":0},{"$f":"COUNTIF(AC4,\"<=.699\")","v":0},0,0,0,0,0,{"$f":"SUM(AA5:AH5)","v":0}]
["Auditor Guidance for this tab:  \n\nUsing the Individualized Career Services (ICS) Matrix,\nrandomly select the minimally required participant files and\nprovide responses for each indicator, in accordance with the\nauditor guidance provided for each indicator. ",null,null,null,"Auditor Guidance: \n\nUsing the Individualized Career Services (ICS) Matrix, randomly select the minimally required participant files and list those participants on this spreadsheet in column A.  Enter the name of the DVOP who provided services to that participant and the DVOP's location in column C.  For column E, review the files to determine if the participant was eligible for DVOP services in accordance with VETS' most recent guidance.  ","Auditor Guidance:  \n\nCompare participant case notes (electronic or hard copy) with the services entered in the MIS to determine if:\n- dates of services recorded correlate to the case notes, AND\n- the types of service recorded correlate to the case notes (e.g., assessment, resume assistance, referrals, etc.).","Auditor Guidance: \n\nReview participant files to determine if all three elements of case management were documented in the participant file.\n\nNote: Consistent contact was added as the third element of case management.",null,"Auditor Guidance:  \n\nReview participant files to determine if they identify  barriers to employment (e.g. disability, education/training, transportation, child care, etc.).  \n\nNote: SBEs may or may not be an employment barrier. \n","Auditor Guidance: \n\nReview participant files to determine if the plan identifies employment barrier(s) and the steps to overcome the barrier(s) and achieve the employment goal.",null,"Auditor Guidance: \n\nReview participant files to determine if documented services are appropriate to overcoming an employment barrier(s) and consistent contact was provided.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of concern",{"$f":"COUNTIFS(AA4,\">=.80\", AA4, \"<=.899\")","v":0},{"$f":"COUNTIFS(AB4,\">=.70\", AB4,\"<=.849\")","v":0},{"$f":"COUNTIFS(AC4,\">=.70\", AC4,\"<=.849\")","v":0},0,0,0,0,0,{"$f":"SUM(AA6:AH6)","v":0}]
[null,null,null,null,"Is the SBE or special population for DVOP/CP eligibility identified?","Are the services in the case file / case note (hard copy or electronic) consistent with the coded entries for services in the MIS?","Is the Participant being case managed?  Did the DVOP provide:\n1. a documented comprehensive assessment (skills, education, job history, desired career),  \n2. a documented plan of action (such as an IEP), AND\n3. consistent contact?",null,"Does the assessment accurately identify all specific, applicable barriers to employment?","Does the plan address the actions and services designed to overcome the barriers and achieve the employment goals identified?","Considering the barriers identified, is the career goal(s) appropriate?","Are the services documented in the case file appropriate in assisting the veteran to overcome the barrier(s) to employment?","Was adequate consistent contact provided and documented?  ",null,null,null,null,null,null,null,null,null,null,null,null,"Compliant",{"$f":"COUNTIF(AA4,\">=.90\")","v":0},{"$f":"COUNTIFS(AB5,\">=.70\", AB5,\"<=.849\")","v":0},{"$f":"COUNTIF(AC4,\">=.85\")","v":0},0,0,{"$f":"COUNTIF(AF4,\">=.85\")","v":0},0,0,{"$f":"SUM(AA7+AB7+AC7+AD7+AE7+AF7+AG7+AH7)","v":0}]
[null,null,null,null,"Criteria for compliance: \n90.0% and above = Acceptable\n80% – 89.9% = Area of Concern  \nAnything below 80% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding",null,"Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding"]
["Summary of Compliance as a Percentage",null,null,null,{"$f":"COUNTIF(E11:E1008,\"Yes\")/COUNTA(E11:E1008)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F11:F1008,\"Yes\")/COUNTA(F11:F1008)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G11:G1008,\"Yes\")/(COUNTA(G11:G1008)-COUNTIF(G11:G1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTIF(I11:I1008,\"Yes\")/(COUNTA(I11:I1008)-COUNTIF(I11:I1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J11:J1008,\"Yes\")/(COUNTA(J11:J1008)-COUNTIF(J11:J1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Participant First and Last Name","Column1","DVOP/CP and Location","Column2","Indicator 1","Indicator 2","Indicator 3","Column3","Indicator 4","Indicator 5a","Indicator 5b","Indicator 6a","Indicator 6b","Additional Comments"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A10:A503)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(#REF!=\"No\",\"N/A\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(E1012=\"No\",\"N/A\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(#REF!=\"No\",\"N/A\",\"\")","v":{"$error":"#REF!"}},{"$f":"COUNTIF(G11:G1008, \"N/A\")","v":0},null,{"$f":"COUNTIF(I11:I1008, \"N/A\")","v":0},0,0,0,0]

{"sheet":"On-Site Review","index":15,"n_rows":1012,"n_cols":35,"rows_kept":1012,"cut":false,"hidden":false,"merged":[[0,0,0,13],[4,7,8,7],[1,0,1,13],[2,0,3,13],[4,9,4,10],[4,11,4,12],[5,9,5,10],[5,11,5,12],[8,0,8,2],[4,13,8,13],[5,0,7,2]]}
["Accessibility key: Values followed by an exclamation point indicate an area of concern. Values followed by an asterisk indicate a finding."]
["FY 2022-2024 Participant File Review (On-site during Audit Phase)"]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E5","F5","G5","I5","J5","K5","L5","M5","Totals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E9","v":{"$error":"#DIV/0!"}},{"$f":"F9","v":{"$error":"#DIV/0!"}},{"$f":"G9","v":{"$error":"#DIV/0!"}},{"$f":"I9","v":{"$error":"#DIV/0!"}},{"$f":"J9","v":{"$error":"#DIV/0!"}},{"$f":"K9","v":{"$error":"#DIV/0!"}},{"$f":"L9","v":{"$error":"#DIV/0!"}},{"$f":"M9","v":{"$error":"#DIV/0!"}}]
["Expectation:\n\nProper Roles and Responsibilities for DVOP Specialist and Consolidated Positions (CP):  \nCase management continues to be an appropriate service delivery strategy or framework to ensure the deliberate delivery of Individualized Career Services, and other appropriate services, designed to assist the veteran in overcoming barriers and gaining employment.  Services should be delivered following the case management framework as taught by the National Veterans’ Training Institute (NVTI) in the delivery of Individualized Career Services.  Participant files should include a comprehensive assessment, documented plans of action, and consistent contact with the participant in support of the employment goal.  \nEligibility in accordance with statute, regulation, and current VETS policies must be determined prior to the provision of JVSG services.  DVOP specialists will provide services only to eligible veterans and eligible persons who meet the definition of an individual with a Significant Barrier to Employment (SBE) as defined in VPL 03-14, as amended, or the most current VPL/guidance on the subject, and to any other categories of veterans and eligible persons set forth in VPL 03-19 and/or current VPLs/guidance on these or related subjects or as otherwise required by federal law.",null,"References required for this step:\n\nApproved State Plan\nState- and local-level policies governing the DVOP program\n38 U.S.C. §§ 4103A(1) and 4102A(h)\nVPL 03-14 w/ changes (or the most current guidance on this subject)\nParticipant Files (may require access to the State's MIS)\nVPL 03-19\nVPL 01-20\nTEGL 19-16 \nJVSG Special Grant Provisions F(1)\nTEGL 23-19                                                                                                                                                                                                                                                                                                                                                                       ",null,"Indicator 1:\n\nIs the SBE or special population for DVOP/CP eligibility documented? \n\nCriteria for compliance: \n90.0% and above = Acceptable\n80% – 89.9% = Area of Concern  \nAnything below 80% = Finding\n\nThe required standard for column E is 90%.  \nAn outcome below 80% in column E would result in a CAP.","Indicator 2:\n\nAre the services documented in the MIS consistent with the services documented in the case file? \n\nNote: Case files may be separate from or part of MIS.\n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a CAP.","Indicator 3:\n\nDo the case files include the following elements: \n \n1. A comprehensive assessment to determine realistic employment goals and barriers to achieving those goals; \n2. A documented plan of actions and services designed to overcome the barriers; and \n3. Consistent contact, which is defined as the documented interaction between the DVOP/CP and eligible veteran, including contacts, meetings, updates, and any post-employment contact following completion of the written plan.  Consistent contact also includes documented attempted contact.  \n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a CAP.","If auditor selects Yes for Indicator 3, the auditor \nwill complete columns I through M.","Indicator 4:\n\nIs there a documented comprehensive assessment that identifies barriers to employment?\n\n\nThe required standard for this column 85%.  \nAn outcome below 70% in this column would result in a CAP.","Indicator 5:\n\nIs there a documented employment plan which identifies employment barrier(s) and the steps to overcome the barrier(s) and achieve the employment goal?\n\nThe required standard for columns J and K 85%.  \nAn outcome below 70% in these columns would result in a CAP.",null,"Indicator 6:\n\nAre the services appropriate and was consistent contact provided?\n\n\nThe required standard for columns L and M is 85%.  \nAn outcome below 70% in these columns would result in a CAP.",null,0,null,null,null,null,null,null,null,null,null,null,null,"Finding",{"$f":"COUNTIF(AA4,\"<=.799\")","v":0},{"$f":"COUNTIF(AB4,\"<=.699\")","v":0},{"$f":"COUNTIF(AC4,\"<=.699\")","v":0},0,0,0,0,0,{"$f":"SUM(AA5:AH5)","v":0}]
["Auditor Guidance for this tab: \n\nReview active participant files during the Audit Phase and\ncomplete each indicator per the provided guidance.\n\nNote: Auditors will review 20% (minimum required: 2; maximum\nsuggested: 6) of active participant files for each DVOP\nassigned to the AJC visited. If there are not enough active\nparticipant files to meet the minimum requirement, the auditor\nmay conduct a review of participant files recently closed within\nthe past 30 days. \n\nAuditors may review active participant files prior to the on-site\nvisit, but within 30 days of the visit, as part of the on-site\nparticipant file review. \n\nNote: Since the participant files reviewed during this time may\nstill be active or even recently opened, the DVOP specialist may\nnot have had the opportunity to complete all criteria within the\ncolumns of the audit tool tab. Auditors may select “N/A” if\nappropriate and provide a comment for these open cases when\napplicable.",null,null,null,"Auditor Guidance: \n\nReview the files to determine if the participant was eligible for DVOP services in accordance with VETS' most recent guidance. \n\n","Auditor Guidance:  \n\nCompare participant case notes (electronic or hard copy) with the services entered in the MIS to determine if:\n- dates of services recorded correlate to the case notes, AND\n- the types of service recorded correlate to the case notes (e.g., assessment, resume assistance, referrals, etc.).","Auditor Guidance: \n\nReview participant files to determine if all three elements of case management were documented in the participant file. \n\nNote: Consistent contact was added as the third element of case management.",null,"Auditor Guidance:  \n\nReview participant files to determine if they identify employment barriers (e.g. disability, education/training, transportation, child care, etc.).  \n\nNote: SBEs may or may not be an employment barrier. \n","Auditor Guidance: \n\nReview participant files to determine if the plan identifies employment barrier(s) and the steps to overcome the barrier(s) and achieve the employment goal.",null,"Auditor Guidance: \n\nReview participant files to determine if documented services are appropriate to overcoming an employment barrier(s) and consistent contact was provided.  \n",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of concern",{"$f":"COUNTIFS(AA4,\">=.80\", AA4, \"<=.899\")","v":0},{"$f":"COUNTIFS(AB4,\">=.70\", AB4, \"<=.849\")","v":0},{"$f":"COUNTIFS(AC4,\">=.70\", AC4, \"<=.849\")","v":0},0,0,0,0,0,{"$f":"SUM(AA6:AH6)","v":0}]
[null,null,null,null,"Is the SBE or special population for DVOP/CP eligibility identified?","Are the services in the case file / case note (hard copy or electronic) consistent with the coded entries for services in the MIS?","Is the Participant being case managed?  Did the DVOP provide:\n1. a documented comprehensive assessment (skills, education, job history, desired career),  \n2. a documented plan of action (such as an IEP), AND\n3. consistent contact?",null,"Does the assessment accurately identify all specific, applicable barriers to employment?","Does the plan address the actions and services designed to overcome the barriers and achieve the employment goals identified?","Considering the barrier(s) identified, is the career goal(s) appropriate?","Are the services documented in the case file appropriate in assisting the veteran to overcome the barrier(s) to employment?","Was adequate consistent contact provided and documented?  ",null,null,null,null,null,null,null,null,null,null,null,null,"Compliant",{"$f":"COUNTIF(AA4,\">=.90\")","v":0},{"$f":"COUNTIF(AB4,\">=.85\")","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Criteria for compliance: \n90.0% and above = Acceptable\n80% – 89.9% = Area of Concern  \nAnything below 80% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding",null,"Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding","Criteria for compliance: \n85% and above = Acceptable\n70% – 84.9% = Area of Concern  \nAnything below 70% = Finding"]
["Summary of Compliance as a Percentage",null,null,null,{"$f":"COUNTIF(E11:E1007,\"Yes\")/COUNTA(E11:E1007)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(F11:F1007,\"Yes\")/COUNTA(F11:F1007)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(G11:G1008,\"Yes\")/(COUNTA(G11:G1008)-COUNTIF(G11:G1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},null,{"$f":"COUNTIF(I11:I1008,\"Yes\")/(COUNTA(I11:I1008)-COUNTIF(I11:I1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(J11:J1008,\"Yes\")/(COUNTA(J11:J1008)-COUNTIF(J11:J1008,\"N/A\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Participant First and Last Name","Column1","DVOP/CP and Location","Column2","Indicator 1","Indicator 2","Indicator 3","Column3","Indicator 4","Indicator 5a","Indicator 5b","Indicator 6a","Indicator 6b","Additional Comments"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown Info"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A10:A502)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(#REF!=\"No\",\"N/A\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(E1011=\"No\",\"N/A\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(#REF!=\"No\",\"N/A\",\"\")","v":{"$error":"#REF!"}},{"$f":"COUNTIF(G11:G1007,\"N/A\")","v":0},null,{"$f":"COUNTIF(I11:I1007,\"N/A\")","v":0},{"$f":"COUNTIF(J11:J1007,\"N/A\")","v":0},0,{"$f":"COUNTIF(L11:L1007,\"N/A\")","v":0},0]