Contract Total by Weapon System Code

File Name: kwpnsys

Description: This report provides a listing of the total number of open Prime contracts for a user requested ORG code by Weapons System Codes. The primary sort is Weapons System Code. Users can further tailor the query data by ACO, Cage, Buying Activity, and Section, or any combination of these fields.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO's organization code.

ACO

Optional

Text

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

CAGE

Optional

Text

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

WEAPON SYS CODE

Optional

Text

A code which identifies a priority weapon system selected for inclusion in the Weapon System support program.

BUYING ACTIVITY (2 Pos)

Optional

Text

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

SECTION

Optional

Text

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

 

Report Fields:

Field Name

MOCAS Name

Description

Weapons System

wpn sys des

A code which identifies a priority weapon system selected for inclusion in the Weapon System support program.

Number of Contracts

N/A

Total number of procurement instruments.

Contract Obligation

obligated amount

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

Contract Unliquidated

unlq dv con

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

Totals

N/A

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

 

Report Sample:

Contract Total by Weapon System Code


ORG:
'JF'
ACO:    CAGE:    WEAPON SYS CODE:
BUYING ACTIVITY:    SECTION:
Date: 1999-08-26
Weapons
System
Number of
Contracts
Contract Obligation Contract Unliquidated
ZZZZ 593 $84,881,481.97 $62,670,476.94
NONE 512 $190,910,966.30 $16,725,860.19
3000 29 $78,768,716.94 $1,224,672.37
3BSR 3 $46,549,250.00 $12,169,826.70
2DEA 1 $6,491.16 $0.00
3ACD 1 $3,035,266.54 $0.00
3ACR 1 $21,973.00 $10,318.00
3AHL 1 $44,162,473.13 $1,141,616.41
3ATB 1 $0.00 $0.00
Totals: 1,142 $448,336,619.04 $93,942,770.61

9 rows returned.

Elapsed time: 1.25 seconds.

SELECT weapon_system_cd, count(piin) num_con, SUM(obligated_amount) obligated_amount, SUM(unliq_con_amount) unliq_con_amount FROM contracts WHERE assignment_cd = 'P' AND current_sts < '5' AND admin_by_cao in ('JF') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(weapon_system_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(current_sts,'X') LIKE DECODE('',NULL,'%','%') GROUP BY weapon_system_cd ORDER BY num_con DESC, weapon_system_cd ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT