Last Updated (2/23/2006)
PD2 Clause logic - Available Data Criteria, Characteristics and SQLs
This document provides a list of the currently available data criteria, characteristics, and SQLs (embedded routines) available to create clause rules.
Available PD² Data Criteria
Vendor CAS Code
Full CAS
Modified CAS
Acceptance Terms By
Acceptance By Contractor
Acceptance By Government
Acceptance Terms Location
Acceptance At Contractor
Acceptance At Government
Bond Type
Both Payment and Performance Bonds
Payment Bond Only
Performance Bond Only
Contract Type
Cost
CPAF (Cost Plus Award Fee)
CPFF (Cost Plus Fixed Fee)
CPIF (Cost Plus Incentive Fee)
CS (Cost Sharing)
FCP-RPD (Fixed Ceiling Price – Retroactive Price Determination)
FFP (Firm Fixed Price)
FFP-LOE (Firm Fixed Price – Level of Effort)
FP-EPA (Fixed Price – Economic Price Adjustment)
FPI (Fixed Price Incentive)
FP-PPR (Fixed Price – Prospective Price Redetermination)
Labor Hour
Time & Materials
Not Cost
Not CPAF (Cost Plus Award Fee)
Not CPFF (Cost Plus Fixed Fee)
Not CPIF (Cost Plus Incentive Fee)
Not CS (Cost Sharing)
Not FCP-RPD (Fixed Ceiling Price – Retroactive Price Determination)
Not FFP (Firm Fixed Price)
Not FFP-LOE (Firm Fixed Price – Level of Effort)
Not FP-EPA (Fixed Price – Economic Price Adjustment)
Not FPI (Fixed Price Incentive)
Not FP-PPR (Fixed Price – Prospective Price Redetermination)
Not Labor Hour
Not Time & Materials
Cost Constraint
Not Separately Priced
Delivery Date
Delivery Date Specified
Delivery Period
ADC (After Date of Contract) Delivery
FOB
C&F Destination
CIF Destination
FAS Vessel
FOB Air Terminal POE
FOB Air Terminal POI
FOB Destination
FOB Destination Consignees Premises
FOB Ex Dock
FOB Inland Carrier
FOB Inland Point
FOB Origin
FOB Origin Contractor’s Facility
FOB Origin Freight Allowed
FOB Origin Freight Prepaid
FOB Origin with Differentials
FOB Vessel
Not C&F Destination
Not CIF Destination
Not FAS Vessel
Not FOB Air Terminal POE
Not FOB Air Terminal POI
Not FOB Destination
Not FOB Destination Consignees Premises
Not FOB Ex Dock
Not FOB Inland Carrier
Not FOB Inland Point
Not FOB Origin
Not FOB Origin Contractor’s Facility
Not FOB Origin Freight Allowed
Not FOB Origin Freight Prepaid
Not FOB Origin with Differentials
Not FOB Vessel
FSC Code
Audit Services (FSC R704)
Bakery (FSC 8920)
Dairy (FSC 8910)
European Union FSCs
FSC 5920
FSC 5925
FSC 6830
FSC 9515
FSC’s C111 – C216, C219, T002, T004, T008, T009, T014, R404
FSC’s J998, J999
FSC S205
Laundry/Dry Cleaning (FSC S209)
Mortuary Services (FSC G001)
Not Dairy (FSC 8910)
Not FSC 6515
Not FSC 6525
Not FSC 6630
Not FSC 6665
Not FSC 8810
Not FSC 8905
Not FSC 8910
Not FSC 8915
Not FSC 8920
Not FSC J019
Not FSC Mortuary Services (FSC G001)
Not Personal Services (FSC R497)
Not Refuse Services (FSC S205)
Personal Services (FSC R497)
Refuse Services (FSC S205)
Stevedoring Services (FSC V114)
FSC Group
Ammunition and Explosives (FSG 13)
European Union FSGs
FSG 14, 15, or 18
FSG 15
FSG 15, 16, or 17
FSG 15, 16, or 18
FSG 19, or 20
FSG 20
FSG 20 or 40
FSG 51 or 52
FSG 70
FSG 74
FSG 91
FSG Q
FSG W
Information Technology (FSG 70 or 74)
Not FSG 91
Not Subsistence (FSG 89)
Subsistence (FSG 89)
HAZMAT Requirements
HAZMAT Requirements
IDC Type
IDDQ (Indefinite Delivery Definite Quantity)
IDIQ (Indefinite Delivery Indefinite Quantity)
Requirements
Not Requirements
Inspection Terms By
Inspection By Contractor
Inspection By Government
Inspection Terms Location
Inspection At Contractor
Inspection At Government
Option Flag
Base Period
Option Period
NAICS
NAICS Identified
Parent CLIN
Is Sub-CLIN
Payment Type
Advance Payment
Not Progress Payment
Progress Payment
Performance of Test (First Article Test or Production Lot Test)
Contractor Activity
Government Activity
Government and Contractor Activity
Period of Performance Start Date
Period of Performance Start Date Specified
Program Code
Program Code A20
Progress Payment Type
Progress Payment – Cost Based
Test Type
First Article Test
Variation in Quantity
Variation in Quantity (+)
Variation in Quantity (-)
FMS Case
FMS
Document Format Name
UCF
Not UCF
Document Number (CON – Contract, IFB – Invitation for Bids, RFP – Request for Proposals, RFQ – Request for Quotes, PO – Purchase Order)
CON
CON or IFB
CON, IFB or PO
CON, IFB, PO or RFP
CON, IFB, PO or RFQ
CON, IFB or RFP
CON, IFB, RFP or RFQ
CON, IFB or RFQ
CON or PO
CON, PO or RFP
CON, PO, RFP or RFQ
CON, PO or RFQ
CON or RFP
CON, RFP or RFQ
CON or RFQ
IFB
IFB or PO
IFB, PO or RFP
IFB, PO, RFP or RFQ
IFB, PO, or RFQ
IFB or RFP
IFB, RFP or RFQ
IFB or RFQ
None
PO
PO or RFP
PO, RFP or RFQ
PO or RFQ
RFP
RFP or RFQ
RFQ
DPAS (Defense Priorities and Allocations System)
DPAS Entered
EFT
EFT (Electronic Funds Transfer) Payment
Purchase Order Type
Bilateral
Not Bilateral
Not Unilateral
Unilateral
Line Item NSN - PD² NSN Field
NSN Not Null
Solicitation to Award – Solicitation Document Number
Award from PD² IFB
Award from PD² RFP
Award from PD² RFQ
Total Cost (Sum of Line Item Price/Cost)
< $1,000,000
< $193,000
< $25,000
< $5,000,000
< $58,550
< $8,422,165
< Simplified Acquisition Threshold
< $50,000
< $7,407,000
< $7,611,532
<= $10,000,000
<= $100,000
<= 25,000
<= $50,000,000
<= $50,000
<= $500,000
<= Micropurchase Threshold
<= Simplified Acquisition Threshold
> $10,000,000
> $500,000
> $100,000
> $2,500
> $25,000
>= $1,000,000
>= $10,000
>= $10,000,000
>= $100,000
>= $190,000
>= $2,000
>= $2,500
>= $25,000
>= $5,000,000
>= $50,000
>= $193,000
>= $500,000
>= $58,550
>= $7,407,000
>= $8,422,165
>= Simplified Acquisition Threshold
Available PD² Characteristics
Applicable Acts
Defense Base Act
Service Contract Act
Competitive Types
Other Than Full and Open
Sole Source
Two Step Bidding
Other
Non-Profits
Office Relocation
EVMS (Earned Value Management System)
A-76 (Contracting Out)
Government Agency, State or Local Government, Foreign Government or Agency
Handling of Ammunition and Explosives
Closing Military Installations
Records on Individuals
Non-SAP (Other Than Simplified Acquisition Procedures)
Shop/Record Drawings
Higher Education
Production Progress Reports
Advisory and Assistance Services
Patents
ECP (Engineering Change Proposals)
Bid Samples
Annual Representations and Certifications
Bill of Lading
Value Engineering
Cost/Schedule Status Report
Contracting Officer’s Representative
GFP (Government Furnished Property)
Rights/Technical Data
Export of Supplies
System Acquisition
Bid Guarantee
Indemnification
UCAs (Undefinitized Contract Actions)
Specialty Metals
Cost and Price Data
Incremental Funding
Royalties
Warranty
Personal Property/Household Goods
Options
Letter Contract
Make or Buy
EPA Designated Item
Master Agreement for Repair and Alteration of Vessels
Multi-year Contact
Brand Name or Equal
Place of Performance
Foreign Contract
Foreign Use
Germany
GOCO (Government Owned - Contractor Operated)
Overseas Performance
North Carolina
New Mexico
Italy
United States
United Kingdom
Spain
Guam
Government Installation (DoD, Government, or Federal Installation)
Product Type
R&D (Research and Development)
A&E (Architect and Engineering)
Facility
Modification and Repair
Leasing of Motor Vehicles
Utilities
DDRI (Dismantling, Demolition, and Removal of Improvements)
Transportation
Supply
Supplies Incidental to Services
Subscriptions
Construction
Services
Services Incidental to Supplies
Communication Services
Commercial Items
Set-Aside Program
Emerging Small Business
Evaluation Preference for SDB (Small Disadvantaged Business)
HUBZONE (Historically Underutilized Business Zone) Set-Aside
HBCU/MI (Historically Black Colleges and Universities/Minority Institutions)
8(a) Set-Aside Under the 2 Feb 02 PA (Partnership Agreement)
SDB (Small Disadvantaged Business) Set-Aside
SBIR (Small Business Innovative Research) Program
SB (Small Business) Set-Aside
8(a) Set-Aside
SBCDP (Small Business Competitive Demonstration Program)
SDVOSB (Service Disabled, Veteran-Owned Small Business)
Solicitation Not in PD²
Award From IFB Not In PD²c
Award From RFP Not In PD²
Award From RFQ Not In PD²
Available PD² SQL Statements
Check for DD 254 in PD²