Security Cooperation Information Portal (SCIP)

1. Security Cooperation Information Portal (SCIP) Ad Hoc Query Instructions To Produce Customer Status of Closed SDRs Report

2. Advantages of SCIP Ad Hoc Report • Timely • No production / mail / distribution delays • Data is current – daily downloads • Easy to use • Just change report timeframes once query is established and saved • Flexible • Country-unique data requirements and qualifiers • Data saved to EXCEL • Easy to sort, count/total, search, select and tailor data • Easy to distribute to required users • Efficient

3. CISIL Report versus SCIP Data Element Names CISILSCIP TC (Type of Case) Not Available CC Country Case Case Designator Code Document Requisition Document Number Plus Requisition Document Number Suffix SDR Customer Assigned SDR Number SF SDR Number Suffix NSN NSN/Part/Reference Number Requisitioned MRO RIC Processing RIC

4. CISIL Report versus SCIP Data Element Names (continued) CISILSCIP Qty Quantity Discrepant Unit Price Unit Price Ext Value SDR Value TY DC Discrepancy Code AC DS Action Code Adj Value Adjudicated Value Bill No Interfund Bill Number Intr Stat (Interim Statement) Not available Act Tkn Action Taken Code Prg Cde Progression Code Prg Dte Progression Date

5. Closed SDR Report 1. Select Ad Hoc Module by Left-Clicking on “Ad Hoc” 2. Select “SDR Ad Hoc” from Drop Down Menu 3. Left-click on “Continue”

6. Select Data Elements for Report • Highlight Data Element • From “Available Fields” • Partial • Listing of Data • Elements on • Closed SDR • Report 2. Use -> arrow to move Selected Data Element to “Selected Fields”

7. Select Data Elements for Report,Continued Use “up” and “Down” arrows to view all selected data elements Left-click on “Detailed Report” once all data elements are selected for report.

8. Determining Sequence of Report Left-click on “down arrow” of data element to be sorted. Left-click on “Ascending” or “Descending’ as applicable. Repeat as necessary.

9. Determining Sequence of Report,Continued Use Screen Positioning Bar at left to position screen to show Lower View. Left-click on “Confirm”

10. Select Data Element as Report Qualifier 1. Left click on “Add Filter Criteria” after it changes from light gray color to black 2. Left-click on Down Arrow to display data elements able to be qualified. Left-click on desired data element. 3. Left-click on Down Arrow and select desired qualifier. 4. Key in value to to be be selected (alpha values Must be Upper Case) 5. Repeat steps 1-4 to add additional Selection Criteria, changing “And/Or” logic as applicable 6. Left-click on “Continue” when finished.

11. Report Data Sequence Left Click on Down Arrow to display Drop Down Menu Select Sequence Option from Drop Down Menu

12. Report Sequence, Continued Use Screen Position Bar at Right to display bottom of screen (if large Number of data elements have been included) Once Report Sort is finalized, left click on “Confirm”

13. Confirmation of Query Detail

14. Report Display Left-click on “Save Ad Hoc Query” To save query for later access. Left-click on “Convert to MS Excel” To convert Report Output to Excel File Data is displayed here.

15. Saving Ad-Hoc Query Key in name of query (25 characters limit) for future use. Left click on “OK” to proceed

16. Saved Query Confirmation

17. Accessing Saved Queries Left-click on Down arrow to display all saved queries. Select desired query and Left-click on “Continue.” Note: user must leave Ad-Hoc before accessing saved query after saving it.

18. Modifying Saved Query Key in new dates as required for next report. When finished keying in changes, left-click on “Continue.”

19. MS Excel File Access Left-click on “Open” Or “Save” as applicable Country specific data deleted.