Contracts Received, Closed, and On-Hand Detail

File Name: statvald

Description: This report provides detail information on contracts received and closed during the date range entered by the user as well as the contracts on hand (Sec 1-4) at the time the report is run. The data shown is Org, Cage, Contractor, PIIN, SPIIN, Kind, Type, Contract Obligation, and Contract Unliquidated. Subtotals are provided by the Received, Closed, and On-Hand contracts, as well as grand totals provided for the report. The report is sorted in Org, Cage, and PIIN/SPIIN sequence. Users can further tailor the query by Buying Activity, Cage, ACO, or IS/CMA Code.

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.

BEGIN DATE

Required

Text

The begin date to be selected.

END DATE

Required

Text

The end date to be selected.

ASSIGNMENT CODE

Required

Picklist

The code that depicts the level of administration.

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.

ACO

Optional

Text

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

IS/CMA CODE

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.

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 service 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.

Asgn Cd

Asgnm cd

The code that depicts the level of administration.

Kind

Kind contr cd

The kind of Contract Code reflects the basic intent of the contract, such as procurement of supplies, services, or research.

Type

Ty contr cd

The specific type of contract pricing provisions.

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.

Closed Contracts Totals

N/A

The amount totals for closed contracts.

Report Totals Received Contracts

N/A

Received contract amounts for the report.

Report Totals On Hand Contracts

N/A

On hand contract amounts for the report.

Report Totals Closed Contracts

N/A

Closed contract amount for the report.

 

Report Sample:

Contracts Received, Closed and On-Hand Detail

BEGIN DATE: 1997-07-01   END DATE: 1999-08-30
ORG:
'JF'
DEPT CODE: 'All'
ASSIGNMENT CODE: 'All'
BUYING ACTIVITY:    ACO:    CAGE: MARY3   IS/CMA:
Date: 1999-08-30

ORG

CAGE

Contractor

PIIN

SPIIN

Asgn Cd

Kind

Type

Contract Obligation

Contract Unliquidated
RECEIVED/ON-HAND CONTRACTS
JF MARY3 RETEST TOO DAAA09 99 C0009   P 2 J $0.00 $0.00
RECEIVED/ON-HAND CONTRACT TOTALS: 1   $0.00 $0.00
RECEIVED/CLOSED CONTRACTS
RECEIVED/CLOSED CONTRACT TOTALS: 0   $0.00 $0.00
ON-HAND CONTRACTS
F09603 99 C0005   P 2 J $0.00 $0.00
ON-HAND CONTRACT TOTALS: 1   $0.00 $0.00
CLOSED CONTRACTS
CLOSED CONTRACT TOTALS: 0   $0.00 $0.00
RECEIVED CONTRACTS: 1 $0.00 $0.00
REPORT TOTALS: CLOSED CONTRACTS: 0 $0.00 $0.00
ON-HAND CONTRACTS: 2 $0.00 $0.00

2 rows returned.

Elapsed time: .04 seconds.

SELECT admin_by_cao, prime_cage, prime_name, piin, spiin, assignment_cd, contract_purpose, contract_type, obligated_amount, unliq_con_amount, received_dt, closed_dt, current_sts FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND admin_by_cao in ('JF') AND (current_sts < '5' OR (current_sts > '4' AND ((closed_dt >= TO_DATE('1997-07-01','YYYY-MM-DD') AND closed_dt <= TO_DATE('1999-08-30','YYYY-MM-DD'))))) AND current_sts > '4' AND (received_dt < TO_DATE('1997-07-01','YYYY -MM-DD') OR received_dt > TO_DATE('1999-08-30','YYYY-MM-DD')) AND prime_cage LIKE DECODE('MARY3',NULL,'%',LPAD('MARY3',6,' ')) AND NVL(isp_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') ORDER BY admin_by_cao, prime_cage, td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT