Closed Contract Report

File Name: closed

Description: This report provides a listing of all contracts (prime, support, subcontract and payment only) which have been closed within the date range specified by the user on the prompt screen. The primary sort is CAGE, and then within CAGE by closed date and PIIN-SPIIN. Users can further tailor the query data by ACO, Obligated Dollar Value, Part, CAGE, Buying Activity, Assignment Code, or any combination of these fields.

(Note: Closed Contracts are only retained 7 months after they have closed; therefore, contracts closed longer than 7 months will not be displayed.)

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Date

The begin date to be selected.

ENDING DATE

Required

Date

The end date to be selected.

ORG

Required

Picklist

The CAO's organization code.

ACO

Optional

Text

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

CONTRACT OBLIGATED AMT GREATER THAN OR EQUAL

Optional

Text

Those contracts with obligated dollars equal to or in excess of the amount entered by the User.

PART

Optional

Text

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

ASSIGNMENT CODE

Optional

Text

The code that depicts the level of administration.

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.

 

Report Fields:

Field Name

MOCAS Name

Description

Begin Date

contr closed dt

The beginning date that was entered in the prompt field.

End Date

contr closed dt

The ending date that was entered in the prompt field.

Buying Activity

buyg acty cd

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

ORG

org cd

The CAO's organization code.

Closed Date

contr closed 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.

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.

ACO

aco code

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

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.

Voucher No.

 sub vchr no

The number assigned to the voucher at issuance and appears on the voucher that accompanies the check.

Contract Obligation

obligated amount

The dollar amount stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Part

car partno

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

Dept Code

dept cd

A code used for Service Agency designation.

Asgn Code

asgnm cd

The code that depicts the level of administration.

Totals

N/A

Total count of contracts and total amount of Contract Obligation for the report.

 

Report Sample:

Closed Contract Report

ORG:
'All'
BEGIN DATE: 1998-06-01   END DATE: 1999-08-03
ACO:    CAGE:
BUYING ACTIVITY:    PART:
Date: 1999-08-03
ORG Closed Date CAGE Contractor ACO PIIN SPIIN Voucher
No.
Contract Obligation Part Dept
Code
Asgn
Code
JF 1999-01-25 3P167 SEMTEX INDUSTRIAL CORP JN1
SP0960 97 M8819
    $0.00
B
S
P
SP0960 97 M3070
  F11111 $537.50
B
N
P
SP0960 97 M8784
  F11111 $0.00
A
N
P
SP0960 96 M8285
  F11111 $31,947.00
B
N
P
SE 1999-07-10 07484 ACCURATE BUSHING CO INC SAJ
SP0500 97 D5753
0001 H45604 $10,416.00
B
S
P
1999-01-19 33119 BERTOT INDUSTRIES INC SAH
SP0770 96 MDC44
  H45601 $1,800.00
B
S
P
Totals: 6   $44,700.50  

6 rows returned.

Elapsed time: .33 seconds.

SELECT admin_by_cao, closed_dt, prime_cage, prime_name, aco_code, piin, spiin, sub_voucher_no, obligated_amount, car_partno, dept_cd, assignment_cd FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND closed_dt >= TO_DATE('1998-06-01','YYYY-MM-DD') AND car_partno like '%' AND assignment_cd like '%' AND obligated_amount >= 0000.00 AND closed_dt <= TO_DATE('1999-08-03','YYYY-MM-DD') ORDER BY admin_by_cao,prime_cage, prime_name, aco_code, closed_dt,td_piin, sub_voucher_no, obligated_amount, car_partno, dept_cd,assignment_cd


Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT