Contents Show
The Overpriced Checks Report FDI013 (Output) includes checks redeemed during the selected date range that include infant formula and have a price that exceeds the maximum for the formula type.. The report is generated when the OK button is clicked on the Generate Overpriced Checks Report screen.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
"FDI013"
Format
The value is included as its literal value.
Origin of Data Element
The value is the current value of the REPORTHEADING business rule.
Format
The value is included as its literal value.
Origin of Data Element
The value is the date on which the report is generated.
Format
The value is included in the following format: MM/DD/CCYY. The value will be the current system date when the report is generated.
Origin of Data Element
The value is the name of the user signed in to the system when the report is generated.
Format
The value is included as its literal value. Because of space constraints, all characters of the user's first and last name may not print within the space allotted.
"Overpriced Checks"
Format
The value is included as its literal value and center aligned. It is positioned at the top of the report in the center below the Report Title.
Origin of Data Element
The value is the time at which the report is generated.
Format
The value is included in the following format: HH:MM:SS (AM/PM).
Origin of Data Element
The report date range is the inclusive range of days from which the data included in the report is retrieved and includes a beginning date and an ending date.
Format
The value is center aligned and included in the following format:
"MM/DD/CCYY - MM/DD/CCYY"
Origin of Data Element
The value is the current page of the report.
Format
The value is included as its literal value.
Origin of Data Element
The value comes from the VendorID column of the FoodInstrument database table.
Format
The value can be up to six characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the SerialNo column of the FoodInstrument database table.
Format
The value can be up to eight characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the HouseholdID column of the Member database table where the StateWICID value is equal to the StateWICID value in the FoodInstrumentSet database table where the FoodInstrumentSetID value is equal to the FoodInstrumentSetID value in the FoodInstrument database table.
Format
The value can be up to eight characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the StateWICID column of the FoodInstrumentSet database table where the FoodInstrumentSetID value is equal to the FoodInstrumentSetID value in the FoodInstrument database table.
Format
The value can be up to eight characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the AgencyID column of the FoodInstrumentSet database table where the FoodInstrumentSetID value is equal to the FoodInstrumentSetID value in the FoodInstrument database table.
Format
The value can be up to three characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the ServiceSiteID column of the FoodInstrumentSet database table where the FoodInstrumentSetID value is equal to the FoodInstrumentSetID value in the FoodInstrument database table.
Format
The value can be up to three characters long, numeric or alphabetic, and is left aligned in its column.
Origin of Data Element
The value comes from the PaidDate column of the FoodInstrument database table.
Format
The value is a date formatted as follows: "MM/DD/CCYY".
Origin of Data Element
The value comes from the PaidAmt column of the FoodInstrument database table.
Format
The value is numeric with up to 7 digits, including two decimal places.
Origin of Data Element
The value is derived from the FormulaType value in the FoodItemFormula database table where the FoodItemID value is equal to the FoodItemID value in the FoodInstrumentItem database table where the FoodInstrumentID is equal to the FoodIntsturmentID value in the FoodInstrument database table.
Format
The value displayed is determined by the FormulaType value in the FoodItemFormula database table as follows:
If the FormulaType value is equal to "C", then the value is "Contract".
If the FormulaType value is equal to "M", "N", or "S", then the value is "Special".
If the FormulaType value is not equal to "C", "M", "N", or "S", then the value is "F O O D".
Records in the FoodInstrument database table where the following criteria are true:
The value in the PaidDate column of the FoodInstrument database table falls within the report date range selected by the user.
The value in the Rejected column of the FoodInstrument database table is not equal to "Y".
If the FormulaType value in the FoodItemFormula database table is equal to "C", and the Description value in the ReferenceDictionary database table is not NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Contract":
The FoodIntrument.PaidAmt minus the ReferenceDictionary.Description value is greater than zero.
If the FormulaType value in the FoodItemFormula database table is equal to "C", and the Description value in the ReferenceDictionary database table is NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Contract":
The FoodIntrument.PaidAmt minus 190 is greater than zero.
If the FormulaType value in the FoodItemFormula database table is equal to "M", "N", or "S", and the Description value in the ReferenceDictionary database table is not NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Special":
The FoodIntrument.PaidAmt minus the ReferenceDictionary.Description value is greater than zero.
If the FormulaType value in the FoodItemFormula database table is equal to "M", "N", or "S", and the Description value in the ReferenceDictionary database table is NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Special":
The FoodIntrument.PaidAmt minus 250 is greater than zero.
If the FormulaType value in the FoodItemFormula database table is not equal to "C", "M", "N", or "S", and the Description value in the ReferenceDictionary database table is not NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Other":
The FoodIntrument.PaidAmt minus the ReferenceDictionary.Description value is greater than zero.
If the FormulaType value in the FoodItemFormula database table is not equal to "C", "M", "N", or "S", and the Description value in the ReferenceDictionary database table is NULL where the Category is equal to "OverPricedChecksRpt" and the ExternalID value is equal to "Other":
The FoodIntrument.PaidAmt minus 80 is greater than zero.
The report will be sorted first by file input date.
The report will be sorted by check # within vendor ID.
|
Software Version: 2.40.00
