The Request CoCasa Extract screen is used to create an extract for your provider organization containing information from the ALERT IIS database that can be used for CoCASA reporting purposes. CoCASA stands for Comprehensive Clinic Assessment Software Application, a tool which is published by the Centers for Disease Control.

The CoCASA output is a tab-delimited text file, suitable for importing into the CoCASA application.

• Functionality

• • Creating the Extract

  • Reporting for Patients associated with your organization

  • Reporting for Patients residing in selected counties

  • Reporting for Patients within your organization or residing in selected counties

• The CoCASA Process

• Extract Layout

• Creating the Extract

1. Enter an assessment date in the format 'MM/DD/CCYY' in the 'Common Review Date' text box, or click on the calendar icon to set the date.

2. You have the option of selecting additional date ranges (or leaving the date range at the default 0 - 36 months).

3. You can set your minimum age (on common review date) by selecting either days, months, or years, and then entering a number in the 'Patient will be at least ___ old on common review date.' field.

4. You can set your maximum age (on common review date) by selecting either days, months, or years, and then entering a number in the 'Patient will be less than ___ old on common review date.' field.

5. Your provider organization name displays next to the Org Name label if your organization is not a county organization.

6. County Provider Organizations will have this additional section explained below for more options when creating the extract.

County Provider Organization Options:

7.  Click on the Save button to submit the assessment date information.

Back to Top

• Reporting for Patients associated with your organization:

• 1. All you have to do is select this option and select any other report criteria you wish to use for the report.

• Reporting for Patients residing in your county:

1. 1. All you have to do is select this option and select any other report criteria you wish to use for the report.

Back to Top

• Reporting for Patients within your organization or residing in your county:

1. 1. All you have to do is select this option and select any other report criteria you wish to use for the report

   Back to Top

1. After selecting the assessment date and other criteria and submitting this information, the system will find all patients in the system that are eligible based upon the common review date and minimum/maximum date range criteria.

2. The system then runs a batch process which will create a self-extracting zip file that will be placed on an FTP server.

3. Go to the check request status screen to view the status of the extract.

4. When the extract is finished the 'Status' column will display "COMPLETE", and the file will be displayed as a hyperlink which you can click on to download the CoCASA file.

5. Once the file is downloaded, you can extract the text file and import it directly into the CoCASA application for processing, using the updated ALERT IIS import template in the CoCASA. Please use the template which consists of the 19 fields specified in the Extract Layout below.

   1. Back to Top

For each patient included in the CoCASA file extract, the layout will be as follows:

1. 1. Name of Field	Description
      Unique Patient Identifier	The ALERT IIS internal ID which uniquely identifies the patient. The ALERT IIS internal ID is different from the Patient ID, and most end users do not see this field in their daily work.
      Last Name	The patient's last name.
      First Name	The patient's first name.
      Date of Birth	The patient's birth date.
      Address Line 1	The first line of the patient's address.
      Address Line 2	The second line of the patient's address.
      City	The city of the patient's address.
      State	The state of the patient's address.
      Zip	The zip code of the patient's address.
      Blank Field	n/a
      Blank Field	n/a
      Blank Field	n/a
      Shot Date	The date when the dose was administered.
      Shot Type	The CVX code for the vaccine which was administered.
      Moved or Gone Elsewhere	Y for a patient who has a Moved or Gone Elsewhere status in this organization. Otherwise, N.
      Provider Organization Identifier	The organization's Primary Patient ID, which is visible to end users on the Edit Patient screen.
      Gender	The gender of the patient. The values are as follows: 1 for Male 2 for Female 98 for Unknown
      Ethnicity	The ethnicity of the patient. The values are as follows: 1 for Not Hispanic or Latino 2 for Hispanic or Latino 98 for Unknown
      VFC Eligibility	The dose-specific VFC eligibility. The values are as follows: 0 for empty 1 for Medicaid 2 for Native American/Alaskan Native 3 for Not VFC-Eligible 4 for Underinsured 5 for Uninsured

      Back to Top

• Unzip Download Note

The file you download will be a self-extracting zip file which means all you have to do is download the file and then click on it to extract the text file used in CoCASA. The text file extracted will appear in the same directory where you downloaded the original CoCASA file. Call the help desk if you have questions.

1. 1. Back to Top