330 likes | 441 Views
Sustainability Reporting Support System. Prepared for Great-PR.com. Richard Herzfeld TechComm Associates, LLC. Foreword. Multi-function database GRI data repository NGO Survey/GRI Topic cross reference. Project Overview. Publicly Traded Corporations. Research groups, NGOs. SQL
E N D
Sustainability Reporting Support System Prepared for Great-PR.com. Richard Herzfeld TechComm Associates, LLC
Foreword • Multi-function database • GRI data repository • NGO Survey/GRI Topic cross reference
Project Overview Publicly Traded Corporations Research groups, NGOs SQL database organized by GRI Topics Annual Sustainability Reports Surveys Research is simplified Corporate-wide access Immediate access to updates Easily reproduce NGO surveys NGOs can update own surveys Organized access to support documents
Project Goals • standardize responses from a company’s to Non-Governmental Organizations • provide a common repository for the most current NGO/GRI (Global Resource Initiative) sustainability reporting data
Project Goals • simplify the task of preparing responses to NGO surveys and questionnaires submitted by these organizations to a company • enable NGO personnel to obtain current responses to their past Surveys, or update past surveys or setup new Description
Acronyms - Glossary • DataTopics – Question topics found in NGO Surveys. Often generalized from multiple surveys • GRI – Global Reporting Initiative; developed the Sustainability Reporting Guidelines • NGO – Non Governmental Organizations
Acronyms – Glossary, cont • Surveys, Survey Document – Questionnaire received from NGO • TopicData – Current JCI answers and/or examples of answers provided for Surveys
Capabilities, cont. • Casual Viewers • View individual GRI DataTopics, TopicData • Print Individual DataTopic Contents • Edit and Format Contents Before Printing • Search individual DataTopics using Find, FindNext • (also available to all Password users)
Capabilities, cont. • Casual Viewers • Display Entire Database and search using Find, FindNext • Print entire database contents • Edit and Format Contents Before Printing • includes fonts, font sizes, color, bold, italics, etc. (Please See Slide 29: “Edit/Print Screen) • (also available to all Password users)
Capabilities, cont. • Password Holders • Add new NGO Records Surveys • Update individual GRI DataTopics • View Individual GRI Topics • Add Additional NGO Surveys • Find and Replace within One DataTopic or Entire Database
Capabilities, cont. • Password Holders • NGO-Specific Data: • Update • View Surveys and Related Topic Data • Produce Survey report showing NGO Topics, GRI Topics, and All Data • All historic data • Only most recent data where available, otherwise historic data
Capabilities, cont. • NGO Password Holders • Identical to Password Holders except • Can Only Access Their Own Surveys • Can Add, Delete, Change Their Own Survey Questions • Can Use All Non-Password Functions • Cannot Change TopicData in Database
Technology • Visual Basic Programming • Commonly used language • Microsoft Access Database • SQL use throughout will facilitate conversion to larger database
Program Flow from Welcome Screen – All Viewers • Add NGO option: • Password Authorization Screen • Add/View NGO Data • Multiple Document Topics or GRI Category Screens • TopicData Screen • Edit/Print Data Screen • (First screen seen by Casual Viewers is F)
Program Flow from Welcome Screen – All Viewers • Review Organization • A. Update NGO option: • Password Authorization Screen • Find Organization Screen • Add/View NGO Data • Multiple Document Topics or GRI Category Screens • New Topic Name Screen • TopicData Screen • Edit/Print Screen
Program Flow from Welcome Screen – All Viewers • Review Organization • B. View NGO only option: • Find Organization Screen • Add/View NGO Data • Multiple Document Topics or GRI Category Screens • TopicData Screen • Edit/Print Screen
Program Flow from Welcome Screen – All Viewers • Review Organization • C. Produce NGO Report option: • Password Authorization Screen • Find Organization Screen • Add/View NGO Data • Edit/Print Screen
Program Flow from Welcome Screen – All Viewers • Lookup Data Option: • Multiple Document Topics or GRI Category Screens • TopicData Screen • Show Report screen • Edit/Print Screen
Program Flow from Welcome Screen – All Viewers • Update Data Option: • Password Authorization Screen • Add Description Screen • Multiple NGO DataTopic or GRI DataTopic Screens • TopicData Screen • Edit/Print Screen
Program Flow from Welcome Screen – All Viewers • Setup New Topic Option: • Authorization Screen • Add New Topics Screen
Future Enhancements • Customer Suggestions Requested • Ongoing User Interface Simplification • Ongoing Code Reduction
Current Status • Beta Released 15 July 2003 • Version 2.0 15 September 2003
Customer Support • Submit Questions, Suggestions, or Report Problems: • dick.herzfeld@ieee.org • 414-445-2670 • fax: 414-445-2730
Related Documents • Help Menu • Screen-sensitive Positioning • Four Help data sets: • Casual Viewers • Password Users • NGO Password users • Administrator • Sustainability Reporting System Technical Manual