OREGON 2011 CID DATABASE HELP GUIDE

PLEASE NOTE: ALWAYS VIRUS CHECK BEFORE EXTRACTING DATA FROM CD

DATA IS TIME SENSITIVE 
(Data as of 12/31/2010)

THE CID-DATA.COM™ Oregon CID Database represents the active Common Interest Developments (CIDs -- HOAs, PUDs, etc.) corporations, on file with the Oregon Secretary of State, as of the reference date on the CD. CID-DATA.COM™ publishes the Oregon database annually in December with data as of December 31st of the respective year. Please see the reference date on your CD.

Each database is provided on a Compact Disc (CD) in both an ASCII text tab delimited format (.txt), for easy import into virtually any database management program you may have; and in Microsoft EXCEL (.xls) - Microsoft EXCEL format. Mailing addresses have been verified against the U.S. Postal Service Database. The data is organized in five (5) records for each CID: (1) the Registered Agent for the Association "A"; 2) Association Mailing address "M"; (3) Principal Place of Business “PB”; (4) the President of the Association "P"; and (5) the Secretary "S" of the Association. Once installed in your data management program you can select any record type (A, M or P) and sort the data on parameters based on your needs.  See actual data listing samples below.

NOTE: WHERE WE HAVE BEEN ABLE TO IDENTIFY AN ACTUAL MANAGEMENT COMPANY IN THE "A" AND "M" RECORDS, THE MANAGEMENT COMPANY IS NOW LISTED INSTEAD OF AN INDIVIDUAL MANAGER OR COMPANY CEO'S NAME.

Ten [10] Data Fields

Data Samples:

CORPNAME, CAREOF, ADDRESS, CITY, STATE, ZIP, COUNTY, ADDRTYPE, CORPSTATUS, CORPDATE

Sample 1 (Managed):

"ADDINGTON PLACE HOMEOWNERS ASSOCIATION","NORTHWEST COMMUNITY MANAGEMENT CO","7000 SW HAMPTON ST STE 205","TIGARD","OR","97223", "WASHINGTON","A","1","8/1/1996"

"ADDINGTON PLACE HOMEOWNERS ASSOCIATION","NORTHWEST COMMUNITY MANAGEMENT CO","PO BOX 23099","TIGARD","OR","97281","WASHINGTON", "M","1","8/1/1996"

"ADDINGTON PLACE HOMEOWNERS ASSOCIATION","NORTHWEST COMMUNITY MANAGEMENT CO","7000 SW HAMPTON ST STE 205","TIGARD","OR","97223", "WASHINGTON","PPB","1","8/1/1996"

"ADDINGTON PLACE HOMEOWNERS ASSOCIATION","SCOTT  LEMERT","PO BOX 23099","TIGARD", "OR","97281", "WASHINGTON", "P","1","8/1/1996"

"ADDINGTON PLACE HOMEOWNERS ASSOCIATION","PAM MCKENNA","PO BOX 23099","TIGARD", "OR","97281", "WASHINGTON", "S","1","8/1/1996"


Sample 2 (Self-managed):

"ASSOCIATION OF UNIT OWNERS OF OCEAN PANORAMA CONDOMINIUMS","MONROE GLASS","29134 ELLENSBURG AVE STE 9","GOLD BEACH","OR","97444","GOLD BEACH","A","1","9/19/1983"

"ASSOCIATION OF UNIT OWNERS OF OCEAN PANORAMA CONDOMINIUMS","", "29134 ELLENSBURG AVE", "GOLD BEACH","OR","97444","GOLD BEACH","M","1","9/19/1983"

"ASSOCIATION OF UNIT OWNERS OF OCEAN PANORAMA CONDOMINIUMS","", "29134 ELLENSBURG AVE", "GOLD BEACH","OR","97444","GOLD BEACH","PB","1","9/19/1983"

"ASSOCIATION OF UNIT OWNERS OF OCEAN PANORAMA CONDOMINIUMS","MONROE GLASS","29134 ELLENSBURG AVE STE 9","GOLD BEACH"," OR","97444","GOLD BEACH","P","1","9/19/1983"

"ASSOCIATION OF UNIT OWNERS OF OCEAN PANORAMA CONDOMINIUMS","JERRY BIEWIND","31804 RUMLEY HILL RD","GOLD BEACH"," OR","97444","GOLD BEACH","S","1","9/19/1983"

Sample 3 (Developer Controlled):

"THE ELLIOT ESTATES ROW HOUSES HOME OWNERS ASSOCIATION", "SEQUOIA CUSTOM HOMES LLC", "11785 SE HWY 212 STE 313", "CLACKAMAS", "OR", "97015", "CLACKAMAS", "A", "1", "2/17/2004"

"THE ELLIOT ESTATES ROW HOUSES HOME OWNERS ASSOCIATION", "SEQUOIA CUSTOM HOMES LLC", "11785 SE HWY 212 STE 313", "CLACKAMAS", "OR", "97015", "CLACKAMAS", "M", "1", "2/17/2004"

"THE ELLIOT ESTATES ROW HOUSES HOME OWNERS ASSOCIATION"," TIM LIESY", "11785 SE HWY 212 STE 313", "CLACKAMAS", "OR", "97015", "CLACKAMAS", "P", "1 2/17/2004"

"THE ELLIOT ESTATES ROW HOUSES HOME OWNERS ASSOCIATION","PAULA LEHR ", "11785 SE HWY 212 STE 313", "CLACKAMAS", "OR", "97015", "CLACKAMAS", "S", "1 2/17/2004"

Explanation of Data Fields:

FIELD
MEANING
"CORPNAME" Association's corporate name
"CAREOF" Designates "in-care-of" corresponds to the "ADDRTYPE" (may be blank)
"ADDRESS" Street or PO mailing address corresponding to the "ADDRTYPE"
"CITY" City corresponding to the record address
"STATE" State corresponding to the record address
"ZIP" ZIP Code
"COUNTY" County location
"ADDRTYPE" Record Type Registered Agent/Manager "A"; Mailing "M";Principal Place of Business "PPB", President "P"; and Secretary "S"
"CORPDATE" Date of first corporate filing (MM/DD/YYYY)
"CORPORATE STATUS" Only "Active Associations " status = 1 are included in our initial database

Agent's Record
The "Agent" (Statutory Agent/Agent for Service) may or may not be a management company - it may be a law firm, CPA, member of the Board of Directors, etc. In those cases where the association also has an identifiable management company - it will be listed in both the "A" and the "M" records. . Additionally, we try to maintain up-to-date management company and other related business entity contact records, and where we have a more current physical address for the company, than that listed in the latest corporate filing, we have substituted the new address.

President's Record
The president may have elected to receive all association related mail addressed, in their name, at the address of the Agent, or the Community Association Manager, if managed. CID-DATA.COM™ has no control over this selection.

Accuracy of the Data
Our goal is to provide you the highest quality data at the most economical price. CID-DATA.COM™ data is derived from the corporate filings that Common Interest Developments (CIDs) submit to the Secretary of State. CID-DATA.COM™ has no control over the following activities, which may introduce inaccuracies in the data:

  • How the form was completed by the registered agent for the association.
  • Whether the registered agent submitted the form in a timely manner.
  • The address used for the President. This address may also be the agent's address, if the
    Agent (manager) filled out the form.
  • The accuracy of the data as it was entered into the Secretary of State's master database by
    their data entry personnel.
  • The accuracy of the data contained in the Secretary of State's master database at any given time. Some records indicate an active status code "1" but may not have been updated since
    the last indicated file date, as the required filings, apparently were not submitted.
  • If fields were left blank in the submission to Secretary of State, then the respective field in
    our database is empty.
  • The scheduling of an association's annual meeting. Therefore the name of the President and the listed address may have changed during the time the latest version of the database was run and the time your order was filled.

Note: In order to provide you with the most accurate data avaulable, we have reviewed ALL entries and attempted to correct obvious inaccuracies and conducted extensive Q/A on the original data received.

New CIDs
If a CID has recently been incorporated and the project is still in build-out, a board President may not have been elected and the "P" record will be blank. Additionally, there may or may not be an entry in the "FILEDATE" field. We suggest you also sort on the "CORPDATE" field to identify these new CIDs. There may be a 12 to 30 month or longer - build out window - for these new CIDs before they file a second report.

Using the Data
There are many uses for information contained in the CID-DATA.COM™ databases. They include: validation and verification of corporate filings; current corporate status; various statistical, business planning and marketing analyses; direct mail marketing - customize your own labels, envelopes, post cards; telemarketing in conjunction with a telephone number database; etc.

To meet your various needs we have provided a complete and unfiltered listing of associations which includes both active, delinquent, suspended , revoked and dissolved CIDs. Therefore you will need to filter and sort the data according to your business needs.

Direct Mail Marketing
If you are using the database for direct mail marketing - we suggest that you select the appropriate "ADDRTYPE" (A, M, PPB, P or S); all Oregon data is "CORPSTATUS" = "1" as of the date of the data - "FILEDATE" use not more than eighteen (24) months back from the current date of the data, for the best results. To determine new CIDs - sort on the "CORPDATE."While we have made every effort to help you ensure the best results for your marketing effort, based on the factors that we have no control over, we suggest you add "RETURN SERVICE REQUESTED" or "ADDRESS CORRECTION REQUESTED" to your promotional material.

Mailing Labels
We suggest that you use an 8-9 point font and a 1"x 4" label, as some association names are very long and this size label presents the best appearance. We recommend that you pre-print and review the label content, format and position on standard 8.5"x11" plain paper before printing the actual labels.

Telemarketing
If you plan to use the data for telemarketing, you may want to purchase a CD-ROM telephone number database such as "Phone Disc" or some similar product from your local software house, computer store or catalogue. There are also a number of directory type internet web sites that may offer assistance in obtaining telephone numbers.

Age of an Association
If you wish to determine the approximate age of a particular CID just use the diffrence between corporate filing date from the most "CORPDATE" and the current date.

We have also included the respective "COUNTY" location of the CID. You can sort on the "COUNTY" field and determine the number of CIDs currently on file for that county.

Installation Note
CID-DATA.COM ™ provides data to our clients on Compact Disc (CD) in two formats - Tab-Delimited text (.txt); and in a Microsoft EXCEL (.xls) format

Compact Discs (CDs) are screened for viruses before shipping. However, we recommend you always screen for viruses when installing any CD or diskette in your computer!

Data format (.txt)
If the data file on the CD or diskette you receive has an extension of ".txt/.csv," it is a comma delimited text file, and no expansion is required in either a Windows or Macintosh environment. This data file is ready to be placed on your hard drive and then imported into the data management application program you are using.

Data Format (.xls)
We are also providing the file in an Microsoft EXCEL (.xls) format Field names are provided in the first row of the data. Please note, later versions of EXCEL have a capability for exporting the data into Microsoft ACCESS.

Importing the Data
The "comma delimited format," allows you to import the data into virtually any database management or database (contact management) capable program you may have. The data fields in the application you are importing the data to, must match one-to-one with the eleven (11) data fields indicated on the first page of this 'help guide." Some applications will do this automatically. Please see the instructions for the particular application program you will be using. Please note, you will be able to manipulate the data to suit your various business needs in a data base management or contact management program. The data can be imported into spread sheet and word processing programs but your ability to filter, search, format, and manipulate the data may be very limited.

We recommend the use of a relational database management program such as Microsoft Access, FileMaker Pro or similar programs. These programs allow you to filter and select record data based on several parameters and have built-in layout/formatting capabilities for using the data in letters, and to print envelopes, labels, post-cards and more.

The "EXCEL (.xls)" data is ready to use and the field names are listed in the first row of the spreadsheet. Once you open the EXCEL file you may save it in any number of other formats to suite your needs.

Using the CID-DATA.COM™ Databases
After you have imported the data into your database application program, please take a moment to review and become familiar with the contents. Then review the database application program documentation to understand the capabilities of the program to sort, filter and manipulate the data for analysis or to produce labels, lists and other formats for the information that you may require.

Technical Assistance
Limited technical assistance is provided by calling 1-800-350-8333 between 9:00 AM-12:00 PM PST or by e-mailing support@cid-data.com. Instructions for importing the data files into Microsoft Access 97 are included on the CD.

USE OF THIS DATA CONSTITUTES AGREEMENT TO THE FOLLOWING CONDITIONS

Copyright
CID-DATA.COM™ - Databases are copyrighted and provided for your sole use. You may not assign, transfer, distribute, or copy and resell the data to a third party. You may not use the data, in whole or in part, as a derivative or basis for another product, without the express, written permission of CID-DATA.COM™.

Hold Harmless Notice
By using your CID-DATA.COM™ - Databases, you agree to hold CID-DATA.COM™ and all associated parties harmless for any damages in using the data or software. The data files and diskette or CD ROM are provided to you on an "as-is" basis. CID-DATA.COM™ disclaims all other warranties, either expressed or implied, including but not limited to warranties of merchantability and fitness for a particular purpose with respect to the data or accompanying written materials. CID-DATA.COM™ does not warrant or guarantee, or make any representations regarding the use or the results of the use of this product. In no event will CID-DATA.COM™, its owners, employees or agents, be liable to you for any consequential or indirect damage resulting from the use of this product.

Damaged/Unreadable CD - Policy
In the rare event you receive a damaged or unreadable CD, please return the original CD to us, so that we can determine the cause of damage, and we will provide you a replacement.



CID-DATA.COM™
PO Box 12584 • La Jolla, CA 92039
Ph. 800-350-8333 • Fax. 800-350-8334
info@cid-data.com