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 from Appendix B of the TIP user manual.
Origin of Data Element
The value is taken from the TIPStateAgencyCD column of the STATEPROFILE table.
Format
The Agency Code is stored in the TIP file as a fixed length string of 2 characters. This control must contain a value and can not be blank.
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 Federal Fiscal Year masked edit box and spin control on the Generate The Integrity Profile (TIP) screen.
Format
The Fiscal Year is stored in the TIP file as a fixed length string of 4 characters. This control must contain a value and can not be blank.
This value is the ID of the vendor.
Origin of Data Element
The value is taken from the VendorID column of the VENDOR entity.
Format
The vendor ID is stored in the TIP file as a fixed length string of 12 characters. If the vendor ID does not contain 12 characters, spaces is added to the end of the vendor ID until it contains contain 12 characters. This control must contain a value and can not be blank.
This value indicates that the vendor was given their initial contract during the selected fiscal year.
Origin of Data Element
The value of the New Vendor indicator is determined by comparing the DateInitContract column of the VENDOR table to the Date Range From value entered on the Generate The Integrity Profile (TIP) screen.
Format
The New Vendor indicator is stored in the TIP file as a single character. If the value of the DateInitContract column is greater than or equal to the Date Range From value and less than or equal to the Date Range To value, then the letter "X" is stored in the TIP file for the New Vendor indicator. If the date of the initial contract does not fall within the range, then a single space is stored in the TIP file for the New Vendor indicator.
This value indicates whether or not the vendor attended a training session during the selected fiscal year.
Origin of Data Element
The value is determined using the Attended, DateAttended and TrainingType columns of the TRAININGATTENDED table and the category and External-ID columns of the Reference Dictionary.
Format
The Training indicator is stored in the TIP file as a single character.
An "A" is stored as the Training indicator if: The DateAttended is greater than or equal to the Date Range From value and less than or equal to the Date Range To value The value of Reference Dictionary category = 'TRAININGTYPE' The value of Reference Dictionary.ExternalID = "1",.
An "I" is stored for Training indicator The DateAttended is greater than or equal to the Date Range From value and less than or equal to the Date Range To value The value of Reference Dictionary category = 'TRAININGTYPE' If the value of Reference Dictionary.ExternalID = "3",
If the vendor attended both an Annual training and an Interactive training with in the date range, then an "I" is stored in the TIP file for the Training indicator.
If no training sessions are found to fit the criteria, then an N is stored in the TIP file for the Training indicator.
This control must contain a value and may not be left blank.
This value indicates the vendor store type.
Origin of Data Element
The value is determined using the Vendor-Type column of the STORETYPE table via Store-Type-ID column of the VENDOR table.
Format
The Type of Vendor is stored in the TIP file as a single character, using the value of the Vendor-Type column of the StoreType table associated with the vendor's Store Type ID in the following table. This control must contain a value and can not be blank.
StoreType table:
|
Store Type ID |
Vendor Type |
|
Retail |
R |
|
WIC-Only |
W |
|
Above 50% |
A |
|
Commissary |
C |
|
Pharmacy |
P |
|
Home Delivery |
H |
|
Direct Distribution |
D |
This value indicates that the vendor was determined to be high risk during the selected fiscal year.
Origin of Data Element
The value is determined using the High-Risk-Month column of the VENDORHIGHRISK table.
Format
The Risk Designation indicator is stored in the TIP file as a single character.
For the Month-end risk analysis, when the value of the HighRiskMonth column is greater than or equal to the Federal Fiscal Year date range (for example, selecting the 2012 Federal Fiscal Year includes the date range 10/01/2011 - 09/30/2012) and if any of the following columns has a value of "Y", the letter "H" is stored in the TIP file for the Risk Designation indicator.
LoVar
HighAvg
HighCost
OutSideArea
Over10percent
FivedollarOfmax
Within85percent
PercentIncrease
If no vendor high risk entries are found to fit the criteria, the letter "N" is stored in the TIP file for the Risk Designation indicator. This control must contain a value and cannot be blank.
For the High Risk Analysis, when the vendor's score in the HighRiskAnalysisResults record is greater than the threshold value in the HighRiskCriteria table, the letter "H" is stored in the TIP file for the Risk Designation indicator. If there are no high risk analysis results within the fiscal year, the letter "N" is stored in the TIP file for the Risk Designation indicator. This control must contain a value and cannot be blank.
This value is the vendor's Food Stamp Authorization number.
Origin of Data Element
The value is taken from the FS-Authorization-Number column of the VENDOR table.
Format
The FNS Number is stored in the TIP file as a fixed length string of 7 characters. If the vendor is not FSP authorized, then 7 spaces is stored in the TIP file for the FNS Number indicator.
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 Vendor Name is stored in the TIP file as a fixed length string of 50 characters. If the Vendor Name does not contain 50 characters, spaces is added to the end of the Vendor Name until it contains contain 50 characters.
This value is the street number of the vendor's physical address.
Origin of Data Element
The value is taken from the numeric portion of the Physical-Address-1 column of the VENDOR table.
Format
The Vendor Street Number is stored in the TIP file as a fixed length string of 8 characters. If the Vendor Street Number does not contain 8 characters, spaces is added to the end of the Vendor Street Number until it contains contain 8 characters. If the vendor does not have a street number (e.g., the vendor address is stored in the Vendor Additional Address), then 8 spaces is stored in the TIP file for Vendor Street Number.
This value is the street name of the vendor's physical address.
Origin of Data Element
The value is taken from the remainder of the Physical-Address-1 of the VENDOR table.
Format
The Vendor Street Name is stored in the TIP file as a fixed length string of 40 characters. If the Vendor Street Name does not contain 40 characters, spaces is added to the end of the Vendor Street Name until it contains contain 40 characters.
This value is the additional physical address of the vendor.
Origin of Data Element
The value is taken from the Physical-Address-2 column of the VENDOR table.
Format
The Vendor Additional Address is stored in the TIP file as a fixed length string of 40 characters. If the Vendor Additional Address does not contain 40 characters, spaces is added to the end of the Vendor Additional Address until it contains contain 40 characters.
This value is the city where the vendor is located.
Origin of Data Element
The value is taken from the Physical-City column of the VENDOR table.
Format
The Vendor City is stored in the TIP file as a fixed length string of 30 characters. If the Vendor City does not contain 30 characters, spaces is added to the end of the Vendor City until it contains contain 30 characters.
This value is the state where the vendor is located.
Origin of Data Element
The value is taken from the Physical-City column of the VENDOR table.
Format
The Vendor State is stored in the TIP file as a fixed length string of 2 characters.
This value is the ZIP code in which the vendor is located.
Origin of Data Element
The value is the first 5 numbers from the Vendor-Physical-ZIP-Code column of the VENDOR table.
Format
The Vendor ZIP is stored in the TIP file as a fixed length string of 5 characters. This control must contain a value and can not be blank.
This value is the extended ZIP code in which the vendor is located.
Origin of Data Element
The value is the last four numbers from the Physical-ZIP-Code column of the VENDOR table.
Format
The Vendor ZIP +4 is stored in the TIP file as a fixed length string of 4 characters. If the Vendor ZIP +4 does not contain a value or the value equals '0000', then 4 spaces is stored in the TIP file for Vendor ZIP +4.
This value is the WIC redemptions for the vendor during the selected fiscal year.
Origin of Data Element
The value is the Amount-Of-FI-Redeemed column of the REDEMPTIONHISTORY table for the Federal Fiscal Year selected on the Generate TIP File - Step 1 screen.
Format
The Annual WIC Redemptions is stored in the TIP file as a fixed length string of 15 characters. If the value of the Month-Of-Redemption falls within the selected Federal Fiscal Year, the Amount-Of-FI-Redeemed column of the REDEMPTIONHISTORY table is included in the total. If the Annual WIC Redemption indicator does not contain 15 characters, spaces are added to the beginning of the Annual WIC Redemptions indicator until it contains 15 characters. The decimal is place on character space 221. No dollar signs or commas are allowed. This control must contain a value and may not be left blank.
This value indicates the number of months the annual WIC redemptions cover during the selected fiscal year.
Origin of Data Element
The value is a count of the number of entries in the REDEMPTIONHISTORY table and FOODINSTRUMENTITEMREDEEMED table where the value of the Month-Of-Redemption column falls within the date range entered on the Generate TIP File - Step 1 screen.
Format
The Redemption Months is stored in the TIP file as a fixed length string of 2 characters. If the Redemption Months does not contain 2 characters, a zero is added to the beginning of the Redemption Months until it contains contain 2 characters. This control must contain a value and can not be blank.
This value indicates if the vendor had extremely small amount of variation in food instrument prices during the selected fiscal year - the individual food instrument prices do not vary substantially from the average price.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Redemption Indicator A, is stored in the TIP file as a single character.
This value indicates if the vendor had large percent of food instruments redeemed at same price during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Redemption Indicators B, is stored in the TIP file as a single character.
This value indicates if the vendor had unusually high average food instrument prices - submitting extremely high average food instruments compared with similar vendors during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Redemption Indicators C, is stored in the TIP file as a single character.
This value indicates if the vendor had redeemed prices higher than their price list during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Redemption Indicators D, is stored in the TIP file as a single character.
This value indicates if the vendor had large percent of high-priced food instruments during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators E, is stored in the TIP file as a single character.
This value indicates the vendor was flagged for investigation because of volume of WIC business during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators F, is stored in the TIP file as a single character.
This value indicates if the vendor had large increase of dollar volume of food instruments redeemed over time during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators G, is stored in the TIP file as a single character.
This value indicates if the vendor had large percent of the area's total WIC redemptions during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators H, is stored in the TIP file as a single character.
This value indicates if the vendor had WIC sales that are unusually high percentage of vendor's total sales during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators I, is stored in the TIP file as a single character.
This value indicates if the vendor had high WIC to Food Stamps redemption ratio during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators J, is stored in the TIP file as a single character.
This value indicates if the vendor had WIC and Food Stamp sales that are unusually high percentage of total sales during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Volume Indicators K, is stored in the TIP file as a single character.
This value indicates if the vendor had Participant/other complaints during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Participant Indicators L, is stored in the TIP file as a single character.
This value indicates if the vendor had large number of participants redeeming food instruments outside of their health service area during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Participant Indicators M, is stored in the TIP file as a single character.
This value indicates if the vendor had large number of participants redeeming food instruments who are considered to be at high health risk during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Participant Indicators N, is stored in the TIP file as a single character.
This value indicates if the vendor had large number of food instruments with consecutive serial numbers during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Participant Indicators O, is stored in the TIP file as a single character.
This value indicates if the vendor had large percentage of manually issued food instruments during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Participant Indicators P, is stored in the TIP file as a single character.
This value indicates if the vendor had excessive number of returned checks due to errors during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators Q, is stored in the TIP file as a single character.
This value indicates if the vendor had past history of violations and disqualifications during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators R, is stored in the TIP file as a single character.
This value indicates if the vendor had associations with known violators during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators S, is stored in the TIP file as a single character.
This value indicates if the vendor had multiple ownerships that include known violators during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators T, is stored in the TIP file as a single character.
This value indicates if the vendor was short on authorized food items or had no inventory during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators U, is stored in the TIP file as a single character.
This value indicates if the vendor is a new vendor during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators V, is stored in the TIP file as a single character.
This value indicates if the vendor was randomly selected for investigation during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators W, is stored in the TIP file as a single character.
This value indicates if the vendor was selected for investigation for other reasons during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to fill in manually.
Format
The Other Indicators X, is stored in the TIP file as a single character.
This value indicates that a monitoring visit event or follow-up activity is recorded on the Vendor Folder during the selected fiscal year.
Origin of Data Element
The value is a count of the monitoring visit events and monitoring visit follow-up activities using the Start-Date and Type columns of the EVENT table and the Start-Date and Type columns of the FOLLOWUPACTIVITY table. The value of the Start-Date columns is compared to the Federal Fiscal Year value selected on the Generate The Integrity Profile (TIP) screen.
Format
The Number of Routine Monitoring Visits is stored in the TIP file as a fixed length string of 2 characters. If the Event.Type or FollowUpActivity.Type is a monitoring visit, then the total number of monitoring visits during the reporting period for this vendor is stored in the TIP file for the Number of Routine Monitoring Visits column. If no monitoring visits are found to fit these criteria, then 2 spaces is stored in the TIP file for the Number of Routine Monitoring Visits indicator.
This value indicates that the vendor received one or more compliance buys or follow up activity is recorded on the Vendor Folder during the selected fiscal year.
Origin of Data Element
The value is from the Event table that is joined with data from the EventRelationship and FollowUpActivity tables.
Format
The Compliance Investigations are stored in the TIP file as a single character based on the information below:
|
Character |
Investigation Status |
|
<blank> |
The "Compliance Investigations" status is set to <blank> in the following situations:
|
|
I |
The "Compliance Investigations" status is set to "I" (i.e. initiated) in the following situations:
|
|
O |
The "Compliance Investigations" status is set to "O" (i.e. open) in the following situations:
|
|
C |
The "Compliance Investigations" status is set to "C" (i.e. complete) in the following situations:
|
This value indicates that 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. during the selected fiscal year
Origin of Data Element
The value is taken from the ReturnedComplianceBuyFI table where the Bank-Date column is between the start date and end date of the fiscal year being reported and where the From-Outside-Of-System column equals "Y".
Format
The Investigations by Other table is stored in the TIP file as a single character.
This value indicates the total number of compliance buys the vendor received during this fiscal year.
Origin of Data Element
The value is the total count of all Compliance Buy Returned records in the FollowUpActivity table.
Format
The Number of Compliance Buys indicator is stored in the TIP file as a fixed length string of 2 characters.
This value indicates the total number of vendor audit events or follow-up activities during this fiscal year.
Origin of Data Element
The value is the total of all Inventory Audit Type records in the FollowUpActivity table.
Format
The Number of Inventory Audits indicator is stored in the TIP file as fixed length string of 2 characters.
This value indicates that the vendor was found to be trafficking food instruments during the selected fiscal year.
Origin of Data Element
The value is determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction T indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-ID indicates equals 39, then the letter "X" is stored in the TIP file for the Reason for Sanction T indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction T indicator.
This value indicates that the vendor was found providing alcohol or alcoholic beverages or tobacco products in exchange for food instruments during the selected fiscal year.
Origin of Data Element
The value is determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction A indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor provided alcohol or alcoholic beverages or tobacco products in exchange for food instruments, then the letter "X" is stored in the TIP file for the Reason for Sanction A indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction A indicator.
This value indicates that during the selected fiscal year 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 determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction I indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code 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, then the letter "X" is stored in the TIP file for the Reason for Sanction I indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction I indicator.
This value indicates that a violation was recorded for the vendor during the selected fiscal year, 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 determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for O indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates an overcharge, then the letter "X" is stored in the TIP file for the Reason for Sanction O indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction O indicator.
This value indicates that the vendor received or redeemed food instruments outside of authorized channels during the selected fiscal year, which may include an unauthorized vendor and or an unauthorized person.
Origin of Data Element
The value is determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction R indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor received or redeemed food instruments outside of authorized channels, then the letter "X" is stored in the TIP file for the Reason for Sanction R indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction R indicator.
This value indicates that during the selected fiscal year the vendor charged WIC for supplemental food not received by the participant.
Origin of Data Element
The value is determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction F indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor charged WIC for supplemental food not received by the participant, then the letter "X" is stored in the TIP file for the Reason for Sanction F indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction F indicator.
This value indicates that during the selected fiscal year 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 determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction C indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor provided credit or non-food items, then the letter "X" is stored in the TIP file for the Reason for Sanction C indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction C indicator.
This value indicates that during the selected fiscal year 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 determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction U indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor provided unauthorized food items in exchange for food instruments, then the letter "X" is stored in the TIP file for the Reason for Sanction U indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction U indicator.
This value indicates that during the selected fiscal year the vendor was disqualified based on a Food Stamp reciprocal action.
Origin of Data Element
The value is determined using the Identified-Date and Violation-Type-ID columns of the VIOLATION table. For more information, see the ViolationTypeIDs Reported in the TIP File topic.
Format
The Reason for Sanction FSP indicator is stored in the TIP file as a single character. If the Violation-Identified-Date falls during the fiscal year and the Violation-Type-Code indicates that the vendor was disqualified base on a Food Stamp reciprocal action, then the letter "X" is stored in the TIP file for the Reason for Sanction FSP indicator. If no violations are found to fit the criteria, then a single space is stored in the TIP file for the Reason for Sanction FSP indicator.
This value indicates that the vendor was disqualified during the selected fiscal year.
Origin of Data Element
The value is determined using the Occurred-Date and Type columns of the SANCTION table.
Format
The Type of Sanction D indicator is stored in the TIP file as a single character. If the vendor was disqualified during the fiscal year, then the letter "X" is stored in the TIP file for the Type of Sanction D indicator. If the vendor was not disqualified during the fiscal year, then a single space is stored in the TIP file for the Type of Sanction D indicator.
This value indicates that during the selected fiscal year the State agency completed an investigation and imposed a Civil Money Penalty (CMP) on the vendor.
Origin of Data Element
The value is determined using the Occurred-Date and Type columns of the SANCTION table.
Format
The Type of Sanction C indicator is stored in the TIP file as a single character. If the vendor received a CMP during the fiscal year, then the letter "X" is stored in the TIP file for the Type of Sanction C indicator. If the vendor did not receive a CMP, then a single space is stored in the TIP file for the Type of Sanction C indicator.
This value indicates that during the selected fiscal year the State agency completed an investigation and imposed a fine on the vendor.
Origin of Data Element
The value is determined using the Occurred-Date and Type columns of the SANCTION table.
Format
The Type of Sanction F indicator is stored in the TIP file as a single character. If the vendor received a fine during the fiscal year, then the letter "X" is stored in the TIP file for the Type of Sanction F indicator. If the vendor did not receive a fine, then a single space is stored in the TIP file for the Type of Sanction F indicator.
This value indicates that during the selected fiscal year the State agency imposed a State agency sanction on the vendor.
Origin of Data Element
The value is determined using the Occurred-Date and Type columns of the SANCTION table.
Format
The Type of Sanction S indicator is stored in the TIP file as a single character. If the vendor received a State agency sanction during the fiscal year, then the letter "X" is stored in the TIP file for the Type of Sanction S indicator. If the vendor did not receive a State agency sanction, then a single space is stored in the TIP file for the Type of Sanction S indicator.
This value indicates that during the selected fiscal year the State agency sent the vendor a warning letter or did not sanction the vendor.
Origin of Data Element
The value is determined using the Occurred-Date and Type columns of the SANCTION table.
Format
The Type of Sanction N or W indicator is stored in the TIP file as a single character. If the State agency did not sanction the vendor during the fiscal year, then the letter "N" is stored in the TIP file for the Type of Sanction N or W indicator. If the State agency sent the vendor a warning letter during the fiscal year, then the letter "W" is stored in the TIP file for the Type of Sanction N or W indicator. If an investigation was not completed or no investigation was conducted, then a single space is stored in the TIP file for the Type of Sanction N or W indicator.
This value indicates the type of administrative review a vendor appealed during the selected fiscal year. The vendor appealed an adverse action imposed by the State agency.
Origin of Data Element
The value is left blank for the state to be filled in manually.
Format
The Administrative Reviews is stored in the TIP file as a single character, using the Value associated with the Administrative Reviews in the following table:
|
Administrative Reviews |
Value |
|
Pending (P) - The administrative review process was not completed during the fiscal year. |
P |
|
Upheld (U) - The State agency's sanction was upheld by the hearing officer's administrative review decision. |
U |
|
Modified (M) - The State agency's sanction was modified (e.g., length of disqualification or amount of a civil money penalty reduced) by a hearing official or administrative law judge. |
M |
|
Judicial (J - |
J |
|
Overturned (O) - The State agency's sanction was overturned by the hearing officer's administrative review decision. |
O |
If the vendor did not appeal the sanction, then a single space is stored in the TIP file for Administrative Reviews.
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 determined using the Termination-Date and Reason columns of the TERMDISQUALIFICATION table.
Format
The Vendor Agreement indicator is stored in the TIP file as a single character. If the category ID VNDTERMRSN in Reference Dictionary is "4" or "6", the value of "E" is populated in the column. All other VNDTERMRSN options populate "T" in the column. If no termination reasons are found to fit the criteria, then a single space is stored in the TIP file for the Vendor Agreement indicator.
This value indicates that during the selected fiscal year the vendor was disqualified and referred to FSP for reciprocal action during the selected fiscal year.
Origin of Data Element
The value is left blank for the state to be filled in manually.
Format
The Date Referred to FSP indicator is stored in the TIP file as fixed length string of 8 characters. The format is mmddyyyy. If the vendor was referred to FSP for reciprocal action during the fiscal year, then the date of referral is stored in the TIP file for the Date Referred to FSP indicator. If the vendor was not referred to FSP, then 8 spaces is stored in the TIP file for the Date Referred to FSP.
All vendors who had a valid contract during the selected fiscal year is included in the report.
No Farmers Market vendors is included in the report.
|
Software Version: 2.40.00