Contracts in Terminal Digit Sequence

File Name: tdseq

Description: This report provides an inventory of all contracts (primes, supports, subcontracts and payment only) in Terminal Digit Sequence. Users can tailor the query data by ORG Code, CAGE, ACO, Section, Part, Buying Activity and IS/CMA Code or any combination of these codes.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO's organization code.

CAGE

Optional

Text

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

ACO

Optional

Text

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

SECTION

Optional

Text

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

PART

Optional

Text

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

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

IS/CMA CODE

Optional

Text

A locally assigned code identifying a specific individual to whom the contract is assigned for surveillance.

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO's organization code.

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.

ACO

aco code

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

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.

Kind

contract purpose

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

Type

contract type

The specific type of contract pricing provisions.

Part

car partno

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

Sec

current sts

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

Asgn Code

assignment code

The code that depicts the level of administration.

IS/CMA Code

isp code

A locally assigned code identifying a specific Industrial Specialist, Engineer, or Contract Management Assistant clerk to whom the contract is assigned for surveillance.

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

unliq dv con

Contract Unliquidated Obligation.

Totals

N/A

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

 

Report Sample:

Contracts in Terminal Digit Sequence

ORG:
'JF'
CAGE: 14590     ACO:       SECTION: 4       PART:
BUYING ACTIVITY:       IS/CMA CODE:
Date: 1999-08-10
ORG CAGE Contractor ACO PIIN SPIIN Kind Type Part Sec Asgn
Code
IS/CMA
Code
Contract Obligation Contract Unliquidated
JF 14590 SYSTEMS RESEARCH LAB INC JN1 F33615 87 D0601 0007 6 U A 4 P WN2 $266,575.00 $100.48
JF 14590 SYSTEMS RESEARCH LAB INC JN1 F33615 91 C1716   2 U A 4 P WN2 $5,844,117.00 -$95,958.00
JF 14590 SYSTEMS RESEARCH LAB INC JN1 F33601 90 DJ028 5200 2 Y A 4 P WN2 $2,035,068.63 $2,035.33
JF 14590 SYSTEMS RESEARCH LAB INC JN1 F33615 88 C1746   2 U A 4 P WN2 $0.00 $0.00
Totals: 4 $8,145,760.63 -$93,822.19
4 rows returned.

Elapsed time: .13 seconds.

SELECT admin_by_cao,prime_cage,prime_name,aco_code, piin,spiin,contract_purpose,contract_type,car_partno,current_sts,assignment_cd,isp_code,obligated_amount, unliq_con_amount FROM contracts WHERE current_sts < '5'AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND admin_by_cao in ('JF') AND prime_cage LIKE DECODE('14590',NULL,'%',LPAD('14590',6,' ')) AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND current_sts LIKE '4' AND car_partno LIKE '%' AND NVL(isp_code,'X') LIKE NVL('','%') ORDER BY td_piin, admin_by_cao,prime_cage, prime_name, aco_code, contract_purpose,contract_type,car_partno,current_sts,assignment_cd, isp_code,obligated_amount,unliq_con_amount

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT