Contract Kind Detail

File Name: kinddisd

Description: This report provides a listing of all prime (Assignment Code P) contracts in Sections 1-4 sorted by Contract Kind. The data shown is ORG code, CAGE, Contractor, PIIN, SPIIN, ACO, Buying Activity, Contract Obligation, and Contract Unliquidated. The primary selection is by ORG code, Section, and Dept Code.

The report is in Cage, Kind and PIIN/SPIIN sequence. Users can further tailor the query by Buying Activity, ACO, CAGE and Paying Office. This report is available as a summary report which list statistics as well as a detail report which provides individual contract information.

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.

SECTION

Required

Picklist

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

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.

BUYING ACTIVITY (2 Pos)

Optional

Text

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

PAYING OFFICE

Optional

Text

The DoD Activity Address Code (DODAAC) of the payment office cited on the contract.

 

Report Fields:

Field Name

MOCAS Name

Description

Section

car secno

The contract administration report section number that was entered in the prompt field.

Dept Code

dept cd

The service agency designation code that was entered in the prompt field.

Paying Office

paying office

The DODAAC of the payment office that was entered in the prompt field

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

Buying Activity

buyg act cd

The 2-position code of the Office issuing the contract.

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

unliq dv cont

The total remaining dollar obligation on a contract after disbursements have been made.

Unliquidated Progress Payments

unliq dv pp

The total unrecouped progress payments made to the contractor or subcontractor.

Kind Totals

N/A

The total number of contracts for a particular kind.

Report Totals

N/A

Total of the individual totals combined.

 

Report Sample:

Contract Kind Detail

ORG:
'All'
SECTION: 'All'
DEPT CODE: 'All'
BUYING ACTIVITY: QU  ACO:   CAGE:   PAYING OFFICE:
Date: 1999-08-26
ORG CAGE Contractor PIIN SPIIN ACO Buying
Activity
Contract
Obligation
Contract
Unliquidated
Unliquidated
Progress Payments
KIND: 0 - OTHER
LG
96214 RAYTHEON TI SYSTEMS INC
F08626 97 D0242
  A48
QU
$0.00 $0.00 $0.00
KIND 0 Totals: 1 $0.00 $0.00 $0.00
KIND: 1 - SUPPLY CONTRACT PRICED ORDERS
LG
96214 RAYTHEON TI SYSTEMS INC
F08626 95 C0237
  A49
QU
$9,029,929.21 $290,981.86 $0.00
F08626 97 D0242
0001 A48
QU
$2,104,916.00 $2,104,916.00 -$145,715.00
F08626 93 C0055
  A49
QU
$10,970,925.64 $3.00 $0.00
KIND 1 Totals: 3 $22,105,770.85 $2,395,900.86 -$145,715.00
KIND: 6 - SERVICE CONTRACTS
LG
96214 RAYTHEON TI SYSTEMS INC
F08626 97 C0123
  A48
QU
$2,925,345.00 $2,405,213.00 -$293,706.00
KIND 6 Totals: 1 $2,925,345.00 $2,405,213.00 -$293,706.00
KIND: 8 - UNDEFINED LETTER CONTRACTS
JF
14590 SYSTEMS RESEARCH LAB INC
F41608 90 C2281
  JN1
QU
$34,401,782.00 $22,358.70 $128,854.96
KIND 8 Totals: 1 $34,401,782.00 $22,358.70 $128,854.96
Report Totals: 6 $59,432,897.85 $4,823,472.56 -$310,566.04

6 rows returned.

Elapsed time: 1.05 seconds.

SELECT t1.contract_purpose, t1.admin_by_cao, t1.prime_cage, t1.prime_name, t1.piin, t1.spiin, t1.aco_code,t1.buying_activity_cd, sum (t1.obligated_amount), sum (t1.unliq_con_amount), sum (t1.unliq_pp_amount), t2.table_in_the_clear_entry FROM contracts t1, tb0003 t2 WHERE t1.contract_purpose = t2.table_key(+) AND t1.assignment_cd = 'P' AND NVL(t1.paying_office,'X') LIKE DECODE('',NULL,'%','%') AND NVL(t1.aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(t1.buying_activity_cd,'X') LIKE DECODE('QU',NULL,'%','QU%') AND current_sts < '5' GROUP BY t1.contract_purpose, t2.table_in_the_clear_entry, t1.admin_by_cao, t1.prime_cage, t1.prime_name, t1.td_piin, t1.piin, t1.spiin, t1.aco_code, t1.buying_activity_cd ORDER BY t1.contract_purpose, t2.table_in_the_clear_entry, t1.admin_by_cao, t1.prime_cage, t1.prime_name, t1.td_piin, t1.piin, t1.spiin, t1.aco_code, t1.buying_activity_cd

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT