Print Columns File line: File/PAN (width 25) Concatenate file name and date – (EBTRemoteIssuance.AvailFileNm and .SentAvailableDt) Pan line File/PAN - PAN (EBTRemoteIssuance.EBTC_ID) Ref Num Remote Issuance Reference Number – (EBTRemoteIssuance.RemoteRefNr Economic Unit Name (width 20) - Based on EBTRemoteIssuance.EBTC_ID Clinic LA ID + + Clinic ID (Based on – ‘-‘ EBTRemoteIssuance.EBTC_ID) Status 10)– EBTRemoteIssuance.StatusCd Remote – ‘EBT Status’ code description Date If status is Available, then – EBTRemoteIssuance.SentAvailableDt If status is Loaded, then EBTRemoteIssuance.IssueDt If status is Canceled, then EBTRemoteIssuance.CancelDt FDTU EBTRemoteIssuedFood.FirstUseDt – Category 35)– FoodCategory.CategoryNr Subcategory (width 40)– Based on EBTRemoteIssuedFood.PCon_ID. Product.SubCategoryNr UOM 6) – Based on EBTRemoteIssuedFood.PCon_ID. ProdContainer.ContainerSizeCd - USDA UOM Description Units EBTRemoteIssuedFood.Quantity – Vendor (width 40) Based on EBTRemoteIssuance.Vend_ID. – Vendor.FFVendorID - Vendor.StoreName if EBTRemoteIssuance.Vend_ID is populated, otherwise blank Sort Order File, PAN, FDTU, Category Number, Subcategory Number Total / Count None Columns State Totals None Primary Group None (page break) Additional File Name Group By Due to amount of displayed information (150% of normal report); the standard report font is not used. A smaller font is selected. This small mockup may need to be viewed in MS Word’s zoom mode.
Print Columns File line: File/PAN (width 25) – Concatenate file name and date (EBTRemoteIssuance.AvailFileNm and .SentAvailableDt) Pan line File/PAN - PAN (EBTRemoteIssuance.EBTC_ID) Ref Num – Remote Issuance Reference Number (EBTRemoteIssuance.RemoteRefNr Economic Unit Name (width 20) - Based on EBTRemoteIssuance.EBTC_ID Clinic – LA ID + ‘-‘ + Clinic ID (Based on EBTRemoteIssuance.EBTC_ID) Status 10)– EBTRemoteIssuance.StatusCd – ‘EBT Remote Status’ code description Date – If status is Available, then EBTRemoteIssuance.SentAvailableDt If status is Loaded, then EBTRemoteIssuance.IssueDt If status is Canceled, then EBTRemoteIssuance.CancelDt FDTU – EBTRemoteIssuedFood.FirstUseDt Category 35)– FoodCategory.CategoryNr Subcategory (width 40)– Based on EBTRemoteIssuedFood.PCon_ID. Product.SubCategoryNr UOM 6) – Based on EBTRemoteIssuedFood.PCon_ID. ProdContainer.ContainerSizeCd - USDA UOM Description Units – EBTRemoteIssuedFood.Quantity Vendor (width 40) – Based on EBTRemoteIssuance.Vend_ID. Vendor.FFVendorID - Vendor.StoreName if EBTRemoteIssuance.Vend_ID is populated, otherwise blank Sort Order File, PAN, FDTU, Category Number, Subcategory Number Total / Count Columns None State Totals None Primary Group (page break) None Additional Group By File Name Due to amount of displayed information (150% of normal report); the standard report font is not used. A smaller font is selected. This small mockup may need to be viewed in MS Word’s zoom mode.
DFDD%20CS%20Clinic%20Services%20Reports.docx