Yes

studies

is_ppsd

boolean

-

Is PPSD

Yes

studies

is_us_export

boolean

-

Is US Export

Yes

studies

biospec_retention

character varying

-

Bio Spec Retention

Yes

studies

biospec_description

text

-

Bio Spec Description

Yes

studies

ipd_time_frame

character varying

-

IPD Sharing Time Frame

Yes

studies

ipd_access_criteria

character varying

-

IPD Sharing Access Criteria

Yes

studies

ipd_url

character varying

-

IPD Sharing URL

Yes

studies

plan_to_share_ipd

character varying

-

IPD Sharing

Yes

studies

plan_to_share_ipd_description

character varying

-

IPD Sharing Description

Yes

studies

created_at

timestamp without time zone

-

-

Yes

studies

updated_at

timestamp without time zone

-

-

Yes

studies

source_class

character varying

Organization type

Org Class

Yes

studies

delayed_posting

boolean

-

Delayed Posting

Yes

studies

expanded_access_nctid

character varying

-

Expanded Access NCT Id

Yes

studies

expanded_access_status_for_nctid

character varying

recruitment status of the EA study that's linked to INT/OBS

Expanded Access Status For NCT Id

Yes

studies

fdaaa801_violation

boolean

-

FDAA A801 Violation

Yes

studies

baseline_type_units_analyzed

character varying

-

Baseline Type Units Analyzed

Yes

studies

patient_registry

boolean

A type of observational study that collects information about patients' medical conditions and/or treatments to better understand how a condition or treatment affects patients in the real world.

Patient Registry

Yes

study_records

id

bigint

primary key

-

Yes

study_records

nct_id

character varying

foreign key referencing studies.nct_id

-