security cooperation information portal scip n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SECURITY COOPERATION INFORMATION PORTAL (SCIP) PowerPoint Presentation
Download Presentation
SECURITY COOPERATION INFORMATION PORTAL (SCIP)

Loading in 2 Seconds...

play fullscreen
1 / 20

SECURITY COOPERATION INFORMATION PORTAL (SCIP) - PowerPoint PPT Presentation


  • 144 Views
  • Uploaded on

SECURITY COOPERATION INFORMATION PORTAL (SCIP). Creating Requisition Ad Hoc Query By NSN By Document Number By Case Et Cetera. Initial Welcome Screen. Left-click on “Ad-Hoc ”. Ad Hoc Query Screen. Click cursor on Down Arrow to activate Drop Down-Menu.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SECURITY COOPERATION INFORMATION PORTAL (SCIP)' - acacia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
security cooperation information portal scip

SECURITY COOPERATION INFORMATION PORTAL (SCIP)

Creating Requisition Ad Hoc Query

By NSN

By Document Number

By Case

Et Cetera

initial welcome screen
Initial Welcome Screen

Left-click on “Ad-Hoc”

ad hoc query screen
Ad Hoc Query Screen

Click cursor on

Down Arrow to

activate Drop

Down-Menu

select report active requisition ad hoc
Select Report “Active Requisition Ad Hoc”

Select “Active

Requisition

Ad Hoc” from

Drop Down Menu

select report continued
Select Report Continued

Left Click on

“Continue”

selecting data elements for report
Selecting Data Elements for Report

1. Highlight Data

Element for Report

with Left Click

2. Left Click on -> Arrow

to select highlighted

data element(s)

for report

3. De-select (or remove)

data element from “Selected

Fields” by highlighting it and

left clicking on <- Arrow

4. Order that data elements

appear on report is order that

data elements are selected. However,

order can be changed by highlighting

data element and then left clicking

“Up” or “Down” Arrow

typical data elements for requisition type report continued
Typical Data Elements for Requisition Type Report, Continued

1. Use Bar At

left to position

Screen to see

all “Selected

Fields”

2. When finished selecting data elements

for report, left click on “Detailed Report”

to determine how to sequence data on report

selection criteria
Selection Criteria

Left click on “Add Filter Criteria”

after it changes from light gray

color to black

1. Left Click on Down Arrow

To display possible filters

3. Left Click on Down Arrow

to display possible qualifiers

2. Select “NSN/Part/

Reference Number”

from Drop Down Menu

4. Select “Equals”

5. Key NSN/part number

To be selected

alternative requisition related ad hoc queries
Alternative Requisition Related Ad Hoc Queries
  • For a specific Document Number
    • Select Filter Criteria “Requisition Document Number”
    • Select Filter Qualifier “Equals”
    • Key in applicable Document Number
  • For all active requisitions for a specific LOA
    • Select Filter Criteria “Case Designator Code”
    • Select Filter Qualifier “Equals”
    • Key in applicable Document Number
  • For all active requisitions for a specific Federal Supply Class (e.g., 5331 for O-Rings, 6140 for Rechargeable Batteries, or 9150 for Oils and Greases)
    • Select Filter Criteria “NSN/Part/Reference Number
    • Select Filter Qualifier “Starts With”
    • Key in applicable Federal Supply Class (First 4 Digits of NSN)
alternative requisition related ad hoc queries continued
Alternative Requisition Related Ad Hoc Queries, Continued
  • For all requisitions which shipped in certain timeframe (e.g., last month)
    • Select Filter Criteria “Date of Shipment”
    • Select Filter Qualifier “Is Greater Than or Equals”
    • Key in starting date in mm/dd/yyyy format
    • AND Left Click on Add Filter Criteria
    • Accept Default “And” logic box to left of Filter Criteria
    • Select Filter Criteria “Date of Shipment”
    • Select Filter Qualifier “Is Less Than or Equals”
    • Key in ending date in mm/dd/yyyy
  • Additional qualifiers such as specific LOAs or In-Country Service Codes, etc, can be added to above query (or any query) as needed
alternative requisition related ad hoc queries continued1
Alternative Requisition Related Ad Hoc Queries, Continued
  • Other queries can be created, as needed, for specific country requirements
    • Such as specific Project Coded requisitions (e.g., Project Code “HSP” for Fair Share Sustainment Program)
    • Requisitions in a specific Status Code (i.e., BB - Back Order) more than 12 Months or with an Estimated Ship Date greater than 1 year in future
  • You define the requirement per your information needs and save the queryif needed in the future
report data sort
Report Data Sort

Left Click on Down

Arrow to display

Drop Down Menu

Select Sequence

Option from

Drop Down Menu

report sort continued
Report Sort, Continued

Use Screen Position

Bar at Left to

display bottom of

screen (if large

Number of data

elements have

been included)

Once Report Sort is finalized,

left click on “Confirm”

confirmation of query detail continued
Confirmation of Query Detail,Continued

Screen Display Bar

used to see bottom

of query description

If query is in error,

left click on “Back”

to correct

If query discrepancy

is accurate, left click on

“View Report”

save query screen
Save Query Screen

Key in name of query

(25 characters limit)

for future use.

Left click on “OK” to proceed