Physically Completed Overage Contract

 

File Name: phyovr

Description: This report provides a listing of all overage contracts that are physically complete within the date range specified by the user on the prompt screen. The primary sort is Cage, and then within Cage by Overage date and PIIN-SPIIN. Users tailor the query data by ACO, Buying Activity, Department, Part, or any combination of these fields.

At the end of each ORG listing, totals should be reflected for the following fields: PIIN, Contract Obligation, and Contract Unliquidated.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Date

The beginning date to be selected.

END DATE

Required

Date

The ending date to be selected.

ORG

Required

Picklist

The CAO’s organization code.

PART

Required

Picklist

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

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.

DEPT CODE

Optional

Text

A code used for Service Agency designation.

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

ACO

aco code

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

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.

Part

car partno

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

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.

Buy Act

buyg acty cd

The 2-digit Buying Activity Code of the office issuing the contract. These codes can be found in DFARS Appendix G.

Dept Code

dept code

A code used for Service Agency designation.

Overage Date

ovrg dt

The date that all contract closing actions are scheduled to be completed.

O/A Reason

r2 rsn cds

Overage Reason Code. Defines the reason for delay in contract closure.

ECD

est contr clsg dt

Estimated Closing Date - The anticipated contract close out date.

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 cnt

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

Totals

n/a

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

 

Report Sample:

Physically Completed Overage Contract

BEGIN DATE: 1999-01-01   END DATE: 1999-08-11
ACO:     CAGE:    BUYING ACTIVITY:
DEPT CODE:    PART: 'All'
ORG:
'JF','SE'
Date: 1999-08-11
ORG ACO CAGE Contractor Part PIIN SPIIN Buy
Act
Dept
Code
Overage
Date
O/A
Reason
ECD Contract
Obligation
Contract
Unliquidated
JF JN1 14590 SYSTEMS RESEARCH LAB INC A F33657 89 D0066 0009 SC F 1999-01-31 A   $2,119.70 $0.01
A F33657 89 D0066 0026 SC F 1999-01-31 A   $85,924.86 $0.50
A F33657 89 D0066 0028 SC F 1999-01-31 A   $34,996.96 $0.00
SE SAA 55070 LUCAS AEROSPACE INC A N00019 80 G0572   EF N 1999-06-30     $0.00 $0.00
SAD 01852 THOMAS ELECTRONICS INC A SP0960 98 M3803   UD S 1999-07-31     $0.00 $0.00
SAJ 07484 ACCURATE BUSHING CO INC A SP0500 96 D5G87   TZ N 1999-06-30     $0.00 $0.00
64022 ENGINEERING AND PROFESSIONAL A DAAB07 91 DQ515 0006 BG A 1999-02-28     $38,000.00 $351.58
96487 VALCOR ENGINEERING CORP A N00383 92 MC246   GB N 1999-02-28     $1,245.00 $0.00
Totals: 8   $162,286.52 $352.09

8 rows returned.

Elapsed time: .37 seconds.

SELECT unliq_con_amount, obligated_amount, r2_est_closing_dt, r2_delay_reason_cd, overage_dt,dept_cd, buying_activity_cd, spiin, piin, td_piin, car_partno, prime_name, prime_cage, aco_code, admin_by_cao FROM contracts WHERE (car_partno = 'A' OR car_partno = 'B') AND current_sts = 2 AND assignment_cd = 'P' AND admin_by_cao in ('JF','SE') AND 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 dept_cd LIKE NVL('','%') AND overage_dt >= TO_DATE('1999-01-01','YYYY-MM-DD') AND overage_dt <= TO_DATE('1999-08-11','YYYY-MM-DD') ORDER BY admin_by_cao,aco_code,prime_cage,prime_name,td_piin

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT