Section J-13C ATCH 083-004-1 PPL Template.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 70Z02326R93280004
- Issued by
- Not on record
About this file
This file is a Provisioning Parts List (PPL) template and data dictionary for the Homeland Security Cutter - Light Icebreaker (HSC-L) acquisition. The template establishes the standardized format and requirements for documenting all parts, components, and assemblies required for HSC-L vessel construction and maintenance. The PPL uses a hierarchical structure with indenture codes (top-level systems, sub-assemblies, and components) and requires detailed specifications for each line item including CAGE codes, part numbers, item names, Federal Supply Classification codes, National Item Identification Numbers (NSNs), unit of issue, unit pricing, quantities per assembly and end item, production lead times, shelf life information, criticality codes, and source/maintenance/recoverability codes. Each entry must include a sequentially-incremented Provisioning Document Control Number (PDCN) starting with "HL0001" and unique Provisioning List Item Sequence Numbers (PLISN) formatted as alphanumeric identifiers (e.g., A001).
The template is mandatory for all suppliers and incorporates strict formatting rules, including a 19-character maximum for item names using standard military abbreviations and noun-first nomenclature conventions. Key data elements include essentiality codes (mission critical, safety, or non-essential), reference number category codes, alternate manufacturer CAGE codes and part numbers, demilitarization and criticality codes, precious metal indicators, pilferage sensitivity ratings, maintenance replacement rates, and logistics control numbers reflecting the hardware breakdown structure. This standardized PPL approach enables the Government to maintain comprehensive visibility into vessel component sourcing, pricing, lead times, and supply chain management throughout the IDIQ contract performance period for the HSC-L program.
View the file
Other files
Show 40 more
Latest 50 of 58 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
PPL
PDCN PLISN INDC CAGE PN NAME FSC NIIN UI UI PRICE QPA QPE RNCC RNVC PLT NHA EC SL SLAC QUP SMR ALTCAGE1 ALTPN1 DMIL CC PSPC PMIC MRRI LCN REMARKS
PPL Data Dictionary
| Acronym | Element Type | Format / Length | Required? | Rules & Allowed Values (What to tell the Builder) |
| PDCN | Provisioning Document Control Number | Alphanumeric (6) | Mandatory | Format: Two letters, four numbers (e.g., HL0001). Shall start with "HL0001" and increment sequentially. (Per SOW C.3.083) |
| PLISN | Provisioning List Item Sequence Number | Alphanumeric (4-5) | Mandatory | Unique identifier for each row (e.g., A001). Must be in sequence. |
| INDC | Indenture Code | Numeric (1) | Mandatory | Shows assembly relationship. 1=Top Level, 2=Sub-assembly, 3=Component. |
| CAGE | Commercial & Government Entity | Alphanumeric (5) | Mandatory | The 5-character code for the primary manufacturer. Must be active in SAM.gov. |
| PN | Part Number | Alphanumeric (≤ 32) | Mandatory | The primary manufacturer's part number. Do not include spaces, dashes, or special characters unless they are part of the official manufacturer part designation. |
| NAME | Item Name | Text (≤ 19) | Mandatory | Standard format: Noun, Modifier (e.g., PUMP,CENTRIFUGAL). HARD LIMIT: Max 19 characters including spaces. Must use standard noun-first format (e.g., VALVE,BALL). Use standard military abbreviations to fit (e.g., ASSY for Assembly, XMTR for Transmitter, MTR for Motor) if the name exceeds 19 spaces. |
| FSC | Federal Supply Classification | Numeric (4) | Conditional | First 4 digits of the NSN (e.g., 4730). Required if NIIN is provided. |
| NIIN | National Item Identification Number | Numeric (9) | Conditional | Last 9 digits of the NSN. Use N/A if no NSN exists. |
| UI | Unit of Issue | Text (2) | Mandatory | Must use standard 2-character codes (e.g., EA=Each, HD=Hundred, FT=Foot). |
| UI PRICE | Unit Issue Price | Decimal (2 places) | Mandatory | Price in USD. Do not include "$" symbol (e.g., 150.50). |
| QPA | Quantity per Assembly | Numeric | Mandatory | Quantity of this item used in its direct Next Higher Assembly (NHA). |
| QPE | Quantity per End Item | Numeric | Mandatory | Total quantity of this item used on the entire vessel. |
| RNCC | Reference Number Category Code | Text (1) | Mandatory | Code for the type of Part Number. Use A for CAGE/PN. |
| RNVC | Reference Number Variation Code | Numeric (1) | Mandatory | Always use 1 unless otherwise directed. |
| PLT | Production Lead Time | Numeric | Mandatory | Time in days required to manufacture or procure the item. |
| NHA | Next Higher Assembly | Alphanumeric (4-5) | Conditional | The PLISN of the assembly this item is part of. (Leave blank if INDC is 1). |
| EC | Essentiality Code | Text (1) | Mandatory | Use 1 for Mission Critical, 3 for Safety, 7 for Non-Essential. |
| SL | Shelf Life | Text (1) | Conditional | Single-digit code for items with a limited storage life (e.g., 1 = 3 months). Use 0 if no shelf life. |
| SLAC | Shelf Life Action Code | Text (1) | Conditional | Action code for expired shelf-life items. Required if SL is not 0. |
| QUP | Quantity per Unit Pack | Numeric | Mandatory | The number of items in the smallest package sold by the vendor (e.g., 100 for a box of 100 screws). |
| SMR | Source, Maintenance, Recoverability | Alphanumeric (5-6) | Mandatory | Standard SMR code that defines repair and supply policy (e.g., PAOZZ). |
| ALTCAGE1 | Alternate Cage Code 1 | Alphanumeric (5) | Optional | CAGE code for an approved alternate manufacturer, if one exists. |
| ALTPN1 | Alternate Part Number 1 | Alphanumeric (≤ 32) | Optional | Part number for the alternate manufacturer. |
| DMIL | Demilitarization Code | Text (1) | Mandatory | A single character indicating disposal requirements (e.g., A for no demil required). |
| CC | Criticality Code | Text (1) | Mandatory | A single character indicating safety criticality (e.g., A=Safety Critical). |
| PSPC | Physical Security/Pilferage Code | Text (1) | Mandatory | Code for item's sensitivity to theft (e.g., I for high pilferage risk). |
| PMIC | Precious Metal Indicator Code | Text (1) | Mandatory | A single character indicating if the item contains precious metals. Use A if none. |
| MRRI | Maintenance Replacement Rate | Numeric (Decimal) | Mandatory | The predicted number of replacements per item per year. |
| LCN | Logistics Control Number | Alphanumeric (≤ 18) | Mandatory | Structured code showing hardware breakdown structure. |
| REMARKS | Remarks | Text | Optional | Use for vendor drawing numbers, notes, etc. |
Example
| PDCN | PLISN | INDC | CAGE | PN | NAME | FSC | NIIN | UI | UI PRICE | QPA | QPE | RNCC | RNVC | PLT | NHA | EC | SL | SLAC | QUP | SMR | ALTCAGE1 | ALTPN1 | DMIL | CC | PSPC | PMIC | MRRI | LCN | REMARKS |
| HL0001 | A0001 | 1 | 5M2Y6 | 14.3.00000 | SYSTEM,STABILIZER | 4730 | N/A | EA | 85000 | 1 | 1 | A | 1 | 180 | [Blank] | 1 | 0 | 1 | PAOZZ | A | N | U | A | 0.01 | Z1390100020 | Main Stabilizer System | |||
| HL0001 | A0002 | 2 | 5M2Y6 | 14.3.04346 | MANIFOLD,STABILIZER | 4730 | N/A | EA | 12500 | 1 | 2 | A | 1 | 120 | A0001 | 1 | 0 | 1 | PAOZZ | A | N | U | A | 0.02 | Z1390100020AMIQ | Fits into A0001 |
File details come from the government source that posted it. Updated .