openspecimen
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
refresh_anticipated_specimens
Parameters
Name
Type
Mode
cp_list
text
IN
Definition
begin call stage_anticipated_specimens(cp_list); drop table if exists os_cpr_anticipated_spmns; alter table tmp_os_cpr_anticipated_spmns rename os_cpr_anticipated_spmns; create index os_cpr_aspmns_cpr_date_idx on os_cpr_anticipated_spmns (cpr_id, event_date); end