Cancelling Funds Detail

File Name: cancfund

Description: This report provides a list of all contracts with ACRNs that will cancel at the end of the current fiscal year. The data shown is ORG, ACO, CAGE, Contract, Part, Section, PIIN, SPIIN, Kind, Type, ACRN, Fund Code, Department Code, Sub Trans, Appropriation, ACRN Obligation, ACRN Unliquidated. Subtotals (contract count, ACRN count, ACRN obligation, ACRN unliquidated) are shown for the CAGE, ACO, and CAO. 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 which holds (Subtrans H) and adding in properly posted progress payments (properly posted means in as a credit(-)). Users can tailor the report by Section, ACO, Buying Activity, Dept Code and Part.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO's organization code.

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 that identifies the Administrative Contracting Officer assigned to the contract.

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.

ACO

aco code

The code that 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.

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.

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.

K

kind contr cd

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

Type

ty contr cd

The specific type of contract pricing provisions.

ACRN

acrn

Accounting Classification Reference Number-a control number which relates to the long line accounting classification citation number.

Fund Code

fund cd

A code used to indication that funds are available, and for customers, to identify the appropriation and year of funds.

Dept Code

dept cd

A code used for Service Agency designation.

Sub Trans

sub trx cd

Sub Transaction Code of the basic accounting line information.

Appropriation

appropriation

A field that identifies the Department, transfer department, fiscal year, and appropriation fund.

ACRN Unliquidated

unliq dv

Total unliquidated dollar value for this ACRN.

ACRN Obligation

oblg amt

That dollar amount stated at ACRN level.

CAGE Subtotals

N/A

Subtotals for the CAGE.

ACO Subtotals

N/A

Subtotals for the ACO.

ORG Subtotals

N/A

Subtotals for the Org.

Affected Contracts

N/A

The number of contracts affected.

Affected ACRNs

N/A

The number of ACRNs affected.

Net Total ULO

N/A

The subtotals of the Unliquidated Obligation.

Net Total PPULO

N/A

The subtotal of the remaining dollar obligation of the progress payments.

At Risk ULO

N/A

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

Army ULO

N/A

The sum of all Unliquidated Obligations for the Army.

Air Force ULO

N/A

The sum of all Unliquidated Obligations for the Air Force

DLA ULO

N/A

The sum of all Unliquidated Obligations for the DLA.

Navy ULO

N/A

The sum of all Unliquidated Obligations for the Navy.

 

Report Sample:

Cancelling Funds Detail

ORG:
'JF'
SECTION: '4'
BUYING ACTIVITY:   DEPT CODE:
ACO:   PART:

Date: 1999-10-12

ORG ACO CAGE Contractor P S PIIN SPIIN K Type ACRN Fund
Code
Dept
Code
Sub
Trans
Appropriation ACRN
Obligation
ACRN
Unliquidated
JF JN1 7W030 SELECTTECH SERVICES CORP A 4 F33601 90 DJ027 5004 6 Y AB 30 2     $1,578,641.00 -$19,331.84
A 4 F33601 90 DJ027 5004 6 Y BX WN 4     $20,000.00 $20,000.00
CAGE Subtotals: Affected Contracts: 1
Affected ACRNS: 2
$1,598,641.00 $668.16
ACO Subtotals for JN1: Affected Contracts: 1
Affected ACRNS: 2
At Risk ULO: $20,000.00
$1,598,641.00 $668.16
ORG Subtotals for JF: $1,598,641.00 $668.16
Sec/Part Contract ULO Sec/Part Contract ULO
1/A 0 $0.00 1/B 0 $0.00
2/A 0 $0.00 2/B 0 $0.00
3/A 0 $0.00 3/B 0 $0.00
4/A 1 $668.16 4/B 0 $0.00
Affected Contracts: 1 Affected ACRNS: 2
Net Total ULO: $668.16
Net Total PPULO:
At Risk ULO: $20,000.00
Army ULO: $0.00
Air Force ULO: -$19,331.84
DLA ULO: $0.00
Navy ULO: $20,000.00
Report Totals: $1,598,641.00 $668.16
Sec/Part Contract ULO Sec/Part Contract ULO
1/A 0 $0.00 1/B 0 $0.00
2/A 0 $0.00 2/B 0 $0.00
3/A 0 $0.00 3/B 0 $0.00
4/A 1 $668.16 4/B 0 $0.00
Affected Contracts: 1 Affected ACRNS: 2
Net Total ULO: $668.16
Net Total PPULO:
At Risk ULO: $20,000.00
Army ULO: $0.00
Air Force ULO: -$19,331.84
DLA ULO: $0.00
Navy ULO: $20,000.00

Elapsed time: .23 seconds.

select T1.PRIME_CAGE, T1.ACO_CODE, T1.ADMIN_BY_CAO, T1.CAR_PARTNO, T1.CURRENT_STS, T1.OBLIGATED_ACRN_AMOUNT, T1.APPROPRIATION_CD, T1.SUB_TRANS_CD, T1.CONTRACT_TYPE, T1.CONTRACT_PURPOSE, T1.SPIIN, T1.PIIN, T1.PRIME_NAME, T1.UNLIQ_ACRN_AMOUNT, T1.DEPT_CD, T1.ACRN_ID, T1.FUND_CD 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 DECODE(T1.DEPT_CD,'2',T1.DEPT_CD || T1.FUND_CD || T1.PGM_YR, '6', T1.DEPT_CD || T1.FUND_CD || T1.PGM_YR, 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') and T1.CURRENT_STS in ('4') order by T1.ADMIN_BY_CAO asc, T1.ACO_CODE asc, T1.PRIME_CAGE asc, T1.CURRENT_STS asc, T1.TD_PIIN asc, T1.ACRN_ID asc

Query returns 2 rows.

All records displayed

Cancelling Funds Detail

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT