PROJECT in a Box allows you to define the status of Portfolios, Projects and individual Documents. The status values available to your users are called Lookup Values and are stored in the database table tblLookupValues. These values are common between all the projects on a single PIAB server.
PIAB comes with a default set of lookup values. Using the administration tool, you may change them to suite your own workflow and project reporting requirements. Alternatively you may edit the table directly using the information and rules below.
You can define any number of portfolio status values. PIAB looks for a Lookup Type of “portfolio status”, a display order and the value set in the LookupValue and LookupDisplay fields.
Similar to for Portfolio Status, but PIAB looks for a Lookup Type of “project status”.
You many define up to six categories of Document Status values. In order to define the categories, PIAB looks for a Lookup Type of “docheading” and a Lookup Value of “docheadingN” where N is a number between 1 and 6. The corresponding values are linked with their parent categories using the Lookup Type of “docheadingN”.
The display order is a number that defines how the lookup value list is displayed to the user. Contiguous values starting at 1 should be used.
The MinPermission field allows you set the minimum permission that a user must have in order to be able to use the lookup value category. This only applies to Document Status values. The permissions are as follows:
MinPermission | User Permission |
---|---|
0 | Not Set |
1 | Read |
2 | Read/Write |
3 | Modify |
The database table 'tblLookupValues' contains the following data by default.
Notes
The 'docheading4' lookup value ('Exclude from Project') is used by PIAB to flag whether a document is excluded from the export to a web page. If you modify this value then this feature will no longer work.
LookupType | DisplayOrder | LookupValue | LookupDisplay | MinPermission |
---|---|---|---|---|
docheading | 1 | docheading1 | Priority | 3 |
docheading | 2 | docheading2 | Status | 2 |
docheading | 3 | docheading3 | Progress | 2 |
docheading | 4 | docheading4 | Export | 3 |
docheading1 | 1 | Not Required | Not Required | 3 |
docheading1 | 2 | Guidance | Guidance | 3 |
docheading1 | 3 | Optional | Optional | 3 |
docheading1 | 4 | Mandatory | Mandatory | 3 |
docheading2 | 1 | Draft | Draft | 2 |
docheading2 | 2 | Provisional | Provisional | 2 |
docheading2 | 3 | For Approval | For Approval | 2 |
docheading2 | 4 | In Review | In Review | 2 |
docheading2 | 5 | Approved | Approved | 2 |
docheading2 | 6 | Live | Live | 2 |
docheading3 | 1 | Not Started | Not Started | 2 |
docheading3 | 2 | Started | Started | 2 |
docheading3 | 3 | Stopped for Problem | Stopped for Problem | 2 |
docheading3 | 4 | Delayed | Delayed | 2 |
docheading3 | 5 | Ahead of Plan | Ahead of Plan | 2 |
docheading3 | 6 | Cancelled | Cancelled | 2 |
docheading3 | 7 | Complete | Complete | 2 |
docheading4 | 1 | Exclude from Export | Exclude from Export | 3 |
portfolio status | 1 | Not Specified | Not Specified | 0 |
portfolio status | 2 | On Track | On Track | 0 |
portfolio status | 3 | Exception | Exception | 0 |
portfolio status | 4 | Completed | Completed | 0 |
project status | 1 | Not Specified | Not Specified | 0 |
project status | 2 | Not Started | Not Started | 0 |
project status | 3 | Started | Started | 0 |
project status | 4 | On Track | On Track | 0 |
project status | 5 | Exception | Exception | 0 |
project status | 6 | Completed | Completed | 0 |