Contracts Received, Closed, and On-Hand Summary

File Name: statvals

Description: This report provides statistical summary information on contracts received and closed during the date range specified by the user as well as the contracts on hand (Section 1-4) at the time the report is run. The data shown is Total Contract Obligation, Total Contract Unliquidated Obligation, Contract Count for Received, Closed, and On-Hand categories. User can further tailor the query by ACO, Buying Activity, IS/CMA, or Cage.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

ASSIGNMENT CODE

Required

Picklist

The code that depicts the level of administration.

BEGIN DATE

Required

Text

The begin date to be selected.

END DATE

Required

Text

The end date to be selected.

ACO

Optional

Text

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

BUYING ACTIVITY (2 POS)

Optional

Text

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

IS/CMA CODE

Optional

Text

A locally assigned code identifying a specific individual to whom the contract is assigned for surveillance.

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

Contract Obligation

obligated amount

The dollars 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 contract, call/order after disbursements have been made.

Contract Count

N/A

The count of the contracts.

Received

N/A

The number of contracts received.

Closed

N/A

The number of contracts closed.

On Hand

N/A

The number of contracts On Hand.

 

Report Sample:

Contracts Received, Closed and On-Hand Summary

BEGIN DATE: 1999-08-09   END DATE: 1999-08-10
ORG:
'All'
DEPT CODE: 'All'
ASSIGNMENT CODE: 'All'
BUYING ACTIVITY:    ACO:    CAGE:    IS/CMA:
Date: 1999-08-11


Contract Count

Contract Obligation

Contract Unliquidated
RECEIVED: 0 $0.00 $0.00
CLOSED: 0 $0.00 $0.00
ON-HAND: 3,328 $16,500,962,830.82 $2,125,350,898.62

3 rows returned.

Elapsed time: 11.94 seconds.

SELECT obligated_amount,unliq_con_amount,received_dt,closed_dt, current_sts FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND (current_sts < '5' OR (current_sts > '4' AND ((closed_dt >= TO_DATE('1999-08-09','YYYY-MM-DD') AND closed_dt <= TO_DATE('1999-08-10','YYYY-MM-DD'))))) AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(isp_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%')

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT