Via user interface - Enterprise users

...

1. Connect to the database
2. Insert new values in table catissue_permissible_values.
3. Identifier: is auto generated, do not set any value to this.
4. Public ID: Refer catissue_cde table to know the public id of dropdowns.

Adding new permissible values

Examples:

1. Add new value in 'Gender'
   

   insert into catissue_permissible_value(value, public_id) values('Male', 'gender');

2. Add new value in "Specimen Type" under "Fluid"
   
   insert into catissue_permissible_value(value, public_id, parent_identifier) 
   select 
     'Buffy Coat', 'specimen_type', identifier 
   from 
     catissue_permissible_value 
   where 
     value="Fluid" and public_id="specimen_type";