Active
Table
Column
Type
Description
CTGov Data Point
Yes
outcomes
dispersion_type
character varying
-
Outcome Measure Dispersion Type
Yes
outcomes
param_type
character varying
-
Outcome Measure Param Type
Yes
overall_officials
id
integer
primary key
-
Yes
overall_officials
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
overall_officials
role
character varying
-
Overall Official Role
Yes
overall_officials
name
character varying
-
Overall Official Name
Yes
overall_officials
affiliation
character varying
-
Overall Official Affiliation
Yes
participant_flows
id
integer
primary key
-
Yes
participant_flows
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
participant_flows
recruitment_details
text
-
Flow Recruitment Details
Yes
participant_flows
units_analyzed
character varying
-
Flow Type Units Analyzed
Yes
pending_results
id
integer
primary key
-
Yes
pending_results
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
pending_results
event
character varying
-
Unposted Event Type
Yes
pending_results
event_date_description
character varying
-
Unposted Event Date
Yes
pending_results
event_date
date
-
Unposted Event Date
Yes
provided_documents
id
integer
primary key
-
Yes
provided_documents
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
provided_documents
document_type
character varying
-
Large Doc Label