Random Food Instrument Report Sample VND038 (Output)

The Random Food Instrument Report Sample VND038 (Output) includes a subset list of food instruments redeemed within the selected month. The report is generated when the OK button is clicked on the Generate Random Food Instrument Report screen.

Report Title

Origin of Data Element

The text of the title is "Random Food Instrument Sample". The report has a sub-title showing the As of Month the user chose for the report.

Format

The report title prints as a literal value. The sub-title prints in the format "As of Month {Textual Month} {CCYY}".

As of Month

Origin of Data Element

The user records this value when the report is submitted.

Format

This is a calendar month and year formatted as Month Name CCYY.

FI Number

Origin of Data Element

This value comes from the Serial_No column of the Food_Instrument table.

Format

This is an eight-character value.

Paid Date

Origin of Data Element

This value comes from the Paid_Date column of the Food_Instrument table.

Format

This is an eight-digit number formatted MM/DD/CCYY.

Vendor ID

Origin of Data Element

This value comes from the Vendor_ID column of the Food_Instrument table.

Format

This is a six-character value.

Paid Amount

Origin of Data Element

This value comes from the Paid_Amt column of the Food_Instrument table.

Format

This is a five-digit number plus two decimal places.

Filter Criteria

Base of Data

Up to five hundred food instruments redeemed within the selected month are included on the report. The following details how the food instruments are selected.

• Determine the number of food instruments redeemed for the month. Divide the count by 500, giving the interval value. Round to the nearest whole number.

• Determine the current time. Save the last digit of the current time, giving the starting digit value. (Example: If current time were 11:57:48, the starting digit value would be "8".)

• Select list of all food instruments paid within the selected month. Order the list by paid date and check number.

• From this list, the first food instrument selected is the one positioned at the starting digit value point. (Example: If starting digit value equals "8", select the eighth food instrument in the list.)

• Select remaining food instruments based on the interval value, until 500 food instruments have been selected. (Example: If starting digit value equal "8" and interval value equal "50", select food instruments from list in positions 8, 58, 108, 158, 208, 258 and so on until 500 food instruments are selected or at the end of the list.)

Sort Order

Paid Date

This report is sorted first by paid date.

FI Number

This report is sorted by food instrument check number within paid date.