Office of Child Support Enforcement



Access and Visitation
















Access and Visitation

















Instruction Manual

Document Version: 1.3

(TBD)









Administration for Children and Families Office of Child Support Enforcement 370 L’Enfant Promenade S.W. Washington, DC 20447



DCN:






















































This document was prepared for the United States Department of Health and Human Services, Office of Child Support Enforcement under Contract Number HHS-N26-3999-900033I by Lockheed Martin, Information Systems & Global Solutions, Incorporated (LM IS&GS). The work was authorized in compliance with the following specific prime task order:

Delivery Order Number: HHS-P23-3201-175055W Delivery Order Title: Access and Visitation Document Date: TBD






DM v2.8.6

Office of Child Support Enforcement Instruction Manual

Access and Visitation Document Version: 1.2



TABLE OF CONTENTS

  1. Introduction 1-1

    1. Reporting Requirements 1-1

    2. Online Submittal 1-1

    3. Annual Submission to OCSE 1-1

    4. Purpose1-1

  2. State Details Pages 2-1

    1. Helpful Information 2-1

    2. State Reporting 2-3

  3. Preparing The File for Upload 3-1

    1. File Name 3-1

    2. File Format 3-1

    3. Data Entry 3-2

  4. System Validation 4-1

  5. Uploading The File 5-3

  6. Content Verification .......................................... Error! Bookmark not defined. 6.1 State Summary 6-1

6.2 Sub-Grantee Profile 6-2

  1. Survey Submission 7-1

7.2 Survey Returns 7-3


A. Frequently Asked Questions..................................................................... A-1


B. Checklist: Avoid Processing Errors ......................................................... B-1


List of Figures and Charts

Figure 2-1: State Details Page 1 (Upper) 2-3

Figure 2-3: State Details Page 2 (Upper) 2-7

Figure 2-4: State Details Page 2 (Lower) 2-9

Figure 2-5: State Details Page 2-11

Figure 3-1: State Spreadsheet Page 1 3-3

Figure 3-2: State Spreadsheet Page 2 (Left Side) 3-5

Figure 3-3: State Spreadsheet Page 2 (Right Side) 3-10

Figure 6-2: Sub Grantee Profile 6-3

Figure 7-1: Survey Status 7-1

Figure 7-2: Survey Submission Confirmation 7-2

Chart 2-1: Allowable Characters 2-1

Chart 4-1: Quality Checks 4-1






Shape1 Table of Contents i



  1. INTRODUCTION



    1. Reporting Requirements


According to federal statute 42 US.C. 669b, states are required to monitor, evaluate, and report on programs funded through the Access and Visitation Grant Program on an annual basis – in accordance with regulations prescribed by the Secretary of the Department of Health and Human Services (45 CFR 303.109).



    1. Online Submittal


All reports will be submitted online via the Access and Visitation (AV) portal on the Federal Parent Locator Service (FPLS).



    1. Annual Submission to OCSE


Annual submission of fiscal year reports is due December 30 of each year that the survey is authorized.



    1. Purpose


This instructional manual is a how-to guide for state AV portal users for navigating the portal and fulfilling reporting requirements.



  1. STATE DETAILS PAGES


After logging into the portal, click the State Details’ tab to report general information about the grant program. For information on the data elements contained in this section, please refer to section 2.2.



    1. Helpful Information


The State Details pages automatically pre-populate the most recent submitted content. In other words, text submitted in the previous year will pre-populate on the state details pages the following year. Edit pre-populated text as necessary. If you would like to empty all text boxes, select Clear at the bottom of the page.


To complete the State Details section of the survey, select Save, located on the bottom of each page. It is recommended that you save frequently to avoid losing unsaved work. After all required text boxes are complete and the data on each State Details page is saved, the State Details section status on the Survey Status page will state complete. The Survey Status page will not state complete’ until all required text boxes are complete and all three pages of the section have been saved. You will be able to make changes to the State Details pages after the Survey Statue page states ‘complete’ and before final submission.



Chart 2-1 shows the allowable characters (fields C, D, E, F, G1, G2, H, I, and J):


CHART 2-1: ALLOWABLE CHARACTERS

Name

Character

Period

.

Apostrophe

'

Dollar Sign

$

Question Mark

?

Exclamation Point

!

Open Parenthesis

(

Close Parenthesis

)

Hyphen/Dash

-

Asterisk

*

Right Quotation Mark

Semi Colon

;



CHART 2-1: ALLOWABLE CHARACTERS

Name

Character

Colon

:

Forward Slash

/

Hash

#

Ampersand

&


No other special characters are allowed.



Type content directly into the text boxes. If copied text contains any unallowable characters, none of the copied text will save.


In 15 minute intervals, the portal will display a pop-up that asks if you want to continue working. Enable your system to allow pop-ups so that you receive this notice. If you do not enable pop- ups, you will not receive this notice and will not be able to indicate that you want to continue working, consequently losing all unsaved work.


Save each page as you work. Press Save at the bottom of each page before pressing Next to proceed.



Note: You do not have to complete any section of the portal in a single session. Save information on the State Details page and return to it later. To save data on the State Details pages, use only allowable characters, do not copy text into the portal, and allow pop-ups.


Note: Text boxes have a 4,000 character limit.




    1. State Reporting


On the State Details page, the state reports:





Fiscal Year Award Information


Figure 2-1 shows the upper part of the State Details page that contains Fiscal Year Award Information and Services Funded with AV Grant Money (B).



Figure 2-1: State Details Page 1 (Upper)



Shape6


  1. Federal Grant Amount is a required field.



State Match Amount or Funds From Other Sources, should not include funds received through the federal grant


  1. Services Funded with AV Grant Money





  1. Custody and Visitation Guidelines





Figure 2-2 shows the section of the State Details page that contains Custody and Visitation Guidelines (C), State Child Access Program Description (D), Accomplishment of Program Goals (E), and the Next button.



Figure 2-2: State Details Page 1 (Lower)



Shape7



  1. State Child Access Program Description





  1. Accomplishment of Program Goals




Figure 2-3 shows the upper sections of the State Details (page 2) containing the Summary of State’s Anticipated Program Costs vs. Actual Expenses (F) and Parenting Time Increased Description (G1).



Figure 2-3: State Details Page 2 (Upper)



Shape8


  1. Summary of State’s Anticipated Program Costs vs. Actual Expenses





G1. Parenting Time Increased Description


colon, forwards slash, hash, and ampersand.



Figure 2-4 shows the lower section of the State Details (page 2) containing Increased Knowledge of Effective Co-Parenting Strategies (G2).



Figure 2-4: State Details Page 2 (Lower)



Shape9





G2. Increased Knowledge of Effective Co-Parenting Strategies






Figure 2-5 shows an example of the State Details page (page 3) containing Domestic Violence Safeguards (H), Monitoring (I), and Supplemental Narrative (J).



Figure 2-5: State Details Page



Shape10


  1. Domestic Violence Safeguard




  1. Monitoring


  1. Supplemental Narrative




Note 1: After completing required fields on State Details page 3, click Save. The status of the State Details section on the Survey Status page will state complete’.


Note 2: Make changes to the State Details page any time before survey submission.



  1. PREPARING THE FILE FOR UPLOAD


Access the correct template of the State Excel Spreadsheet by clicking Sample xls on the File Upload page.


For the correct state spreadsheet, download the state spreadsheet from the File Upload page. Click on the Sample button.



    1. File Name

Upload the state AV file (Microsoft Excel .xls or .xlsx file format) via the AV web application. Files name must adhere to these requirements:

fiscal year (for example, MD.AV.FY13.)


Note: Files names that violate any of these naming requirements will not successfully upload.


    1. File Format


When completing the state spreadsheet, adhere to the following formatting requirements:



Important Note: Add an extra row for totals. It is recommended to sum the totals to ensure the data will pass all automated quality checks. Some quality checks require equal sums of specific data elements. For example, the sums of Client Referral Source (S-Y), AND Client Information (Z-AD), AND Race/Ethnicity (AP-AX) AND Annual Income (AY-BD) must be equal. It will be helpful to ensure that these totals are equal BEFORE attempting upload. If these totals are not equal, the file will fail this validation. Refer to Section 4.



* If the MS Excel file violates any of these formatting requirements, the MS Excel file will not process successfully.



    1. Data Entry


Please review the instructions for entering the correct data into the state spreadsheet.



Important Note: Using special characters in specific cells can result in unsuccessful processing. Note the description of allowable characters for each data element.



Figure 3-1 shows the state spreadsheet (page 1) containing Name of Grantee and/or Sub-Grantee (A), Title of AV Program (B), Contact Name (C), Address Line 1 (D), City (E), State (F), Zip (G), Grant Amount (H), Grant Period From Date (I), and Grant Period To Date (J)



Figure 3-1: State Spreadsheet Page 1



Shape20




  1. Name of Grantee and/or Sub-Grantee




  1. Title of the AV Program



  1. Contact Name



  1. Address Line 1




  1. City


  1. State



  1. Zip



Note: If the zip code begins with zeros, the cell format must be text. Right click on the cell and select Format Cells. Select Text and click OK. After the format is changed, manually re-type the zip code value.



  1. Grant Amount



  1. Grant Period From Date



The dates entered for Grant Period From Date and the Grant Period To Date must cover the intended federal fiscal year. Most states report on services provided during the federal fiscal year (e.g., October 1-September 30). If a state has difficulty reporting on services provided during the federal fiscal year and prefers to report services based on the state calendar, contact an OCSE administrator for additional guidance.



Figure 3-2: State Spreadsheet Page 2 (Left Side)




Figure 3-2 shows the State Spreadsheet (page 2) containing Grant Period From Date (I), Grant Period To Date (J), Service Provided (K-Q), Geographic Area Served (R), Client Referral Source (S-Y), Client Information (Z-AE), Child Support Cases (AF-AJ), Marital Status (AK-AO), and Race/Ethnicity (AP-AX).



  1. Grant Period To Date




K-Q. Service Provided



R. Geographic Area Served



S-Y. Client Referral Source




Recording tip:


If multiple individuals are part of the same case/reference identifier, report the multiple referrals. The number of Client Referral Sources should equal the number of clients who received services. The total Client Referral Sources should match the same total for Client Information (Z-D), Annual Income (AX-BC), and Race/Ethnicity (AP-AW).



Z-AE. Client Information




Recording tip:


If multiple individuals are part of the same case/reference identifier, report the multiple client types. The total for Client Information should match the same total for Client Referral Source (S-Y), Annual Income (AX-BC), and Race/Ethnicity (AP-AW).



AF-AJ. Child Support Cases




Recording tip:


If multiple individuals are part of the same case/reference identifier, report each individual involved.



AK-AO. Marital Status




Recording tip:


If multiple individuals are part of the same case/reference identifier, count the marital status of biological parents twice per case. The total parents for whom Marital Status was recorded should equal the total biological parents recorded (


Z-AC).



AP-AX. Race/Ethnicity





Recording tip:


If multiple individuals are part of the same case/reference identifier, enter the various quantities in the Race/Ethnicity fields. The total for Race/Ethnicity should match the same total for Client Referral Source (S-Y), Client Information (Z-D), and Annual Income (AX-BC).



Figure 3-3: State Spreadsheet – Page 2 (Right Side)



Shape33


Figure 3-3 shows an example of the state spreadsheet (page 2) containing Annual Income (AY- BD), Service Provided (BE-BK), Frequency of Service (Hours) (Optional) (BL-BR), Outcome

#1-Parenting Time (Required) (BS-BT), and Outcome #2 Knowledge of Effective Co-Parenting Strategies (Optional) (BU-BX).


AY-BD. Annual Income


$10,000 to $19,999, $20,000 to 29,999, $30,000 to $39.999, $40,000 to $39,999, $40,000 &

above, and Data Not Reported.





Recording tip:


If multiple individuals are part of the same case/reference identifier, report each persons income.



BE-BK. Services Provided




Recording tip:


If multiple individuals are part of the same case/reference identifier, record the services that each person receives. Shared services (i.e., Mediation, Development of Parenting Plan, etc.) should equal the number of individuals receiving those services.



BL-BR. Frequency of Hours



BS-BT. Outcome #1-Parenting Time



These number values are unique to the state’s definition of success and cannot be compared with any other state.



BU-BX. Outcome #2-Knowledge of Effective Co-Parenting Strategies


do not provide information in these fields.



  1. SYSTEM VALIDATION


The portal conducts data validations or quality checks on all uploaded files. Several quality checks affect the successful processing of the state spreadsheet. If the state spreadsheet does not pass one or more quality checks, you will receive an email within 5 minutes of the upload which indicates unsuccessful processing and identifies the rows that contain errors.


Some quality checks require that the sums of specific data elements are equal. The specific data elements that are required to be equal are listed in the chart below. To ensure the sums of the data elements listed below are equal, it is recommended that you include a row for totals on your excel file. If the sums of the specific data elements listed below are not equal, the file will not pass quality checks and subsequently, the file will not be processed successfully.


CHART 4-1: QUALITY CHECKS

Quality Check

Validation

The totals for Client Referral Source (S-Y), AND Client Information (Z-AD), AND Race/Ethnicity (AP-AW) AND Annual Income (AX-BC) must be equal

Record the referral source for each individual client served. If one case number/reference identifier represents two clients (i.e., NCP Father and CP Mother), record the two referral sources.

Service providers should only record clients who receive federally funded AV services. Clients are individuals who directly participate in federally funded AV programs. To determine whether someone is a federally supported AV client, ask, Would I record them as having received a federally funded AV service type? If the answer is Yes, record the client as such. If the answer is “No, service providers should report these services on other systems.

Service providers record the race/ethnicity for every client served.

Service providers record the annual income for every client served.

The totals for biological parents (Z-AC) AND Marital Status (AK-AO) must be equal.

***NOTE: this is the sum of NCP Father, CP Father, NCP Mother, and CP Mother constituting the first four columns in Client Information. Grandparents/Legal Guardian SHOULD NOT be included in this total***

Record the marital status for every biological parent served. DO NOT record the marital status of any Grandparent/Legal Guardian.



CHART 4-1: QUALITY CHECKS

Quality Check

Validation

The totals for Client Information (Z-AD) must be equal to or less than the totals for Services Provided (BD-BJ).

For every client reported, at least one federally funded service type should also be reported.


Not all persons who encounter AV services become clients. Therefore, record only individuals who receive federally funded AV services. Record at least one service provided to the client.


Remember: Custodial parents can be clients, too!



  1. UPLOADING THE FILE


A file upload of the state spreadsheet is required for submission to OCSE. States can upload multiple files. However, the most recent uploaded file overwrites previously uploaded files. After the spreadsheet is successfully processed, the data will pre-populate in the Summary Data and Sub-Grantee Profile sections of the portal.


Figure 5-1 shows the File Upload section containing the state file upload options.



Figure 5-1: File Upload Page



Shape39


To upload the state spreadsheet, click Browse to access the prepared file. Click on the prepared file and select OK. Once the file name displays in the browse bar, click Upload. After clicking Upload, read the text at the top of the page indicating whether the upload was successful. If the upload was not successful, rename the file so that it satisfies the required name format (refer to section 2.1). If the upload was successful, the system generates an e-mail within 5 minutes to indicate whether the file processed successfully. If the e-mail message indicates that the state spreadsheet processed unsuccessfully, make the recommended revisions and call the AV program administrator if you need assistance. If the e-mail message indicates that the state



spreadsheet processed successfully, the next step in the reporting process is validation of the Summary Data and Sub-Grantee Profile Sections.



  1. CONTENT VERIFICATION



    1. State Summary


Once the spreadsheet has successfully uploaded, the data pre-populates the Summary Data page. Click the Summary Data tab to view the data.



Figure 6 -1 shows an example of the Summary Data section.



Figure 6-1: Summary Data



Shape41



If data looks accurate, click Verify (see Figure 6-2). If data is inaccurate, adjust the state spreadsheet and upload attempt an additional file upload.


After verifying the Summary Data page, the Survey Status table now indicates that both the State Details page and the Summary Data page are complete.



Note: You can make changes to the Summary Data page any time before survey submission. To change the Domestic Violence Safeguards section, make changes to field H on the State Details page. To make changes to all other sections on the Summary Data page, upload a new spreadsheet containing the changes.


    1. Sub-Grantee Profile


A state spreadsheet that has successfully processed pre-populates the Sub-Grantee Profile page. Click on the Sub-Grantee Profile tab to view the totaled data pulled from the state spreadsheet.


Be sure to review all sections on the Sub-Grantee Profile page. Figure 6-2 shows an example of the Sub-Grantee Profile section.



Figure 6-2: Sub Grantee Profile



Shape45


After verifying the accuracy of the information in all sections on the Summary Data page, click

Verify .


The Survey Status table now indicates that the State Details, Summary Data, and Sub-Grantee Profile pages are complete.



Note: Make changes to the Sub-Grantee Profile page any time before survey submission. To make changes, upload a new Microsoft Excel file containing the changes. After uploading the new file, verify both the Summary Data and the Sub-Grantee Profile pages.



  1. SURVEY SUBMISSION


Once the State Details, Summary Data, and Sub-Grantee Profile pages are complete, there will be a prompt to submit the survey. When ready, click Submit Survey on the bottom of the Survey Status page.


Figure 7-1 shows the Survey Status page after all survey sections are complete prior to submission.



Figure 7-1: Survey Status



Shape48



Once submitted, a message verifies the submission (see Figure 7-2). Once submitted, the online survey will no longer be accessible. The reporting process is complete.





Figure 7-2: Survey Submission Confirmation



Shape50




7.2 Survey Returns


If your submitted survey contains any errors, you will receive an email notification which indicates the reason the survey was returned. Returned surveys need to be corrected before resubmitting to OCSE.



Note: When a survey is returned, all survey sections revert to Incomplete. In order to resubmit the survey, the State Details pages need to be ‘Saved’ again, AND the Summary Data and Sub-Grantee Profile pages also need to beVerified’ again.




If you make revisions to the State Details section, please be sure that you save all three pages of the section. After all required text boxes are complete and the data on each State Details page is saved, the State Details section status on the Survey Status page will read complete.


If you make revisions to the State Excel Spreadsheet, make sure its content will pass all data checks before uploading the revised file (see Section 4. System Validation). Upload the revised file (see Section 5. Uploading the File) and wait for the email confirmation indicating the status of file processing. The system generates an e-mail within 5 minutes to indicate whether the file processed successfully. If the e-mail message indicates that the state spreadsheet processed successfully, the next step in the reporting process is validation of the Summary Data and Sub- Grantee Profile Sections. Validate the Summary Data and Sub-Grantee Profile Sections by selecting Verify at the bottom of both pages. Once the status of the Summary Data and Sub- Grantee Profile Sections on the Survey Status page state “complete”, you will be prompted to resubmit to OCSE.



  1. FREQUENTLY ASKED QUESTIONS


  1. Q: Can I access the system from my home computer?

A: No. You can only access the new web-based system through the authorized computer and location assigned to your access.



  1. Q: How do I know when the system has processed my uploaded file successfully?

A: After the system has processed your Microsoft Excel spreadsheet, you will receive an e- mail within 5 minutes to let you know if the upload was successful.



  1. Q: What happens if the system does not process my file successfully?

A: You will receive an e-mail message which indicates that the state spreadsheet did not process successfully. Make the recommended revisions and call the AV program administrator if you need assistance.



  1. Q: How do I view previously uploaded files?

A: To view files:

    1. Click File Download.

    2. Select the appropriate fiscal year.

    3. Click Go to view the upload history.



  1. Q: I uploaded several Microsoft Excel spreadsheets. How do I make sure OCSE receives the intended upload?

A: When you complete the online reporting, the system will submit the most recent upload.



  1. Q: How do I complete the summary data and sub-grantee profile sections?

A: To complete the summary data and sub-grantee profile sections:

    1. Upload your Microsoft Excel spreadsheet. (Once the system processes your file successfully, the summary data and sub-grantee profile sections of the survey populate automatically.)

    2. Click Verify. (The table on the Survey Status page shows that the summary data and sub-grantee profile sections are complete.)

Shape54


  1. CHECKLIST: AVOID PROCESSING ERRORS


Get your spreadsheet ready for a successful file processing before upload! Each stated must be satisfied in order to pass all data checks. Use this checklist to prepare your file.


Shape55 Use the correct State Excel Spreadsheet template. Download the most updated version directly from the portal (Refer to Section 3).


Shape56 The sum of biological parents who received Access and Visitation services (rows Z- AC) (NCP and CP mothers and fathers) must EQUAL the sum of the marital status (rows AK-AO).


For example, if 75 of the 100 total clients served were biological parents, the sum of the marital status section should total 75.


Shape57 The sum of Client Information (Z-AD) must be equal to the sum of Client Referral Source (S-Y) which must be equal to the sum of the Race/Ethnicity (AP-AW) entries.


For example, if the sum of all clients served equals 100, the sum of the client referral sources should equal 100, and the sum of race/ethnicity entries should equal 100.


Shape58 Include a totals row on the state spreadsheet to ensure that your file will pass all data checks.


Shape59 Do not change the spreadsheet margins.