Prime Contracts by Service

 

File Name: cservsum

Description: This report provides a count of open Prime contracts by Service, Contract Obligation, Contract Unliquidated and Unliquidated Progress Payments. The primary sort is Service. Users can tailor the query data by size of business, ORG Code, ACO, CAGE, Section, Part.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

ORG

Required

Picklist

The CAO’s organization code.

SECTION

Required

Picklist

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

PART

Required

Picklist

Contract Administration Report (CAR) Part Codes assigned to the PIIN-SPIIN displayed.

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.

 

Report Fields:

Field Name

MOCAS Name

Description

Department Name

dept name

A name identifying a Service Agency.

No. of Contracts

n/a

Total number of procurement instruments.

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 Payments

unlq dv pp

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

Totals

n/a

Total count of contracts and total dollar amount of Contact Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

 

Report Sample:

Prime Contracts by Service


SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:     CAGE:
SECTION: 'All'    PART: 'All'
Date: 1999-08-13
Department Name No. of Contracts Contract Obligation Contract Unliquidated Unliquidated Progress Payments
AIR FORCE 622 $5,010,743,798.95 $682,076,861.20 -$253,347,924.84
ARMY 249 $1,083,721,819.52 $38,903,640.07 -$4,014,961.19
DLA 1,523 $101,401,294.44 $49,217,899.78 -$1,592,054.49
DNA 24 $2,000.00 $2,000.00 $0.00
MARINE CORPS 1 $0.00 $0.00 $0.00
MDA 5 $103,099,388.08 $14,384,602.26 -$6,140,366.72
NAVY 811 $10,136,032,449.70 $1,337,275,212.75 -$217,912,292.97
SDI 1 $4,147,344.00 $9,350.43 $0.00
Totals: 3,236 $16,439,148,094.69 $2,121,869,566.49 -$483,007,600.21

8 rows returned.

Elapsed time: .47 seconds.

SELECT dept_name, 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 NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) GROUP BY dept_name ORDER BY dept_name ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT