ODO Contracts Received Summary

File Name: odocons

Description: This report provides summary statistics of the number of ODO contracts that have been received/accepted within the date range specified by the user. The data shown is Org, EDI Indicator, Contract Count, ODO Obligation, Contract Obligation, and Contract Unliquidated. The report is sorted by Org. Grand totals are provided. Users can tailor the query by ACO, Cage, or Buying Activity. Note: ODO contracts normally do not contain a obligation or unliquidated obligation as they are paid by other than MOCAS. The only time an ODO contract contains entries in these fields is if it is improperly input into MOCAS, or is a partial ODO, i.e. that is part of the contract is paid by MOCAS and part is paid by another Payment Office.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

BEGIN DATE

Required

Text

Start date of the search.

END DATE

Required

Text

End date of the search.

ORG

Required

Picklist

The CAO's organization code.

DEPT CODE

Required

Picklist

A code used for Service Agency designation.

ACO

Optional

Text

The code with 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 code of the office issuing the contract.

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAO's organization code.

EDI Indicator

edi ind

An indicator as to how the contract was received; E-EDI, M-MILSCAP, Blank-manual input.

Contract Count

N/A

The count of the contracts.

ODO Obligation

odo obligation

The ODO obligation for the contract.

Contract Obligation

obligated

The dollars 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 contact, call/order after disbursements have been made.

Org Sub Totals

N/A

The total for the individual organization.

Report Totals

N/A

Total of individual totals combined.

 

Report Sample:

ODO Contracts Received Summary

BEGIN DATE: 1998-01-01  END DATE: 1999-03-30
ORG:
'JF'
DEPT CODE: 'All'
BUYING ACTIVITY:   ACO:    CAGE:
Date: 1999-08-11
ORG EDI Indicator Contract Count ODO Obligation Contract Obligation Contract Unliquidated
JF EDI 234 $723,038.63 $0.00 $0.00
MILSCAP 63 $4,431,687.68 $0.00 $0.00
ON-LINE 43 $193,671.59 $0.00 $0.00
ORG Sub Totals: 340 $5,348,397.90 $0.00 $0.00
Report Totals
    EDI: 234 $723,038.63 $0.00 $0.00
    MILSCAP: 63 $4,431,687.68 $0.00 $0.00
    ON-LINE: 43 $193,671.59 $0.00 $0.00
Totals: 340 $5,348,397.90 $0.00 $0.00

3 rows returned.

Elapsed time: .33 seconds.

SELECT admin_by_cao, decode (edi_ind,'E','EDI','M','MILSCAP',NULL,'ON-LINE',NULL) edi_ind,count (td_piin) num_con, sum (other_obligated_amt) other_obligated_amt,sum (obligated_amount) obligated_amount,sum (unliq_con_amount) unliq_con_amount FROM contracts WHERE assignment_cd = 'P' AND paying_office = '9' AND admin_by_cao in ('JF') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND received_dt >= TO_DATE('1998-01-01','YYYY-MM-DD') AND received_dt <= TO_DATE('1999-03-30','YYYY-MM-DD') GROUP BY admin_by_cao,edi_ind

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT