Master Address File

File Name: massadd

Description: This report provides a listing of all contractors within a ORG selected by the user on the prompt screen. The primary sort is by Contractor’s name. Users can further tailor the query data by ACO, IS/CMA, Size of Business, QA ORG, and Contractor Name, or any combination of these fields.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

ACO

Optional

Text

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

IS

Optional

Text

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

CMA

Optional

Text

Contract Management Assistant (CMA).

QA ORG

Optional

Text

Quality Assurance (QA) Organizational Code - This field is used to identify the QA organizational code to which the contractor is assigned.

CONTRACTOR NAME

Optional

Text

The official name of the entity supplying goods or services to the Government.

 

Report Fields:

Field Name

MOCAS Name

Description

CAGE

cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor Name

contr/payee name

The official name of the entity supplying goods and services to the Government.

ORG

cao org cd

The CAO’s organization code.

City

address line

The city where the contractor’s facility is located.

State

address line

The state where the contractor’s facility is located.

Zip

address line

The zip code where the contractor’s facility is located.

ACO

aco cd

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

IS

industrail spec cd

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

CMA

contr mgmt asst cd

Contract Management Assistant- clerk to whom the contract is assigned for surveillance.

PROP

property admin cd

The Property Administrator. Assigned to a person who has property administrator responsibility.

Type

type business cd

The specific type of contract pricing provisions.

QA ORG

qa org cd

Quality Assurance (QA) Organization Code - This field is used to identify the QA Organization Code to which the Contractor is assigned.

Total CAGEs

N/A

Total number of CAGEs that appear on the report.

 

Report Sample:

Master Address File


SIZE OF BUSINESS: 'All'
ORG:
'SE'
ACO: SAA   IS:    CMA:   QA ORG:
CONTRACTOR NAME:    CAGE:
Date: 1999-08-11
CAGE Contractor Name ORG City State Zip ACO IS CMA PROP Type QA
ORG
55070 LUCAS AEROSPACE INC SE ENGLEWOOD NJ 07631 SAA WR4 WR4 WN6 B  
NORM1 WRETEST SE SENDHERE TX 88888 SAA WR4 WR4      
TWEET WRETEST CO SE SOOHERE TX 99999 SAA WR4 WR4      
JENNY WRETEST INC SE LOHERE TX 66666 SAA WR4 WR4      
MICHE WRETEST SOMETIME SE FROMHERE TX 66666 SAA WR4 WR4      
POLLY WRETEST WAY SE TOMHERE TX 88888 SAA WR4 WR4      
Total CAGEs: 6

6 rows returned.

Elapsed time: .14 seconds.

SELECT cage, contractor_name, org_code, city, state, zip, aco_code, isp_code, cma_code, pra_code, contractor_type, qa_org FROM contractors WHERE NVL(aco_code,'X') LIKE DECODE('SAA',NULL,'%','SAA%') AND org_code in ('SE') AND NVL(cma_code, 'X') LIKE DECODE('',NULL,'%','%') AND NVL(qa_org, 'X') LIKE DECODE('',NULL,'%','%') AND contractor_name LIKE DECODE('',NULL,'%','%') AND cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(isp_code, 'X') LIKE DECODE('',NULL,'%','%') AND (NOT aco_code IS NULL OR NOT isp_code IS NULL OR NOT cma_code IS NULL OR NOT pra_code IS NULL OR NOT contractor_type IS NULL OR NOT qa_org IS NULL) ORDER BY contractor_name ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT