Prime Contracts Closed Management Information Report

File Name: mngdrpc1

Description: This report provides a statistical report of all prime contracts closed during a specified date range and the obligated and unliquidated dollars associated with these contracts. Once the contract is closed the unliquidated dollars are deobligated and will reflect zero; therefore there should be no dollar entries in this field. The data is grouped first by fixed price contracts and other than fixed price and then within these categories the data is grouped by Service. Users can further tailor the query data by size of business, ACO, Buying Activity, CAGE or Part.

In addition the report stratifies the number of contracts closed by obligated dollar ranges.

Note: Contracts are only retained in SDW for 7 months after they are closed.

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.

BEGIN DATE

Required

Interval

The begin date to be selected.

END DATE

Required

Interval

The end date to be selected.

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.

BUYING ACTIVITY (2 Pos)

Optional

Text

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

PART A OR B

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

Size of Business

ty contrr cd

The company's relative size code that was entered in the prompt field.

Org

org cd

The CAO's organization code that was entered in the prompt field.

Begin Date

contr clsd dt

The beginning date that was entered in the prompt field.

End Date

contr clsd dt

The ending date that was entered in the prompt field.

Aco

aco code

The Administrative Contracting Officer code that was entered in the prompt field.

Cage

cage

The code assigned to an entity conducting business that was entered in the prompt field.

Buying Activity

buyg acty cd

The Buying Activity code that was entered in the prompt field.

Part

car partno

The Contract Administration Report Part number code that was entered in the prompt field.

Department Name

dept name

A name identifying a Service Agency.

Contracts Closed

piin

The number of contracts closed during a specific time period.

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

unliq dv cont

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

Fixed Price Contract Data

N/A

Statistical data related to fixed price contract.

Fixed Price Totals

N/A

Totals of statistical data related to fixed price contract.

Other Contract Data

N/A

Statistical data related to other contracts.

Other Totals

N/A

Totals of statistical data related to other contract.

Grand Totals

N/A

The total of both fixed price and other contracts.

FFP Contracts Closed ($0-$100,000)

N/A

The number of contracts that are of Fixed price (Contract Type = 'J' or 'K') and have an Obligated amount less than $100,000.

FFP Contracts Closed ($100,000 and higher)

N/A

The number of contracts that are of Fixed price (Contract Type = 'J' or 'K') and have an Obligated amount greater than $100,000.

Other Contracts Closed ($0-$100,000)

N/A

The number of contracts that are of Other Type (Contract Type not 'J' or 'K') and have an Obligated amount less than $100,000.

Other Contracts Closed ($100,000 and higher)

N/A

The number of contracts that are of Other Type (Contract Type not 'J' or 'K') and have an Obligated amount greater than $100,000.

Grand Totals

N/A

Total of all the individual totals combined.

 

Report Sample:

Prime Contracts Closed Management Information Report

SIZE OF BUSINESS: 'All'
ORG:
'All'
BEGIN DATE: 1999-01-01  END DATE: 1999-08-13
ACO:   CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-13
Department
Name
Contracts
Closed
Contract
Obligation
Contract
Unliquidated
 
Fixed Price Contract Data:
 
DLA 3 $12,216.00 $0.00
NAVY 3 $32,484.50 $0.00
Fixed Price Totals: 6 $44,700.50 $0.00
Grand Totals: 6 $44,700.50 $0.00

FFP Contracts Closed ($0-$100,000): 6
FFP Contracts Closed ($100,000 and higher): 0
Other Contracts Closed ($0-$100,000): 0
Other Contracts Closed ($100,000 and higher): 0
Grand Totals: 6
 

2 rows returned.

Elapsed time: .21 seconds.

SELECT decode(contract_type, 'J', 'Fixed Price', 'K', 'Fixed Price', 'Other') contract_type, obligated_amount FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND assignment_cd = 'P' AND current_sts IN ('5','8','9') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND buying_activity_cd LIKE DECODE('',NULL,'%','%') AND closed_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND closed_dt <= TO_DATE('1999-08-13','YYYY-MM-DD')AND car_partno like '%'

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT