Categories: All - features - database - projects - difficulties

by Chan Chan 4 years ago

239

Database

A centralized database is essential for efficiently storing and retrieving TGRC information, making it easy to avoid redundant efforts and save time on data mining. This database is particularly useful for self-training materials for new employees, contacts for know-how, and detailed information on projects and inquiries.

Database

Database

Examples of database

C2P (need licence)
UL Navigator https://www.ul.com/apps/navigator
Subport - CHEM database http://www.subsportplus.eu/listoflists
SGS got sth https://www.digicomply.com/restricted-substances

Closest thing to a KM database?

C2P + data analysis tool (e.g. Power bi or CDMS) + Diigo

Automation? e.g. link to chemical inventory

Add-on features

Reporting tool - enquiry statistics? team capacity?
Project management tools?

Difficulties

Budget $$
Man-power and time to build in data

Why better than eDoc?

Same set of data for different output > cannot accommodate the needs for different purposes (differs in content level, display of data, formats).
eDoc's output is not flexible
eDOC is an eTRF / eTP tool TP is one type of KM output, KM > eDOC need to consider user interfaces that sit on top of eDOC (e.g NAV, Intergator for National Deviations)
Compare current company databases, and identify the gap for our needs

Types of output

Test Plans
Summary Tables
PPTs
Guidelines

Features

Once the related information is updated, corresponding output can be updated automatically
Easy to use. Someone without much technical bg can also find the info.
Share info via correspondin info via key words
Flexible exported output
Alert function for upcoming requirement
Set permission for access of information
Allow mult-dimentions filter to select right info

Type of Information

Self-training / start-up materials for new comers
What TGRC can do/cannot do
Contact persons for know-how People can directly contact them instead of TGRC
Contain info of projects/enquiry
Level of information
Supporting info

Websites

Studies

NGOs, trade association info

Official info

Test item (digested info

Potential Users

Technical colleagues
TGRC

Purpose

Centralized location - save time for data mining
Now we have super manual, RSL can work
To store TGRC information - can be easily found Aviod double efforts
Not Aim as One stop solution Cannot replace enquiry/project handling