![](media/image1.png){width="2.9993055555555554in"
height="0.8854166666666666in"}

*vERSION 4.1.4*

IMPORT AND EXPORT Modules SPECIFICATION

NCIRD/ISD

Revision 10

*06/26/2008*

VERSION HISTORY

+------+----------+----------+---------+----------+------------------+
| *    | **Imple  | **Re     | **App   | **Ap     | **Reason**       |
| *Ver | mented** | vision** | roved** | proval** |                  |
| sion |          |          |         |          |                  |
| \#** | **By**   | **Date** | **By**  | **Date** |                  |
+------+----------+----------+---------+----------+------------------+
| 10   | *Dennis  | *06/     | *Karron | *06/     | Added new field: |
|      | Bryan*   | 26/2008* | Sin     | 26/2008* | Order Type to    |
|      |          |          | gleton* |          | the Provider     |
|      |          |          |         |          | Orders table;    |
|      |          |          |         |          | Direct Ship --   |
|      |          |          |         |          | Archive or       |
|      |          |          |         |          | Update table;    |
|      |          |          |         |          | and Direct Ship  |
|      |          |          |         |          | -- New Orders    |
|      |          |          |         |          | table. Added     |
|      |          |          |         |          | OrderHold to the |
|      |          |          |         |          | Provider data    |
|      |          |          |         |          | table and        |
|      |          |          |         |          | Vac_Type to the  |
|      |          |          |         |          | Provider         |
|      |          |          |         |          | Inventory data   |
|      |          |          |         |          | table            |
+------+----------+----------+---------+----------+------------------+
|      |          |          |         |          |                  |
+------+----------+----------+---------+----------+------------------+

###### Table of Contents

[**Introduction to Import Module 3**](#__RefHeading___Toc150246139)

[Specific Requirements 3](#specific-requirements)

[Import Options -- The VACMAN Interface Screen
3](#import-options-the-vacman-interface-screen)

[**File to import into VACMAN** 3](#__RefHeading___Toc150246142)

[**File Type** 3](#__RefHeading___Toc150246143)

[**Import Type** 3](#__RefHeading___Toc150246144)

[User Procedures 3](#user-procedures)

[Field Descriptions - Distribution (via Project Depot)
3](#field-descriptions---distribution-via-project-depot)

[Field Descriptions - Transactions
3](#field-descriptions---transactions)

[Field Descriptions -- Provider data 3](#__RefHeading___Toc150246148)

[Field Descriptions -- Enrollment data 3](#__RefHeading___Toc150246149)

[Field Descriptions -- Physicians data 3](#__RefHeading___Toc150246150)

[Field Descriptions -- Provider Inventory data
3](#__RefHeading___Toc150246151)

[Field Descriptions -- Doses Administered data
3](#__RefHeading___Toc150246152)

[Field Descriptions -- Provider Orders 3](#__RefHeading___Toc150246153)

[Field Descriptions -- Direct Ship Orders -- Archive or Update
3](#__RefHeading___Toc150246154)

[Field Descriptions --Direct Ship -- New Orders
3](#__RefHeading___Toc150246155)

[Error Detection Criteria 3](#__RefHeading___Toc150246156)

[Export Module 3](#__RefHeading___Toc150246157)

[Export Options -- The VACMAN Interface Screen
3](#__RefHeading___Toc150246158)

[**Export File Options** 3](#__RefHeading___Toc150246159)

Introduction to Import Module[]{#__RefHeading___Toc150246139 .anchor}

##### Purpose 

This Functional Specification document describes the Import module of
Visual VACMAN v4x. When applicable, differences between VACMAN 4x and
Visual VACMAN 3.0 are indicated. This document provides specifications
for file formats to be used in the event import data is to be prepared
from some source other than VACMAN v4x.

##### Scope 

This product is an import module included as part of VACMAN v4x. Other
than as specifically detailed in this document, no other provisions or
interfaces with other software are addressed or supported in this
specification.

##### Business Rule Objects

VACMAN utilizes business rules objects. This component is the enforcer
of how data is treated and tested before being added to the tables in
the system. This object is designed to accept input either from the
keyboard, or from a file. In both cases, as the object tests individual
elements of a new record, they either pass (are properly formatted), or
they fail, and the program generates an error message that goes back to
the system that sent the data. In the case of keyboard entry, the user
receives an error message and then has the opportunity to correct the
error. In the case of the import module (file input), these error
messages are gathered into a file and shown to the user after
processing. The user is required to save the error file to a valid file
name.

Errors in Import Processing

-   Incomplete records are returned to the external system attempting to
    import into the VACMAN system. The originator also receives a log of
    incomplete records by provider.

-   Incomplete records in an input file do not prevent complete records
    in the same input file from being imported into VACMAN. This
    represents a change from VACMAN import processing prior to vv4x.

##### General Requirements

**Product Perspective**

> This Functional Specification documents an existing product.
> Significant changes between VACMAN v3.0 and VACMAN v4x import
> specifications are indicated.

**Product Functions**

> Implementation of VACMAN v4x provides for the following:

-   Validating and inputting records from standard tables (.dbf files)

-   Validating and inputting records from standard Excel® spreadsheet
    files (.xls files)

-   Validating and inputting records from standard comma delimited text
    files (.txt files)

-   Validating and inputting records from fixed length data files (.sdf
    files)

**User Characteristics**

> Users of this product require the same basic skill set as current
> VACMAN users. Users should have these basic computer skills:

-   Ability to successfully start their machine and log into their local
    area network.

-   Ability to enter data on typical data input screens.

-   Basic keyboarding skills.

-   Basic mouse and other input device operation.

-   Awareness of when, why, and how data is imported into VACMAN, and
    potential data integrity issues posed by incorrect use of the import
    module.

-   Use of the Import module requires a VACMAN user security level 2 or
    3.

**General Constraints**

> Equipment -- Equipment required to support the Import module are
> identical to those specified for VACMAN v4x as a whole. No additional
> requirements are specified.
>
> Required software -- Software required to support the Import module
> are identical to those specified for VACMAN v4x as a whole. No
> additional requirements are specified.
>
> Memory available - Memory requirements for the Import module are
> identical to those specified for VACMAN v4x as a whole. No additional
> requirements are specified.
>
> Operating system -- Operating system requirements to support the
> Import module are identical to those specified for VACMAN v4x as a
> whole. No additional requirements are specified.
>
> Network configuration -- Network configuration required to support the
> Import module is identical to those specified for VACMAN v4x as a
> whole. No additional requirements are specified.
>
> Other constraints on the system -- Users must be able to access VACMAN
> v4x.

**Assumptions and Dependencies**

> The Import module is part of VACMAN v4x as a whole. It is not
> available as a stand-alone process, nor is it accessible from outside
> the CDC network. The product cannot provide information to users
> outside the currently existing network.

####### Specific Requirements

The following functional requirements are the basis for all requirements
specified for this product.

####### Import Options -- The VACMAN Interface Screen 

> The user selects import options from the VACMAN *Utilities* tab -
> *Import Options* screen. These options include file type, the file to
> import, and the import type. The screen provides a **Pick File**
> button, which lets users navigate the file path and select the file to
> import.
>
> File formats other than those listed on the *Import Options* screen
> are not supported by VACMAN.
>
> Regardless of how the file is created, the formatting described in
> this document must be followed. If the file to be imported fails to
> meet criteria, it will reject with an appropriate error message. Best
> results for file creation can be obtained by using the VACMAN Export
> module.

[]{#_Ref150245679 .anchor}Figure 1. VACMAN *Utilities* tab -- *Import
Options* screen.

> ![](media/image3.png){width="5.002083333333333in"
> height="4.607638888888889in"}
>
> **Description of File to import into
> VACMAN**[]{#__RefHeading___Toc150246142 .anchor}**.** The *Import
> Options* screen offers the following data type options that can be
> imported into VACMAN.

-   Distribution (via Project Depot) -- project distributions prior to
    VACMAN v4x.

```{=html}
<!-- -->
```
-   Transactions -- transactions by other than the project, such as
    wasted, expired or lost vaccine.

-   Provider data -- general information about the provider.

-   Enrollment data -- the provider's patient demographics information.

-   Physicians data -- information about a physician who is a provider.

-   Provider Inventory data -- the provider's vaccine inventory
    information.

-   Doses Administered data -- information about vaccinations
    administered by the provider.

-   Provider Orders -- import Provider order data.

-   Direct Ship Orders -- import Direct Ship order data.

> **File Type**[]{#__RefHeading___Toc150246143 .anchor}**.** The *Import
> Options* screen offers the following import file type options, which
> are described in the table below:

-   DBF - Standard database (.dbf files)

-   TXT -- ASCII Comma delimited text files (.txt files)

-   SDF -- ASCII Fixed length text files (.sdf files or space delimited
    files)

-   XLS - Microsoft Excel spreadsheet files (.xls files)

> **Note:** As of VACMAN v4x, Lotus spreadsheet is not a VACMAN
> import/export option.

[]{#_Ref150245778 .anchor}Figure 2. File Type options.

+-------------+----------+---------------------------------------------+
| **File      | **File   | **File Type Description**                   |
| Type**      | Ext      |                                             |
|             | ension** |                                             |
+=============+==========+=============================================+
| **Standard  | .dbf     | Data to be imported in the form of a table  |
| database**  |          | is formatted according to the applicable    |
|             |          | Field Descriptions table in this document.  |
|             |          | The fields are listed in the order in which |
|             |          | they must be presented for import.          |
+-------------+----------+---------------------------------------------+
| **ASCII     | .txt     | Data fields are exported from the           |
| comma       |          | applicable VACMAN table into an ASCII       |
| delimited** |          | standard text file containing one line of   |
|             |          | text for each record in the table.          |
|             |          |                                             |
|             |          | -   The fields in comma delimited files are |
|             |          |     separated by commas; there are no extra |
|             |          |     spaces.                                 |
|             |          |                                             |
|             |          | -   Fields containing character data are    |
|             |          |     surrounded by double quotes.            |
|             |          |                                             |
|             |          | -   Fields containing numeric data are      |
|             |          |     trimmed to the minimum length.          |
|             |          |                                             |
|             |          | -   Fields containing date data is          |
|             |          |     formatted to 8 spaces containing        |
|             |          |     YYYYMMDD data. In the event there is no |
|             |          |     data in the corresponding table field,  |
|             |          |     the appropriate space in the text file  |
|             |          |     contains 8 spaces.                      |
|             |          |                                             |
|             |          | -   Data must be arranged in the order      |
|             |          |     listed in the applicable Field          |
|             |          |     Descriptions table in this document.    |
+-------------+----------+---------------------------------------------+
| **ASCII     | .sdf     | Data fields are exported from the           |
| space       |          | applicable VACMAN table into an ASCII       |
| delimited\  |          | standard text file containing one line of   |
| (fixed      |          | data for each record in the table.          |
| length)**   |          |                                             |
|             |          | -   Space delimited files contain no        |
|             |          |     separators or delimiting characters.    |
|             |          |                                             |
|             |          | -   SDF files format the data in streams of |
|             |          |     values of exactly the same length as    |
|             |          |     the corresponding fields in the table   |
|             |          |     from which the data is exported.        |
|             |          |                                             |
|             |          | -   No quotation marks or other special     |
|             |          |     characters for dates distinguish data   |
|             |          |     types.                                  |
|             |          |                                             |
|             |          | -   Data must be arranged in the order      |
|             |          |     listed in the applicable Field          |
|             |          |     Descriptions table in this document.    |
+-------------+----------+---------------------------------------------+
| **Excel v4x | .xls     | Excel spreadsheet files are formatted with  |
| sp          |          | a column heading corresponding to the name  |
| readsheet** |          | of each field, as defined in the applicable |
|             |          | Field Descriptions table in this document.  |
|             |          |                                             |
|             |          | Each record to be imported is listed on a   |
|             |          | single row of the spreadsheet in the same   |
|             |          | order and with the same formatting          |
|             |          | described in the applicable Field           |
|             |          | Descriptions table in this document.        |
+-------------+----------+---------------------------------------------+

> **Import Type**[]{#__RefHeading___Toc150246144 .anchor}**.** The
> *Import Options* screen offers the following import type options,
> which are described below. Some import type options are not be
> available for some files.

-   Import Archived Records

-   Update Existing Records

-   Add New Records

-   **Import Archived Records** -- This option matches all of the
    records in the import file and only appends records that do not
    exist in the system at the time of the action.

> This action mirrors the Export function that allows for the removal of
> records currently in place. The Export program copies data into the
> system when moving records to archive.
>
> **Notes:**

-   Data created outside of VACMAN should NOT be used for the archive
    function.

-   If any duplicate records are found in the import file that do not
    match records existing in the system, they will be ignored. The user
    will be prompted with the appropriate error message.

-   Archived data should not be tampered with in any way. If the user
    wishes to enter data that has been altered the update or add
    functions should be used. Other than checking for record matches, NO
    ERROR CHECKING IS DONE.

```{=html}
<!-- -->
```
-   **Update Existing Records** -- Only records that currently exist in
    the VACMAN system can be imported.

> Records that do not already exist are moved to a separate file and an
> error record is saved to the error file.
>
> **Notes:**

-   As the records are matched and updated into the system, the new
    information is treated by the business rules object as an edit.

-   The seekid field in ALL of the records in the import file must match
    before ANY of the records will be imported. If all of the records do
    not match, the user is notified and given the chance to view and
    save the errors found. Additionally, the user has the opportunity to
    view the records that did not pass duplicate checking and save them
    to a separate file.

-   If the user intends to change data external to VACMAN, the seekid
    key field, along with action, dateout, fromPIN, PIN, vaccine, and
    lot must not be changed. If they are changed, the record cannot be
    matched to a current record in the system, and the system does not
    allow the record to be imported.

-   Changes to lot inventories and other calculated data are conducted
    in accordance with current business rules.

```{=html}
<!-- -->
```
-   **Add New Records** -- Only records that are NOT duplicates are
    imported.

> New records are handled in accordance with the same business rules
> that apply for a standard keyboard entry.
>
> **Notes:**

-   Per current business rules, the system checks whether excess
    ordering has occurred.

-   The add option on the main interface screen provides these options:
    the user can auto-assign a shipment date when the shipdate field in
    the import table is blank, and auto-assign lot numbers when they are
    blank. A radio box will be provided for each option. A separate
    field lets the user input a desired ship date. The default the date
    is the current date.

-   Distid and Seekid (unique fields) are overwritten if present by
    system-generated identifiers in add mode. If importing data using
    the add mode, the values originally present in these fields change.
    The import file itself is not changed, only the values entered in
    the import table.

####### User Procedures 

Use these instructions to import a file into VACMAN.

Figure 3. User instructions for importing into VACMAN.

+----+-----------------------------------------------------------------+
| ** | **Description**                                                 |
| St |                                                                 |
| ep |                                                                 |
| ** |                                                                 |
+====+=================================================================+
| *  | Access the VACMAN *Utilities* tab and select **the Import Data  |
| *1 | into VACMAN** option.                                           |
| ** |                                                                 |
|    | **Result:** The system displays the VACMAN *Import Options*     |
|    | screen.                                                         |
+----+-----------------------------------------------------------------+
| *  | Choose one radio button from each of these frames:              |
| *2 |                                                                 |
| ** | -   Description of file to import                               |
|    |                                                                 |
|    | -   File type                                                   |
|    |                                                                 |
|    | -   Import Type                                                 |
+----+-----------------------------------------------------------------+
| *  | Click the **Pick file** button.                                 |
| *3 |                                                                 |
| ** | **Result:** The system displays the *Select Import File*        |
|    | screen. This enables you to navigate to, and select, the file   |
|    | you need to import.                                             |
+----+-----------------------------------------------------------------+
| *  | Select the file you need to import.                             |
| *4 |                                                                 |
| ** | **Result:** The *Import Options* screen displays the selected   |
|    | file in the *Source filename* field.                            |
+----+-----------------------------------------------------------------+
| *  | Click the **Continue** button.                                  |
| *5 |                                                                 |
| ** | **Results:** The system does the following.                     |
|    |                                                                 |
|    | -   Checks for duplicate records.                               |
|    |                                                                 |
|    | -   After checking for duplication, if the number of records    |
|    |     remaining to import is less than 1, a message notifies that |
|    |     there are no records to import.                             |
|    |                                                                 |
|    | -   After checking for duplication, if the number of records    |
|    |     remaining to import is 1 or more, the system launches its   |
|    |     error checking routine. The system displays error and       |
|    |     warning messages as appropriate. If no critical errors are  |
|    |     detected, users can continue the import process. For more   |
|    |     information, see *Error Detection Criteria*.                |
|    |                                                                 |
|    | -   After successfully completing error checking, the system    |
|    |     scans the file to be imported and compares it against the   |
|    |     applicable VACMAN table.                                    |
|    |                                                                 |
|    | ```{=html}                                                      |
|    | <!-- -->                                                        |
|    | ```                                                             |
|    | -   If matches exist, and there is no transmit date, the system |
|    |     overwrites the existing record in the applicable table with |
|    |     the import record.                                          |
|    |                                                                 |
|    | -   If matches exist, and there is a transmit date, the system  |
|    |     updates the existing record in the applicable table with    |
|    |     the import record.                                          |
|    |                                                                 |
|    | -   If matches do not exist, the system adds the import record  |
|    |     to the applicable table.                                    |
|    |                                                                 |
|    | ```{=html}                                                      |
|    | <!-- -->                                                        |
|    | ```                                                             |
|    | -   Regardless the choice of the type of import to do, error    |
|    |     checking will first be conducted. If no critical errors are |
|    |     detected -- the user will be required to view any warning   |
|    |     messages and then be able to continue the import process as |
|    |     described previously.                                       |
|    |                                                                 |
|    | **Note:** Choosing the **Cancel** button will abort the         |
|    | operation and close the import module.                          |
+----+-----------------------------------------------------------------+
| *  | When processing is complete, the system does the following:     |
| *6 |                                                                 |
| ** | -   Generates a log of incomplete records by provider, if any.  |
|    |                                                                 |
|    | -   Generates a detailed result log and summary screen, and a   |
|    |     printable, exportable file.                                 |
+----+-----------------------------------------------------------------+

#######  Field Descriptions - Distribution (via Project Depot)

**Note:** VACMAN v4x does not require that projects distribute vaccine
from their depots, as in previous versions of VACMAN. VACMAN v4x does
allow projects to view historical distribution data, and therefore can
continue to export and import distribution records that existed prior to
installation of VACMAN v4x.

Source Table in VACMAN: **distrib.dbf**

Figure 4. Field Descriptions -- Distribution (via Project Depot).

+--------+-----+---+----+------+-------------------------------------+
| *      | **  | * | ** | **Re | **distrib.dbf -- Field              |
| *Field | Typ | * | De | quir | Description**                       |
| Name** | e** | S | c. | ed** |                                     |
|        |     | i | ** |      |                                     |
|        |     | z |    |      |                                     |
|        |     | e |    |      |                                     |
|        |     | * |    |      |                                     |
|        |     | * |    |      |                                     |
+========+=====+===+====+======+=====================================+
| R      | N   | 1 | 0  |      | Record type. Codes are:             |
| ectype | ume |   |    |      |                                     |
|        | ric |   |    |      | > 1 - Bulk order (manufacturer to   |
|        |     |   |    |      | > distributor).                     |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 2 - Direct ship order             |
|        |     |   |    |      | > (manufacturer to provider).       |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 3 -- Non-CDC inventory            |
|        |     |   |    |      | > (manufacturer or distributor, to  |
|        |     |   |    |      | > distributor or project). Not      |
|        |     |   |    |      | > applicable to Import module.      |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 4 -- Return viable vaccine        |
|        |     |   |    |      | > (provider to manufacturer or      |
|        |     |   |    |      | > distributor ). Not applicable to  |
|        |     |   |    |      | > Import module.                    |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 5 -- Provider order (distributor to |
|        |     |   |    |      | provider) Not applicable to Import  |
|        |     |   |    |      | module.                             |
+--------+-----+---+----+------+-------------------------------------+
| Input  | D   | 8 | 0  | *    | Date the record is entered into the |
|        | ate |   |    | *X** | database. Value can be up to five   |
|        |     |   |    |      | years prior to the current date, or |
|        |     |   |    |      | up to one year from the value in    |
|        |     |   |    |      | the *Date Out* field.               |
+--------+-----+---+----+------+-------------------------------------+
| Xm     | D   | 8 | 0  |      | Transmit date. Not in use.          |
| itdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| D      | D   | 8 | 0  | *    | Date out; date of the code in the   |
| ateout | ate |   |    | *X** | *Action* field in ACTREF.dbf. For   |
|        |     |   |    |      | Distribution by the project, the    |
|        |     |   |    |      | only applicable action code is 1.   |
|        |     |   |    |      | Codes are:                          |
|        |     |   |    |      |                                     |
|        |     |   |    |      | **1 -** **date shipment is actually |
|        |     |   |    |      | shipped to the provider**           |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 2 - date vaccine is returned        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 3 thru 7, 11, 12 - date vaccine is  |
|        |     |   |    |      | reported spoiled, expired, or       |
|        |     |   |    |      | lost/damaged                        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 8 - date vaccine is shipped         |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 9 - date vaccine order is           |
|        |     |   |    |      | transmitted                         |
+--------+-----+---+----+------+-------------------------------------+
| PIN    | Cha | 6 | 0  | *    | Provider identification number.     |
|        | rac |   |    | *X** | This is the recipient of the        |
|        | ter |   |    |      | vaccine. This identification must   |
|        |     |   |    |      | exist in the VACMAN system, and the |
|        |     |   |    |      | provider must be an active VACMAN   |
|        |     |   |    |      | provider. This field is             |
|        |     |   |    |      | right‑justified.                    |
+--------+-----+---+----+------+-------------------------------------+
| F      | Cha | 6 | 0  | *    | From PIN. This identification must  |
| romPIN | rac |   |    | *X** | exist in the VACMAN system, and the |
|        | ter |   |    |      | referenced PIN must be active.      |
|        |     |   |    |      | Value depends on the code in the    |
|        |     |   |    |      | *Action* field in ACTREF.dbf. The   |
|        |     |   |    |      | action codes and applicable From    |
|        |     |   |    |      | PINs are:                           |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 1 -- PIN for project/depot that is  |
|        |     |   |    |      | sending inventory for distribution  |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 2 thru 7, 11, 12 -- PIN for         |
|        |     |   |    |      | project/depot to which the provider |
|        |     |   |    |      | is reporting                        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 8 -- PIN of provider who is         |
|        |     |   |    |      | transferring vaccine                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 9 -- PIN of a vaccine distribution  |
|        |     |   |    |      | center                              |
+--------+-----+---+----+------+-------------------------------------+
| Action | N   | 2 | 0  | *    | Transaction code; identifies the    |
|        | ume |   |    | *X** | type of transaction. For            |
|        | ric |   |    |      | Distribution by the project, the    |
|        |     |   |    |      | only applicable code is 1. Codes    |
|        |     |   |    |      | are:                                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | **1 -** **vaccine sent from the     |
|        |     |   |    |      | project to a provider**             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 2 -- usable vaccine returned by the |
|        |     |   |    |      | provider                            |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 3 -- vaccine spoiled for a reason   |
|        |     |   |    |      | other than improper storage upon    |
|        |     |   |    |      | receipt or refrigerator failure     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 4 - expired vaccine                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 5 -- vaccine was lost or damaged    |
|        |     |   |    |      | during shipment to the provider     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 6 -- vaccine was improperly stored  |
|        |     |   |    |      | upon receipt and spoiled            |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 7 -- refrigerator failed and the    |
|        |     |   |    |      | vaccine spoiled                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 8 -- usable vaccine transferred     |
|        |     |   |    |      | from one provider to another        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 11 -- vaccine was lost or cannot be |
|        |     |   |    |      | accounted for in the provider       |
|        |     |   |    |      | inventory                           |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 12 -- vaccine was not usable for    |
|        |     |   |    |      | some reason other than spoiled,     |
|        |     |   |    |      | expired, or lost/damaged            |
+--------+-----+---+----+------+-------------------------------------+
| Lot    | Cha | 1 | 0  | Ma   |                                     |
|        | rac | 5 |    | nufa |                                     |
|        | ter |   |    | ctur |                                     |
|        |     |   |    | er's |                                     |
|        |     |   |    | lot  |                                     |
|        |     |   |    | num  |                                     |
|        |     |   |    | ber. |                                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 4 | 0  |      | Order size.                         |
| rdsize | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| V      | Cha | 8 | 0  | *    | Short name for vaccine type. This   |
| accine | rac |   |    | *X** | name must be in the *Vaccine* field |
|        | ter |   |    |      | in STOCK.dbf.                       |
+--------+-----+---+----+------+-------------------------------------+
| Units  | N   | 8 | 0  | *    | Number of vials. Must be an even    |
|        | ume |   |    | *X** | multiple of doses/size.             |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Doses  | N   | 8 | 0  | *    | Number of doses. Value cannot be    |
|        | ume |   |    | *X** | greater than the number of doses    |
|        | ric |   |    |      | available.                          |
+--------+-----+---+----+------+-------------------------------------+
| Fdose1 | N   | 8 | 0  |      | Funding dose 1. Prior to version    |
|        | ume |   |    |      | 3.0: Number of doses assigned to    |
|        | ric |   |    |      | VFC funds.                          |
+--------+-----+---+----+------+-------------------------------------+
| Fdose2 | N   | 8 | 0  |      | Funding dose 1. Prior to version    |
|        | ume |   |    |      | 3.0: Number of doses assigned to    |
|        | ric |   |    |      | G317 funds.                         |
+--------+-----+---+----+------+-------------------------------------+
| Fdose3 | N   | 8 | 0  |      | Funding dose 1. Prior to version    |
|        | ume |   |    |      | 3.0: Number of doses assigned to    |
|        | ric |   |    |      | State/other funds.                  |
+--------+-----+---+----+------+-------------------------------------+
| SeekID | N   | 9 | 0  |      | Sequence ("seek") ID. Unique number |
|        | ume |   |    |      | assigned to this record when the    |
|        | ric |   |    |      | code in the *Action* field = 1. If  |
|        |     |   |    |      | the code in the *Action* field is   |
|        |     |   |    |      | not 1, this field must be blank.    |
+--------+-----+---+----+------+-------------------------------------+
| Cdcpo  | N   | 1 | 0  |      | CDC Purchase Order number.          |
|        | ume | 0 |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Status | Cha | 2 | 0  |      | Quick reference to distribution     |
|        | rac |   |    |      | type. Codes are:                    |
|        | ter |   |    |      |                                     |
|        |     |   |    |      | Di -- Distribution from project     |
|        |     |   |    |      | depot                               |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Re -- Return to project depot       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Sp -- Report of spoiled vaccine     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Ex -- Report of expired vaccine     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Lo -- Lost or missing vaccine       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Im -- Improper storage              |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Fa -- Spoilage due to refrigerator  |
|        |     |   |    |      | failure                             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Tr -- Transfer between providers    |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Ac -- Cannot be accounted for       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Us -- Unusable vaccine              |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Aj -- Inventory Adjustment          |
+--------+-----+---+----+------+-------------------------------------+
| Sh     | D   | 8 | 0  |      | Ship date.                          |
| ipdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 8 | 0  |      | Order dose.                         |
| rddose | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| S      | N   | 1 | 0  |      | Code indicating whether the vaccine |
| hipped | ume |   |    |      | shipped has actually been shipped.  |
|        | ric |   |    |      | Codes are:                          |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 1 -- vaccine has been shipped       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 0 -- vaccine has not been shipped   |
|        |     |   |    |      | (leave field blank)                 |
+--------+-----+---+----+------+-------------------------------------+
| Notes  | Cha | 2 | 0  |      | Optional information. Special       |
|        | rac | 5 |    |      | information about the vaccine       |
|        | ter |   |    |      | shipment that can be included on    |
|        |     |   |    |      | the Shipping Invoice.               |
+--------+-----+---+----+------+-------------------------------------+
| C      | D   | 8 | 0  |      | Change date. Date the record was    |
| hgdate | ate |   |    |      | last changed.                       |
+--------+-----+---+----+------+-------------------------------------+
| Userid | Cha | 8 | 0  |      | ID of the user who last changed the |
|        | rac |   |    |      | record. The ID is copied from the   |
|        | ter |   |    |      | Security profile.                   |
+--------+-----+---+----+------+-------------------------------------+
| Distid | I   | 4 | 0  |      | Distribution ID. Unique ID for each |
|        | nte |   |    |      | distribution record.                |
|        | ger |   |    |      |                                     |
|        |     |   |    |      | **Note:** This is primary key for   |
|        |     |   |    |      | the distribution table and must not |
|        |     |   |    |      | be altered in any way.              |
+--------+-----+---+----+------+-------------------------------------+

#######  

####### Field Descriptions - Transactions

**Note:** "Other Transactions" are Transaction Codes 2 -- 8: expired,
wasted, lost etc., vaccine.

Source Table in VACMAN: **distrib.dbf**

Field Descriptions are generally identical to those for Distribution
(via Project Depot); see Figure 4. Field Descriptions -- Distribution
(via Project Depot).

For Distribution (Other Transactions), all Action codes except "1" are
valid.

**Field Descriptions -- Provider data**[]{#__RefHeading___Toc150246148
.anchor}

Source Table in VACMAN: **provider.dbf**

Figure 5. Field Descriptions -- Provider data.

+--------+-----+---+----+------+-------------------------------------+
| *      | **  | * | ** | **Re | **provider.dbf -- Field             |
| *Field | Typ | * | De | quir | Description**                       |
| Name** | e** | S | c. | ed** |                                     |
|        |     | i | ** |      |                                     |
|        |     | z |    |      |                                     |
|        |     | e |    |      |                                     |
|        |     | * |    |      |                                     |
|        |     | * |    |      |                                     |
+========+=====+===+====+======+=====================================+
| PIN    | Cha | 6 | 0  | *    | Provider identification number.     |
|        | rac |   |    | *X** | This field is right-justified.      |
|        | ter |   |    |      |                                     |
|        |     |   |    |      | This number is a unique identifier  |
|        |     |   |    |      | for provider or depots. This        |
|        |     |   |    |      | identification must exist in the    |
|        |     |   |    |      | VACMAN system, and the provider     |
|        |     |   |    |      | must be an active VACMAN provider.  |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Depots are identified by a value of |
|        |     |   |    |      | 30, 31, or 33 in the *Sector* field |
|        |     |   |    |      | of this table.                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This is the key field to match      |
|        |     |   |    |      | providers in this database with     |
|        |     |   |    |      | providers in the other databases.   |
+--------+-----+---+----+------+-------------------------------------+
| L      | Cha | 6 | 0  | *    | Provider identification number for  |
| inkpin | rac |   |    | *X** | a "parent" provider record of the   |
|        | ter |   |    |      | "satellite" provider being          |
|        |     |   |    |      | displayed. This is to link the      |
|        |     |   |    |      | records for enrollment data.        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The *Sector* field in provider      |
|        |     |   |    |      | table for record matching this      |
|        |     |   |    |      | value must be between 10 or 29, or  |
|        |     |   |    |      | must be 32.                         |
+--------+-----+---+----+------+-------------------------------------+
| A      | Cha | 1 | 0  |      | Optional. User-defined secondary    |
| lphaid | rac | 5 |    |      | identifiers (state-ID or Medicaid   |
|        | ter |   |    |      | number) where existing identified   |
|        |     |   |    |      | codes may not be served by other    |
|        |     |   |    |      | fields in the Provider database.    |
|        |     |   |    |      | This field is assigned on the       |
|        |     |   |    |      | *Setup* tab - *Define Names*        |
|        |     |   |    |      | screen.                             |
+--------+-----+---+----+------+-------------------------------------+
| Fir    | Cha | 1 | 0  |      | For private providers only. Private |
| stname | rac | 5 |    |      | provider's first name. Use the      |
|        | ter |   |    |      | *Last Name* field for a facility    |
|        |     |   |    |      | name.                               |
+--------+-----+---+----+------+-------------------------------------+
| I      | Cha | 1 | 0  |      | For private providers only. Middle  |
| nitial | rac |   |    |      | initial of the private provider's   |
|        | ter |   |    |      | name. Use the *Last Name* field for |
|        |     |   |    |      | a facility name.                    |
+--------+-----+---+----+------+-------------------------------------+
| La     | Cha | 3 | 0  | *    | Last name of a private provider OR  |
| stname | rac | 5 |    | *X** | the entire name of a facility.      |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Title  | Cha | 9 | 0  |      | For private providers only. Suffix  |
|        | rac |   |    |      | or title of the private provider.   |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| C      | Cha | 3 | 0  | *    | Person to contact for information   |
| ontact | rac | 0 |    | *X** | or questions about vaccine          |
|        | ter |   |    |      | shipments or deliveries.            |
+--------+-----+---+----+------+-------------------------------------+
| A      | Cha | 3 | 0  | *    | Provider shipping address for       |
| ddress | rac | 5 |    | *X** | delivery purposes. This should be   |
|        | ter |   |    |      | the street address. DO NOT include  |
|        |     |   |    |      | a P.O. box in this address.         |
+--------+-----+---+----+------+-------------------------------------+
| A      | Cha | 3 | 0  |      | Second line for provider shipping   |
| ddres2 | rac | 5 |    |      | address. Leave this line blank if   |
|        | ter |   |    |      | not needed to complete the address. |
+--------+-----+---+----+------+-------------------------------------+
| City   | Cha | 2 | 0  | *    | Shipping address city               |
|        | rac | 0 |    | *X** |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| State  | Cha | 2 | 0  | *    | Shipping address state              |
|        | rac |   |    | *X** |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Z      | Cha | 1 | 0  | *    | Shipping address ZIP code (5 or 9   |
| ipcode | rac | 0 |    | *X** | digits). Value must exist in the    |
|        | ter |   |    |      | ZIPCODE.dbf file.                   |
+--------+-----+---+----+------+-------------------------------------+
| Ml_c   | Cha | 3 | 0  |      | Optional. Person to contact for     |
| ontact | rac | 0 |    |      | questions or problems about vaccine |
|        | ter |   |    |      | issues.                             |
+--------+-----+---+----+------+-------------------------------------+
| Ml_a   | Cha | 3 | 0  |      | Optional. Provider mailing address  |
| ddress | rac | 5 |    |      | other than the street address       |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ml_a   | Cha | 3 | 0  |      | Optional. Second line for provider  |
| ddres2 | rac | 5 |    |      | mailing address. If a post office   |
|        | ter |   |    |      | box is part of the mailing address, |
|        |     |   |    |      | enter this on the second address    |
|        |     |   |    |      | line, otherwise leave this line     |
|        |     |   |    |      | blank.                              |
+--------+-----+---+----+------+-------------------------------------+
| M      | Cha | 2 | 0  |      | Optional. Mailing address city      |
| l_city | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ml     | Cha | 2 | 0  |      | Optional. Mailing address state     |
| _state | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ml_z   | Cha | 1 | 0  |      | Optional. Mailing address ZIP code  |
| ipcode | rac | 0 |    |      | (5 or 9 digits). The 5-digit code   |
|        | ter |   |    |      | must be in the *ZIP* field in       |
|        |     |   |    |      | ZIPCODES.dbf.                       |
+--------+-----+---+----+------+-------------------------------------+
| County | Cha | 1 | 0  |      | Optional. County name               |
|        | rac | 5 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Phone  | Cha | 1 | 0  | *    | Phone number for the person shown   |
|        | rac | 4 |    | *X** | in the *Contact* field. Field       |
|        | ter |   |    |      | includes parentheses around area    |
|        |     |   |    |      | code and hyphen after local prefix; |
|        |     |   |    |      | for example (404) 555-8245.         |
+--------+-----+---+----+------+-------------------------------------+
| Ext    | Cha | 4 | 0  |      | Optional. Extension number for the  |
| ension | rac |   |    |      | telephone number shown in the       |
|        | ter |   |    |      | *Phone* field.                      |
+--------+-----+---+----+------+-------------------------------------+
| Fax    | Cha | 1 | 0  |      | Optional. FAX number. Field         |
|        | rac | 4 |    |      | includes parentheses around area    |
|        | ter |   |    |      | code and hyphen after local prefix; |
|        |     |   |    |      | for example (404) 555-8245.         |
+--------+-----+---+----+------+-------------------------------------+
| Modem  | Cha | 1 | 0  |      | Not in use.                         |
|        | rac | 4 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Subdiv | Cha | 1 | 0  | *    | User-defined name of the project    |
|        | rac | 5 |    | *X** | jurisdictional subdivision          |
|        | ter |   |    |      | (district, county, region, station, |
|        |     |   |    |      | area, etc.) under which the         |
|        |     |   |    |      | provider is grouped. This field is  |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. The name     |
|        |     |   |    |      | must be in the *Subdiv* field in    |
|        |     |   |    |      | SUBDIV.dbf.                         |
+--------+-----+---+----+------+-------------------------------------+
| Sector | N   | 2 | 0  | *    |                                     |
|        | ume |   |    | *X** |                                     |
|        | ric |   |    | Prov |                                     |
|        |     |   |    | ider |                                     |
|        |     |   |    | cl   |                                     |
|        |     |   |    | assi |                                     |
|        |     |   |    | fica |                                     |
|        |     |   |    | tion |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | ode. |                                     |
|        |     |   |    | I    |                                     |
|        |     |   |    | ndic |                                     |
|        |     |   |    | ates |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | type |                                     |
|        |     |   |    | of   |                                     |
|        |     |   |    | p    |                                     |
|        |     |   |    | rovi |                                     |
|        |     |   |    | der. |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | irst |                                     |
|        |     |   |    | d    |                                     |
|        |     |   |    | igit |                                     |
|        |     |   |    | must |                                     |
|        |     |   |    | be:  |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 1 -  |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | sign |                                     |
|        |     |   |    | ates |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | prov |                                     |
|        |     |   |    | ider |                                     |
|        |     |   |    | is   |                                     |
|        |     |   |    | pu   |                                     |
|        |     |   |    | blic |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 2 -  |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | sign |                                     |
|        |     |   |    | ates |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | prov |                                     |
|        |     |   |    | ider |                                     |
|        |     |   |    | is   |                                     |
|        |     |   |    | pri  |                                     |
|        |     |   |    | vate |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 3 -  |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | sign |                                     |
|        |     |   |    | ates |                                     |
|        |     |   |    | a    |                                     |
|        |     |   |    | proj |                                     |
|        |     |   |    | ect, |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | pot, |                                     |
|        |     |   |    | or   |                                     |
|        |     |   |    | o    |                                     |
|        |     |   |    | ther |                                     |
|        |     |   |    | immu |                                     |
|        |     |   |    | niza |                                     |
|        |     |   |    | tion |                                     |
|        |     |   |    | pro  |                                     |
|        |     |   |    | ject |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | se   |                                     |
|        |     |   |    | cond |                                     |
|        |     |   |    | d    |                                     |
|        |     |   |    | igit |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | sign |                                     |
|        |     |   |    | ates |                                     |
|        |     |   |    | whe  |                                     |
|        |     |   |    | ther |                                     |
|        |     |   |    | a    |                                     |
|        |     |   |    | pri  |                                     |
|        |     |   |    | vate |                                     |
|        |     |   |    | prov |                                     |
|        |     |   |    | ider |                                     |
|        |     |   |    | is   |                                     |
|        |     |   |    | d    |                                     |
|        |     |   |    | eput |                                     |
|        |     |   |    | ized |                                     |
|        |     |   |    | as a |                                     |
|        |     |   |    | F    |                                     |
|        |     |   |    | eder |                                     |
|        |     |   |    | ally |                                     |
|        |     |   |    | Q    |                                     |
|        |     |   |    | uali |                                     |
|        |     |   |    | fied |                                     |
|        |     |   |    | He   |                                     |
|        |     |   |    | alth |                                     |
|        |     |   |    | Ce   |                                     |
|        |     |   |    | nter |                                     |
|        |     |   |    | (F   |                                     |
|        |     |   |    | QHC) |                                     |
|        |     |   |    | or   |                                     |
|        |     |   |    | R    |                                     |
|        |     |   |    | ural |                                     |
|        |     |   |    | He   |                                     |
|        |     |   |    | alth |                                     |
|        |     |   |    | Ce   |                                     |
|        |     |   |    | nter |                                     |
|        |     |   |    | (R   |                                     |
|        |     |   |    | HC). |                                     |
|        |     |   |    | Odd  |                                     |
|        |     |   |    | num  |                                     |
|        |     |   |    | bers |                                     |
|        |     |   |    | indi |                                     |
|        |     |   |    | cate |                                     |
|        |     |   |    | that |                                     |
|        |     |   |    | a    |                                     |
|        |     |   |    | pri  |                                     |
|        |     |   |    | vate |                                     |
|        |     |   |    | prov |                                     |
|        |     |   |    | ider |                                     |
|        |     |   |    | is   |                                     |
|        |     |   |    | d    |                                     |
|        |     |   |    | eput |                                     |
|        |     |   |    | ized |                                     |
|        |     |   |    | as a |                                     |
|        |     |   |    | FQHC |                                     |
|        |     |   |    | or   |                                     |
|        |     |   |    | RHC. |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | Se   |                                     |
|        |     |   |    | ctor |                                     |
|        |     |   |    | ca   |                                     |
|        |     |   |    | nnot |                                     |
|        |     |   |    | be   |                                     |
|        |     |   |    | 30,  |                                     |
|        |     |   |    | 31,  |                                     |
|        |     |   |    | or   |                                     |
|        |     |   |    | 33.  |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | code |                                     |
|        |     |   |    | must |                                     |
|        |     |   |    | be   |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | *Sec |                                     |
|        |     |   |    | tor* |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | ield |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | S    |                                     |
|        |     |   |    | ECTO |                                     |
|        |     |   |    | REF. |                                     |
|        |     |   |    | dbf. |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Cat1   | Cha | 1 | 0  | *    | First optional user-defined field.  |
|        | rac | 0 |    | *X** | If used, the value must exist in    |
|        | ter |   |    |      | the OWNREF.dbf. This field is       |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. This field   |
|        |     |   |    |      | can be used for project information |
|        |     |   |    |      | not served by other fields in the   |
|        |     |   |    |      | Provider database.                  |
+--------+-----+---+----+------+-------------------------------------+
| Cat2   | Cha | 1 | 0  | *    | Second optional user-defined field. |
|        | rac | 0 |    | *X** | If used, the value must exist in    |
|        | ter |   |    |      | the OWNREF.dbf. This field is       |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. This field   |
|        |     |   |    |      | can be used for project information |
|        |     |   |    |      | not served by other fields in the   |
|        |     |   |    |      | Provider database.                  |
+--------+-----+---+----+------+-------------------------------------+
| Cat3   | Cha | 1 | 0  | *    | Third optional user-defined field.  |
|        | rac | 0 |    | *X** | If used, the value must exist in    |
|        | ter |   |    |      | the OWNREF.dbf. This field is       |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. This field   |
|        |     |   |    |      | can be used for project information |
|        |     |   |    |      | not served by other fields in the   |
|        |     |   |    |      | Provider database.                  |
+--------+-----+---+----+------+-------------------------------------+
| Note   | Cha | 5 | 0  |      | Optional; additional information    |
|        | rac | 0 |    |      | about the provider that is to be    |
|        | ter |   |    |      | included on the shipping label.     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The VACMAN Import function          |
|        |     |   |    |      | generates warning messages if there |
|        |     |   |    |      | is no value in this field, or if    |
|        |     |   |    |      | keyboard characters other than      |
|        |     |   |    |      | letters or numbers are present.     |
+--------+-----+---+----+------+-------------------------------------+
| Active | Cha | 1 | 0  | *    | Code to indicate whether a provider |
|        | rac |   |    | *X** | is active. Codes are:               |
|        | ter |   |    |      |                                     |
|        |     |   |    |      | Y - active provider                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | N - inactive provider               |
|        |     |   |    |      |                                     |
|        |     |   |    |      | S -- suspended provider             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | T -- temporary provider             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The inactive (N) code maintains the |
|        |     |   |    |      | provider in the database, even      |
|        |     |   |    |      | though the provider does not        |
|        |     |   |    |      | actively participate in the         |
|        |     |   |    |      | program.                            |
+--------+-----+---+----+------+-------------------------------------+
| Codes  | Cha | 1 | 0  | *    | Indicates whether a provider is     |
|        | rac | 0 |    | *X** | eligible for direct ship. Codes     |
|        | ter |   |    |      | are:                                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Y - provider can receive direct     |
|        |     |   |    |      | ship (frozen) vaccine               |
|        |     |   |    |      |                                     |
|        |     |   |    |      | blank - provider cannot receive     |
|        |     |   |    |      | direct ship                         |
+--------+-----+---+----+------+-------------------------------------+
| Phy    | N   | 2 | 0  |      | Future use                          |
| scount | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Or     | D   | 8 | 0  |      | Future use                          |
| igdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Other  | Cha | 1 | 0  |      | Future use                          |
|        | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| D      | D   | 8 | 0  | *    | Date the provider became eligible   |
| atevfc | ate |   |    | *X** | to participate in the VFC program.  |
|        |     |   |    |      | Value cannot exceed the current     |
|        |     |   |    |      | date by more than 30 days.          |
+--------+-----+---+----+------+-------------------------------------+
| Crea   | D   | 8 | 0  |      | Date the provider record was        |
| tedate | ate |   |    |      | created                             |
+--------+-----+---+----+------+-------------------------------------+
| Xm     | D   | 8 | 0  |      | Date the provider record was last   |
| itdate | ate |   |    |      | transmitted to CDC/NIP              |
+--------+-----+---+----+------+-------------------------------------+
| C      | D   | 8 | 0  |      | Change date. Date the provider      |
| hgdate | ate |   |    |      | record was last updated. For newly  |
|        |     |   |    |      | added records, this date will be    |
|        |     |   |    |      | the same as the *Create Date*.      |
+--------+-----+---+----+------+-------------------------------------+
| Userid | Cha | 8 | 0  |      | User ID of person adding or editing |
|        | rac |   |    |      | provider's record. The ID is copied |
|        | ter |   |    |      | from the Security profile.          |
+--------+-----+---+----+------+-------------------------------------+
| Phone2 | Cha | 1 | 0  |      | Optional. Additional telephone      |
|        | rac | 4 |    |      | number to use to contact the        |
|        | ter |   |    |      | provider. Field includes            |
|        |     |   |    |      | parentheses around area code and    |
|        |     |   |    |      | hyphen after local prefix, for      |
|        |     |   |    |      | example (404) 555-8245.             |
+--------+-----+---+----+------+-------------------------------------+
| Email  | Cha | 4 | 0  |      | E-mail address to contact the       |
|        | rac | 0 |    |      | provider                            |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Cat4   | Cha | 1 | 0  | *    | Fourth optional user-defined field. |
|        | rac | 0 |    | *X** | If used, the value must exist in    |
|        | ter |   |    |      | the OWNREF.dbf. This field is       |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. This field   |
|        |     |   |    |      | can be used for project information |
|        |     |   |    |      | not served by other fields in the   |
|        |     |   |    |      | Provider database.                  |
+--------+-----+---+----+------+-------------------------------------+
| Cat5   | Cha | 1 | 0  | *    | Fifth optional user-defined field.  |
|        | rac | 0 |    | *X** | If used, the value must exist in    |
|        | ter |   |    |      | the OWNREF.dbf. This field is       |
|        |     |   |    |      | assigned on the *Setup* tab -       |
|        |     |   |    |      | *Define Names* screen. This field   |
|        |     |   |    |      | can be used for project information |
|        |     |   |    |      | not served by other fields in the   |
|        |     |   |    |      | Provider database.                  |
+--------+-----+---+----+------+-------------------------------------+
| Pr     | Cha | 1 | 0  |      | Optional user-defined field.        |
| ovtype | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Email2 | Cha | 3 | 0  |      | Email address associated with       |
|        | rac | 5 |    |      | Mailing address.                    |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Exte   | Cha | 4 | 0  |      | Phone extension associated with     |
| nsion2 | rac |   |    |      | Mailing address.                    |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fax2   | Cha | 1 | 0  |      | Second fax number for the provider  |
|        | rac | 4 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| W      | Cha | 5 | 0  |      | Warehouse notes for packaging.      |
| h_note | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Date   | D   | 8 | 0  |      | Date that provider's active status  |
| active | ate |   |    |      | last changed.                       |
+--------+-----+---+----+------+-------------------------------------+
| Da     | D   | 8 | 0  |      | Date that provider left VFC         |
| texvfc | ate |   |    |      | program.                            |
+--------+-----+---+----+------+-------------------------------------+
| Provid | I   | 4 | 0  |      | Unique ID for record.               |
|        | nte |   |    |      |                                     |
|        | ger |   |    |      | **Note:** The *Provid* field is the |
|        |     |   |    |      | primary key for the provider table  |
|        |     |   |    |      | and must not be altered in any way; |
|        |     |   |    |      | this could prevent the record from  |
|        |     |   |    |      | matching.                           |
+--------+-----+---+----+------+-------------------------------------+
| Ord    | I   | 4 | 0  |      | Suspend provider from placing       |
| erHold | nte |   |    |      | Provider orders.                    |
|        | ger |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+

**Field Descriptions -- Enrollment data**[]{#__RefHeading___Toc150246149
.anchor}

Source Table in VACMAN: **enroll.dbf**

Figure 6. Field Descriptions -- Enrollment data.

+-------+------+---+----+------+-------------------------------------+
| **    | **Ty | * | ** | **Re | **enroll.dbf -- Field Description** |
| Field | pe** | * | De | quir |                                     |
| N     |      | S | c. | ed** |                                     |
| ame** |      | i | ** |      |                                     |
|       |      | z |    |      |                                     |
|       |      | e |    |      |                                     |
|       |      | * |    |      |                                     |
|       |      | * |    |      |                                     |
+=======+======+===+====+======+=====================================+
| PIN   | C    | 6 | 0  | *    | Provider identification number.     |
|       | hara |   |    | *X** | This identification must exist in   |
|       | cter |   |    |      | the VACMAN system, and the provider |
|       |      |   |    |      | must be an active VACMAN provider.  |
|       |      |   |    |      | This field is right‑justified.      |
|       |      |   |    |      |                                     |
|       |      |   |    |      | The *PIN* field is the primary key  |
|       |      |   |    |      | for the enroll table and must not   |
|       |      |   |    |      | be altered; this could prevent the  |
|       |      |   |    |      | record from matching.               |
+-------+------+---+----+------+-------------------------------------+
| Aged  | C    | 6 | 0  |      | Age group definitions.              |
| efine | hara |   |    |      |                                     |
|       | cter |   |    |      | If the value is 1998, age groups    |
|       |      |   |    |      | are as re-defined in 1998.          |
|       |      |   |    |      |                                     |
|       |      |   |    |      | If the value is blank, age groups   |
|       |      |   |    |      | are as defined prior to 1998.       |
+-------+------+---+----+------+-------------------------------------+
| Ens   | C    | 1 | 0  |      | Source code for the enrollment      |
| ource | hara | 0 |    |      | information. The codes are the same |
|       | cter |   |    |      | as in the *Source Code* field in    |
|       |      |   |    |      | ENROLLSC.dbf. This field can        |
|       |      |   |    |      | contain any combination of codes.   |
|       |      |   |    |      | Codes are:                          |
|       |      |   |    |      |                                     |
|       |      |   |    |      | A - benchmarking data               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | B - Medicaid claims data            |
|       |      |   |    |      |                                     |
|       |      |   |    |      | C - provider encounter data         |
|       |      |   |    |      |                                     |
|       |      |   |    |      | D - registry data                   |
|       |      |   |    |      |                                     |
|       |      |   |    |      | E - vaccine replacement data        |
|       |      |   |    |      |                                     |
|       |      |   |    |      | F - doses administered data         |
|       |      |   |    |      |                                     |
|       |      |   |    |      | G - prior ordering data             |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Z -- other                          |
+-------+------+---+----+------+-------------------------------------+
| All   | Num  | 7 | 0  | *    | Total children under 1 year of age  |
| kids1 | eric |   |    | *X** | receiving immunizations. The sum of |
|       |      |   |    |      | VFCkids1, G317kids1, and Statekids1 |
|       |      |   |    |      | must be less than or equal to the   |
|       |      |   |    |      | total for Allkids1.                 |
|       |      |   |    |      |                                     |
|       |      |   |    |      | This data is maintained on the      |
|       |      |   |    |      | VACMAN *Enrollment* screen.         |
+-------+------+---+----+------+-------------------------------------+
| Medi  | Num  | 7 | 0  |      | Number of children under 1 year of  |
| caid1 | eric |   |    |      | age qualifying for Medicaid         |
+-------+------+---+----+------+-------------------------------------+
| Unins | Num  | 7 | 0  |      | Number of children under 1 year of  |
| ured1 | eric |   |    |      | age uninsured for health care       |
+-------+------+---+----+------+-------------------------------------+
| Amin  | Num  | 7 | 0  |      | Number of American Indian and       |
| dian1 | eric |   |    |      | Alaskan Native children under 1     |
|       |      |   |    |      | year of age                         |
+-------+------+---+----+------+-------------------------------------+
| Fqhc  | Num  | 7 | 0  |      | Number of children under 1 year of  |
| _rhc1 | eric |   |    |      | age underinsured (no coverage for   |
|       |      |   |    |      | immunizations) AND are served in a  |
|       |      |   |    |      | Federally Qualified Health Center   |
|       |      |   |    |      | (FQHC) or Rural Health Center (RHC) |
+-------+------+---+----+------+-------------------------------------+
| Vfc   | Num  | 7 | 0  | *    | Total children under 1 year of age  |
| kids1 | eric |   |    | *X** | who are VFC eligible. This amount   |
|       |      |   |    |      | should equal the number in the      |
|       |      |   |    |      | MEDICAID1, UNINSURED1, AMINDIAN1,   |
|       |      |   |    |      | and FQHC_RHC1 fields.               |
+-------+------+---+----+------+-------------------------------------+
| G317  | Num  | 7 | 0  | *    | Number of children under 1 year of  |
| kids1 | eric |   |    | *X** | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through direct assistance  |
|       |      |   |    |      | or G317 funds.                      |
+-------+------+---+----+------+-------------------------------------+
| State | Num  | 7 | 0  | *    | Number of children under 1 year of  |
| kids1 | eric |   |    | *X** | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through state/other funds. |
+-------+------+---+----+------+-------------------------------------+
| All   | Num  | 7 | 0  | *    | Age group is 1-18 if the            |
| kids2 | eric |   |    | *X** | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Total children in age group         |
|       |      |   |    |      | receiving immunizations. The sum of |
|       |      |   |    |      | VFCkids2, G317kids2, and Statekids2 |
|       |      |   |    |      | must be less than or equal to the   |
|       |      |   |    |      | total for Allkids2.                 |
|       |      |   |    |      |                                     |
|       |      |   |    |      | This data is maintained on the      |
|       |      |   |    |      | VACMAN *Enrollment* screen.         |
+-------+------+---+----+------+-------------------------------------+
| Medi  | Num  | 7 | 0  |      | Age group is 1-18 if the            |
| caid2 | eric |   |    |      | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of children in age group     |
|       |      |   |    |      | qualifying for Medicaid             |
+-------+------+---+----+------+-------------------------------------+
| Unins | Num  | 7 | 0  |      | Age group is 1-18 if the            |
| ured2 | eric |   |    |      | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of children in age group     |
|       |      |   |    |      | uninsured for health care           |
+-------+------+---+----+------+-------------------------------------+
| Amin  | Num  | 7 | 0  |      | Age group is 1-18 if the            |
| dian2 | eric |   |    |      | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of American Indian and       |
|       |      |   |    |      | Alaskan Native children in age      |
|       |      |   |    |      | group                               |
+-------+------+---+----+------+-------------------------------------+
| Fqhc  | Num  | 7 | 0  |      | Age group is 1-18 if the            |
| _rhc2 | eric |   |    |      | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of children in age group     |
|       |      |   |    |      | underinsured (no coverage for       |
|       |      |   |    |      | immunizations) AND are served in a  |
|       |      |   |    |      | Federally Qualified Health Center   |
|       |      |   |    |      | (FQHC) or Rural Health Center (RHC) |
+-------+------+---+----+------+-------------------------------------+
| Vfc   | Num  | 7 | 0  | *    | Age group is 1-18 if the            |
| kids2 | eric |   |    | *X** | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Total number of children in age     |
|       |      |   |    |      | group who are VFC eligible. This    |
|       |      |   |    |      | amount should equal the number in   |
|       |      |   |    |      | the MEDICAID2, UNINSURED2,          |
|       |      |   |    |      | AMINDIAN2, and FQHC_RHC2 fields.    |
+-------+------+---+----+------+-------------------------------------+
| G317  | Num  | 7 | 0  | *    | Age group is 1-18 if the            |
| kids2 | eric |   |    | *X** | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of children in age group not |
|       |      |   |    |      | eligible for VFC vaccines, but      |
|       |      |   |    |      | eligible for free vaccines through  |
|       |      |   |    |      | distribution of direct assistance   |
|       |      |   |    |      | or G317 funds.                      |
+-------+------+---+----+------+-------------------------------------+
| State | Num  | 7 | 0  | *    | Age group is 1-18 if the            |
| kids2 | eric |   |    | *X** | *Agedefine* field does not contain  |
|       |      |   |    |      | 1998. Age group is 1-6 if the       |
|       |      |   |    |      | *Agedefine* field does contain      |
|       |      |   |    |      | 1998.                               |
|       |      |   |    |      |                                     |
|       |      |   |    |      | Number of children in age group not |
|       |      |   |    |      | eligible for VFC vaccines, but      |
|       |      |   |    |      | eligible for free vaccines through  |
|       |      |   |    |      | State/other funds.                  |
+-------+------+---+----+------+-------------------------------------+
| All   | Num  | 7 | 0  | *    | Total children 7-18 years of age    |
| kids3 | eric |   |    | *X** | receiving immunizations. The sum of |
|       |      |   |    |      | VFCkids3, G317kids3, and Statekids3 |
|       |      |   |    |      | must be less than or equal to the   |
|       |      |   |    |      | total for Allkids3.                 |
|       |      |   |    |      |                                     |
|       |      |   |    |      | This data is maintained on the      |
|       |      |   |    |      | VACMAN *Enrollment* screen.         |
+-------+------+---+----+------+-------------------------------------+
| Medi  | Num  | 7 | 0  |      | Number of children 7-18 years of    |
| caid3 | eric |   |    |      | age qualifying for Medicaid         |
+-------+------+---+----+------+-------------------------------------+
| Unins | Num  | 7 | 0  |      | Number of children 7-18 years of    |
| ured3 | eric |   |    |      | age uninsured for health care       |
+-------+------+---+----+------+-------------------------------------+
| Amin  | Num  | 7 | 0  |      | Number of American Indian and       |
| dian3 | eric |   |    |      | Alaskan Native children 7-18 years  |
|       |      |   |    |      | of age                              |
+-------+------+---+----+------+-------------------------------------+
| Fqhc  | Num  | 7 | 0  |      | Number of children 7-18 years of    |
| _rhc3 | eric |   |    |      | age underinsured (no coverage for   |
|       |      |   |    |      | immunizations) AND are served in a  |
|       |      |   |    |      | Federally Qualified Health Center   |
|       |      |   |    |      | (FQHC) or Rural Health Center (RHC) |
+-------+------+---+----+------+-------------------------------------+
| Vfc   | Num  | 7 | 0  | *    | Total children 7-18 years of age    |
| kids3 | eric |   |    | *X** | who are VFC eligible. This amount   |
|       |      |   |    |      | should equal the number in the      |
|       |      |   |    |      | MEDICAID3, UNINSURED3, AMINDIAN3,   |
|       |      |   |    |      | and FQHC_RHC3 fields.               |
+-------+------+---+----+------+-------------------------------------+
| G317  | Num  | 7 | 0  | *    | Number of children 7-18 years of    |
| kids3 | eric |   |    | *X** | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through direct assistance  |
|       |      |   |    |      | or G317 funds.                      |
+-------+------+---+----+------+-------------------------------------+
| State | Num  | 7 | 0  |      | Number of children 7-18 years of    |
| kids3 | eric |   |    |      | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through State/other funds. |
+-------+------+---+----+------+-------------------------------------+
| All   | Num  | 7 | 0  | *    | Optional user-selected field. Total |
| kids4 | eric |   |    | *X** | of children over 18 years of age    |
|       |      |   |    |      | receiving immunizations. The sum of |
|       |      |   |    |      | VFCkids4, G317kids4, and Statekids4 |
|       |      |   |    |      | must be less than or equal to the   |
|       |      |   |    |      | total for Allkids4.                 |
|       |      |   |    |      |                                     |
|       |      |   |    |      | This data is maintained on the      |
|       |      |   |    |      | VACMAN *Enrollment* screen.         |
+-------+------+---+----+------+-------------------------------------+
| Medi  | Num  | 7 | 0  |      | Optional user-selected field.       |
| caid4 | eric |   |    |      | Number of children over 18 years of |
|       |      |   |    |      | age qualifying for Medicaid         |
+-------+------+---+----+------+-------------------------------------+
| Unins | Num  | 7 | 0  |      | Optional user-selected field.       |
| ured4 | eric |   |    |      | Number of children over 18 years of |
|       |      |   |    |      | age uninsured for health care       |
+-------+------+---+----+------+-------------------------------------+
| Amin  | Num  | 7 | 0  |      | Optional user-selected field.       |
| dian4 | eric |   |    |      | Number of American Indian and       |
|       |      |   |    |      | Alaskan Native children over 18     |
|       |      |   |    |      | years of age                        |
+-------+------+---+----+------+-------------------------------------+
| Fqhc  | Num  | 7 | 0  |      | Optional user-selected field.       |
| _rhc4 | eric |   |    |      | Number of children over 18 years of |
|       |      |   |    |      | age underinsured (no coverage for   |
|       |      |   |    |      | immunizations) AND are served in a  |
|       |      |   |    |      | Federally Qualified Health Center   |
|       |      |   |    |      | (FQHC) or Rural Health Center (RHC) |
+-------+------+---+----+------+-------------------------------------+
| Vfc   | Num  | 7 | 0  | *    | Optional user-selected field. Total |
| kids4 | eric |   |    | *X** | children over 18 years of age who   |
|       |      |   |    |      | are VFC eligible. This amount       |
|       |      |   |    |      | should equal the number in the      |
|       |      |   |    |      | MEDICAID4, UNINSURED4, AMINDIAN4,   |
|       |      |   |    |      | and FQHC_RHC4 fields.               |
+-------+------+---+----+------+-------------------------------------+
| G317  | Num  | 7 | 0  | *    | Optional user-selected field.       |
| kids4 | eric |   |    | *X** | Number of children over 18 years of |
|       |      |   |    |      | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through direct assistance  |
|       |      |   |    |      | or G317 funds.                      |
+-------+------+---+----+------+-------------------------------------+
| State | Num  | 7 | 0  |      | Optional user-selected field.       |
| kids4 | eric |   |    |      | Number of children over 18 years of |
|       |      |   |    |      | age not eligible for VFC vaccines,  |
|       |      |   |    |      | but eligible to receive free        |
|       |      |   |    |      | vaccines through State/other funds. |
+-------+------+---+----+------+-------------------------------------+
| Ch    | Date | 8 | 0  |      | Date the ENROLL record was last     |
| gdate |      |   |    |      | updated by the project.             |
+-------+------+---+----+------+-------------------------------------+
| U     | C    | 8 | 0  |      | User ID of person adding or editing |
| serid | hara |   |    |      | the ENROLL record. The ID is copied |
|       | cter |   |    |      | from the Security profile.          |
+-------+------+---+----+------+-------------------------------------+
| O     | Num  | 7 | 0  |      | Optional.                           |
| ther1 | eric |   |    |      |                                     |
+-------+------+---+----+------+-------------------------------------+
| O     | Num  | 7 | 0  |      | Optional.                           |
| ther2 | eric |   |    |      |                                     |
+-------+------+---+----+------+-------------------------------------+
| O     | Num  | 7 | 0  |      | Optional.                           |
| ther3 | eric |   |    |      |                                     |
+-------+------+---+----+------+-------------------------------------+
| O     | Num  | 7 | 0  |      | Optional.                           |
| ther4 | eric |   |    |      |                                     |
+-------+------+---+----+------+-------------------------------------+
| Las   | C    | 3 | 0  |      | Optional.                           |
| tname | hara | 5 |    |      |                                     |
|       | cter |   |    |      |                                     |
+-------+------+---+----+------+-------------------------------------+

**Field Descriptions -- Physicians data**[]{#__RefHeading___Toc150246150
.anchor}

Source Table in VACMAN: **physicn.dbf**

Figure 7. Field Descriptions -- Physicians.

+--------+------+---+----+------+-------------------------------------+
| *      | **Ty | * | ** | **Re | **physicn.dbf -- Field              |
| *Field | pe** | * | De | quir | Description**                       |
| Name** |      | S | c. | ed** |                                     |
|        |      | i | ** |      |                                     |
|        |      | z |    |      |                                     |
|        |      | e |    |      |                                     |
|        |      | * |    |      |                                     |
|        |      | * |    |      |                                     |
+========+======+===+====+======+=====================================+
| PIN    | C    | 6 | 0  | *    | Provider identification number.     |
|        | hara |   |    | *X** | This identification must exist in   |
|        | cter |   |    |      | the VACMAN system, and the provider |
|        |      |   |    |      | must be an active VACMAN provider.  |
|        |      |   |    |      | This field is right‑justified.      |
|        |      |   |    |      |                                     |
|        |      |   |    |      | The *PIN* field is the primary key  |
|        |      |   |    |      | for the enroll table and must not   |
|        |      |   |    |      | be altered; this could prevent the  |
|        |      |   |    |      | record from matching.               |
+--------+------+---+----+------+-------------------------------------+
| Physid | C    | 1 | 0  |      | Optional user-defined physician     |
|        | hara | 2 |    |      | identification field. This field is |
|        | cter |   |    |      | assigned using the *Setup* tab --   |
|        |      |   |    |      | *Define Names* screen. This field   |
|        |      |   |    |      | can be used for an additional       |
|        |      |   |    |      | project-defined ID of the           |
|        |      |   |    |      | physician. The name assigned to     |
|        |      |   |    |      | this category is stored in the      |
|        |      |   |    |      | *Udphysid* field in the OWNREF.dbf  |
|        |      |   |    |      | table.                              |
+--------+------+---+----+------+-------------------------------------+
| La     | C    | 2 | 0  | *    | Physician's last name.              |
| stname | hara | 0 |    | *X** |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Fir    | C    | 1 | 0  |      | Physician's first name.             |
| stname | hara | 5 |    |      |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| I      | C    | 1 | 0  |      | Physician's middle initial.         |
| nitial | hara |   |    |      |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Title  | C    | 9 | 0  |      | Physician's title; e.g., MD.        |
|        | hara |   |    |      |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Other1 | C    | 1 | 0  |      | Optional user-defined field. This   |
|        | hara | 2 |    |      | field is assigned using the *Setup* |
|        | cter |   |    |      | tab -- *Define Names* screen. This  |
|        |      |   |    |      | field can be used for project       |
|        |      |   |    |      | --needed information about the      |
|        |      |   |    |      | physician not served by other       |
|        |      |   |    |      | fields. The name assigned to this   |
|        |      |   |    |      | category is stored in the           |
|        |      |   |    |      | *Udother1* field in OWNREF.dbf      |
|        |      |   |    |      | table.                              |
+--------+------+---+----+------+-------------------------------------+
| Other2 | C    | 1 | 0  |      | Optional user-defined field. This   |
|        | hara | 2 |    |      | field is assigned using the *Setup* |
|        | cter |   |    |      | tab -- *Define Names* screen. This  |
|        |      |   |    |      | field can be used for project       |
|        |      |   |    |      | --needed information about the      |
|        |      |   |    |      | physician not served by other       |
|        |      |   |    |      | fields. The name assigned to this   |
|        |      |   |    |      | category is stored in the           |
|        |      |   |    |      | *Udother2* field in OWNREF.dbf.     |
+--------+------+---+----+------+-------------------------------------+
| Medi   | C    | 1 | 0  |      | Physician's Medicaid number.        |
| caidno | hara | 2 |    |      |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Medl   | C    | 1 | 0  |      | Physician's medical license number. |
| icense | hara | 2 |    |      |                                     |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| C      | Date | 8 | 0  |      | Date the physician's record was     |
| hgdate |      |   |    |      | last updated by the project.        |
+--------+------+---+----+------+-------------------------------------+
| Userid | C    | 8 | 0  |      | User ID of person adding or editing |
|        | hara |   |    |      | the physician record. The ID is     |
|        | cter |   |    |      | copied from the Security profile.   |
+--------+------+---+----+------+-------------------------------------+
| Addt   | Num  | 1 | 0  | *    | Stores value for "Add to Physician  |
| ocount | eric |   |    | *X** | Count?". Codes are:\                |
|        |      |   |    |      | 0 = No, 1 = Yes.                    |
+--------+------+---+----+------+-------------------------------------+
| Active | C    | 1 | 0  | *    | Contains "Y" or "N" to indicate     |
|        | hara |   |    | *X** | whether this is an active record.   |
|        | cter |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Date   | Date | 8 | 0  | *    | Date that provider's active status  |
| active |      |   |    | *X** | last changed.                       |
+--------+------+---+----+------+-------------------------------------+
| P      | Int  | 4 | 0  |      | Unique ID for record.               |
| hysnid | eger |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+

**Field Descriptions -- Provider Inventory
data**[]{#__RefHeading___Toc150246151 .anchor}

Source Table in VACMAN: **provhas.dbf**

Figure 8. Field Descriptions -- Provider Inventory data.

+--------+------+---+----+------+-------------------------------------+
| *      | **Ty | * | ** | **Re | **provhas.dbf -- Field              |
| *Field | pe** | * | De | quir | Description**                       |
| Name** |      | S | c. | ed** |                                     |
|        |      | i | ** |      |                                     |
|        |      | z |    |      |                                     |
|        |      | e |    |      |                                     |
|        |      | * |    |      |                                     |
|        |      | * |    |      |                                     |
+========+======+===+====+======+=====================================+
| PIN    | C    | 6 | 0  | *    | Provider identification number.     |
|        | hara |   |    | *X** | This identification must exist in   |
|        | cter |   |    |      | the VACMAN system, and the provider |
|        |      |   |    |      | must be an active VACMAN provider.  |
|        |      |   |    |      | This field is right‑justified.      |
+--------+------+---+----+------+-------------------------------------+
| Idate  | Date | 8 | 0  | *    | Date the inventory was done,        |
|        |      |   |    | *X** | usually the last day in a month or  |
|        |      |   |    |      | quarter (02/28/xx or 12/31/xx). The |
|        |      |   |    |      | date 01/01/01 is valid only as an   |
|        |      |   |    |      | initial inventory date, not as a    |
|        |      |   |    |      | periodic inventory date.            |
+--------+------+---+----+------+-------------------------------------+
| V      | C    | 8 | 0  | *    | Short name for vaccine types. This  |
| accine | hara |   |    | *X** | name must be in the *Vaccine* field |
|        | cter |   |    |      | in PVACCREF.dbf.                    |
+--------+------+---+----+------+-------------------------------------+
| Lot    | C    | 1 | 0  |      | Manufacturer's lot number;          |
|        | hara | 5 |    |      | optional. Providers may report      |
|        | cter |   |    |      | inventory by lot number or by       |
|        |      |   |    |      | vaccine type.                       |
+--------+------+---+----+------+-------------------------------------+
| Po     | Num  | 2 | 0  |      | Not in use.                         |
| sition | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Doses  | Num  | 8 | 0  |      | Number of doses reported in         |
|        | eric |   |    |      | inventory for this date and vaccine |
|        |      |   |    |      | type (and optionally, lot number).  |
+--------+------+---+----+------+-------------------------------------+
| C      | Date | 8 | 0  |      | Date the record was last changed.   |
| hgdate |      |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Userid | C    | 8 | 0  |      | ID of the user who last changed the |
|        | hara |   |    |      | record. The ID is copied from the   |
|        | cter |   |    |      | Security profile.                   |
+--------+------+---+----+------+-------------------------------------+
| Pro    | Int  | 4 | 0  |      | Unique identifier assigned to the   |
| vhasid | eger |   |    |      | record by VACMAN.                   |
|        |      |   |    |      |                                     |
|        |      |   |    |      | The provhasid is the primary key    |
|        |      |   |    |      | for the provider inventory table    |
|        |      |   |    |      | and must not be altered; this could |
|        |      |   |    |      | prevent the record from matching.   |
+--------+------+---+----+------+-------------------------------------+
| NDCNO  | C    | 1 | 0  |      | National Drug Code (NDC) number.    |
|        | hara | 6 |    |      | Unique number assigned to each      |
|        | cter |   |    |      | vaccine manufacturer, per the       |
|        |      |   |    |      | applicable CDC contract             |
|        |      |   |    |      | (VACCBULK.dbf)                      |
|        |      |   |    |      |                                     |
|        |      |   |    |      | This field is not applicable for    |
|        |      |   |    |      | non-CDC orders                      |
+--------+------+---+----+------+-------------------------------------+
| Va     | Log  | 1 | 0  |      | True = CDC, False = Non-CDC         |
| c_Type | ical |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+

**Field Descriptions -- Doses Administered
data**[]{#__RefHeading___Toc150246152 .anchor}

Source Table in VACMAN: **dosesadm.dbf**

Figure 9. Field Descriptions -- Doses Administered data.

+--------+------+---+----+------+-------------------------------------+
| *      | **Ty | * | ** | **Re | **dosesadm.dbf -- Field             |
| *Field | pe** | * | De | quir | Description**                       |
| Name** |      | S | c. | ed** |                                     |
|        |      | i | ** |      |                                     |
|        |      | z |    |      |                                     |
|        |      | e |    |      |                                     |
|        |      | * |    |      |                                     |
|        |      | * |    |      |                                     |
+========+======+===+====+======+=====================================+
| ADATE  | Date | 8 | 0  | *    | Last day of the period (such as     |
|        |      |   |    | *X** | month or quarter) being reported.   |
+--------+------+---+----+------+-------------------------------------+
| PIN    | C    | 6 | 0  | *    | Provider identification number.     |
|        | hara |   |    | *X** | This identification must exist in   |
|        | cter |   |    |      | the VACMAN system, and the provider |
|        |      |   |    |      | must be an active VACMAN provider.  |
|        |      |   |    |      | This field is right‑justified.      |
+--------+------+---+----+------+-------------------------------------+
| Sector | Num  | 1 | 0  |      | Code for vaccine sector type. Codes |
|        | eric |   |    |      | are:                                |
|        |      |   |    |      |                                     |
|        |      |   |    |      | 1 - public provider doses           |
|        |      |   |    |      |                                     |
|        |      |   |    |      | 2 - private provider doses          |
+--------+------+---+----+------+-------------------------------------+
| V      | C    | 8 | 0  | *    | Short name for vaccine types. This  |
| accine | hara |   |    | *X** | name must be in the *Vaccine* field |
|        | cter |   |    |      | in PVACCREF.dbf.                    |
+--------+------+---+----+------+-------------------------------------+
| Po     | Num  | 2 | 0  |      | Source code for the re-defined age  |
| sition | eric |   |    |      | categories. Codes are:              |
|        |      |   |    |      |                                     |
|        |      |   |    |      | 1 - re-defined, post-1998 age       |
|        |      |   |    |      | categories                          |
|        |      |   |    |      |                                     |
|        |      |   |    |      | blank - original, pre-1998 age      |
|        |      |   |    |      | categories                          |
+--------+------+---+----+------+-------------------------------------+
| Dose   | Num  | 1 | 0  | *    | Number of doses in the series for a |
|        | eric |   |    | *X** | vaccine (1^st^ dose, 2^nd^ dose,    |
|        |      |   |    |      | etc.)                               |
+--------+------+---+----+------+-------------------------------------+
| G1     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 1 (less than 1 year of     |
|        |      |   |    |      | age)                                |
+--------+------+---+----+------+-------------------------------------+
| G2     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 2 (1 year of age)          |
+--------+------+---+----+------+-------------------------------------+
| G3     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 3 (2 years of age)         |
+--------+------+---+----+------+-------------------------------------+
| G4     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 4 (3 -- 4 years of age)    |
+--------+------+---+----+------+-------------------------------------+
| G5     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 5 (5 years of age)         |
+--------+------+---+----+------+-------------------------------------+
| G6     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 6 (6 -- 9 years of age)    |
+--------+------+---+----+------+-------------------------------------+
| G7     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 7 (10 -- 14 years of age)  |
+--------+------+---+----+------+-------------------------------------+
| G8     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 8 (15 -- 19 years of age)  |
+--------+------+---+----+------+-------------------------------------+
| G9     | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 9 (20 -- 24 years of age)  |
+--------+------+---+----+------+-------------------------------------+
| G10    | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 10 (25 -- 44 years of age) |
+--------+------+---+----+------+-------------------------------------+
| G11    | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 11 (45 -- 64 years of age) |
+--------+------+---+----+------+-------------------------------------+
| G12    | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 12 (65 years of age or     |
|        |      |   |    |      | greater)                            |
+--------+------+---+----+------+-------------------------------------+
| G13    | Num  | 7 | 0  |      | Number of doses administered to age |
|        | eric |   |    |      | category 13 (unknown age)           |
+--------+------+---+----+------+-------------------------------------+
| Rowtot | Num  | 1 | 0  |      | Total number of doses administered  |
|        | eric | 0 |    |      | for age categories 1 -- 13          |
+--------+------+---+----+------+-------------------------------------+
| Dauzr1 | Num  | 7 | 0  |      | First optional user-defined field.  |
|        | eric |   |    |      | This field is assigned on the       |
|        |      |   |    |      | *Setup* tab -- *Define Names*       |
|        |      |   |    |      | screen. This field can be used for  |
|        |      |   |    |      | project analysis in doses           |
|        |      |   |    |      | administered data and related       |
|        |      |   |    |      | reports. The name must be in the    |
|        |      |   |    |      | *Uzr1da* field in OWNREF.dbf.       |
+--------+------+---+----+------+-------------------------------------+
| Dauzr2 | Num  | 7 | 0  |      | Second optional user-defined field. |
|        | eric |   |    |      | . This field is assigned on the     |
|        |      |   |    |      | *Setup* tab -- *Define Names*       |
|        |      |   |    |      | screen. This field can be used for  |
|        |      |   |    |      | project analysis in doses           |
|        |      |   |    |      | administered data and related       |
|        |      |   |    |      | reports. The name must be in the    |
|        |      |   |    |      | *Uzr2da* field in OWNREF.dbf.       |
+--------+------+---+----+------+-------------------------------------+
| Dauzr3 | Num  | 7 | 0  |      | Third optional user-defined field.  |
|        | eric |   |    |      | This field is assigned on the       |
|        |      |   |    |      | *Setup* tab -- *Define Names*       |
|        |      |   |    |      | screen. This field can be used for  |
|        |      |   |    |      | project analysis in doses           |
|        |      |   |    |      | administered data and related       |
|        |      |   |    |      | reports. The name must be in the    |
|        |      |   |    |      | *Uzr3da* field in OWNREF.dbf.       |
+--------+------+---+----+------+-------------------------------------+
| C      | Date | 8 | 0  |      | Date the record was last changed.   |
| hgdate |      |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Userid | C    | 8 | 0  |      | ID of the user who last changed the |
|        | hara |   |    |      | record. The ID is copied from the   |
|        | cter |   |    |      | Security profile.                   |
+--------+------+---+----+------+-------------------------------------+
| Dauzr4 | Num  | 7 | 0  |      | Optional user-defined field.        |
|        | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Dauzr5 | Num  | 7 | 0  |      | Optional user-defined field.        |
|        | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Dauzr6 | Num  | 7 | 0  |      | Optional user-defined field.        |
|        | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Dauzr7 | Num  | 7 | 0  |      | Optional user-defined field.        |
|        | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Dauzr8 | Num  | 7 | 0  |      | Optional user-defined field.        |
|        | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Da     | Num  | 8 | 0  |      | Total, all DAUZR fields.            |
| uzrtot | eric |   |    |      |                                     |
+--------+------+---+----+------+-------------------------------------+
| Dose   | Int  | 4 | 0  |      | Unique ID for record. The           |
| sadmid | eger |   |    |      | dosesadmid is the primary key for   |
|        |      |   |    |      | the dosesadm table and must not be  |
|        |      |   |    |      | altered; this could prevent the     |
|        |      |   |    |      | record from matching.               |
+--------+------+---+----+------+-------------------------------------+
| Va     | Log  | 1 | 0  |      | Identifies vaccine type as either   |
| c_Type | ical |   |    |      | CDC or non-CDC vaccine.             |
+--------+------+---+----+------+-------------------------------------+
| NDCNO  | C    | 1 | 0  |      | National Drug Code (NDC) number.    |
|        | hara | 6 |    |      | Unique number assigned to each      |
|        | cter |   |    |      | vaccine manufacturer, per the       |
|        |      |   |    |      | applicable CDC contract             |
|        |      |   |    |      | (VACCBULK.dbf)                      |
|        |      |   |    |      |                                     |
|        |      |   |    |      | This field is not applicable for    |
|        |      |   |    |      | non-CDC orders                      |
+--------+------+---+----+------+-------------------------------------+

**Field Descriptions --Provider Orders**[]{#__RefHeading___Toc150246153
.anchor}

Source Table in VACMAN: **neworder.dbf** Import Type: **Add New
Records**

Figure 10. Field Descriptions -- Provider Orders.

+--------+-----+---+----+------+-------------------------------------+
| *      | **  | * | ** | **Re | **neworder.dbf -- Field             |
| *Field | Typ | * | De | quir | Description**                       |
| Name** | e** | S | c. | ed** |                                     |
|        |     | i | ** |      |                                     |
|        |     | z |    |      |                                     |
|        |     | e |    |      |                                     |
|        |     | * |    |      |                                     |
|        |     | * |    |      |                                     |
+========+=====+===+====+======+=====================================+
| R      | Cha | 1 | 0  | *    | Type of record. For Provider        |
| ectype | rac |   |    | *X** | orders, the value must be 5. Codes  |
|        | ter |   |    |      | are:                                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | > 1 -- Bulk order (manufacturer to  |
|        |     |   |    |      | > distributor). Cannot Import into  |
|        |     |   |    |      | > VACMAN.                           |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 2 -- Direct ship order            |
|        |     |   |    |      | > (manufacturer to provider)        |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 3 -- Non-CDC inventory            |
|        |     |   |    |      | > (manufacturer or distributor, to  |
|        |     |   |    |      | > distributor or project). Cannot   |
|        |     |   |    |      | > Import into VACMAN.               |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 4 -- Return viable vaccine        |
|        |     |   |    |      | > (provider to manufacturer or      |
|        |     |   |    |      | > distributor                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | **5 -- Provider order (distributor  |
|        |     |   |    |      | to provider)**                      |
+--------+-----+---+----+------+-------------------------------------+
| PIN    | Cha | 6 | 0  | *    | Provider identification number.     |
|        | rac |   |    | *X** | This identification must exist in   |
|        | ter |   |    |      | the VACMAN system, and the provider |
|        |     |   |    |      | must be an active VACMAN provider.  |
|        |     |   |    |      | This field is right-justified.      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The provider must be eligible to    |
|        |     |   |    |      | receive direct shipments. Contact,  |
|        |     |   |    |      | shipping, and address information   |
|        |     |   |    |      | for the provider on the *Data* tab  |
|        |     |   |    |      | -- *Providers* *Address* screen,    |
|        |     |   |    |      | must be complete.                   |
+--------+-----+---+----+------+-------------------------------------+
| O      | D   | 8 | 0  | *    | Date that an order, that is to be   |
| rddate | ate |   |    | *X** | transmitted to CDC, was entered.    |
|        |     |   |    |      | Value must be no more than 30 days  |
|        |     |   |    |      | prior to the current date.          |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Ordnum | Cha | 1 | 0  |      | Optional field for CDC bulk vaccine |
|        | rac | 0 |    |      | orders. Local order number assigned |
|        | ter |   |    |      | by the project.                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 8 | 0  | *    | Doses. Number of doses ordered for  |
| rddose | ume |   |    | *X** | an order that is to be transmitted  |
|        | ric |   |    |      | to CDC. Must be an even multiple of |
|        |     |   |    |      | the package size, per the           |
|        |     |   |    |      | applicable CDC contract             |
|        |     |   |    |      | (VACCBULK.dbf).                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Value must be equal to the value    |
|        |     |   |    |      | for the *fcode1* (funding code 1)   |
|        |     |   |    |      | field.                              |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Total varicella order cannot exceed |
|        |     |   |    |      | a cost of \$25,000.                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Ordpin | Cha | 6 | 0  |      | Not used; null.                     |
|        | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 4 | 0  |      | Number of doses per vial ordered.   |
| rdsize | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Size   | N   | 6 | 0  | *    | Number of doses per package, per    |
|        | ume |   |    | *X** | the applicable CDC contract         |
|        | ric |   |    |      | (VACCBULK.dbf).                     |
+--------+-----+---+----+------+-------------------------------------+
| V      | Cha | 8 | 0  | *    | Short name for vaccine types.       |
| accine | rac |   |    | *X** |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Maker  | Cha | 8 | 0  | *    | Vaccine manufacturer's name. The    |
|        | rac |   |    | *X** | name must be in the *Maker* field   |
|        | ter |   |    |      | in SUPPLIER.dbf.                    |
+--------+-----+---+----+------+-------------------------------------+
| Cost   | N   | 9 | 4  | *    | Actual cost per dose, per the       |
|        | ume |   |    | *X** | applicable CDC contract             |
|        | ric |   |    |      | (VACCBULK.dbf). This is used in     |
|        |     |   |    |      | computing the value of inventory    |
|        |     |   |    |      | and shipments.                      |
+--------+-----+---+----+------+-------------------------------------+
| Co     | Cha | 1 | 0  | *    | Federal contract number. Typical    |
| ntract | rac | 5 |    | *X** | form is: 200-95-0001. Value must    |
|        | ter |   |    |      | match the *Contract* field value in |
|        |     |   |    |      | the applicable VACCBULK.dbf table.  |
+--------+-----+---+----+------+-------------------------------------+
| Fcode1 | Cha | 1 | 0  | *    | Funding code. The first three codes |
|        | rac |   |    | *X** | are set by CDC. An unlimited number |
|        | ter |   |    |      | of other codes can be defined. Use  |
|        |     |   |    |      | the *Setup* tab - *Funding* screen  |
|        |     |   |    |      | to change certain information on    |
|        |     |   |    |      | the three CDC codes and to define   |
|        |     |   |    |      | additional codes. Codes are:        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 1 - VFC funds                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 2 - G317 funds                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 3 - state funds                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The codes must be in the *Fund      |
|        |     |   |    |      | Code* field in FUNDING.dbf.         |
+--------+-----+---+----+------+-------------------------------------+
| Fdose1 | N   | 8 | 0  | *    | Number of doses ordered or          |
|        | ume |   |    | *X** | received/shipped.                   |
|        | ric |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | value is 1 or 3, this field equals  |
|        |     |   |    |      | the number of doses ordered         |
|        |     |   |    |      | (ORDDOSE). Once the vaccine is      |
|        |     |   |    |      | received, this field is updated to  |
|        |     |   |    |      | the number of doses received        |
|        |     |   |    |      | (DOSES).                            |
|        |     |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | value is 2, 4, or 5, this field     |
|        |     |   |    |      | equals the number of doses ordered  |
|        |     |   |    |      | (ORDDOSE). Once the vaccine is      |
|        |     |   |    |      | shipped, this field is updated to   |
|        |     |   |    |      | the number of doses shipped         |
|        |     |   |    |      | (DOSES).                            |
+--------+-----+---+----+------+-------------------------------------+
| Note   | Cha | 5 | 0  |      | Notes on this order                 |
|        | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| C      | D   | 8 | 0  |      | Date the record was last changed.   |
| hgdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| S      | Cha | 3 | 0  |      | State purchase order number entered |
| tatepo | rac | 2 |    |      | by the project for state funded     |
|        | ter |   |    |      | orders. If the *fcode1* field value |
|        |     |   |    |      | is other than 1 or 2, the state     |
|        |     |   |    |      | P.O. number is required.            |
+--------+-----+---+----+------+-------------------------------------+
| Userid | Cha | 8 | 0  |      | ID of the user who last changed the |
|        | rac |   |    |      | record. The ID is copied from the   |
|        | ter |   |    |      | Security profile.                   |
+--------+-----+---+----+------+-------------------------------------+
| Ndcno  | Cha | 1 | 0  | *    | Unique number assigned to each      |
|        | rac | 6 |    | *X** | vaccine manufacturer. The value     |
|        | ter |   |    |      | must match a record in the          |
|        |     |   |    |      | VACCBULK.dbf table.                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is blank for non-CDC     |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Exctax | N   | 9 | 4  |      | Future use                          |
|        | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Seekid | N   | 9 | 0  |      | Unique ID for record; must be blank |
|        | ume |   |    |      | or record will be rejected.         |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Xm     | D   | 8 | 0  |      | Transmit date, must be blank or     |
| itdate | ate |   |    |      | record will be rejected.            |
+--------+-----+---+----+------+-------------------------------------+
| Urgent | L   | 1 | 0  |      | If checked, specifies that the      |
|        | ogi |   |    |      | order receive expedited handling.   |
|        | cal |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| D      | Cha | 5 | 0  |      | Describes the vaccine code.         |
| escrip | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ord    | Cha | 1 | 0  | X    | Identifies the order as Federal or  |
| erType | rac |   |    |      | Non-Federal (F/N)                   |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+

**Field Descriptions -- Direct Ship -- Archive or
Update**[]{#__RefHeading___Toc150246154 .anchor}

Source Table in VACMAN: **stock.dbf**

Import Type: **Import Archived Records** or **Update Existing Records**

Figure 11. Field Descriptions -- Import Direct Ship data -- Archived
Records or Update Existing Records.

+--------+-----+---+----+------+-------------------------------------+
| *      | **  | * | ** | **Re | **stock.dbf -- Field Description**  |
| *Field | Typ | * | De | quir |                                     |
| Name** | e** | S | c. | ed** |                                     |
|        |     | i | ** |      |                                     |
|        |     | z |    |      |                                     |
|        |     | e |    |      |                                     |
|        |     | * |    |      |                                     |
|        |     | * |    |      |                                     |
+========+=====+===+====+======+=====================================+
| R      | Cha | 1 | 0  | *    | Type of record. For Direct Ship     |
| ectype | rac |   |    | *X** | Orders, the value must be 2. Codes  |
|        | ter |   |    |      | are:                                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | > 1 - Bulk order (manufacturer to   |
|        |     |   |    |      | > distributor). Cannot Import into  |
|        |     |   |    |      | > VACMAN.                           |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > **2 - Direct ship order           |
|        |     |   |    |      | > (manufacturer to provider)**      |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 3 -- Non-CDC inventory            |
|        |     |   |    |      | > (manufacturer or distributor, to  |
|        |     |   |    |      | > distributor or project). Cannot   |
|        |     |   |    |      | > Import into VACMAN.               |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 4 -- Return viable vaccine        |
|        |     |   |    |      | > (provider to manufacturer or      |
|        |     |   |    |      | > distributor. Cannot Import into   |
|        |     |   |    |      | > VACMAN.                           |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 5 -- Provider order (distributor  |
|        |     |   |    |      | > to provider).                     |
+--------+-----+---+----+------+-------------------------------------+
| PIN    | Cha | 6 | 0  | *    | Provider identification number.     |
|        | rac |   |    | *X** | This identification must exist in   |
|        | ter |   |    |      | the VACMAN system, and the provider |
|        |     |   |    |      | must be an active VACMAN provider.  |
|        |     |   |    |      | This field is right-justified.      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The provider must be eligible to    |
|        |     |   |    |      | receive direct shipments. Contact,  |
|        |     |   |    |      | shipping, and address information   |
|        |     |   |    |      | for the provider on the *Data*      |
|        |     |   |    |      | tab - *Providers* *Address* screen, |
|        |     |   |    |      | must be complete.                   |
+--------+-----+---+----+------+-------------------------------------+
| O      | D   | 8 | 0  | *    | Date that an order, that is to be   |
| rddate | ate |   |    | *X** | transmitted to CDC, was entered.    |
|        |     |   |    |      | Value must be within 30 days of the |
|        |     |   |    |      | current date.                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Ordnum | Cha | 1 | 0  |      | Optional field for CDC bulk vaccine |
|        | rac | 0 |    |      | orders. Local order number assigned |
|        | ter |   |    |      | by the project.                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 8 | 0  | *    | Number of doses ordered for an      |
| rddose | ume |   |    | *X** | order that is to be transmitted to  |
|        | ric |   |    |      | CDC. Total order cannot exceed a    |
|        |     |   |    |      | cost of \$25,000. Must be an even   |
|        |     |   |    |      | multiple of the package size, per   |
|        |     |   |    |      | the applicable CDC contract         |
|        |     |   |    |      | (VACCBULK.dbf).                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Xm     | D   | 8 | 0  |      | Date that an order was transmitted  |
| itdate | ate |   |    |      | to CDC.                             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Datein | D   | 8 | 0  |      | If the code in the *Rectype* field  |
|        | ate |   |    |      | is 1 or 3, this is the date the     |
|        |     |   |    |      | project received the vaccine order. |
|        |     |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | is 2, 4, or 5, this is the date the |
|        |     |   |    |      | manufacturer/distributor shipped    |
|        |     |   |    |      | the order.                          |
+--------+-----+---+----+------+-------------------------------------+
| R      | D   | 8 | 0  |      | Date that receiving information for |
| cvxmit | ate |   |    |      | a CDC vaccine order was transmitted |
|        |     |   |    |      | to CDC.                             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Timein | Cha | 5 | 0  |      | Time that the project received the  |
|        | rac |   |    |      | order and placed it in inventory.   |
|        | ter |   |    |      | There is no distinction between AM  |
|        |     |   |    |      | and PM hours. An assumption is made |
|        |     |   |    |      | based on standard business hours    |
|        |     |   |    |      | (for example, 08:00 is 8:00 AM and  |
|        |     |   |    |      | 06:00 is 6:00 PM.                   |
+--------+-----+---+----+------+-------------------------------------+
| Signee | Cha | 2 | 0  |      | If the code in the *Rectype* field  |
|        | rac | 5 |    |      | is 1 or 3, this is the person       |
|        | ter |   |    |      | receiving the vaccine order.        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | is 2, 4, or 5, this field is        |
|        |     |   |    |      | optional. This information about    |
|        |     |   |    |      | the order is for project use only.  |
+--------+-----+---+----+------+-------------------------------------+
| V      | Cha | 8 | 0  | *    | Short name for vaccine types.       |
| accine | rac |   |    | *X** | Values are:                         |
|        | ter |   |    |      |                                     |
|        |     |   |    |      | VAR                                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | MMR-V                               |
|        |     |   |    |      |                                     |
|        |     |   |    |      | FLU                                 |
+--------+-----+---+----+------+-------------------------------------+
| Units  | N   | 8 | 0  |      | Number of vials received for a      |
|        | ume |   |    |      | vaccine order. The system           |
|        | ric |   |    |      | calculates this field by dividing   |
|        |     |   |    |      | the amount in the *Doses* field by  |
|        |     |   |    |      | the amount in the *Size* field.     |
+--------+-----+---+----+------+-------------------------------------+
| Size   | N   | 6 | 0  |      | Number of doses per vial.           |
|        | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Doses  | N   | 8 | 0  |      | The number of doses shipped or      |
|        | ume |   |    |      | received.                           |
|        | ric |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | is 1 or 3, this is the number of    |
|        |     |   |    |      | doses received.                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | is 2, 4, or 5, this is the number   |
|        |     |   |    |      | of doses shipped.                   |
+--------+-----+---+----+------+-------------------------------------+
| Maker  | Cha | 8 | 0  | *    | Vaccine manufacturer's name. Value  |
|        | rac |   |    | *X** | must match the maker of the vaccine |
|        | ter |   |    |      | specified per the applicable CDC    |
|        |     |   |    |      | contract (VACCBULK.dbf).            |
+--------+-----+---+----+------+-------------------------------------+
| Lot    | Cha | 1 | 0  | Man  |                                     |
|        | rac | 5 |    | ufac |                                     |
|        | ter |   |    | ture |                                     |
|        |     |   |    | r\'s |                                     |
|        |     |   |    | lot  |                                     |
|        |     |   |    | nu   |                                     |
|        |     |   |    | mber |                                     |
|        |     |   |    | (nu  |                                     |
|        |     |   |    | mber |                                     |
|        |     |   |    | on   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | out  |                                     |
|        |     |   |    | side |                                     |
|        |     |   |    | of   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | box  |                                     |
|        |     |   |    | co   |                                     |
|        |     |   |    | ntai |                                     |
|        |     |   |    | ning |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | v    |                                     |
|        |     |   |    | acci |                                     |
|        |     |   |    | ne). |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | Cha  |                                     |
|        |     |   |    | nges |                                     |
|        |     |   |    | to   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | va   |                                     |
|        |     |   |    | lues |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | this |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | ield |                                     |
|        |     |   |    | sh   |                                     |
|        |     |   |    | ould |                                     |
|        |     |   |    | be   |                                     |
|        |     |   |    | made |                                     |
|        |     |   |    | to   |                                     |
|        |     |   |    | rel  |                                     |
|        |     |   |    | ated |                                     |
|        |     |   |    | rec  |                                     |
|        |     |   |    | ords |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | dist |                                     |
|        |     |   |    | ribu |                                     |
|        |     |   |    | tion |                                     |
|        |     |   |    | ta   |                                     |
|        |     |   |    | ble. |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Expiry | D   | 8 | 0  |      | Date the vaccine will expire. If    |
|        | ate |   |    |      | only the month and year are         |
|        |     |   |    |      | available, use the last day of the  |
|        |     |   |    |      | month.                              |
+--------+-----+---+----+------+-------------------------------------+
| Cost   | N   | 9 | 4  | *    | Actual cost per dose, per the       |
|        | ume |   |    | *X** | applicable CDC contract             |
|        | ric |   |    |      | (VACCBULK.dbf). This is used to     |
|        |     |   |    |      | compute the value of inventory and  |
|        |     |   |    |      | shipments.                          |
+--------+-----+---+----+------+-------------------------------------+
| Co     | Cha | 1 | 0  | *    | Federal contract number of the CDC  |
| ntract | rac | 5 |    | *X** | contract applicable to acquiring    |
|        | ter |   |    |      | the vaccine (VACCBULK.dbf). Typical |
|        |     |   |    |      | format is: 200-95-0001.             |
+--------+-----+---+----+------+-------------------------------------+
| Fcode1 | Cha | 1 | 0  | **X* |                                     |
|        | rac |   |    | *Fun |                                     |
|        | ter |   |    | ding |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | ode. |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | irst |                                     |
|        |     |   |    | t    |                                     |
|        |     |   |    | hree |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | odes |                                     |
|        |     |   |    | are  |                                     |
|        |     |   |    | set  |                                     |
|        |     |   |    | by   |                                     |
|        |     |   |    | CDC. |                                     |
|        |     |   |    | An   |                                     |
|        |     |   |    | u    |                                     |
|        |     |   |    | nlim |                                     |
|        |     |   |    | ited |                                     |
|        |     |   |    | nu   |                                     |
|        |     |   |    | mber |                                     |
|        |     |   |    | of   |                                     |
|        |     |   |    | o    |                                     |
|        |     |   |    | ther |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | odes |                                     |
|        |     |   |    | can  |                                     |
|        |     |   |    | be   |                                     |
|        |     |   |    | defi |                                     |
|        |     |   |    | ned. |                                     |
|        |     |   |    | Use  |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | *Se  |                                     |
|        |     |   |    | tup* |                                     |
|        |     |   |    | tab  |                                     |
|        |     |   |    | --   |                                     |
|        |     |   |    | *    |                                     |
|        |     |   |    | Fund |                                     |
|        |     |   |    | ing* |                                     |
|        |     |   |    | sc   |                                     |
|        |     |   |    | reen |                                     |
|        |     |   |    | to   |                                     |
|        |     |   |    | ch   |                                     |
|        |     |   |    | ange |                                     |
|        |     |   |    | cer  |                                     |
|        |     |   |    | tain |                                     |
|        |     |   |    | inf  |                                     |
|        |     |   |    | orma |                                     |
|        |     |   |    | tion |                                     |
|        |     |   |    | on   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | t    |                                     |
|        |     |   |    | hree |                                     |
|        |     |   |    | CDC  |                                     |
|        |     |   |    | co   |                                     |
|        |     |   |    | des, |                                     |
|        |     |   |    | and  |                                     |
|        |     |   |    | to   |                                     |
|        |     |   |    | de   |                                     |
|        |     |   |    | fine |                                     |
|        |     |   |    | ad   |                                     |
|        |     |   |    | diti |                                     |
|        |     |   |    | onal |                                     |
|        |     |   |    | co   |                                     |
|        |     |   |    | des. |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | CDC  |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | odes |                                     |
|        |     |   |    | are: |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 1 -  |                                     |
|        |     |   |    | VFC  |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | unds |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 2 -  |                                     |
|        |     |   |    | G317 |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | unds |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | 3 -  |                                     |
|        |     |   |    | sta  |                                     |
|        |     |   |    | te/o |                                     |
|        |     |   |    | ther |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | unds |                                     |
|        |     |   |    |      |                                     |
|        |     |   |    | The  |                                     |
|        |     |   |    | c    |                                     |
|        |     |   |    | odes |                                     |
|        |     |   |    | must |                                     |
|        |     |   |    | be   |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | the  |                                     |
|        |     |   |    | *    |                                     |
|        |     |   |    | Fund |                                     |
|        |     |   |    | C    |                                     |
|        |     |   |    | ode* |                                     |
|        |     |   |    | f    |                                     |
|        |     |   |    | ield |                                     |
|        |     |   |    | in   |                                     |
|        |     |   |    | FUND |                                     |
|        |     |   |    | ING. |                                     |
|        |     |   |    | dbf. |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fdose1 | N   | 8 | 0  |      | Prior to version 3.0: Number of     |
|        | ume |   |    |      | doses assigned to VFC funds.        |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fcode2 | Cha | 1 | 0  |      | Not in use.                         |
|        | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fdose2 | N   | 8 | 0  |      | Prior to version 3.0: Number of     |
|        | ume |   |    |      | doses assigned to G317 funds        |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fcode3 | Cha | 1 | 0  |      | Not in use.                         |
|        | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Fdose3 | N   | 8 | 0  |      | Prior to version 3.0: Number of     |
|        | ume |   |    |      | doses assigned to state funds       |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Uzr    | Cha | 1 | 0  |      | User-defined field; optional. This  |
|        | rac | 0 |    |      | field is assigned using the *Setup* |
|        | ter |   |    |      | tab -- *Define Names* screen, in    |
|        |     |   |    |      | the *Additional Inventory* field.   |
|        |     |   |    |      | Use the field for vaccine receipt   |
|        |     |   |    |      | information that is not served by   |
|        |     |   |    |      | other fields.                       |
+--------+-----+---+----+------+-------------------------------------+
| Remain | N   | 8 | 0  |      | Indicates the number of shipments   |
|        | ume |   |    |      | received. and which shipment is the |
|        | ric |   |    |      | current record. Used to track       |
|        |     |   |    |      | partial shipments (1 of 2, 2 of 2,  |
|        |     |   |    |      | etc.).                              |
+--------+-----+---+----+------+-------------------------------------+
| Seekid | N   | 9 | 0  |      | Unique, system-generated number     |
|        | ume |   |    |      | assigned to this record when the    |
|        | ric |   |    |      | order is transmitted to CDC.        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Cdcpo  | N   | 1 | 0  |      | Purchase order (delivery order)     |
|        | ume | 0 |    |      | number assigned by CDC when a       |
|        | ric |   |    |      | transmitted order is approved by    |
|        |     |   |    |      | CDC. This field is blank for        |
|        |     |   |    |      | non-CDC orders, and can be used to  |
|        |     |   |    |      | store a state/local purchase order  |
|        |     |   |    |      | number.                             |
+--------+-----+---+----+------+-------------------------------------+
| Podate | D   | 8 | 0  |      | CDC purchase order date; the date   |
|        | ate |   |    |      | when the transmitted order is       |
|        |     |   |    |      | approved, and assigned a purchase   |
|        |     |   |    |      | order number, by CDC.               |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Nipord | N   | 8 | 0  |      | Number of doses approved by CDC for |
|        | ume |   |    |      | a transmitted order.                |
|        | ric |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Status | Cha | 2 | 0  |      | Status code for an order that has   |
|        | rac |   |    |      | been transmitted to CDC. The codes  |
|        | ter |   |    |      | are the same as in the *Status*     |
|        |     |   |    |      | field in STATCODE.dbf. This field   |
|        |     |   |    |      | is optional for non-CDC orders.     |
|        |     |   |    |      | Codes are:                          |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 00 - unknown                        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 01 - pending (initial status, not   |
|        |     |   |    |      | yet processed)                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 02 - approved by CDC/NIP            |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 03 - obligated by CDC/FMO           |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 04 - submitted (forwarded to        |
|        |     |   |    |      | manufacturer)                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 05 - received in part (RCV record)  |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 06 - received in full (RCV record)  |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 07 - received in excess (RCV        |
|        |     |   |    |      | record)                             |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 08 - canceled                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 09 - held at CDC                    |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 10 - shipped in full                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 11 - reshipment                     |
+--------+-----+---+----+------+-------------------------------------+
| Note   | Cha | 5 | 0  |      | Optional. Special information about |
|        | rac | 0 |    |      | the order; for project use only.    |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| C      | D   | 8 | 0  |      | Date the record was last changed.   |
| hgdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| S      | Cha | 3 | 0  | *    | State purchase order number entered |
| tatepo | rac | 2 |    | *X** | by the project for state- funded    |
|        | ter |   |    |      | orders. This is required if the     |
|        |     |   |    |      | *fcode1* (funding code) field value |
|        |     |   |    |      | is other than 1 (VFC) or 2 (G317).  |
+--------+-----+---+----+------+-------------------------------------+
| Userid | Cha | 8 | 0  |      | Identification of the user who last |
|        | rac |   |    |      | changed the record. The ID is       |
|        | ter |   |    |      | copied from the Security profile.   |
+--------+-----+---+----+------+-------------------------------------+
| Rc     | D   | 8 | 0  |      | Date that the lot number or         |
| vchgdt | ate |   |    |      | expiration date was last changed    |
|        |     |   |    |      | for an order record that contains   |
|        |     |   |    |      | receiving data.                     |
+--------+-----+---+----+------+-------------------------------------+
| Ordpin | Cha | 6 | 0  | *    | Original PIN associated with an     |
|        | rac |   |    | *X** | order record. Must be equal to the  |
|        | ter |   |    |      | value in the *PIN* field.           |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 4 | 0  |      | Number of doses per vial.           |
| rdsize | ume |   |    |      |                                     |
|        | ric |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | orders.                             |
+--------+-----+---+----+------+-------------------------------------+
| Ndcno  | Cha | 1 | 0  | *    | National Drug Code (NDC) number.    |
|        | rac | 6 |    | *X** | Unique number assigned to each      |
|        | ter |   |    |      | vaccine manufacturer, per the       |
|        |     |   |    |      | applicable CDC contract             |
|        |     |   |    |      | (VACCBULK.dbf)                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is not applicable for    |
|        |     |   |    |      | non-CDC orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Exctax | N   | 9 | 4  |      | Future use                          |
|        | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ad     | N   | 1 | 0  |      | Add to inventory? Codes are: 0 --   |
| dtoinv | ume |   |    |      | no; 1 - yes.                        |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| S      | I   | 4 | 0  |      | Stock ID. System-generated unique   |
| tockid | nte |   |    |      | ID for the stock record. This is    |
|        | ger |   |    |      | the primary key for the stock table |
|        |     |   |    |      | and must not be altered in any way. |
+--------+-----+---+----+------+-------------------------------------+
| Tra    | Cha | 3 | 0  |      | Shipment tracking number; optional. |
| cking# | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Car    | Cha | 3 | 0  |      | Carrier identification; optional.   |
| rierID | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Distr  | Cha | 1 | 0  |      | Distributor identification.         |
| ibutor | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Urgent | L   | 1 | 0  |      | If checked, specifies that the      |
|        | ogi |   |    |      | order receive expedited handling.   |
|        | cal |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ord    | Cha | 1 | 0  | X    | Identifies the order as Federal or  |
| erType | rac |   |    |      | Non-Federal (F/N)                   |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+

**Field Descriptions --Direct Ship -- New
Orders**[]{#__RefHeading___Toc150246155 .anchor}

Source Table in VACMAN: **neworder.dbf** Import Type: **Add New
Records**

Figure 12. Field Descriptions -- Import Direct Ship data -- Add New
Records.

+--------+-----+---+----+------+-------------------------------------+
| *      | **  | * | ** | **Re | **neworder.dbf - Field              |
| *Field | Typ | * | De | quir | Description**                       |
| Name** | e** | S | c. | ed** |                                     |
|        |     | i | ** |      |                                     |
|        |     | z |    |      |                                     |
|        |     | e |    |      |                                     |
|        |     | * |    |      |                                     |
|        |     | * |    |      |                                     |
+========+=====+===+====+======+=====================================+
| R      | Cha | 1 | 0  | *    | Type of record. For Direct Ship     |
| ectype | rac |   |    | *X** | orders, the value must be 2. Codes  |
|        | ter |   |    |      | are:                                |
|        |     |   |    |      |                                     |
|        |     |   |    |      | > 1 - Bulk order (manufacturer to   |
|        |     |   |    |      | > distributor). Cannot Import into  |
|        |     |   |    |      | > VACMAN.                           |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > **2 - Direct ship order           |
|        |     |   |    |      | > (manufacturer to provider)**      |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 3 -- Non-CDC inventory            |
|        |     |   |    |      | > (manufacturer or distributor, to  |
|        |     |   |    |      | > distributor or project). Cannot   |
|        |     |   |    |      | > Import into VACMAN.               |
|        |     |   |    |      | >                                   |
|        |     |   |    |      | > 4 -- Return viable vaccine        |
|        |     |   |    |      | > (provider to manufacturer or      |
|        |     |   |    |      | > distributor.                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 5 -- Provider order (distributor to |
|        |     |   |    |      | provider)                           |
+--------+-----+---+----+------+-------------------------------------+
| PIN    | Cha | 6 | 0  | *    | Provider identification number.     |
|        | rac |   |    | *X** | This identification must exist in   |
|        | ter |   |    |      | the VACMAN system, and the provider |
|        |     |   |    |      | must be an active VACMAN provider.  |
|        |     |   |    |      | This field is right-justified.      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The provider must be eligible to    |
|        |     |   |    |      | receive direct shipments. Contact,  |
|        |     |   |    |      | shipping, and address information   |
|        |     |   |    |      | for the provider on the *Data*      |
|        |     |   |    |      | tab - *Providers* *Address* screen, |
|        |     |   |    |      | must be complete.                   |
+--------+-----+---+----+------+-------------------------------------+
| O      | D   | 8 | 0  | *    | Date that an order, that is to be   |
| rddate | ate |   |    | *X** | transmitted to CDC, was entered.    |
|        |     |   |    |      | Value must be within 30 days of the |
|        |     |   |    |      | current date.                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Ordnum | Cha | 1 | 0  |      | Optional field for CDC bulk vaccine |
|        | rac | 0 |    |      | orders. Local order number assigned |
|        | ter |   |    |      | by the project.                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 8 | 0  | *    | Doses. Number of doses ordered for  |
| rddose | ume |   |    | *X** | an order that is to be transmitted  |
|        | ric |   |    |      | to CDC. Must be an even multiple of |
|        |     |   |    |      | the package size, per the           |
|        |     |   |    |      | applicable CDC contract             |
|        |     |   |    |      | (VACCBULK.dbf).                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Must be equal to the value for the  |
|        |     |   |    |      | *fcode1* (funding code 1) field.    |
|        |     |   |    |      |                                     |
|        |     |   |    |      | Total varicella order cannot exceed |
|        |     |   |    |      | a cost of \$25,000.                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field is optional for non-CDC  |
|        |     |   |    |      | vaccine orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Ordpin | Cha | 6 | 0  |      | Not used; null.                     |
|        | rac |   |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| O      | N   | 4 | 0  |      | Number of doses per vial ordered.   |
| rdsize | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Size   | N   | 6 | 0  | *    | Number of doses per package, per    |
|        | ume |   |    | *X** | the applicable CDC contract         |
|        | ric |   |    |      | (VACCBULK.dbf).                     |
+--------+-----+---+----+------+-------------------------------------+
| V      | Cha | 8 | 0  | *    | Short name for vaccine types. The   |
| accine | rac |   |    | *X** | name must be in the *Vaccine* field |
|        | ter |   |    |      | in STOCK.dbf.                       |
+--------+-----+---+----+------+-------------------------------------+
| Maker  | Cha | 8 | 0  | *    | Vaccine manufacturer's name. The    |
|        | rac |   |    | *X** | name must be in the *Maker* field   |
|        | ter |   |    |      | in SUPPLIER.dbf.                    |
+--------+-----+---+----+------+-------------------------------------+
| Cost   | N   | 9 | 4  | *    | Actual cost per dose, per the       |
|        | ume |   |    | *X** | applicable CDC contract             |
|        | ric |   |    |      | (VACCBULK.dbf). This is used in     |
|        |     |   |    |      | computing the value of inventory    |
|        |     |   |    |      | and shipments.                      |
+--------+-----+---+----+------+-------------------------------------+
| Co     | Cha | 1 | 0  | *    | Federal contract number. Typical    |
| ntract | rac | 5 |    | *X** | form is: 200-95-0001. Value must    |
|        | ter |   |    |      | match the *Contract* field value in |
|        |     |   |    |      | the applicable VACCBULK.dbf table.  |
+--------+-----+---+----+------+-------------------------------------+
| Fcode1 | Cha | 1 | 0  | *    | Funding code. The first three codes |
|        | rac |   |    | *X** | are set by CDC. An unlimited number |
|        | ter |   |    |      | of other codes can be defined. Use  |
|        |     |   |    |      | the *Setup* tab - *Funding* screen  |
|        |     |   |    |      | to change certain information on    |
|        |     |   |    |      | the three CDC codes and to define   |
|        |     |   |    |      | additional codes. Codes are:        |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 1 - VFC funds                       |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 2 - G317 funds                      |
|        |     |   |    |      |                                     |
|        |     |   |    |      | 3 - state funds                     |
|        |     |   |    |      |                                     |
|        |     |   |    |      | The codes must be in the *Fund      |
|        |     |   |    |      | Code* field in FUNDING. dbf.        |
+--------+-----+---+----+------+-------------------------------------+
| Fdose1 | N   | 8 | 0  | *    | Number of doses ordered or          |
|        | ume |   |    | *X** | received/shipped.                   |
|        | ric |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | value is 1 or 3, this field equals  |
|        |     |   |    |      | the number of doses ordered         |
|        |     |   |    |      | (ORDDOSE). Once the vaccine is      |
|        |     |   |    |      | received, this field is updated to  |
|        |     |   |    |      | the number of doses received        |
|        |     |   |    |      | (DOSES).                            |
|        |     |   |    |      |                                     |
|        |     |   |    |      | If the code in the *Rectype* field  |
|        |     |   |    |      | value is 2, 4, or 5, this field     |
|        |     |   |    |      | equals the number of doses ordered  |
|        |     |   |    |      | (ORDDOSE). Once the vaccine is      |
|        |     |   |    |      | shipped, this field is updated to   |
|        |     |   |    |      | the number of doses shipped         |
|        |     |   |    |      | (DOSES).                            |
+--------+-----+---+----+------+-------------------------------------+
| Note   | Cha | 5 | 0  |      | Notes on this order                 |
|        | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| C      | D   | 8 | 0  |      | Date the record was last changed.   |
| hgdate | ate |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| S      | Cha | 3 | 0  |      | State purchase order number entered |
| tatepo | rac | 2 |    |      | by the project for state funded     |
|        | ter |   |    |      | orders. If the fcode1 value is      |
|        |     |   |    |      | other than 1 or 2, the state P.O.   |
|        |     |   |    |      | number is required.                 |
+--------+-----+---+----+------+-------------------------------------+
| Userid | Cha | 8 | 0  |      | ID of the user who last changed the |
|        | rac |   |    |      | record. The ID is copied from the   |
|        | ter |   |    |      | Security profile.                   |
+--------+-----+---+----+------+-------------------------------------+
| Ndcno  | Cha | 1 | 0  | *    | Unique number assigned to each      |
|        | rac | 6 |    | *X** | vaccine manufacturer. The value     |
|        | ter |   |    |      | must match a record in the          |
|        |     |   |    |      | VACCBULK.dbf table.                 |
|        |     |   |    |      |                                     |
|        |     |   |    |      | This field must be blank for        |
|        |     |   |    |      | non-CDC orders.                     |
+--------+-----+---+----+------+-------------------------------------+
| Exctax | N   | 9 | 4  |      | Future use                          |
|        | ume |   |    |      |                                     |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Seekid | N   | 9 | 0  |      | Unique ID for record; must be blank |
|        | ume |   |    |      | or record will be rejected.         |
|        | ric |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Xm     | D   | 8 | 0  |      | Transmit date, must be blank or     |
| itdate | ate |   |    |      | record will be rejected.            |
+--------+-----+---+----+------+-------------------------------------+
| Urgent | L   | 1 | 0  |      | Check box indicating to the         |
|        | ogi |   |    |      | distributor whether this order is   |
|        | cal |   |    |      | urgent. The default value is        |
|        |     |   |    |      | unchecked - not an urgent order.    |
+--------+-----+---+----+------+-------------------------------------+
| D      | Cha | 5 | 0  |      | Describes the vaccine code.         |
| escrip | rac | 0 |    |      |                                     |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+
| Ord    | Cha | 1 | 0  | X    | Identifies the order as Federal or  |
| erType | rac |   |    |      | Non-Federal (F/N)                   |
|        | ter |   |    |      |                                     |
+--------+-----+---+----+------+-------------------------------------+

Error Detection Criteria[]{#__RefHeading___Toc150246156 .anchor}

This section lists the error checking applicable to required fields in
the VACMAN Import module. This error checking also is done during normal
keyboard entry affecting the various tables listed.

This information is organized based on the order shown on the
"Description of file to import" frame of the VACMAN *Utilities* tab --
*Import* screen.

### File to Import Option: Distribution (via Project Depot)

Figure 13. Error Detection Criteria -- Distribution (via Project Depot).

+------+---------------------------+----------------------------------+
| *    | **Class/Method/Program    | **Validation Steps -             |
| *Fie | Called**                  | distrib.dbf**                    |
| ld** |                           |                                  |
+======+===========================+==================================+
| I    | clsBusiness.ckMulDate()   | 1.  Date cannot be blank.        |
| nput |                           |                                  |
|      |                           | 2.  Date must be a valid date.   |
|      |                           |                                  |
|      |                           | 3.  Date cannot be more than 5   |
|      |                           |     years prior to current date. |
|      |                           |                                  |
|      |                           | 4.  Date cannot be more than 1   |
|      |                           |     year from value in dateout   |
|      |                           |     field.                       |
+------+---------------------------+----------------------------------+
| Dat  | clsBusiness.ckMulDate()   | 1.  Date cannot be blank.        |
| eout |                           |                                  |
|      |                           | 2.  Date must be a valid date.   |
+------+---------------------------+----------------------------------+
| PIN  | clsBusiness.ckMulPIN()    | 1.  Value cannot be blank.       |
|      |                           |                                  |
|      |                           | 2.  Value cannot be '999999'.    |
|      |                           |                                  |
|      |                           | 3.  Value must match a PIN       |
|      |                           |     number in the Provider       |
|      |                           |     table. For more information, |
|      |                           |     see Figure 5. Field          |
|      |                           |     Descriptions -- Provider     |
|      |                           |     data.                        |
|      |                           |                                  |
|      |                           | 4.  Provider referenced with PIN |
|      |                           |     must be an active provider.  |
+------+---------------------------+----------------------------------+
| Fro  | clsBusiness.ckMulPIN()    | 1.  Value cannot be blank.       |
| mPIN |                           |                                  |
|      |                           | 2.  If 'action' field = 8, value |
|      |                           |     cannot be same as PIN field  |
|      |                           |     above.                       |
|      |                           |                                  |
|      |                           | 3.  Value cannot be same as a    |
|      |                           |     Depot level PIN number.      |
|      |                           |                                  |
|      |                           | 4.  Value cannot be '999999'.    |
|      |                           |                                  |
|      |                           | 5.  Value must match a value in  |
|      |                           |     the Provider table. For more |
|      |                           |     information, see Figure 5.   |
|      |                           |     Field Descriptions --        |
|      |                           |     Provider data.               |
|      |                           |                                  |
|      |                           | 6.  Provider referenced with     |
|      |                           |     this value must be an active |
|      |                           |     provider.                    |
+------+---------------------------+----------------------------------+
| Ac   | frmImport.distribimport() | 1.  Value must be 1.             |
| tion |                           |                                  |
+------+---------------------------+----------------------------------+
| Vac  | clsBusiness.ckDistVacc()  | 1.  Value cannot be blank.       |
| cine |                           |                                  |
|      |                           | 2.  Vaccine name must match a    |
|      |                           |     value in the Vaccref table.  |
|      |                           |     For more information, see    |
|      |                           |     Table Definitions in the     |
|      |                           |     VACMAN User Guide.           |
+------+---------------------------+----------------------------------+
| Lot  | clsBusiness.ckDistLot()   | 1.  Value cannot be blank.       |
|      |                           |                                  |
|      |                           | 2.  Lot number must match a lot  |
|      |                           |     number in the Stock table.   |
|      |                           |     For more information, see    |
|      |                           |     Figure 11. Field             |
|      |                           |     Descriptions -- Import       |
|      |                           |     Direct Ship data -- Archived |
|      |                           |     Records or Update Existing   |
|      |                           |     Records.                     |
|      |                           |                                  |
|      |                           | 3.  Lot cannot be expired.       |
+------+---------------------------+----------------------------------+
| D    | clsBusiness.ckDistLot()   | 1.  Value cannot exceed value in |
| oses |                           |     'remain' field of stock      |
|      | clsBusiness.xsMain()      |     table for matching lot       |
|      |                           |     number.                      |
|      |                           |                                  |
|      |                           | 2.  Value cannot exceed          |
|      |                           |     providers maximum allowance. |
+------+---------------------------+----------------------------------+
| U    | clsP                      | 1.  Units must be an even        |
| nits | rocFile.frvdistribution() |     multiple of value of         |
|      |                           |     doses/size in the Lots       |
|      |                           |     table. For more information, |
|      |                           |     see Table Definitions in the |
|      |                           |     VACMAN User Guide.           |
+------+---------------------------+----------------------------------+
| Mult | clsBusiness.ckDistDup()   | 1.  All records are checked for  |
| iple |                           |     duplication.                 |
| fi   |                           |                                  |
| elds |                           |                                  |
+------+---------------------------+----------------------------------+

### File to Import Option: Transactions

Figure 14. Error Detection Criteria -- Transactions.

+------+---------------------------+----------------------------------+
| *    | **Class/Method/Program    | **Validation Steps -             |
| *Fie | Called**                  | distrib.dbf**                    |
| ld** |                           |                                  |
+======+===========================+==================================+
| I    | clsBusiness.ckMulDate()   | 1.  Date cannot be blank.        |
| nput |                           |                                  |
|      |                           | 2.  Date must be a valid date.   |
|      |                           |                                  |
|      |                           | 3.  Date cannot be more than 5   |
|      |                           |     years prior to current date. |
|      |                           |                                  |
|      |                           | 4.  Date cannot be more than 1   |
|      |                           |     year from value in dateout   |
|      |                           |     field.                       |
+------+---------------------------+----------------------------------+
| Dat  | clsBusiness.ckMulDate()   | 1.  Date cannot be blank.        |
| eout |                           |                                  |
|      |                           | 2.  Date must be a valid date.   |
+------+---------------------------+----------------------------------+
| PIN  | clsBusiness.ckDoxPIN()    | 1.  Value cannot be blank.       |
|      |                           |                                  |
|      |                           | 2.  Value cannot be '999999'.    |
|      |                           |                                  |
|      |                           | 3.  Value must match a PIN       |
|      |                           |     number in the Provider       |
|      |                           |     table. For more information, |
|      |                           |     see Figure 5. Field          |
|      |                           |     Descriptions -- Provider     |
|      |                           |     data.                        |
|      |                           |                                  |
|      |                           | 4.  Provider referenced with PIN |
|      |                           |     must be an active provider.  |
+------+---------------------------+----------------------------------+
| Fro  | clsBusiness.ckMulPIN()    | 1.  Value cannot be blank.       |
| mPIN |                           |                                  |
|      |                           | 2.  If 'action' field = 8, value |
|      |                           |     cannot be same as PIN field  |
|      |                           |     above.                       |
|      |                           |                                  |
|      |                           | 3.  Value cannot be same as a    |
|      |                           |     Depot level PIN number.      |
|      |                           |                                  |
|      |                           | 4.  Value cannot be '999999'.    |
|      |                           |                                  |
|      |                           | 5.  Value must match a value in  |
|      |                           |     the Provider table. For more |
|      |                           |     information, see Figure 5.   |
|      |                           |     Field Descriptions --        |
|      |                           |     Provider data.               |
|      |                           |                                  |
|      |                           | 6.  Provider referenced with     |
|      |                           |     this value must be an active |
|      |                           |     provider.                    |
+------+---------------------------+----------------------------------+
| Ac   | clsBusiness.ckDoxAction() | 1.  Value must be 2, 3, 4, 5, 6, |
| tion |                           |     7, 8, 9, 11, or 12.          |
+------+---------------------------+----------------------------------+
| Vac  | clsBusiness.ckDistVacc()  | 1.  Value cannot be blank.       |
| cine |                           |                                  |
|      |                           | 2.  Vaccine name must match a    |
|      |                           |     value in the Vaccref table.  |
|      |                           |     For more information, see    |
|      |                           |     Table Definitions in the     |
|      |                           |     VACMAN User Guide.           |
+------+---------------------------+----------------------------------+
| Lot  | clsBusiness.ckDoxLot()    | 1.  Value cannot be blank.       |
|      |                           |                                  |
|      |                           | 2.  Lot number must match a lot  |
|      |                           |     number in the STOCK table.   |
|      |                           |     For more information, see    |
|      |                           |     Figure 11. Field             |
|      |                           |     Descriptions -- Import       |
|      |                           |     Direct Ship data -- Archived |
|      |                           |     Records or Update Existing   |
|      |                           |     Records.                     |
|      |                           |                                  |
|      |                           | 3.  Lot cannot be expired.       |
+------+---------------------------+----------------------------------+
| D    | clsBusiness.ckDoxDoses()  | 1.  Value cannot exceed value in |
| oses |                           |     'remain' field of stock      |
|      |                           |     table for matching lot       |
|      |                           |     number.                      |
+------+---------------------------+----------------------------------+
| U    | clsP                      | 1.  Units must be an even        |
| nits | rocFile.frvdistribution() |     multiple of value of         |
|      |                           |     doses/size in the lots       |
|      |                           |     table.                       |
+------+---------------------------+----------------------------------+
| Mult | clsBusiness.ckDistDup()   | 1.  All records are checked for  |
| iple |                           |     duplication.                 |
| fi   |                           |                                  |
| elds |                           |                                  |
+------+---------------------------+----------------------------------+

### File to Import Option: Provider data

Figure 15. Error Detection Criteria -- Provider data.

+---------+--------------------------+--------------------------------+
| **      | **Class/Method/Program   | **Validation Steps -           |
| Field** | Called**                 | provider.dbf**                 |
+=========+==========================+================================+
| PIN     | clsBusiness.ckProvPIN()  | 1.  Value cannot be blank.     |
|         |                          |                                |
|         |                          | 2.  Value cannot be zero.      |
|         |                          |                                |
|         |                          | 3.  Value cannot be '999999'.  |
|         |                          |                                |
|         |                          | 4.  Value cannot be '999998'.  |
|         |                          |                                |
|         |                          | 5.  Value cannot be            |
|         |                          |     duplicated.                |
|         |                          |                                |
|         |                          | 6.  Value cannot already be in |
|         |                          |     use in the Stock table.    |
+---------+--------------------------+--------------------------------+
| linkPIN | clsBusiness.ckParPIN()   | 1.  Sector field in provider   |
|         |                          |     table for record matching  |
|         |                          |     this value must be between |
|         |                          |     10 and 29, or must be 32.  |
+---------+--------------------------+--------------------------------+
| L       | clsBusiness.ckMulName    | 1.  Value cannot be blank.     |
| astname |                          |                                |
+---------+--------------------------+--------------------------------+
| Sector  | cl                       | 1.  Value cannot be 30, 31 or  |
|         | sBusiness.ckProvSector() |     33.                        |
|         |                          |                                |
|         |                          | 2.  Value must match a record  |
|         |                          |     in the Sectoref table. For |
|         |                          |     more information, see      |
|         |                          |     Table Definitions in the   |
|         |                          |     VACMAN User Guide.         |
+---------+--------------------------+--------------------------------+
| County  | cl                       | 1.  Value must match a record  |
|         | sBusiness.ckProvCounty() |     in the County table. For   |
|         |                          |     more information, see      |
|         |                          |     Table Definitions in the   |
|         |                          |     VACMAN User Guide.         |
+---------+--------------------------+--------------------------------+
| Subdiv  | clsBusiness.ckProvSubD() | 1.  Value must match a record  |
|         |                          |     in the Subdiv table. For   |
|         |                          |     more information, see      |
|         |                          |     Table Definitions in the   |
|         |                          |     VACMAN User Guide.         |
+---------+--------------------------+--------------------------------+
| Cat1    | clsBusiness.ckProvCat()  | 1.  Value must either be blank |
|         |                          |     or must match a value in   |
|         |                          |     the *cat1* field of the    |
|         |                          |     CAT1 table. For more       |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Cat2    | clsBusiness.ckProvCat()  | 1.  Value must either be blank |
|         |                          |     or must match a value in   |
|         |                          |     the *cat2* field of the    |
|         |                          |     CAT2 table. For more       |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Cat3    | clsBusiness.ckProvCat()  | 1.  Value must either be blank |
|         |                          |     or must match a value in   |
|         |                          |     the *cat3* field of the    |
|         |                          |     CAT3 table. For more       |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Cat4    | clsBusiness.ckProvCat()  | 1.  Value must either be blank |
|         |                          |     or must match a value in   |
|         |                          |     the *cat4* field of the    |
|         |                          |     CAT4 table. For more       |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Cat5    | clsBusiness.ckProvCat()  | 1.  Value must either be blank |
|         |                          |     or must match a value in   |
|         |                          |     the *cat5* field of the    |
|         |                          |     CAT5 table. For more       |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Codes   | clsBusiness.ckMulCode()  | 1.  Value must be either 'Y'   |
|         |                          |     or 'N'.                    |
+---------+--------------------------+--------------------------------+
| Active  | c                        | 1.  Value must be 'Y', 'N',    |
|         | lsBusiness.ckMulActive() |     'S' or 'T'.                |
|         |                          |                                |
|         |                          | 2.  If modifying the record    |
|         |                          |     and the old value 'Y' is   |
|         |                          |     being changed to 'N', 'S'  |
|         |                          |     or 'T', there cannot be an |
|         |                          |     active order record in the |
|         |                          |     Neworder table. For more   |
|         |                          |     information, see           |
|         |                          |     Figure 12. Field           |
|         |                          |     Descriptions -- Import     |
|         |                          |     Direct Ship data -- Add    |
|         |                          |     New Records.               |
|         |                          |                                |
|         |                          | 3.  If modifying the record    |
|         |                          |     and the value is not 'Y',  |
|         |                          |     the date value for the     |
|         |                          |     *dateXVFC* field cannot be |
|         |                          |     blank.                     |
+---------+--------------------------+--------------------------------+
| DateVFC | c                        | 1.  Value must be a valid date |
|         | lsBusiness.ckProvVFCdt() |     if used.                   |
|         |                          |                                |
|         |                          | 2.  Value cannot exceed        |
|         |                          |     current date by more than  |
|         |                          |     30 days.                   |
+---------+--------------------------+--------------------------------+
| Contact | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
+---------+--------------------------+--------------------------------+
| Address | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
+---------+--------------------------+--------------------------------+
| Phone   | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
|         |                          | 2.  Value must be properly     |
|         |                          |     formatted as:              |
|         |                          |                                |
|         |                          | > \(999\) 999-9999.            |
+---------+--------------------------+--------------------------------+
| City    | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
+---------+--------------------------+--------------------------------+
| State   | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
+---------+--------------------------+--------------------------------+
| Zipcode | cls                      | 1.  Value cannot be blank.     |
|         | Business.ckMuladdrship() |                                |
|         |                          | 2.  Value SHOULD match an      |
|         |                          |     existing value in the      |
|         |                          |     Zipcode table. For more    |
|         |                          |     information, see Table     |
|         |                          |     Definitions in the VACMAN  |
|         |                          |     User Guide.                |
+---------+--------------------------+--------------------------------+
| Fax     | cls                      | 1.  Value must be properly     |
|         | Business.ckMuladdrship() |     formatted if used as:      |
|         |                          |                                |
|         |                          | > \(999\) 999-9999.            |
+---------+--------------------------+--------------------------------+
| Modem   | cls                      | 1.  Value must be properly     |
|         | Business.ckMuladdrship() |     formatted if used as:      |
|         |                          |                                |
|         |                          | 2.  \(999\) 999-9999.          |
+---------+--------------------------+--------------------------------+
| Note    | clsBusiness.ckProvNote() | 1.  Import module will record  |
|         |                          |     warning message if one of  |
|         |                          |     the following characters   |
|         |                          |     referenced is present in   |
|         |                          |     this field: !, @, #, \$,   |
|         |                          |     %, \^, &, \*, (, ), +, \|, |
|         |                          |     \\, /, {, }, \[, \], :,    |
|         |                          |     \<, \>, ?, \'.\"           |
|         |                          |                                |
|         |                          | 2.  A warning message will be  |
|         |                          |     generated if the field is  |
|         |                          |     blank. Enter "NONE" if no  |
|         |                          |     value is available.        |
+---------+--------------------------+--------------------------------+
| ML_     | clsBusiness.clMulMAddr   | 1.  The mailing address        |
| address |                          |     information, if used, is   |
|         |                          |     checked in a manner        |
| ML_     |                          |     similar to that done in    |
| addres2 |                          |     ckMuladdrship() method     |
|         |                          |     mentioned above. This      |
| ML_City |                          |     information is optional    |
|         |                          |     and will not generate a    |
| M       |                          |     fatal error.               |
| L_State |                          |                                |
|         |                          |                                |
| ML_     |                          |                                |
| ZipCode |                          |                                |
+---------+--------------------------+--------------------------------+

### File to Import Option: Enrollment data

Figure 16. Error Detection Criteria -- Enrollment data.

+------------+--------------------------+------------------------------+
| **Field**  | **Class/Method/Program   | **Validation Steps -         |
|            | Called**                 | enroll.dbf**                 |
+============+==========================+==============================+
| PIN        | clsBusiness.ckMulPIN()   | 1.  Value cannot be blank.   |
|            |                          |                              |
|            |                          | 2.  Value cannot be          |
|            |                          |     '999999'.                |
|            |                          |                              |
|            |                          | 3.  Value must match a PIN   |
|            |                          |     number in the Provider   |
|            |                          |     table. For more          |
|            |                          |     information, see         |
|            |                          |     Figure 5. Field          |
|            |                          |     Descriptions -- Provider |
|            |                          |     data.                    |
|            |                          |                              |
|            |                          | 4.  Provider referenced with |
|            |                          |     PIN must be an active    |
|            |                          |     provider.                |
+------------+--------------------------+------------------------------+
| impor      | c                        | 1.  Sum of vfckids, g317kids |
| t.allkids1 | lsBusiness.ckEnrolCnts() |     and statekids must be    |
| impor      |                          |     less than or equal to    |
| t.vfckids1 |                          |     allkids field.           |
| import     |                          |                              |
| .g317kids1 |                          |                              |
| import.    |                          |                              |
| statekids1 |                          |                              |
+------------+--------------------------+------------------------------+
| impor      | c                        | 2.  Sum of vfckids, g317kids |
| t.allkids2 | lsBusiness.ckEnrolCnts() |     and statekids must be    |
| impor      |                          |     less than or equal to    |
| t.vfckids2 |                          |     allkids field.           |
| import     |                          |                              |
| .g317kids2 |                          |                              |
| import.    |                          |                              |
| statekids2 |                          |                              |
+------------+--------------------------+------------------------------+
| impor      | c                        | 3.  Sum of vfckids, g317kids |
| t.allkids3 | lsBusiness.ckEnrolCnts() |     and statekids must be    |
| impor      |                          |     less than or equal to    |
| t.vfckids3 |                          |     allkids field.           |
| import     |                          |                              |
| .g317kids3 |                          |                              |
| import.    |                          |                              |
| statekids3 |                          |                              |
+------------+--------------------------+------------------------------+
| impor      | c                        | 4.  Sum of vfckids, g317kids |
| t.allkids4 | lsBusiness.ckEnrolCnts() |     and statekids must be    |
| impor      |                          |     less than or equal to    |
| t.vfckids4 |                          |     allkids field.           |
| import     |                          |                              |
| .g317kids4 |                          |                              |
| import.    |                          |                              |
| statekids4 |                          |                              |
+------------+--------------------------+------------------------------+

### File to Import Option: Physicians data

Figure 17. Error Detection Criteria -- Physicians data.

+-----------+--------------------------+-------------------------------+
| **Field** | **Class/Method/Program   | **Validation Steps -          |
|           | Called**                 | physicn.dbf**                 |
+===========+==========================+===============================+
| PIN       | clsBusiness.ckPhysPIN()  | 1.  Value must match a PIN    |
|           |                          |     number in the Provider    |
|           |                          |     table. For more           |
|           |                          |     information, see          |
|           |                          |     Figure 5. Field           |
|           |                          |     Descriptions -- Provider  |
|           |                          |     data.                     |
|           |                          |                               |
|           |                          | 2.  Matching provider record  |
|           |                          |     must have a sector field  |
|           |                          |     value between 10 and 29   |
|           |                          |     or 32                     |
|           |                          |                               |
|           |                          | 3.  Provider referenced with  |
|           |                          |     PIN must be an active     |
|           |                          |     provider.                 |
|           |                          |                               |
|           |                          | 4.  Value cannot be blank.    |
+-----------+--------------------------+-------------------------------+
| Lastname  | clsBusiness.ckMulLName() | 1.  Value cannot be blank.    |
+-----------+--------------------------+-------------------------------+
| A         | frmImport.physImport()   | 1.  Value must be 0 (false)   |
| ddtocount |                          |     or 1 (true).              |
+-----------+--------------------------+-------------------------------+
| Active    | frmImport.physImport()   | 1.  Value must be 'Y' or 'N'. |
+-----------+--------------------------+-------------------------------+
| D         | frmImport.physImport()   | 1.  Value must be a valid     |
| ateactive |                          |     date.                     |
|           |                          |                               |
|           |                          | 2.  Value cannot be blank.    |
+-----------+--------------------------+-------------------------------+

### File to Import Option: Provider Inventory data

Figure 18. Error Detection Criteria -- Provider Inventory data.

+-----------+--------------------------+-------------------------------+
| **Field** | **Class/Method/Program   | **Validation Steps -          |
|           | Called**                 | provhas.dbf**                 |
+===========+==========================+===============================+
| Idate     | clsBusiness.ckPHasIDt()  | 1.  Date must be a valid      |
|           |                          |     date.                     |
|           |                          |                               |
|           |                          | 2.  Date cannot be blank.     |
|           |                          |                               |
|           |                          | 3.  Date cannot be more than  |
|           |                          |     5 years greater than or   |
|           |                          |     less than current date.   |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckMulPPin()  | 1.  Value cannot be blank.    |
|           |                          |                               |
|           |                          | 2.  Sector field value in     |
|           |                          |     matching provider record  |
|           |                          |     must be between 10-29 or  |
|           |                          |     32                        |
|           |                          |                               |
|           |                          | 3.  There must be a matching, |
|           |                          |     non-deleted record in the |
|           |                          |     provider table.           |
|           |                          |                               |
|           |                          | 4.  Matching provider record  |
|           |                          |     must be active            |
+-----------+--------------------------+-------------------------------+
| Vaccine   | clsBusiness.ckMulVacc()  | 1.  Value cannot be blank.    |
|           |                          |                               |
|           |                          | 2.  Value must be present in  |
|           |                          |     vaccref table.            |
+-----------+--------------------------+-------------------------------+
| Lot       | clsBusiness.ckPHasLot()  | 1.  Must be a matching        |
|           |                          |     vaccine + lot number      |
|           |                          |     record in the stock table |
+-----------+--------------------------+-------------------------------+

### File to Import Option: Doses Administered data

Figure 19. Error Detection Criteria -- Doses Administered data.

+-----------+--------------------------+-------------------------------+
| **Field** | **Class/Method/Program   | **Validation Steps -          |
|           | Called**                 | dosesadm.dbf**                |
+===========+==========================+===============================+
| Adate     | clsBusiness.ckDoAdmADt() | 1.  Date must be a valid      |
|           |                          |     date.                     |
|           |                          |                               |
|           |                          | 2.  Date cannot be blank.     |
|           |                          |                               |
|           |                          | 3.  Date cannot be more than  |
|           |                          |     5 years greater than      |
|           |                          |     current date.             |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckMulPPin()  | 1.  Value cannot be blank.    |
|           |                          |                               |
|           |                          | 2.  Sector field value in     |
|           |                          |     matching provider record  |
|           |                          |     must be between 10-29 or  |
|           |                          |     32.                       |
|           |                          |                               |
|           |                          | 3.  There must be a matching, |
|           |                          |     non-deleted record in the |
|           |                          |     provider table.           |
|           |                          |                               |
|           |                          | 4.  Matching provider record  |
|           |                          |     must be active.           |
+-----------+--------------------------+-------------------------------+
| Vaccine   | clsBusiness.ckMulVacc()  | 1.  Value cannot be blank.    |
|           |                          |                               |
|           |                          | 2.  Value must be present in  |
|           |                          |     Vaccref table.            |
+-----------+--------------------------+-------------------------------+
| Lot       | clsBusiness.ckPHasLot()  | 1.  Must be a matching        |
|           |                          |     vaccine + lot number      |
|           |                          |     record in the Stock       |
|           |                          |     table.                    |
+-----------+--------------------------+-------------------------------+
| Doses     | c                        | 1.  Value must be greater     |
|           | lsBusiness.ckDoAdmDose() |     than zero.                |
|           |                          |                               |
|           |                          | 2.  Value may not exceed      |
|           |                          |     value in the maxno field  |
|           |                          |     of the Vaccref table.     |
+-----------+--------------------------+-------------------------------+

### File to Import Option: Direct Ship Order data (Archive or Update) 

Figure 20. Error Detection Criteria -- Direct Ship Order data -- Archive
or Update.

+------+---------------------------+----------------------------------+
| *    | **Class/Method/Program    | **Validation Steps - stock.dbf** |
| *Fie | Called**                  |                                  |
| ld** |                           |                                  |
+======+===========================+==================================+
| Mult | fr                        | 1.  Duplicate records are not    |
| iple | mImport.varicellaImport() |     allowed.                     |
+------+---------------------------+----------------------------------+
| Vac  | fr                        | 1.  Value must be one of the     |
| cine | mImport.varicellaImport() |     following:                   |
|      |                           |                                  |
|      |                           | > VAR FLU MMR-V                  |
+------+---------------------------+----------------------------------+
| N    | fr                        | 1.  The value must match the     |
| dcno | mImport.varicellaImport() |     value for vaccine in the     |
|      |                           |     Vaccbulk table. For more     |
|      |                           |     information, see Table       |
|      |                           |     Definitions in the VACMAN    |
|      |                           |     User Guide.                  |
+------+---------------------------+----------------------------------+
| Ord  | clsBusiness.ckMulOrdDt()  | 1.  Date cannot be blank.        |
| date |                           |                                  |
|      |                           | 2.  Date must be a valid date.   |
|      |                           |                                  |
|      |                           | 3.  Date must be within 30 days  |
|      |                           |     of current date.             |
+------+---------------------------+----------------------------------+
| PIN  | clsBusiness.ckVarPIN()    | 1.  PIN cannot be blank.         |
|      |                           |                                  |
|      |                           | 2.  PIN must be in the Provider  |
|      |                           |     table. For more information, |
|      |                           |     see Figure 5. Field          |
|      |                           |     Descriptions -- Provider     |
|      |                           |     data.                        |
|      |                           |                                  |
|      |                           | 3.  PIN must match an active     |
|      |                           |     provider.                    |
|      |                           |                                  |
|      |                           | 4.  Contact, shipping and        |
|      |                           |     address information for      |
|      |                           |     matching record in the       |
|      |                           |     Provider table must be       |
|      |                           |     complete.                    |
+------+---------------------------+----------------------------------+
| PIN  | clsBusiness.ckEligProv()  | 1.  PIN must not match a public  |
|      |                           |     provider.                    |
|      |                           |                                  |
|      |                           | 2.  PIN must match a direct ship |
|      |                           |     eligible provider.           |
+------+---------------------------+----------------------------------+
| Fc   | clsBusiness.ckVarFundCd() | 1.  Value cannot be blank.       |
| ode1 |                           |                                  |
+------+---------------------------+----------------------------------+
| Sta  | clsBusiness.ckVarFundCd() | 1.  If value in fcode1 is 1 or   |
| tepo |                           |     2, the *State PO* field must |
|      |                           |     be blank.                    |
|      |                           |                                  |
|      |                           | 2.  If value of fcode1 is other  |
|      |                           |     than 1 or 2, the *State PO*  |
|      |                           |     field cannot be blank.       |
+------+---------------------------+----------------------------------+
| Ord  | clsBusiness.ckVarDose()   | 1.  NDCno value must match a     |
| dose |                           |     record in the Vaccbulk       |
|      |                           |     table. For more information, |
| N    |                           |     see Table Definitions in the |
| dcno |                           |     VACMAN User Guide.           |
|      |                           |                                  |
|      |                           | 2.  Total varicella order may    |
|      |                           |     not exceed \$25,000.         |
|      |                           |                                  |
|      |                           | 3.  Orddose must be an even      |
|      |                           |     multiple of package size in  |
|      |                           |     the Vaccbulk table.          |
+------+---------------------------+----------------------------------+
| Rec  | fr                        | 1.  Value must be 2.             |
| type | mimport.varicellaImport() |                                  |
+------+---------------------------+----------------------------------+
| Or   | fr                        | 1.  Value must be the same as    |
| dpin | mimport.varicellaImport() |     *PIN* field.                 |
+------+---------------------------+----------------------------------+
| Pkg  | fr                        | 1.  Value must match the         |
| size | mimport.varicellaImport() |     *Package Size* field in the  |
|      |                           |     matching Vaccbulk table      |
|      |                           |     record.                      |
+------+---------------------------+----------------------------------+
| M    | fr                        | 1.  Value must match the *Maker* |
| aker | mimport.varicellaImport() |     field in the matching        |
|      |                           |     Vaccbulk table record.       |
+------+---------------------------+----------------------------------+
| Cont | fr                        | 1.  Value must match the         |
| ract | mimport.varicellaImport() |     *Contract* field in the      |
|      |                           |     matching Vaccbulk table      |
|      |                           |     record.                      |
+------+---------------------------+----------------------------------+
| Cost | fr                        | 1.  Value must match the *Cost*  |
|      | mimport.varicellaImport() |     field in the matching        |
|      |                           |     Vaccbulk table record.       |
+------+---------------------------+----------------------------------+

### 

###  

### File to Import Option: Direct Ship Orders -- Add New Records

Figure 21. Error Detection Criteria --Direct Ship Orders -- Add New
Records.

+-----------+--------------------------+-------------------------------+
| **Field** | **Class/Method/Program   | **Validation Steps -          |
|           | Called**                 | neworder.dbf**                |
+===========+==========================+===============================+
| Xmitdate  | frm                      | 1.  Value must be blank.      |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Seekid    | frm                      | 1.  Value must be blank.      |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Orddose   | frm                      | 1.  Value of *Orddose* field  |
|           | Import.newOrdersImport() |     must be same as *Fdose1*  |
| Fdose1    |                          |     field. If not, the        |
|           |                          |     program will copy value   |
|           |                          |     of *Fdose1* into this     |
|           |                          |     field and will store a    |
|           |                          |     warning message.          |
+-----------+--------------------------+-------------------------------+
| Vaccine   | frm                      | 1.  Value must be a valid     |
|           | Import.newOrdersImport() |     direct ship vaccine per   |
|           |                          |     the applicable CDC        |
|           |                          |     contract.                 |
+-----------+--------------------------+-------------------------------+
| Ndcno     | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *NDCno* field per the     |
|           |                          |     applicable CDC contract.  |
+-----------+--------------------------+-------------------------------+
| Orddate   | clsBusiness.ckOrdDt()    | 1.  Must be a valid date.     |
|           |                          |                               |
|           |                          | 2.  Cannot be blank.          |
|           |                          |                               |
|           |                          | 3.  Must be less than current |
|           |                          |     date -- 30                |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckVarPIN()   | 1.  PIN cannot be blank.      |
|           |                          |                               |
|           |                          | 2.  PIN must exist in the     |
|           |                          |     Provider table. For more  |
|           |                          |     information, see          |
|           |                          |     Figure 5. Field           |
|           |                          |     Descriptions -- Provider  |
|           |                          |     data.                     |
|           |                          |                               |
|           |                          | 3.  PIN must match an active  |
|           |                          |     provider.                 |
|           |                          |                               |
|           |                          | 4.  Contact, shipping and     |
|           |                          |     address information for   |
|           |                          |     matching record in        |
|           |                          |     Provider table must be    |
|           |                          |     complete.                 |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckEligProv() | 1.  PIN must not match a      |
|           |                          |     public provider.          |
|           |                          |                               |
|           |                          | 2.  PIN must match a direct   |
|           |                          |     ship eligible provider.   |
+-----------+--------------------------+-------------------------------+
| Fcode1    | c                        | 1.  Value cannot be blank.    |
|           | lsBusiness.ckVarFundCd() |                               |
+-----------+--------------------------+-------------------------------+
| Orddose   | clsBusiness.ckVarDose()  | 1.  *NDCno* field value must  |
|           |                          |     match a record in the     |
| Ndcno     |                          |     Vaccbulk table. For more  |
|           |                          |     information, see Table    |
|           |                          |     Definitions in the VACMAN |
|           |                          |     User Guide.               |
|           |                          |                               |
|           |                          | 2.  Total varicella order may |
|           |                          |     not exceed \$25,000.      |
|           |                          |                               |
|           |                          | 3.  Orddose must be an even   |
|           |                          |     multiple of *Package      |
|           |                          |     Size* field in the        |
|           |                          |     Vaccbulk table.           |
+-----------+--------------------------+-------------------------------+
| Rectype   | frm                      | 1.  Value must be 2.          |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Statepo   | frm                      | 1.  If fcode1 is 3, cannot be |
|           | Import.newOrdersImport() |     blank.                    |
|           |                          |                               |
|           |                          | 2.  If fcode1 is 1 or 2 must  |
|           |                          |     be blank.                 |
+-----------+--------------------------+-------------------------------+
| Size      | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     pkgsize field value in    |
|           |                          |     the VACCBULK.dbf table.   |
+-----------+--------------------------+-------------------------------+
| Maker     | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     maker field value in the  |
|           |                          |     VACCBULK.dbf table.       |
+-----------+--------------------------+-------------------------------+
| Contract  | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     contract field value in   |
|           |                          |     the VACCBULK.dbf table.   |
+-----------+--------------------------+-------------------------------+
| Cost      | frm                      | 1.  Value must match the cost |
|           | Import.newOrdersImport() |     field value in the        |
|           |                          |     VACCBULK.dbf table.       |
+-----------+--------------------------+-------------------------------+

### File to Import Option: Provider Orders

Figure 22. Error Detection Criteria --Provider Orders.

+-----------+--------------------------+-------------------------------+
| **Field** | **Class/Method/Program   | **Validation Steps -          |
|           | Called**                 | neworder.dbf**                |
+===========+==========================+===============================+
| Xmitdate  | frm                      | 1.  Value must be blank.      |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Seekid    | frm                      | 1.  Value must be blank.      |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Orddose   | frm                      | 1.  Value of orddose must be  |
|           | Import.newOrdersImport() |     same as fdose1. If not    |
| Fdose1    |                          |     the program will copy     |
|           |                          |     value of fdose1 into this |
|           |                          |     field and will store a    |
|           |                          |     warning message.          |
+-----------+--------------------------+-------------------------------+
| Vaccine   | frm                      | 1.  Value must be a valid     |
|           | Import.newOrdersImport() |     vaccine per the           |
|           |                          |     applicable CDC contract.  |
+-----------+--------------------------+-------------------------------+
| Ndcno     | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *NDCno* field per the     |
|           |                          |     applicable CDC contract.  |
+-----------+--------------------------+-------------------------------+
| Orddate   | clsBusiness.ckOrdDt()    | 1.  Must be a valid date.     |
|           |                          |                               |
|           |                          | 2.  Cannot be blank.          |
|           |                          |                               |
|           |                          | 3.  Must be less than current |
|           |                          |     date -- 30                |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckVarPIN()   | 1.  PIN cannot be blank.      |
|           |                          |                               |
|           |                          | 2.  PIN must be in the        |
|           |                          |     Provider table. For more  |
|           |                          |     information, see          |
|           |                          |     Figure 5. Field           |
|           |                          |     Descriptions -- Provider  |
|           |                          |     data.                     |
|           |                          |                               |
|           |                          | 3.  PIN must match an active  |
|           |                          |     provider.                 |
|           |                          |                               |
|           |                          | 4.  Contact, shipping and     |
|           |                          |     address information for   |
|           |                          |     matching record in        |
|           |                          |     provider table must be    |
|           |                          |     complete.                 |
+-----------+--------------------------+-------------------------------+
| PIN       | clsBusiness.ckEligProv() | 1\. PIN must not match a      |
|           |                          | public provider.              |
+-----------+--------------------------+-------------------------------+
| Fcode1    | c                        | 1.  Value cannot be blank.    |
|           | lsBusiness.ckVarFundCd() |                               |
+-----------+--------------------------+-------------------------------+
| Orddose   | clsBusiness.ckVarDose()  | 1.  *NDCno* field value must  |
|           |                          |     match a record in the     |
| Ndcno     |                          |     Vaccbulk table. For more  |
|           |                          |     information, see Table    |
|           |                          |     Definitions in the VACMAN |
|           |                          |     User Guide.               |
|           |                          |                               |
|           |                          | 2.  Orddose must be an even   |
|           |                          |     multiple of *Package      |
|           |                          |     Size* in the Vaccbulk     |
|           |                          |     table.                    |
+-----------+--------------------------+-------------------------------+
| Rectype   | frm                      | 1.  Value must be 5.          |
|           | Import.newOrdersImport() |                               |
+-----------+--------------------------+-------------------------------+
| Statepo   | frm                      | 1.  If fcode1 is 3, cannot be |
|           | Import.newOrdersImport() |     blank.                    |
|           |                          |                               |
|           |                          | 2.  If fcode1 is 1 or 2 must  |
|           |                          |     be blank.                 |
+-----------+--------------------------+-------------------------------+
| Size      | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *Package Size* field      |
|           |                          |     value in the Vaccbulk     |
|           |                          |     table.                    |
+-----------+--------------------------+-------------------------------+
| Maker     | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *Maker* field value in    |
|           |                          |     the Vaccbulk table.       |
+-----------+--------------------------+-------------------------------+
| Contract  | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *Contract* field value in |
|           |                          |     the Vaccbulk table.       |
+-----------+--------------------------+-------------------------------+
| Cost      | frm                      | 1.  Value must match the      |
|           | Import.newOrdersImport() |     *Cost* field value in the |
|           |                          |     Vaccbulk table.           |
+-----------+--------------------------+-------------------------------+

Export Module[]{#__RefHeading___Toc150246157 .anchor}

The Export Utility provides a way to export data files from VACMAN into
a different data format for use in external applications such as Excel,
or for use in other data-centric programs.

**Notes:**

-   You must have exclusive access to VACMAN while performing this
    function. Other users must exit the system before you begin.

-   VACMAN does not perform any validation of records being exported.

-   Export Options -- The VACMAN Interface
    Screen[]{#__RefHeading___Toc150246158 .anchor}

Figure 23. VACMAN *Utilities* tab -- *Export Options* screen.

![](media/image4.png){width="4.325in" height="3.70625in"}

> **Export File Options**[]{#__RefHeading___Toc150246159 .anchor}**.**
> The *Export Options* screen offers the a list of files you can choose
> to export.

-   The *Select a file to export* options are the same as the options
    for the *Import* screen - *Description of file to import*; see Page
    [6](#_Ref150245679).

-   The *File Type* options are the same as the options for the *Import*
    screen -- *Import Type*; see Page [7](#_Ref150245778).

####### User Procedures 

Use these instructions to export a file from VACMAN.

Figure 24. User instructions for exporting from VACMAN.

+----+-----------------------------------------------------------------+
| ** | **Description**                                                 |
| St |                                                                 |
| ep |                                                                 |
| ** |                                                                 |
+====+=================================================================+
| *  | Access the VACMAN *Utilities* tab and select the **Export Data  |
| *1 | into VACMAN** option.                                           |
| ** |                                                                 |
|    | **Result:** The system displays the VACMAN *Import Options*     |
|    | screen.                                                         |
+----+-----------------------------------------------------------------+
| *  | Choose one radio button from each of these frames:              |
| *2 |                                                                 |
| ** | -   Select a file to export; see Page [6](#_Ref150245679) for   |
|    |     description.                                                |
|    |                                                                 |
|    | -   File type; see Page [7](#_Ref150245778) for description.    |
|    |                                                                 |
|    | -   PIN -- Select either of the following:                      |
|    |                                                                 |
|    | *All* -- Include all Provider Identification Numbers (PINs)     |
|    |                                                                 |
|    | *Range* -- Include PINs within a *Starting* and *Ending* range  |
|    | of PIN numbers that you specify.                                |
|    |                                                                 |
|    | -   Transaction Date - Select either of the following:          |
|    |                                                                 |
|    | *All* -- Include all transaction dates                          |
|    |                                                                 |
|    | *Range* -- Include transactions within a *Starting* and         |
|    | *Ending* range of dates that you specify.                       |
|    |                                                                 |
|    | -   Select either of the following:                             |
|    |                                                                 |
|    | *Copy* -- Export a copy of specified data. This option          |
|    | [retains]{.underline} the data in your active files.            |
|    |                                                                 |
|    | > *Move* -- Export the specified data. This option              |
|    | > [removes]{.underline} that data from your active files. The   |
|    | > VACMAN team recommends that you Back Up and Pack before       |
|    | > performing the Move option, so that you can restore your data |
|    | > in the event the files are lost or corrupted.                 |
|    |                                                                 |
|    | -   Distribution (Other) - If the file you select to export is  |
|    |     Transactions, choose one of the following:                  |
|    |                                                                 |
|    | -   All transactions                                            |
|    |                                                                 |
|    | -   Returned (transaction code 2)                               |
|    |                                                                 |
|    | -   Unusable (transaction codes 3-7, 11-12)                     |
|    |                                                                 |
|    | -   Xfer btwn Providers (transaction code 8, transfer between   |
|    |     providers)                                                  |
+----+-----------------------------------------------------------------+
| *  | Click the **Preview** button to review the records that         |
| *3 | resulted from your selections. Press the **Esc** key to close   |
| ** | the preview screen. You can modify your selections as needed.   |
+----+-----------------------------------------------------------------+
| *  | To export the selected records, click the **Continue** button.  |
| *4 |                                                                 |
| ** | **Result:** The system prompts for a file name, and destination |
|    | location for the file you are exporting.                        |
|    |                                                                 |
|    | The system presents a default file name based on the file you   |
|    | selected and the current date; e.g., **provider20061102**. You  |
|    | can modify this if needed.                                      |
|    |                                                                 |
|    | The destination location must be outside your VACMAN data       |
|    | directory.                                                      |
+----+-----------------------------------------------------------------+
|    | Click the **Save** button to complete the export.               |
+----+-----------------------------------------------------------------+

This document can be found on the CDC website at:

<http://www.cdc.gov/vaccines/programs/vacman/downloads/im-spec-v41-final.doc>