Orders Against Basic Ordering Agreements/Indefinite Delivery Type Contracts - PIID Compliant

 

File Name: orders_piid

Description: This report provides a listing of all orders against a Basic Ordering Agreements (BOA) or an Indefinite Delivery Type (IDT) contracts within the parameters specified by the user on the prompt screen. The report queries both the PIIN and the R1 PRIME PIIN data to provide the ACO, DFAS and Buying Activities the visibility to orders open or closed within the past 6 months under a BOA/IDT and thus the report data will be useful in supporting contract closeout. The PIIN is a required input and the report's primary sort is by ORG, CAGE, PIIN then SPIIN. Users can further tailor the query data by Section and Part, CAGE, Assignment Code, and Issued By or any combination of these fields.

Designed by DCMA.

Prompt Fields:

Field Name

Type

Value

Description

CONTRACT OBLIGATED AMT GREATER THAN OR EQUAL

Required

Dollar

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

CONTRACT OBLIGATED AMT LESS THAN OR EQUAL

Required

Dollar

Those contracts with obligated dollars equal to or less than the amount entered by the User.

CONTRACT UNLIQUIDATED GREATER THAN OR EQUAL

Required

Dollar

Unliquidated dollars greater than or equal to the amount indicated.

CONTRACT UNLIQUIDATED LESS THAN OR EQUAL

Required

Dollar

Unliquidated dollars less than or equal to the amount indicated.

UNLIQUIDATED PROGRESS PAYMENTS > OR =

Required

Dollar

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor greater than or equal to the amount entered.

UNLIQUIDATED PROGRESS PAYMENTS < OR =

Required

Dollar

Records pertaining to total unrecouped progress payments made to the contractor or subcontractor less than or equal to the amount entered.

OTHER OBLIGATED AMT GREATER THAN OR EQUAL

Optional

Dollar

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

OTHER OBLIGATED AMT LESS THAN OR EQUAL

Optional

Dollar

Those contracts with other obligated dollars (ODO) equal to or less than the amount entered by the User.

PIIN

Required

Text

These are the first 13 digits of the contract number.

ASSIGNMENT CODE

Required

Picklist

The code that depicts the level of administration.

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.

PART

Required

Picklist

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

CAGE

Optional

Text

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

ISSUED BY

Optional

Text

The DoD Activity Address Code of the office that issued the contract. Partial values accepted.

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

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.

PRIME PIIN

r1 prime piin

This entry represents the BOA/IDT if order is PIID compliant i.e. 13 digit with F in 9th position of the PIIN.

CAGE

cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor

contr/payrr 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.

K

kind contr cd

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

T

ty contr cd

The specific type of contract pricing provisions.

P

car partno

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

S

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.

Issued By

dodaac

Organization that issued the contract.

Property Admin

pa code

Three position code that identifies the property administrator.

ODO Obligation

oblamt oth

Other Disbursement Office (ODO) obligated amount of the contract.

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 cont

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

Unliquidated Progress Payments

unlq dv pp

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

Asgn Code

asgnm cd

The code that depicts the level of administration.

Date Closed

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.

Effective Date

eff dt

Contract/Agreement effective date.

Final Delivery Date

fnl-dvy-dt

The final delivery date of the contract.

Totals

n/a

Total dollar amount for ODO Obligation, Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

 

Report Sample:

Orders Against Basic Ordering Agreements/Indefinite Delivery Type Contracts - PIID Compliant ( PIIN: FA862016G3027 )

Contract Obligation From: -10000000000.00    Contract Obligation To: 10000000000.00
Contract Unliquidated From: -10000000000.00    Contract Unliquidated To: 10000000000.00
Unliquidated Progress Payments From: -10000000000.00    Unliquidated Progress Payments To: 10000000000.00
Other Obligated Amount From: -10000000000.00 Other Obligated Amount To: 10000000000.00
PIIN: N0001990G0200    CAGE:     ISSUED BY:     ASSIGNMENT CODE: 'All'
SECTION: 'All'    PART: 'All'
Date: 2016-12-14
ORG PIIN SPIIN PRIME PIIN CAGE Contractor ACO K T P S IssuedBy Property
Admin
ODO
Obligation
Contract Obligation Contract Unliquidated Unliquidated
Progress Payments
Asgn
Code
Date
Closed
Effective
Date
Final
Delivery
Date
(FDD)
AD FA8620 17 F4808   FA8620 16 G3027 05395 L-3 COMMUNICATIONS CORPORATI TD2 6 J A 1 FA8620   $0.00 $0.00 $0.00 $0.00 P   2016-09-09 2017-09-30
AD FA8620 17 F4817   FA8620 16 G3027 05395 L-3 COMMUNICATIONS CORPORATI TD2 6 U A 1 FA8620   $0.00 $0.00 $0.00 $0.00 P   2016-09-30 2017-09-30
AD FA8620 17 F4818   FA8620 16 G3027 05395 L-3 COMMUNICATIONS CORPORATI TD2 6 U A 1 FA8620   $0.00 $0.00 $0.00 $0.00 P   2016-09-16 2020-09-30
AD FA8620 16 G3027     05395 L-3 COMMUNICATIONS CORPORATI TD2 0   A 1 FA8620 AD8 $0.00 $0.00 $0.00 $0.00 P   2016-08-12 2017-08-12
AD FA8620 16 G3027 7014   05395 L-3 COMMUNICATIONS CORPORATI TD2 6 U A 1 FA8620 AD8 $0.00 $0.00 $0.00 $0.00 P   2016-08-29 2017-09-30
AD FA8620 16 F4949   FA8620 16 G3027 05395 L-3 COMMUNICATIONS CORPORATI TD2 1 U A 1 FA8620   $0.00 $9,565,818.00 $9,565,818.00 $0.00 P   2016-09-16 2019-09-30
AD FA8620 16 F4963   FA8620 16 G3027 05395 L-3 COMMUNICATIONS CORPORATI TD2 6 J A 1 FA8620 AD8 $0.00 $4,875,584.00 $4,875,584.00 $0.00 P   2016-08-31 2017-08-31
Totals: 7   $0.00 $14,441,402.00 $14,441,402.00 $0.00  

7 rows returned.

Elapsed time: .01 seconds.

SELECT admin_by_cao,piin,spiin,prime_piin,prime_cage,prime_name,aco_code, contract_purpose,contract_type,car_partno,current_sts,issued_by, property_administrator,other_obligated_amt,obligated_amount, unliq_con_amount,unliq_pp_amount,assignment_cd,closed_dt,eff_date,final_schedule_dt FROM contracts WHERE (piin = 'FA862016G3027' OR prime_piin= 'FA862016G3027') AND obligated_amount >= TO_NUMBER('-10000000000.00') AND obligated_amount <= TO_NUMBER('10000000000.00') AND unliq_con_amount >= TO_NUMBER('-10000000000.00') AND unliq_con_amount <= TO_NUMBER('10000000000.00') AND other_obligated_amt >= TO_NUMBER('-10000000000.00') AND other_obligated_amt <= TO_NUMBER('10000000000.00') AND unliq_pp_amount >= TO_NUMBER('-10000000000.00') AND unliq_pp_amount <= TO_NUMBER('10000000000.00') AND ( issued_by LIKE DECODE('',NULL,'%',LPAD('',6,' ')) OR issued_by LIKE '%%' ) AND ( prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) OR prime_cage LIKE '%%' ) ORDER BY admin_by_cao,prime_cage,td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT