Closed Contracts w/o Production Complete Remarks (R8) Detail

File Name: closcond

Description: This report provides a list of all contracts which are either physically complete (in Section 2) or closed and have had no production history built on the contract (i.e. no R-8 Production Complete Remark). The data shown is Org, IS/CMA Code, CAGE, Contractor, PIIN, SPIIN, ACO, Part, Section, Production Surveillance Code, Contract Obligation, Contract Unliquidated, Physical Completion Date, and Closed Date. The report is sorted by ORG, IS/CMA, CAGE, PIIN, and SPIIN. Users can tailor the report by Buying Activity, ACO, CAGE, IS/CMA, and date range. If the user does not enter a date range, the report is cumulative. If the user enters a date range, they will find only those contracts which became physically complete or closed during that timeframe.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

BEGIN DATE

Required

Text

The beginning date to be selected.

END DATE

Required

Text

The end date to be selected.

BUYING ACTIVITY (2 POS)

Optional

Text

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

ACO

Optional

Text

Identifies the Administrative Contracting Officer assigned to the contractor.

CAGE

Optional

Text

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

IS/CMA

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAO’s organization code.

IS/CMA Code

indus spclst cd

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

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.

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.

Part

car partno

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

Section

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.

Prod Surv

prod surv cd

Production Surveillance Code assigned for the level of surveillance.

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

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

Physical Completion Date

phys compl dt

The date the contract moved to CAR Section 2 in MOCAS.

Closed Date

contr clsd dt

The date all administrative actions on a contract have been completed and all excess obligated funds have been removed. The contract is coded as closed in the database.

Total contracts moved to CAO

N/A

Contracts with either a physical completion or a closed date within the stated range.

Total contracts without production complete for CAO

N/A

Contracts that have been moved and do not have production complete remarks (R8).

Total contracts moved for Report

N/A

The grand total of the contracts with either a physical completion or a closed date within the stated range.

Total contracts without production complete for Report

N/A

The grand total of the contracts that have been moved and do not have R8 remarks production complete.

 

Report Sample:

Closed Contracts w/o Production Remarks (R8) Detail

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

ORG
IS/CMA
Code

CAGE

Contractor

PIIN

SPIIN

ACO

Part

Section
Prod
Surv

Contract Obligation

Contract Unliquidated
Physical
Completion Date

Closed Date
JF WN2 3P167 SEMTEX INDUSTRIAL CORP SP0960 97 M8819   JN1 B 9 2 $0.00 $0.00   1999-01-25
SP0960 97 M3070   JN1 B 9 2 $537.50 $0.00 1999-01-25 1999-01-25
SP0960 97 M8784   JN1 A 9 2 $0.00 $0.00 1999-01-25 1999-01-25
Total Contracts Without Production Complete for CAO JF: 3   $537.50 $0.00  
Total Contracts Moved for CAO JF: 4   $32,484.50 $0.00  
SE WR2 07484 ACCURATE BUSHING CO INC SP0500 97 D5753 0001 SAJ B 5 2 $10,416.00 $0.00 1998-04-06 1999-07-10
WS6 01852 THOMAS ELECTRONICS INC SP0960 98 M3803   SAD A 2 2 $0.00 $0.00 1999-04-26  
Total Contracts Without Production Complete for CAO SE: 2   $10,416.00 $0.00  
Total Contracts Moved for CAO SE: 3   $12,216.00 $0.00  
SF WI0 017N4 ALLIEDSIGNAL INC SP0720 00 CE077   XS2 A 2 2 $0.00 $0.00 1999-04-26  
WIS 017N4 ALLIEDSIGNAL INC F41608 90 D0217 0001 XT1 A 2 2 $6,730,409.42 $503,414.03 1999-03-04  
Total Contracts Without Production Complete for CAO SF: 2   $6,730,409.42 $503,414.03  
Total Contracts Moved for CAO SF: 2   $6,730,409.42 $503,414.03  
Total Contracts Without Production Complete for Report: 7   $6,741,362.92 $503,414.03  
Total Contracts Moved for Report: 9   $6,775,109.92 $503,414.03  

9 rows returned.

Elapsed time: .45 seconds.

SELECT admin_by_cao, isp_code, prime_cage, prime_name, piin, spiin, aco_code, car_partno, current_sts, prod_surv_cd, obligated_amount, unliq_con_amount, physical_completion_dt, closed_dt, 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