
| |

Issues
Comprises
-
Data entry screen for
addition of new issue
-
Directory screen with
filters for retrieval
-
Review and edit screen
-
Recording of actions and
history
-
Reports generator, with
filters, and report selector
-
Graph analysis of Issues
Raised/Resolved, Owners, Impact Areas
-
Password
/Security/Privilege system
-
E-mail generation for
automated notification
-
Audit Trail

Issues were the original
feature
of the database. Based on a main Issues Table with a related (one to many) table
for recording Actions and History. Separate look-up tables are implemented for
project names, domains etc. Every field in the two main tables are audited, and
changes to all records stored in one Issues Audit table. Level one security is
required to view Issues, Level two security is required to add or edit Issues.
The Issue numbering system is
DD-NN-I001, where DD is the domain code, PP is the project code, I denotes issue
and 001 is the counter. The counter is specific to the domain (ie each domain
starts at 001) and is incremented by all projects in the domain, and by Issues,
Risks, Assumptions and Dependencies.
|