# adbcva_ophtha adbcva_ophtha # Best Corrected Visual Acuity Analysis Structure: `One or more records per subject per analysis parameter per analysis timepoint` ``` python from pharmadata import pharmaverseadam meta = pharmaverseadam.meta('adbcva_ophtha') print(f"Rows: {meta.number_rows:,} Columns: {meta.number_columns}") ``` Rows: 7,672 Columns: 71 ## Variables Show variable specs shape: (71, 5) | variable | label | type | mandatory | role | |----|----|----|----|----| | str | str | str | str | str | | "STUDYID" | "Study Identifier" | "String" | "Yes" | "Identifier Variables for BDS Datasets" | | "USUBJID" | "Unique Subject Identifier" | "String" | "Yes" | "Identifier Variables for BDS Datasets" | | "DOMAIN" | "Domain Abbreviation" | "String" | "No" | null | | "TRT01P" | "Planned Treatment for Period 01" | "String" | "No" | null | | "TRT01A" | "Actual Treatment for Period 01" | "String" | "No" | null | | "TRTSDT" | "Date of First Exposure to Treatment" | "Date" | "No" | "ADSL Treatment Timing Variables" | | "TRTEDT" | "Date of Last Exposure to Treatment" | "Date" | "No" | "ADSL Treatment Timing Variables" | | "ADT" | "Analysis Date" | "Date" | "No" | "Timing Variables for BDS Datasets" | | "ADY" | "Analysis Relative Day" | "Float64" | "No" | "Timing Variables for BDS Datasets" | | "AVISIT" | "Analysis Visit" | "String" | "No" | "Timing Variables for BDS Datasets" | | "AVISITN" | "Analysis Visit (N)" | "Float64" | "No" | "Timing Variables for BDS Datasets" | | "ATPT" | "Analysis Timepoint" | "String" | "No" | "Timing Variables for BDS Datasets" | | "ATPTN" | "Analysis Timepoint (N)" | "Float64" | "No" | "Timing Variables for BDS Datasets" | | "PARAM" | "Parameter" | "String" | "Yes" | "Analysis Parameter Variables for BDS Datasets" | | "PARAMCD" | "Parameter Code" | "String" | "Yes" | "Analysis Parameter Variables for BDS Datasets" | | "AVAL" | "Analysis Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "AVALC" | "Analysis Value (C)" | "String" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "AVALU" | "Analysis Value Unit" | "String" | "No" | null | | "AVALCAT1" | "Analysis Value Category 1" | "String" | "No" | null | | "AVALCA1N" | "Analysis Value Category 1 (N)" | "Float64" | "No" | null | | "BASE" | "Baseline Value" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "BASEC" | "Baseline Value (C)" | "String" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "BASETYPE" | "Baseline Type" | "String" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "CHG" | "Change from Baseline" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "PCHG" | "Percent Change from Baseline" | "Float64" | "No" | "Analysis Parameter Variables for BDS Datasets" | | "CRIT1" | "Analysis Criterion 1" | "String" | "No" | null | | "CRIT1FL" | "Criterion 1 Evaluation Result Flag" | "String" | "No" | null | | "CRIT2" | "Analysis Criterion 2" | "String" | "No" | null | | "CRIT2FL" | "Criterion 2 Evaluation Result Flag" | "String" | "No" | null | | "CRIT3" | "Analysis Criterion 3" | "String" | "No" | null | | "CRIT3FL" | "Criterion 3 Evaluation Result Flag" | "String" | "No" | null | | "CRIT4" | "Analysis Criterion 4" | "String" | "No" | null | | "CRIT4FL" | "Criterion 4 Evaluation Result Flag" | "String" | "No" | null | | "CRIT5" | "Analysis Criterion 5" | "String" | "No" | null | | "CRIT5FL" | "Criterion 5 Evaluation Result Flag" | "String" | "No" | null | | "CRIT6" | "Analysis Criterion 6" | "String" | "No" | null | | "CRIT6FL" | "Criterion 6 Evaluation Result Flag" | "String" | "No" | null | | "CRIT7" | "Analysis Criterion 7" | "String" | "No" | null | | "CRIT7FL" | "Criterion 7 Evaluation Result Flag" | "String" | "No" | null | | "CRIT8" | "Analysis Criterion 8" | "String" | "No" | null | | "CRIT8FL" | "Criterion 8 Evaluation Result Flag" | "String" | "No" | null | | "DTYPE" | "Derivation Type" | "String" | "No" | "Analysis Descriptor Variables for BDS Datasets" | | "ABLFL" | "Baseline Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" | | "ANL01FL" | "Analysis Flag 01" | "String" | "No" | null | | "ANL02FL" | "Analysis Flag 02" | "String" | "No" | null | | "ONTRTFL" | "On Treatment Record Flag" | "String" | "No" | "Flag Variables for BDS Datasets" | | "OESEQ" | "Sequence Number" | "Int32" | "No" | null | | "OECAT" | "Category for Ophthalmic Test or Exam" | "String" | "No" | null | | "OESCAT" | "Subcategory for Ophthalmic Test or Exam" | "String" | "No" | null | | "OEDTC" | "Date/Time of Collection" | "String" | "No" | null | | "VISIT" | "Visit Name" | "String" | "No" | null | | "VISITNUM" | "Visit Number" | "Float64" | "No" | null | | "VISITDY" | "Planned Study Day of Visit" | "Float64" | "No" | null | | "OESTRESN" | "Numeric Result/Finding in Standard Units" | "Float64" | "No" | null | | "OESTRESC" | "Character Result/Finding in Std Format" | "String" | "No" | null | | "OEORRES" | "Result or Finding in Original Units" | "String" | "No" | null | | "OETEST" | "Name of Ophthalmic Test or Exam" | "String" | "No" | null | | "OETESTCD" | "Short Name of Ophthalmic Test or Exam" | "String" | "No" | null | | "OETSTDTL" | "Ophthalmic Test or Exam Detail" | "String" | "No" | null | | "OELAT" | "Laterality" | "String" | "No" | null | | "OELOC" | "Location Used for the Measurement" | "String" | "No" | null | | "OEDY" | "Study Day of Visit/Collection/Exam" | "Float64" | "No" | null | | "OEMETHOD" | "Method of Test or Examination" | "String" | "No" | null | | "OEORRESU" | "Original Units" | "String" | "No" | null | | "OESTRESU" | "Standard Units" | "String" | "No" | null | | "OESTAT" | "Completion Status" | "String" | "No" | null | | "OETPT" | "Planned Time Point Name" | "String" | "No" | null | | "OETPTNUM" | "Planned Time Point Number" | "Float64" | "No" | null | | "STUDYEYE" | "Study Eye Location" | "String" | "No" | null | | "AFEYE" | "Affected Eye" | "String" | "No" | null | | "WORS01FL" | "Worst Post Baseline Obs" | "String" | "No" | null | ## Examples ``` python from great_docs import tbl_explorer from pharmadata import pharmaverseadam tbl_explorer(pharmaverseadam.adbcva_ophtha.head(10)) ```
PolarsRows10Columns71
STUDYID str
USUBJID str
DOMAIN str
TRT01P str
TRT01A str
TRTSDT date
TRTEDT date
ADT date
ADY f64
AVISIT str
AVISITN f64
ATPT str
ATPTN f64
PARAM str
PARAMCD str
AVAL f64
AVALC str
AVALU str
AVALCAT1 str
AVALCA1N f64
BASE f64
BASEC str
BASETYPE str
CHG f64
PCHG f64
CRIT1 str
CRIT1FL str
CRIT2 str
CRIT2FL str
CRIT3 str
CRIT3FL str
CRIT4 str
CRIT4FL str
CRIT5 str
CRIT5FL str
CRIT6 str
CRIT6FL str
CRIT7 str
CRIT7FL str
CRIT8 str
CRIT8FL str
DTYPE str
ABLFL str
ANL01FL str
ANL02FL str
ONTRTFL str
OESEQ i32
OECAT str
OESCAT str
OEDTC str
VISIT str
VISITNUM f64
VISITDY f64
OESTRESN f64
OESTRESC str
OEORRES str
OETEST str
OETESTCD str
OETSTDTL str
OELAT str
OELOC str
OEDY f64
OEMETHOD str
OEORRESU str
OESTRESU str
OESTAT str
OETPT str
OETPTNUM f64
STUDYEYE str
AFEYE str
WORS01FL str
0 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-05-21 140 Week 20 11 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 2 2 letters < 20/800 1000 77 77 LAST -75 -97.4025974026 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 Y CHG <= 5 Y CHG <= 10 Y CHG >= -15 N CHG >= 15 N None None Y None Y 63 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-05-21 WEEK 20 11 140 2 2 2 Visual Acuity Score VACSCORE None LEFT EYE 140 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye Y
1 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-03-26 84 Week 12 9 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 41 41 letters 20/160 160 77 77 LAST -36 -46.7532467532 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 Y CHG <= 5 Y CHG <= 10 Y CHG >= -15 N CHG >= 15 N None None Y None Y 47 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-03-26 WEEK 12 9 84 41 41 41 Visual Acuity Score VACSCORE None LEFT EYE 84 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
2 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-06-18 168 Week 24 12 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 44 44 letters 20/125 125 77 77 LAST -33 -42.8571428571 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 Y CHG <= 5 Y CHG <= 10 Y CHG >= -15 N CHG >= 15 N None None Y Y Y 71 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-06-18 WEEK 24 12 168 44 44 44 Visual Acuity Score VACSCORE None LEFT EYE 168 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
3 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-05-07 126 Week 16 10 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 52 52 letters 20/100 100 77 77 LAST -25 -32.4675324675 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 Y CHG <= 5 Y CHG <= 10 Y CHG >= -15 N CHG >= 15 N None None Y None Y 55 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-05-07 WEEK 16 10 112 52 52 52 Visual Acuity Score VACSCORE None LEFT EYE 126 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
4 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-02-12 42 Week 6 7 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 64 64 letters 20/50 50 77 77 LAST -13 -16.8831168831 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 N CHG <= 5 Y CHG <= 10 Y CHG >= -15 Y CHG >= 15 N None None Y None Y 31 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-02-12 WEEK 6 7 42 64 64 64 Visual Acuity Score VACSCORE None LEFT EYE 42 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
5 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-01-02 1 Baseline 3 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 77 77 letters 20/32 32 77 77 LAST 0 0 0 <= CHG <= 5 Y -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 N CHG <= 5 Y CHG <= 10 Y CHG >= -15 Y CHG >= 15 N None Y Y Y None 15 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-01-02 BASELINE 3 1 77 77 77 Visual Acuity Score VACSCORE None LEFT EYE 1 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
6 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-01-30 29 Week 4 5 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 77 77 letters 20/32 32 77 77 LAST 0 0 0 <= CHG <= 5 Y -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 N CHG <= 5 Y CHG <= 10 Y CHG >= -15 Y CHG >= 15 N None None Y None Y 23 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-01-30 WEEK 4 5 28 77 77 77 Visual Acuity Score VACSCORE None LEFT EYE 29 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
7 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-03-05 63 Week 8 8 PRE-DOSE -0.5 Fellow Eye Visual Acuity Score (letters) FBCVA 92 92 letters 20/16 16 77 77 LAST 15 19.4805194805 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 Y CHG <= -20 N CHG <= 5 N CHG <= 10 N CHG >= -15 Y CHG >= 15 Y None None Y None Y 39 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-03-05 WEEK 8 8 56 92 92 92 Visual Acuity Score VACSCORE None LEFT EYE 63 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Fellow Eye None
8 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-01-30 29 Week 4 5 PRE-DOSE -0.5 Study Eye Visual Acuity Score (letters) SBCVA 24 24 letters 20/320 320 35 35 LAST -11 -31.4285714286 0 <= CHG <= 5 N -5 <= CHG <= -1 N 10 <= CHG <= 15 N CHG <= -20 N CHG <= 5 Y CHG <= 10 Y CHG >= -15 Y CHG >= 15 N None None Y None Y 24 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-01-30 WEEK 4 5 28 24 24 24 Visual Acuity Score VACSCORE None RIGHT EYE 29 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Study Eye Y
9 CDISCPILOT01 01-701-1015 OE Placebo Placebo 2014-01-02 2014-07-02 2014-03-05 63 Week 8 8 PRE-DOSE -0.5 Study Eye Visual Acuity Score (letters) SBCVA 31 31 letters 20/250 250 35 35 LAST -4 -11.4285714286 0 <= CHG <= 5 N -5 <= CHG <= -1 Y 10 <= CHG <= 15 N CHG <= -20 N CHG <= 5 Y CHG <= 10 Y CHG >= -15 Y CHG >= 15 N None None Y None Y 40 BEST CORRECTED VISUAL ACUITY OVERALL EVALUATION 2014-03-05 WEEK 8 8 56 31 31 31 Visual Acuity Score VACSCORE None RIGHT EYE 63 ETDRS EYE CHART None None None PRE-DOSE -0.5 RIGHT Study Eye None