openspecimen
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
getPvParentId
Parameters
Name
Type
Mode
publicId
varchar(255)
IN
pvValue
varchar(255)
IN
Definition
begin declare pvId bigint(20); select identifier into pvId from catissue_permissible_value where public_id = publicId and value = pvValue; return (pvId); end