Closed Contracts w/o Production Remarks (R8) Summary

File Name: closcons

Description: This report provides a statistical summary of number of contracts, and total obligated and unliquidated dollars for those contracts which are either physically complete or closed and have had no production history (R8 Production Complete Remark) built. The report is sorted by ORG Code. Users can tailor the report by Buying Activity, Cage, IS/CMA or ACO. A grand total is provided on the report.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Text

The beginning date to be selected.

END DATE

Required

Text

The end date to be selected.

ORG

Required

Picklist

The CAO’s organization code.

BUYING ACTIVITY (2 POS)

Optional

Text

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

CAGE

Optional

Text

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

IS/CMA Code

Optional

Text

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

ACO

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAO’s organization code.

Contract Count

N/A

The count of contracts.

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

unlq dv cont

Contract Unliquidated Amount

Total Contracts Without Production Complete for CAO(s)

N/A

Total number of contracts moved to the CAO during the date period that do not have production complete remarks.

Total Contracts Moved to CAO(s)

N/A

Total number of contracts moved to the CAO during the date period.

 

Report Sample:

Closed Contracts w/o Production Remarks (R8) Summary

BEGIN DATE: 1999-01-01   END DATE: 1999-08-03
ORG:
'All'
BUYING ACTIVITY:    ACO:    CAGE:    IS/CMA:
Date: 1999-08-04

ORG
Contract
Count

Contract Obligation

Contract Unliquidated
JF 3 $537.50 $0.00
SE 2 $10,416.00 $0.00
SF 2 $6,730,409.42 $503,414.03
Total Contracts Without Production Complete for CAO(s):
7 $6,741,362.92 $503,414.03
Total Contracts Moved to CAO(s):
9 $6,775,109.92 $503,414.03

9 rows returned.

Elapsed time: .25 seconds.

SELECT admin_by_cao, td_piin, obligated_amount, unliq_con_amount, r8_rmks FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NOT prod_surv_cd IN ('9', '5') 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,'%','%') AND ((closed_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND closed_dt <= TO_DATE('1999-08-03','YYYY-MM-DD'))OR (physical_completion_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND physical_completion_dt <= TO_DATE('1999-08-03','YYYY-MM-DD'))) ORDER BY admin_by_cao, isp_code, prime_cage, td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT