Prime Contracts by Dollar Threshold

File Name: primek

Description: This report provides a listing of all prime contracts by dollar threshold with an ORG and Size of Business specified by the user on the prompt screen. The primary sort is Cage, and then within Cage by PIIN, SPIIN. Users can further tailor the query data by CAGE, ACO, Type Contract, Section, Buying Activity, or any combination of these fields.

At the end of each Cage, Cage totals should be reflected for the following data fields: PIIN, Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

CONTRACT OBLIGATED AMT GREATER THAN OR EQUAL

Required

Interval

Those contracts with obligated dollars equal to or in excess of the amount entered by the User.

CONTRACT OBLIGATED AMT LESS THAN OR EQUAL

Required

Interval

Those contracts with obligated dollars equal to or less than the amount entered by the User.

UNLIQUIDATED GREATER THAN OR EQUAL

Required

Interval

Unliquidated dollars greater than or equal to the amount indicated.

UNLIQUIDATED LESS THAN OR EQUAL

Required

Interval

Unliquidated dollars less than or equal to the amount indicated.

UNLIQUIDATED PROGRESS PAYMENTS > OR EQUAL

Required

Interval

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor greater than or equal to the amount entered.

UNLIQUIDATED PROGRESS PAYMENTS < OR EQUAL

Required

Interval

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor less than or equal to the amount entered.

ORG

Required

Picklist

The CAO’s organization code.

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to the contract.

CAGE

Optional

Text

A unique code assigned by the Government to an entity conducting business with or within the Government.

TYPE CONTRACT

Optional

Text

The specific type of contract pricing provisions.

SECTION

Optional

Text

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

CAGE

cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor

contr/payee name

The official name of the entity supplying goods and services to the Government.

Asgn Code

asgnm cd

The code that depicts the level of administration.

Buy Act

buyg acty cd

The 2-digit Buying Activity Code of the office issuing the contract. These codes can be found in DFARS Appendix G.

Sec

car sec no

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

PIIN

piin

The first 13 digits of the contract number.

SPIIN

spiin

A number used in conjunction with the basic PIIN to identify the contract. This number is referred to as the call/order, or delivery order, under a Blanket Purchase Agreement (BPA), Basic Ordering Agreement (BOA), or Indefinite Delivery-Type (IDT) contract.

ACO

aco code

The code which identifies the Administrative Contracting Officer assigned to the contract.

Kind

kind contr cd

The kind of Contract Code reflects the basic intent of the contract, such as procurement of supplies, services, or research.

Type

ty contr cd

The specific type of contract pricing provisions.

Contract Obligation

obligated amount

The dollar amount stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Contract Unliquidated

unlq dv cont

The total remaining dollar obligation on a contract, call/order after disbursements have been made.

Unliquidated Progress Payment

unlq dv pp

The total unrecouped progress payments made to the contractor or subcontractor.

CAGE Totals

N/A

Total number of contracts and dollars for a specific CAGE.

Totals

N/A

Total number of contracts and dollars for the report.

Report Sample:

Prime Contracts by Dollar Threshold


CONTRACT OBLIGATED AMT GREATER OR EQUAL: -10000000000.00
CONTRACT OBLIGATED AMT LESS THAN OR EQUAL: 10000000000.00
UNLIQUIDATED GREATER THAN OR EQUAL: -10000000000.00
UNLIQUIDATED LESS THAN OR EQUAL: 10000000000.00
UNLIQUIDATED PROGRESS PAYMENTS > OR EQUAL: -10000000000.00
UNLIQUIDATED PROGRESS PAYMENTS < OR EQUAL: 10000000000.00
SIZE OF BUSINESS: 'All'
ORG:
'SF', 'WF'
SECTION: 'All'
ACO:    CAGE:   TYPE CONTRACT: Y  BUYING ACTIVITY: SC
Date: 1999-08-13
ORG CAGE Contractor Asgn
Code
Buy
Act
Sec PIIN SPIIN ACO Kind Type Contract Obligation Contract Unliquidated Unliquidated
Progress Payments
SF 017N4 ALLIEDSIGNAL INC P SC 2
F33657 81 C2047
  XT1 1 Y $26,474,430.57 $120,447.25 $32,190.04
          CAGE Totals:
1
  $26,474,430.57 $120,447.25 $32,190.04
WF 79272 LOCKHEED MARTIN CORP P SC 1
F33657 91 D2236
0008 XV1 1 Y $225,000.00 $9,196.89 $0.00
P SC 2
F33657 91 D2236
0001 XV1 1 Y $198,969.04 $0.00 $0.00
P SC 2
F33657 91 D2236
0002 XV1 1 Y $256,905.99 $0.00 $0.00
P SC 2
F33657 91 D2236
0004 XV1 1 Y $20,000.00 $999.99 $0.00
P SC 2
F33657 91 D2236
0005 XV1 1 Y $100,000.00 $5,000.01 $0.00
P SC 2
F33657 91 D2236
0007 XV1 5 Y $40,000.00 $829.59 $0.00
          CAGE Totals:
6
  $840,875.03 $16,026.48 $0.00
Grand Totals:
7
  $27,315,305.60 $136,473.73 $32,190.04

7 rows returned.

Elapsed time: .39 seconds.

SELECT admin_by_cao, prime_cage, prime_name, assignment_cd, buying_activity_cd, current_sts, piin, spiin, aco_code, contract_purpose, contract_type, count(*) num_con, SUM(obligated_amount) obligated_amount, SUM(unliq_con_amount) unliq_con_amount, SUM(unliq_pp_amount) unliq_pp_amount FROM contracts WHERE assignment_cd = 'P' AND current_sts < '5' AND admin_by_cao in ('SF', 'WF') AND obligated_amount >= -10000000000.00 AND obligated_amount <= 10000000000.00 AND unliq_con_amount >= -10000000000.00 AND unliq_con_amount <= 10000000000.00 AND unliq_pp_amount >= -10000000000.00 AND unliq_pp_amount <= 10000000000.00 AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(contract_type,'X') LIKE DECODE('Y',NULL,'%','Y%') AND NVL(buying_activity_cd,'X') LIKE DECODE('SC',NULL,'%','SC%') GROUP BY admin_by_cao,prime_cage,prime_name,current_sts,td_piin,assignment_cd,buying_activity_cd,piin,spiin,aco_code,contract_purpose,contract_type

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT