samussiah
commented
2 years ago - one record per query
- columns:
- studyid
- ctms_study.studyid
- siteid
- ctms_site.siteid
- subjid
- rawplus_dm.subjid
- folder / folderid
- rawplus_visdt.foldername
- form / formid
- Study Drug Administration (PK)
- Study Drug Accountability
- Visit Date
- Consents
- Adverse Event
- PK
- Vital Signs Performed
- Study Drug Administration (DRUG1)
- Study Drug Administration (DRUG2)
- Study Drug Administration (DRUG3)
- Prior and Concomitant Medication
- Enrollment
- field / fieldid
- fields.csv
- markinggroupname / markinggroupid
- System Query
- CRA to Site Manual Query
- CDA to Site Manual Query
- qrystatus
- Closed
- Cancelled
- Answered
- Open
- qryopendate
- rawplus_dm.rfpst_dt
- rawplus_dm.rfpen_dt + 30
- qryresponsedate
- qryopendate
- qryopendate + 365
- qrycloseddate
- qryopendate
- qryresponsedate + 365
- qryage
- qrycloseddate - qryopendate for closed queries
- qryresponsedate - qryopendate for answered queries