Routine Monitoring Schedule Report VND004 (Output)

The Routine Monitoring Schedule Report VND004 (Output) lists vendors selected for routine monitoring visit. The vendors included in the report are randomly selected from all vendors that are currently enrolled and active in the Vendor system. The number of vendors to include in the report is selected by the user as a percentage of the total number of vendors that are currently enrolled and active in the Vendor system. The report is generated when the OK button is clicked on the Generate Routine Monitoring Schedule screen.

Report Title

The title of the report is the text of "Routine Monitoring Schedule Report". A subtitle indicates the percentage of vendors selected for the report.

Origin of Data Element

The user on the Generate Routine Monitoring Schedule Report screen indicates the percentage of vendors.

Format

The percentage value prints in ##% format.

Staff

This value is the ID of the WIC staff person who is primarily responsible for this vendor.

Origin of Data Element

The value is taken from the UserID column of the Vendor table.

Format

The value prints as its literal value.

Primary Agency

This value is the name of the primary agency for the vendor.

Origin of Data Element

The value is taken from the NAME column of the AGENCY table where AgencyID = VendorLAAssociation.AgencyID and VendorLAAssociation.Primary = "Y".

Format

The value prints as its literal value.

Vendor ID

This value is the ID of the vendor.

Origin of Data Element

The value is taken from the Vendor-ID column of the VENDOR table.

Format

The value prints as its literal value.

Vendor Name

This value is the name of the vendor.

Origin of Data Element

The value is taken from the Trade-Name column of the VENDOR table.

Format

The value prints as its literal value.

Vendor Address

This value is the physical address of the vendor.

Origin of Data Element

The value is taken from the Physical-Address-1, Physical-Address-2, Physical-City and Physical-ZIP columns of the VENDOR table.

Format

The values prints in Physical-Address-1, Physical-Address-2, Physical-City, Physical-ZIP order. Each value prints on a separate line, with the exception of Physical-ZIP, which prints on the same line as the Physical-City.

Filter Criteria

Random Selection of a Percentage of Vendors

The vendors included in the report are randomly selected from all enrolled and active vendors in the Vendor system. The number of vendors included in the report is entered by the user as a percentage of the total number of vendors, in each peer group, that are enrolled and active in the Vendor system. Vendors visited in the previous year are still eligible for another visit, and are included in the random selection process.

For example, if there are 200 enrolled and active vendors in the Vendor system and the user enters 10% in the Percentage of vendors to Include in Report text box then the system chooses 20 vendors in each peer group. These vendors are chosen using a random number generator. If the generator produces the number 6 then the system chooses the sixth vendor within the peer group. The system repeats this selection process until it has enough vendors to meet the requested percentage. In this example the system would repeat the selection process 20 times for each peer group.

Monitoring Visits uses a random number generator to select from a collection of active vendors.

This is achieved by:

• The user enters the percent of active vendors to include in the random sampling. Set the Percent Value by converting the percent entered on the screen to a whole number, 10% becomes 10.

• Retrieve all vendor IDs from the Vendor table where the current status is "3" or "7". Add the selected vendor IDs to a Vendor ID Collection.

• Count the number of Active Vendor IDs in the collection 38

• Divide the Count of Selected VendorIDs by 100

• 38/100 =.38

• Determine the maximum number of vendor IDs required to meet the proportion entered by the user.

• Multiply the Result by the Percent Value and round to a whole number. .38 * 10 = 3.8 and Rounded to the whole number 4 to Set the Number of Vendors to Select for the Random Sampling

• Loop through the collection of active vendor IDs repeating the process until the Number of Vendors to Select for the Random Sampling matches than the number of Vendor IDs selected for the Monitoring List.

• Initialize the random-number generator. The initial value returned by the system timer is used as the new seed value so it is different every time (based on fractional portions of a second). For any given initial seed, the same number sequence is generated because each successive call to the Rnd function uses the previous number as a seed for the next number in the sequence

• Randomly set the Collection Index to the vendor collection:

• index = Int((colAllVendors.Count - 1) * Rnd) + 1

• Count the Selected VendorIDs in the collection at the moment and subtract one to set the upper boundary as the highest possible index to select in the range. 38 - 1 = 37

• Multiply the result by a random number. 37 * RndNmbr and round the result to whole number.

• Add 1 for a lower boundary as the lowest possible index to select in the range.

• Move the vendor ID in this index location within the collection to the Monitor Visit List. The count of vendors in the collection was reduced by one, from 38 to 37. The current number of vendors left to collect for monitoring is 3.

• Loop through the process until the number of vendor IDs added to the Monitoring List meets the Number of Vendors to Select for the Random Sampling. The LOOP ENDS when the number of vendors selected matches the value calculated from the percent of total vendors or the collection of active vendors is exhausted.

Sort Order

Staff

The report is sorted by the UserID of the WIC staff person primarily responsible for the vendor.

Primary Agency

The report is sorted by primary agency within WIC staff UserID.

Control Breaks

Staff

A page break occurs at the change of UserID.

Primary Agency

A page break occurs at the change of primary agency.