System Tables

Managing System Table Values

OVERVIEW

Users can add, update, delete the system table values for different system tables in the Admin which are used in Item management.

ADD THE SYSTEM TABLE VALUE
  • Select System Tables from Customization in Admin
  • List of System Tables defined by Orcanos and User-defined tables gets displayed
  • Click on View icon or Code hyperlink to open the system table values
  • Click on Add icon at the bottom right side of the page
  • Input the Description
    • Description: Name of the value – which the user selects from the selection list
    • Color: Click the Color field to select the code color.
    • Is Default: Selecting the checkbox ensures this value is selected when an item is created.
    • Is Active: On selecting this checkbox every status gets the indication if it is active or complete.
    • Is Complete: This is only for the purpose of status. Selecting this checkbox ensures that If the work item has reached a specific status, it is marked as completed.
    • Is Freeze: Selecting this checkbox prevents you from modifying the work item in this specific status.
  • Click Next to add another system table value, Previous icon to go to the previous item or Save Button.

User can import list of system table values from .csv or .xlsx files using Import System table Values option

UPDATE THE SYSTEM TABLE VALUE
  • Click on Edit icon against a value to update from Action Column
  • Update the Description and checkbox selection
  • Press Save button

Click on Previous or Next icon, to update multiple values at one go

DELETE THE SYSTEM TABLE VALUE
  • Click on Delete icon against a value to remove from Action Column
    • When no record is associated with the deleted value, it is removed directly.
    • When a record is associated with a deleted value, a pop-up is displayed to assign it to a new value

Default System table value is allowed to delete after selecting new value as “Is Default”

All System table values cannot be deleted from the system table

For some System defined system tables such as ‘Risk Severity level’, ‘Risk Probability level’ etc. the values cannot be Updated or Deleted.

ACTIONS ON  THE SYSTEM TABLE VALUES
  • Move First – Moves the value to the first order in the table
  • Move Up     – Moves the value above the immediate value in the table.
  • Move Down – Moves the value below the immediate value in the table.
  • Move Last   – Moves the value to the last order in the table.
  • Add After – Allows to add a value in the middle of the list of the existing system table values
WORK ITEM LIST AUTOMATION Generated SYSTEM TABLES

Users are unable to add or import values into these system tables.

RELATED LINKS

Import System Table Values

System Tables

Related Articles