Peaks to Prairies Home

Comments to: information@peakstoprairies.org

WB01639_.gif (1443 bytes)

Programs DB

Meeting Discussions
  Policy & Vocabulary
  
Database Model
  Action Plan
  Database User's Guide



Last updated:
June 22, 2001
 

 

Programs Database Project

Adopted Database Model  

 

Consensus Reached 9/12/00 Conference Call 

Note: All P2Rx programs databases do not have to have this exact structure. For data to be shared easily and used as a uniform P2Rx product, all databases should contain fields with these general content elements. 

However, to facilitate sharing and searching of the programs database as a unified P2Rx product distributively managed by each Center, controlled vocabularies for particular fields must be exactly the same. For instance, the program values appearing below must be used by each Center.

Primary Table & Fields Related Value Table Related Value Table

Table: Organization

*OrgID (auto fill)
*Organization
*Division
*Address1
Address2
*City
*State (includes territory, province, etc.)
*Zip (includes postal code, etc.)
*Country
*TimeZone (autofill?)
*Telephone#
Hotline#
FAX#
Email#
URL#
*GeoServiceArea
*ProgramType 

Table: GeoValue

(geographic area served by this organization description of the indicated area will be included in the text field)

  • National  

  • State  

  • Regional  

  • City  

  • Local  

  • Text

 

Table: ProgramValue

  • Federal Government

  • State Government

  • Local Government

  • Educational Institution

  • Non-Profit Vendor

  • Consultant

  • Small Business Assistance Program

  • NIST - Manufacturing Extension Program

  • Recycling Program

  • Material Exchange Program

  • Small Business Development Center

  • Energy Efficiency Program


Table: Contact

*ContactID (autofill)
*LastName
*FirstName
MiddleName
Prefix NameSuffix
Title
*Telephone#
FAX#
Email
Primary (Y/N - is this person the primary contact for the org)
*OrgID


Table: PrefixValue

  • Mr.
  • Ms.
  • Mrs.
  • Miss
  • Dr.

*Indicates mandatory entry into these fields