SSDB Companion Guide.docx

Surge & Sustainment Database (SSDB) Companion Guide Introduction This guide was developed to familiarize users with the Surge & Sustainment Database (SSDB) Qlik App. Additional questions not answered in the guide should be directed to a Warstopper Industrial Specialist team email addresses at the applicable MSC using the below:

· DLA HQ Industrial Specialists: HQJ7_warstopperprogram@dla.mil

· DLA Aviation Industrial Specialists: AVNIndustrialPreparedness@dla.mil

· DLA Land & Maritime Industrial Specialists: L.MWarstopper@dla.mil

· DLA Troop Support Industrial Specialists: TS_Warstopper@dla.mil

Please remember to include the Contracting Officer for the upcoming solicitation on the correspondence.

Background The SSDB serves as the Agency’s repository of Service-submitted surge requirements. Once a year, Services submit their “go-to-war requirements” to the DLA War Reserve Office via MILSTRAP (Army, Navy, and Marines) or Consumable Readiness Spares Package (CRSP) (Air Force) data. That data is processed through an algorithm and converted by the Warstopper Program Office to provide a Surge & Sustainment Procurement Rate (SSPR) in D-Phases. Each D-Phase corresponds to a period of 30 days, with D1 equaling days 1-30 after a contingency event, D2 equaling days 31-60 after a contingency event, and so on.

To access the system, a user only needs one Qlik view role, such as:

· EDW Prod - Qlik Sense - General Access - Consumer EDW-00308

· EDW Prod - Qlik Sense Land and Maritime Consumer EDW-00340

· EDW Prod - Qlik Sense - Troop Support - Consumer EDW-00390

· EDW Prod - Qlik Sense Energy Consumer EDW-00330

· EDW Prod - Qlik Sense - Procurement Consumer Role EDW-00394

· EDW Dev - Qlik Sense - Consumer - Finance EDW-00303

· EDW Prod - Qlik Sense - J31 Operations and Sustainment (HQ) - Consumer EDW-00318

· EDW Prod - Qlik Sense - J341 Planning (HQ) - Consumer EDW-00344

· EDW Prod - Qlik Sense - J35 Plans - Consumer EDW-00388 Title Bar and Definitions Below provides a description and definitions on the SSDB Qlik App. As a reminder, please see your local Industrial Specialists if you have additional questions using the e-mail addresses above.

Table 1: Definitions (Moving left to Right on the SSDB page)

· A – Army: An Active Army MILSTRAP Requirement

· B* – Core Army: This item has had a requirement cited in 3 of the last 6 years.

· C – Air Force: Active Consumable Readiness Spares Package (CRSP)

· F – Air Force: OWRMR** Items (within +/- 20% JCS or CRSP)

· G – Air Force: OWRMR** Items (within +/- 20% JCS; adjusted to JCS level)

· H – Air Force: OWRMR** Items (within +/- 20% CRSP; adjusted to CRSP level

· J – OCS: Surge candidates based on peak demand analysis of Joint Staff 9-Series procurements

· L* – Core Marine: This item has had a requirement cited in 3 of the last 6 years.

· M – Marine: An Active Marine MILSTRAP Requirement

· R – Navy: Active Navy Requirement

* Often times the Services will add and drop items off their Requirements submissions to DLA; this Core Requirement is a way to identify critical items that may have dropped for a year but have historical need.

** OWRMR Other War Reserve Material Requirements: This can be of type Army (A), Navy (N), Marine (M) and Air Force (F) Joint Chief of Staff (JCS) project Coded Requisitions.

Performing a Surge Check

1. In the NIIN column, select the magnifying glass. A box should open as pictured below.

2. Enter the NIIN of the item you would like to check into the search box.

a. You can copy and paste multiple NIINs at once into the box, but ensure you are inserting only one NIIN per line.

3. Once the data is entered, select the checkmark.

4. The system will highlight all NIINs entered that have a surge requirement

a. If no data shows, it means there is no surge requirement for the items entered.

5. For items remaining, the SSPR is the current Service requirement.

6. Please note that for some items, there are multiple entries. The system will default to the active requirement (SSPR).

a. For example, if you had an item with an “A”, “B” and “J” surge requirement, the “A” will be the requirement for the item and the only requirement showing an SSPR.

b. The active requirements are “A”, “C”, “M”, and “R”.

c. B & L are both showing requirements that have been listed for 3 of the last 6 years. This is DLA’s attempt at trying to keep requirements consistent.

d. If you have an “A” & “M” these are both requirements and should be combined when you build your solicitation.

CUI-FEDCON

image1.png image2.png image3.png image4.png