Home | About P2Rx™ | Contact Information | Links | Email this page
  
   
 
      P2Rx Administrative Documents
 


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

 



Back to P2Rx Administrative Information

TOP

 

The Pollution Prevention Resource Exchange is a national network of regional information centers: NEWMOA (Northeast), ESRC (Southeast), GLRPPR (Great Lakes), ZeroWasteNet (Southwest), P2RIC (Plains), Peaks to Prairies (Mountain), WSPPN (Pacific Southwest), PPRC (Northwest).

 
   
 

Home | About P2Rx | Contact Information | Links

 

Topic Hubs™ and Sector Resources | Pollution Prevention Publication Collections | Rapid Response | Request for Proposal Clearinghouse | Measurement Project | News | National Programs Directory | Regional Centers | Listserves