Tailored analysis tables with main dates related to patients
tailored_patientsurvival.RdTailored analysis tables with main dates related to patients
Details
tailored_patientsurvival(): PK: patientkey.
- 1. - patientkey: Identifier of patients. Source:- Patient.
- 2. - enrollment_date: Enrollment date. Source:- Patient.
- 3. - deathdate: Death date. Source:- Stop.
- 4. - first_dropoutdate: First dropout date. Source:- Stop.
- 5. - first_dropoutdateaccuracy: Accuracy of the first dropout date. Source:- Stop.
- 6. - last_activedropoutdate: Last dropout date without- backstcs. Source:- Stop.
- 7. - last_activedropoutdateaccuracy: Accuracy of the last dropout date without- backstcs. Source:- Stop.
- 8. - last_patlongkeys: Identifier of the last patient-assessment. Source:- PatientLongitudinal.
- 9. - last_assdate: Date of the last patient-assessment. Source:- PatientLongitudinal.
- 10.-17. - last_[...]_toggle_date: Assessment date of the last mentioned filled toggle (keep:- "Yes",- "No", removed:- "Missing",- NA). Source:- PatientLongitudinal.
- 18. - extraction_date: Extraction date. Source:- Admin.
- 19. - last_complete_patientlongitudinal_crf_date: Assessment date of the latest- crf_statusof the patient assessment defined as- "Complete". Source:- PatientLongitudinal.
- 20. - last_complete_stop_crf_date: Date (latest between:- deathdate,- dropoutdate,- lastalivedate,- backstcsdate) of the latest- crf_statusdefined as- "Complete". Source:- Stop.
- 21. - last_consent_withdrawal_date: Last consent date when the its consent status is- "Withdrawal". Source- Patient.
- 22. - confidental data: Optional.
- 23. - last_complete_psq_crf_date: Optional. Date of the latest- crf_statusof PSQ defined as- "Complete". Source:- PSQ.