| Method |
Description |
|
|
clearAllTempTables ( ) |
|
|
|
createAllTempTables ( ) |
|
|
|
createTmpRcoNodEpisodeBiometry ( ) |
******** EpisodeBiometry ********* |
|
|
createTmpRcoNodEpisodeDiabeticDiagnosis ( ) |
******** EpisodeDiabeticDiagnosis ********* |
|
|
createTmpRcoNodEpisodeDiagnosis ( ) |
******** EpisodeDiagnosis ********* |
|
|
createTmpRcoNodEpisodeDrug ( ) |
******** EpisodeDrug ********* |
|
|
createTmpRcoNodEpisodeIOP ( ) |
Create tmp_rco_nod_EpisodeIOP_ table |
|
|
createTmpRcoNodEpisodeOperation ( ) |
******** EpisodeOperation ********* |
|
|
createTmpRcoNodEpisodeOperationAnesthesia ( ) |
********* EpisodeOperationAnesthesia *************** |
|
|
createTmpRcoNodEpisodeOperationCoPathology ( ) |
******** EpisodeOperationCoPathology ********* |
|
|
createTmpRcoNodEpisodeOperationComplication ( ) |
******** EpisodeOperationComplication ********* |
|
|
createTmpRcoNodEpisodeOperationIndication ( ) |
******** EpisodeOperationIndication ********* |
|
|
createTmpRcoNodEpisodePreOpAssessment ( ) |
******** EpisodePreOpAssessment ********* |
|
|
createTmpRcoNodEpisodeRefraction ( ) |
******** EpisodeRefraction ********* |
|
|
createTmpRcoNodEpisodeTreatment ( ) |
******** EpisodeTreatment ********* |
|
|
createTmpRcoNodEpisodeTreatmentCataract ( ) |
******** EpisodeTreatmentCataract ********* |
|
|
createTmpRcoNodEpisodeVisualAcuity ( ) |
******** EpisodeVisualAcuity ********* |
|
|
createTmpRcoNodMainEventEpisodes ( ) |
******** Episode ********* |
|
|
createTmpRcoNodPatientCVIStatus ( ) |
******** PatientCVIStatus ********* |
|
|
createTmpRcoNodPatients ( ) |
Create tmp_rco_nod_patients_{$this->extractIdentifier} table |
|
|
createTmpRcoNodPostOpComplication ( ) |
******** EpisodePostOpComplication ********* |
|
|
createTmpRcoNodSurgeon ( ) |
******** Surgeon ********* |
|
|
createZipFile ( ) |
Creates zip files from the CSV files |
|
|
getEpisode ( ) |
|
|
|
getEpisodeBiometry ( ) |
|
|
|
getEpisodeDiabeticDiagnosis ( ) |
|
|
|
getEpisodeDiagnosis ( ) |
|
|
|
getEpisodeDrug ( ) |
|
|
|
getEpisodeIOP ( ) |
|
|
|
getEpisodeOperation ( ) |
|
|
|
getEpisodeOperationAnaesthesia ( ) |
|
|
|
getEpisodeOperationCoPathology ( ) |
|
|
|
getEpisodeOperationComplication ( ) |
|
|
|
getEpisodeOperationIndication ( ) |
|
|
|
getEpisodePostOpComplication ( ) |
|
|
|
getEpisodePreOpAssessment ( ) |
|
|
|
getEpisodeRefraction ( ) |
|
|
|
getEpisodeTreatment ( ) |
|
|
|
getEpisodeTreatmentCataract ( ) |
|
|
|
getEpisodeVisualAcuity ( ) |
|
|
|
getPatientCviStatus ( ) |
|
|
|
getPatients ( ) |
The extraction of patient data is psuedoanonymised. All tables prefixed with “Patient” link back to the
“Patient” table via the ‘PatientId’ variable. Each patient on the RCOphth NOD will have one row in the “Patient” table. |
|
|
getSurgeons ( ) |
|
|
|
populateAllTempTables ( ) |
This function will call the functions one by one to populate each tmp tables belongs to a csv file |
|
|
populateTmpRcoNodEpisodeBiometry ( ) |
|
|
|
populateTmpRcoNodEpisodeDiabeticDiagnosis ( ) |
|
|
|
populateTmpRcoNodEpisodeDiagnosis ( ) |
|
|
|
populateTmpRcoNodEpisodeDrug ( ) |
|
|
|
populateTmpRcoNodEpisodeIOP ( ) |
Load Episode IOP data |
|
|
populateTmpRcoNodEpisodeOperation ( ) |
|
|
|
populateTmpRcoNodEpisodeOperationAnesthesia ( ) |
|
|
|
populateTmpRcoNodEpisodeOperationCoPathology ( ) |
|
|
|
populateTmpRcoNodEpisodeOperationComplication ( ) |
|
|
|
populateTmpRcoNodEpisodeOperationIndication ( ) |
|
|
|
populateTmpRcoNodEpisodePreOpAssessment ( ) |
|
|
|
populateTmpRcoNodEpisodeRefraction ( ) |
Populate tmp_rco_nod_EpisodeRefraction_* table |
|
|
populateTmpRcoNodEpisodeTreatment ( ) |
|
|
|
populateTmpRcoNodEpisodeTreatmentCataract ( ) |
|
|
|
populateTmpRcoNodEpisodeVisualAcuity ( ) |
|
|
|
populateTmpRcoNodMainEventEpisodes ( ) |
Load main control table with ALL events |
|
|
populateTmpRcoNodPatientCVIStatus ( ) |
Populate Patient CVI Status |
|
|
populateTmpRcoNodPatients ( ) |
Load nod_patients data (using previously identified patients in control table) |
|
|
populateTmpRcoNodPostOpComplication ( ) |
|
|
|
populateTmpRcoNodSurgeon ( ) |
This table will contain the only person identifiable data (surgeon’s GMC number or national code
) stored on the RCOphth NOD. This information will be used to match a surgeon to their
own data on the RCOphth NOD website and in the prospective projects enable thematching of a surgeons’
record if they move between centres. This was not done with the ‘legacy’ data already in
NOD and therefore at present we do not have the ability to identify individual surgeons. |
|
|
saveCSVfile ( string $dataQuery, string $filename, string $dataFormatter = null ) : null | array |
Save CSV file and returns episodeIDs if $episodeIdField isset |
|