Cancelling Funds Summary

 

File Name: scancfund

Description: This report provides summary statistics of the number of contracts, ACRNs and ACRN obligations and ACRN unliquidated obligations and progress payment ULO relative to those ACRNs which will expire at the end of the current fiscal year. In addition, the report displays the ULO at risk which is calculated by summing all ULOs excluding basic ACRNs which have a negative ULO, and excluding negative withholds (Subtrans H) and adding properly posted progress payments (properly posted mean in as a credit (-)). Users can tailor the report by ACO, Buying Activity, Dept Code, and Part. The report is sorted in Org Code order and provides report totals.

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.

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.

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.

PART

Optional

Text

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

 

Report Fields:

Field Name

MOCAS Name

Description

Org

org cd

The CAO's organization code.

No of Kts

N/A

Number of contracts.

No of ACRNs

N/A

Number of ACRNs.

Obligation

oblg amt

The dollars that have been committed to a specific effort. Specifically, it is the Contract Total Obligated amount.

Progress Pay ULO

N/A

Progress Payment Unliquidated Obligation-the total remaining dollar obligation on a contract, call/order after disbursements have been made.

Dept

dept cd

A code used for Service Agency designation.

ULO By Service

N/A

Unliquidated Obligation by service

Org Totals

N/A

Totals for the designated Org

At Risk ULO

N/A

The sum of all ULOs excluding negative material lines and negative withholds. Properly posted progress payments are subtracted.

Report Totals

N/A

Total of the individual totals combined.

 

Report Sample:

Cancelling Funds Summary

BUYING ACTIVITY:   DEPT CODE:
ACO:   PART:
SECTION: 'All'
ORG:
'JF', 'LG'

Date: 1999-08-30

ORG No
Kts
No of
Acrns
Obligation Progress Pay
ULO
Dept ULO
By Service
JF 15 19 $22,608,631.60 -$8,666,450.00 AIR FORCE $11,110,059.31
ORG Totals: At Risk ULO: $2,474,787.78 $11,110,059.31
LG 12 26 $296,281,025.28 $1,613,546.34 ARMY $2,543,749.26
AIR FORCE $1,541,078.06
NAVY $611,747.81
ORG Totals: At Risk ULO: $6,969,018.82 $4,696,575.13
Report Totals:
27 45 $318,889,656.88 -$7,052,903.66 $15,806,634.44
At Risk ULO: $9,443,806.60

Elapsed time: 307.93 seconds.

select T1.DEPT_CD, T1.ADMIN_BY_CAO, T1.TD_PIIN, T1.SUB_TRANS_CD, T1.OBLIGATED_ACRN_AMOUNT, T1.UNLIQ_ACRN_AMOUNT, T1.SPIIN, T1.ACRN_ID, T1.TD_PIIN from OLAP_OWNER.CONTRACTS T2, OLAP_OWNER.ACRNS T1, OLAP_OWNER.TB8999 T3 where T2.PINS_AGMT_ID=T1.PINS_AGMT_ID and T2.PRIMARY_FLAG='Y' and (T1.DEPT_CD in ('2', '6') and T1.DEPT_CD || T1.FUND_CD || T1.PGM_YR=T3.TABLE_KEY or not (T1.DEPT_CD in ('2', '6')) and T1.DEPT_CD || T1.FUND_CD=T3.TABLE_KEY) and T1.ASSIGNMENT_CD='P' and T1.UNLIQ_ACRN_AMOUNT <> 0 and T1.ADMIN_BY_CAO in ('JF', 'LG') order by T1.ADMIN_BY_CAO asc, T1.TD_PIIN asc, T1.ACRN_ID asc

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT