Non-Incorporated Registration Index Description

(Partnerships, Trade Names and Trademarks)

The Arizona Secretary of State, Business Services Division (SOSAZ) maintains the database of over one hundred fifty thousand partnership, trade name and trademarks for the state of Arizona. These registrations are referred to as non-incorporated registrations and are used as certified name registrations. They are continuously updated through the process of filing Partnership, Trade name and Trademark applications (NIR) at the SOSAZ, where they are imaged and keyed into the NIR system. The NIR registrations, and soon the images of the registrations, are accessible and completely searchable to the public via the Internet at http://www.azsos.gov.

The NIR Registration Index (NIRRI) from the SOSAZ contains a complete index of all NIR registrations on file at SOSAZ. Because of the enormity of the request, only the information in the index can be readily sold to the public, not the images. The information is the same information presented in the NIR Monthly Registration Index NIRMI.

The NIR Monthly Registration Index (NIRMI) from the SOSAZ typically contains over two thousand records of NIR renewals and applications filed at the SOS in a given month. The index is published on the 15th of each month, 12 times a year. The NIRMI is comprised of the registrations for the previous month one summary file and six informational files: YYYYMMDD.CSV, NIR.TAB, NIR_COM.TAB, NIR_X_AGENT.TAB, AGENT.TAB, COR.TAB and MRK.TAB. The NIRMI contains therein:

Note: Non-incorporated registrations are maintained pursuant to different portions of the Arizona Revised Statutes. For more information on the registration of interest, please visit the information page on the registration type at http://www.azsos.gov.

Since NIR documents are continuously filed, SOS can only guarantee the veracity of the file on its issuance date. Requests for the data must be done in writing and must be accompanied by a check or money order.

Summary Information File (YYYYMMDD.CSV)

Field Name

Description

Common Reference

NIR.FILE_ID

File ID assigned to Registration

COR.COR_CODE

Either RENEW or APP for application

NIR_COM.RECEIVED

Date paperwork was received

NIR_COM.ADD_DATE

Date paperwork was input into the system (this is the criteria for which the reports are run)

NIR_TYP.NIR_SHORT_DESC

Registration Type

NIR.NIR_NAME

Name Registered

NIR.ADDR1

NIR.ADDR2

NIR.CITY

NIR.STATE

NIR.ZIP

NIR.PHONE

NIR.BUSINESSTYPE

General Description of services

AGENT.LASTNAME

Owner's last name

AGENT.FIRSTNAME

Owner's first name

AGENT.MIDDLENAME

AGENT.ADDR1

Owner's address

AGENT.ADDR2

AGENT.CITY

AGENT.STATE

AGENT.ZIP

AGENT.PHONE

Owner's phone, NOT NECESSARILY the business phone

 

General Information Table (NIR Table)

NIR table contains all non-incorporated registered names for the State of Arizona. Though Registration types are defined under different statutes, names must be unique and non-misleading among all Registrations at both the Arizona Secretary of State, Business Services Division and those Incorporated Names found at the Arizona Corporation Commission, Corporations Division. A common index is equally shared between the two offices and is referred to as the Names Table. Registrants are issued a Filing number upon acceptance of an application, which is referred to as the Filing Number for that unique name.

The Filing number with the Registration type (NIR_SUFFIX in the NIR Table) create a unique combination that uniquely identifies a Registration within the Names Table, namely: Trade Name, Trademark or Partnership (Limited, Limited Liability, Limited Liability Limited, Foreign Limited, Foreign Limited Liability, and Foreign Limited Liability Limited).

For these specifications, the NIR_ID has been added to uniquely identify the FILE_ID || NIR_SUFFIX key within the Secretary of State databases. The NIR_ID is not presented to the applicant, nor is it identifiable to the Registration, other than the surrogate reference to a FILE_ID || NIR_SUFFIX combination. NIR_ID is an internal surrogate identifier simply for the ease of maintaining database tables. The NIR.FILE_ID is the number "certified" by this office as a name registration for the State of Arizona.

Field Name

Description

Common Reference

NIR.NIR_ID

Unique Internal Key for Registration

NIR.FILE_ID

File ID - Unique to Registration

Registration Number

NIR.NIR_SUFFIX

Registration Type Key

Lookup in NIR_TYP Table

NIR_TYP.NIR_SHORT_DESC

Registration Type Description

Mark Type

NIR.NIR_STATUS

Status

Active or Inactive

NIR.NIR_NAME

Registered Name

Trade Name

NIR.ADDR1

Address 1

Address of Trade Name

NIR.ADDR2

Address 2

NIR.CITY

City

City of Trade Name

NIR.STATE

State

State of Trade Name

NIR.ZIP

Zip

Same as above

NIR.PHONE

Phone

NIR.BUSINESSTYPE

Business Type, if provided

Goods

NIR.OWNER_TYPE

Owner Individual/Organization Type

Lookup in Owner_Typ table

NIR.OWNER_FILE_ID

Owner Registrant Number

NIR.OWNER_FILE_TYPE

Owner Registrant Information

NIR.STATEOFORIGIN

Location of registration

NIR.DOM_BEGINDATE

Domestic Begin Date

First Use State

NIR.FOR_BEGINDATE

Foreign Begin Date

First Use Anywhere

NIR.REGISTEREDDATE

Initial Registration Date

NIR.ADD_DATE

Timestamp of addition

NIR.CHG_DATE

Timestamp of last update

 

Agent/Owner Information Table (AGENT Table)

Contains the Agents (Owner, Statutory, etc) associated with a Registration.

Field Name

Description

Common Reference

AGENT.AGENT_ID

Unique Internal Key for Registration Entity

AGENT.LASTNAME

Last Name / Full Name for converted data

Entity Name

AGENT.FIRSTNAME

First Name

AGENT.MIDDLENAME

Middle Name

AGENT.ADDR1

Address

Address of Entity

AGENT.ADDR2

Address

AGENT.CITY

City

AGENT.STATE

State

AGENT.ZIP

Zip

AGENT.PHONE

Phone

AGENT.ADD_DATE

Timestamp of addition

AGENT.CHG_DATE

Timestamp of last update

 

Cross Index of Registered Names and Agents (NIR_X_AGENT Table)

Field Name

Description

Common Reference

NIR_X_AGENT.NIR_ID

Unique Internal Key for Registration

Lookup in NIR table

NIR_X_AGENT.AGENT_ID

Unique Internal Key for Registration Entity

Lookup in AGENT table

NIR_X_AGENT.AGENT_CODE

Entity Type

Defines Owner, Service of Process, Filer, etc

NIR_X_AGENT.BEGINDATE

Date Relationship begins

NIR_X_AGENT.ENDDATE

Date Relationship ends

NIR_X_AGENT.ADD_DATE

Timestamp of addition

NIR_X_AGENT.CHG_DATE

Timestamp of last update

 

Registration Information (NIR_COM Table)

The NIR Commission table represents the period(s) of validity for a registration. All registration types at this time are valid for continuous time spans, thus a Registration is valid from the first Received Commission to the expiration of the last RECEIVED expiration (if applicable). Trade Names expire every five years, Trademarks every ten years and Partnerships are either a yearly renewal or a non-expiring registration.

NIR_ID is the NIR_ID from the NIR table.

Field Name

Description

Common Reference

NIR_COM.NIR_COM_ID

Unique Internal Key for Registration Commission

NIR_COM.NIR_ID

Unique Internal Key for Registration

Lookup in NIR table

NIR_COM.RECEIVED

Received Date

Date paperwork received for this commission

NIR_COM.AMENDEDDATE

Amended Date

Last Date this commission was amended

NIR_COM.ASSIGNMENTDATE

Assigned Date

Last Date this commission was Assigned

NIR_COM.EXPIRATIONDATE

Expiration

Expiration date of registration

NIR_COM.CANCELDATE

Cancelled

Cancel date

NIR_COM.REVOKEDATE

Revoked

Date Commission is Revoked

NIR_COM.RENEWALNOTICE

Renewal Notice

Date Renewal was mailed

NIR_COM.EXPIRED

Expired

Date Registration Expired and removed from Index

NIR_COM.ADD_DATE

Timestamp of addition

NIR_COM.CHG_DATE

Timestamp of last update

 

Correspondence History (COR Table)

Contains the correspondences received and sent by the Secretary of State. Contains dates of applications, renewals, annual reports, certifications as well as amendments and other actions to the registration.

Field Name

Description

Common Reference

COR.COR_CODE

Description

Application, Renewal, etc.

COR.COR_DATE

Date

Date filed

COR.NIR_ID

Unique Internal Key for Registration

Lookup in NIR table

COR.NIR_COM_ID

Unique Internal Key for Registration Commission

Lookup in NIR_COM table

COR.CERT_PRINTED

Date Certificate is printed to be mailed

It looks like date added to their system

COR.FICHE_FILMED

Filmed

Date microfilmed

COR.FICHE_LOC_NO

Loc.No.

Microfilm storage location

COR.FICHE_PAGE_NO

Page No.

Microfilm No.

COR.FICHE_PAGES

Pages

Number of pages microfilmed

COR.FICHE_DOCTYPE

Medium Indicator

Fiche, Optical, etc

COR.ADD_DATE

Timestamp of addition

COR.CHG_DATE

Timestamp of last update

 

Trademark Information Table (MRK Table)

Field Name

Description

Common Reference

MRK.NIR_ID

Unique Internal Key for Registration

Lookup in NIR table

MRK.MRK_DESC

Description

Trademark and Descriptive Content

MRK.CLASSCODE

Class Code

Class (IC or US?)

MRK.GOODS_DESC

Description of goods, if provided

MRK.ADD_DATE

Timestamp of addition

MRK.CHG_DATE

Timestamp of last update

 

STATIC TABLES

 

Registered Name Types - Static Table (NIR_TYP Table)

Contains the Registration Types on file with the Secretary of State

NIR_SUFFIX

NIR_CODE

NIR_DESC

NIR_SHORT_DESC

100

RES

Name Reservation

Name Reservation

102

GP

General Partnership

General Partnership

105

1LP

Limited Partnership

LP

106

F1LP

Foreign Limited Partnership

Foreign LP

110

2LP

Limited Liability Partnership

LLP

111

F2LP

Foreign Limited Liability Partnership

Foreign LLP

115

3LP

Limited Liability Limited Partnership

LLLP

116

F3LP

Foreign Limited Liability Limited Partnership

Foreign LLLP

120

MRK

Trademark

Trademark

130

NME

Trade Name

Trade Name

 

Agent Types - Static Table (AGENT_TYP Table)

AGENT_CODE

AGENT_CODE_DESC

AGENT

Agent

GENERAL

General Partner

MEMBER

Member

OWNER

Owner

PARTNER

Partner

PRESIDENT

CEO/President

SERVICEOFPROCESS

Service of Process

SIGNOR

Signor

 

Correspondence Types - Static Table (COR_TYP Table)

COR_CODE

COR_DESC

AMEND

Amendment

ANREP

Annual Report

APP

Application

APP-FICHE

Filing - Fiche

ASSIGN

Assignment

CANCEL

Cancellation

CERT

Certification

CERT_COPY

Certification with Copies

CERT_U_COP

Certification with User Specified Copies

CORRECT

Corrections

DELQDATE

Delinquent App

DEMOTE

Demotion of partnership special designation

EXPIRED

Expiration Notice - Filing Expired

NONCERT

Non-Certification

PHONE

Telephone Conversation

PUBDATE

Published Name

RECDATE

Date Received

REINSTATE

Reinstatement

REMIND

Reminder Notice

REM_ANREP

Reminder Notice for Annual Report

RENEW

Renewal

 

Owner Types - Static Table (OWNER_TYP Table)

OWNER_CODE

ASSOCIATION

CORPORATION

FIRM

FOREIGN CORP.

INDIVIDUAL

L.L.C.

ORGANIZATION

PARTNERSHIP

SOCIETY

See Non-Incorporated Registration Index Options for ordering options.

 

revised 09-NOV-2001 mct