Contents Show
The report is generated when the OK button is clicked on the Generate TIP File - Step 1 screen.
This section describes the data elements that are stored in the TIP file.
This value is the State Agency Code.
Origin of Data Element
The value is taken from the State Agency Code column of the TIP Report file.
Format
The value prints as a 2 character string, left justified.
This value is the fiscal year selected on the Generate The Integrity Profile (TIP) screen.
Origin of Data Element
The value is taken from the Fiscal Year column of the TIP Report file.
Format
The value prints as a 4 character string, left justified.
This value is the ID of the vendor.
Origin of Data Element
The value is taken from the Vendor-ID column of the TIP Report file.
Format
The value prints as a 12 character string, left justified with trailing spaces.
This value indicates that the vendor was initially enrolled in the WIC program during the selected fiscal year.
Origin of Data Element
The value is determined using the New-Vendor column of the TIP Report file.
Format
The value prints as an "X" for True and a space for False.
This value indicates that the vendor attended either a new vendor training session or an annual training session during the selected fiscal year.
Origin of Data Element
The value is determined using the Training-Performed columns of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates the vendor's store type.
Origin of Data Element
The value is based on the Vendor-Store-Type column of the TIP Report file. The StoreType table VendorType is based on the TIP report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor was determined to be high risk during the selected fiscal year.
Origin of Data Element
The value is taken from the Risk-Designation column of the TIP Report file.
Format
The value prints as a 1 character string.
This value is the Food Stamp Authorization number of the vendor.
Origin of Data Element
The value is taken from the Food-Stamp-Authorization-Number column of the TIP Report file.
Format
The value prints as a 7 character string, left justified.
This value is the name of the vendor.
Origin of Data Element
The value is taken from the Vendor-Name column of the TIP Report file.
Format
The value prints as a 50 character string, left justified with trailing spaces.
This value is the street number of the vendor's physical address.
Origin of Data Element
The value is taken from the Vendor-Street-Number column of the TIP Report file.
Format
The value prints as an 8 character string, left justified with trailing spaces.
This value is the street name of the vendor's physical address.
Origin of Data Element
The value is the concatenation of the Vendor-Street-Name column of the TIP Report file.
Format
The value prints as a 40 character string, left justified with trailing spaces.
This value is the vendor's additional address.
Origin of Data Element
The value is the concatenation of the Vendor-Additional-Address column of the TIP Report file.
Format
The value prints as a 40 character string, left justified with trailing spaces.
This value is the city where the vendor is located.
Origin of Data Element
The value is taken from the Vendor-City column of the TIP Report file.
Format
The value prints as a 30 character string, left justified with trailing spaces.
This value is the state where the vendor is located.
Origin of Data Element
The value is taken from the Vendor-State column of the TIP Report file.
Format
The value prints as a 2 character string.
This value is the ZIP code in which the vendor is located.
Origin of Data Element
The value is taken from the Vendor-ZIP column of the TIP Report file.
Format
The value prints as a 5 character string.
This value is the extended ZIP code in which the vendor is located.
Origin of Data Element
The value is taken from the Vendor-ZIP+4 column of the TIP Report file.
Format
The value prints as a 4 character string.
This value is average amount of WIC benefit redemptions per month for the vendor during the selected fiscal year.
Origin of Data Element
The value is taken from the Annual-WIC-Redemption column of the TIP Report file.
Format
The value prints as a 12 character string, left justified with trailing spaces.
This value indicates the number of months the annual WIC redemptions cover.
Origin of Data Element
The value is taken from the Redemption-Months column of the TIP Report file.
Format
The value prints as a 2 character string, left justified with leading zero.
This value indicates if the vendor had extremely small amount of variation in food instrument prices - the individual food instrument prices do not vary substantially from the average price.
Origin of Data Element
The value is taken from the Redemption-Indicators-A column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had a large percent of food instruments redeemed at the same price.
Origin of Data Element
The value is taken from the Redemption-Indicators-B column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had unusually high average food instrument prices - submitting extremely high average food instruments compared with similar vendors.
Origin of Data Element
The value is taken from the Redemption-Indicators-C column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had redeemed prices higher than their price list.
Origin of Data Element
The value is taken from the Redemption-Indicators-D column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large percent of high-priced food instruments.
Origin of Data Element
The value is taken from the Volume-Indicators-E column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor was flagged for investigation because of volume of WIC business.
Origin of Data Element
The value is taken from the Volume-Indicators-F column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large increase of dollar volume of food instruments redeemed over time.
Origin of Data Element
The value is taken from the Volume-Indicators-G column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large percent of the area's total WIC redemptions.
Origin of Data Element
The value is taken from the Volume-Indicators-H column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had WIC sales that are unusually high percentage of vendor's total sales.
Origin of Data Element
The value is taken from the Volume-Indicators-I column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had high WIC to Food Stamps redemption ratio.
Origin of Data Element
The value is taken from the Volume-Indicators-J column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had WIC and Food Stamp sales that are unusually high percentage of total sales.
Origin of Data Element
The value is taken from the Volume-Indicators-K column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had Participant/other complaints.
Origin of Data Element
The value is taken from the Participant-Indicators-L column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large number of participants redeeming food instruments outside of their health service area.
Origin of Data Element
The value is taken from the Participant-Indicators-M column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large number of participants redeeming food instruments who are considered to be at high health risk.
Origin of Data Element
The value is taken from the Participant-Indicators-N column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large number of food instruments with consecutive serial numbers.
Origin of Data Element
The value is taken from the Participant-Indicators-O column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had large percentage of manually issued food instruments.
Origin of Data Element
The value is taken from the Participant-Indicators-P column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had excessive number of returned checks due to errors.
Origin of Data Element
The value is taken from the Other-Indicators-Q column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had past history of violations and disqualifications.
Origin of Data Element
The value is taken from the Other-Indicators-R column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had associations with known violators.
Origin of Data Element
The value is taken from the Other-Indicators-S column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had multiple ownerships that include known violators.
Origin of Data Element
The value is taken from the Other-Indicators-T column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor was short on authorized food items or had no inventory.
Origin of Data Element
The value is taken from the Other-Indicators-U column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor is a new vendor.
Origin of Data Element
The value is taken from the Other-Indicators-V column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor was randomly selected for investigation.
Origin of Data Element
The value is taken from the Other-Indicators-W column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor was selected for investigations for other reasons.
Origin of Data Element
The value is taken from the Other-Indicators-X column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates the number of monitoring visit event or follow-up activity occurred.
Origin of Data Element
The value is taken from the Number-of-Routine-Monitoring-Visits column of the TIP Report file.
Format
The value prints as a 2 character string, left justified with leading zero.
This value indicates that vendor received one or more compliance buys or follow up activity is recorded on the Vendor Folder.
Origin of Data Element
The value is taken from the Compliance-Investigatiosn column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates if the vendor had compliance investigations conducted by an outside agency, such as another State agency or the Food Stamp Program, or a Federal Law Enforcement agency.
Origin of Data Element
The value is taken from the Investigations-Conducted-by-Entity-Other-than-the-State column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates the total number of compliance buys the vendor received.
Origin of Data Element
The value is taken from the Number-of-Compliance-Buys column of the TIP Report file.
Format
The value prints as a 2 character string, left justified with leading zero.
This value indicates the total number of vendor audit events or follow-up activities.
Origin of Data Element
The value is taken from the Number-of-Inventory-Audits column of the TIP Report file.
Format
The value prints as a 2 character string, left justified with leading zero.
This value indicates that the vendor was found to be trafficking food instruments.
Origin of Data Element
The value is taken from the Reason-for-Sanction-T column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor was found providing alcohol or alcoholic beverages or tobacco products in exchange for food instruments.
Origin of Data Element
The value is taken from the Reason-for-Sanction-A column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor claimed reimbursement for the sale of an amount of a specific supplemental food item that exceeds the store's documented inventory of that supplemental food item for a specific period of time.
Origin of Data Element
The value is taken from the Reason-for-Sanction-I column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that a violation was recorded for the vendor, where the vendor intentionally or unintentionally charged more for authorized supplemental food items than is permitted under the vendor agreement on a compliance buy check.
Origin of Data Element
The value is taken from the Reason-for-Sanction-O column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor received or redeemed food instruments outside of authorized channels, which may include an unauthorized vendor and or an unauthorized person.
Origin of Data Element
The value is taken from the Reason-for-Sanction-R column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor charged WIC for supplemental food not received by the participant.
Origin of Data Element
The value is taken from the Reason-for-Sanction-F column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor provided credit or non-food items, other than alcohol, alcoholic beverages, tobacco products, cash, firearms, ammunition, explosives, or controlled substances in exchange for food instruments.
Origin of Data Element
The value is taken from the Reason-for-Sanction-C column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor provided unauthorized food items in exchange for food instruments, which includes charging for supplemental foods provided in excess of those on the food instrument.
Origin of Data Element
The value is taken from the Reason-for-Sanction-U column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor was disqualified based on Food Stamp reciprocal action.
Origin of Data Element
The value is taken from the Reason-for-Sanction-FSP column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor was disqualified.
Origin of Data Element
The value is taken from the Type-of-Sanction-D column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the State agency completed an investigation and imposed a Civil Money Penalty (CMP) on the vendor.
Origin of Data Element
The value is taken from the Type-of-Sanction-C column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the State agency completed an investigation and imposed a fine on the vendor.
Origin of Data Element
The value is taken from the Type-of-Sanction-F column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the State agency imposed a State agency sanction on the vendor.
Origin of Data Element
The value is taken from the Type-of-Sanction-S column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the State agency sent the vendor a warning letter or did not sanction the vendor.
Origin of Data Element
The value is taken from the Type-of-Sanction-N-or-W column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates the type of administrative review a vendor appealed.
Origin of Data Element
The value is taken from the Administrative-Reviews column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that during the selected fiscal year the vendor contract was terminated or the vendor contract expired and was not renewed.
Origin of Data Element
The value is taken from the Vendor-Agreement column of the TIP Report file.
Format
The value prints as a 1 character string.
This value indicates that the vendor was disqualified and referred to FSP for reciprocal action.
Origin of Data Element
The value is taken from the Date-Referred-to-FSP column of the TIP Report file.
Format
The value prints as a fixed length string of 8 characters. The format is mmddyyyy.
|
Software Version: 2.40.00