Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- AG.INDICE_AGENDAMIENTO
- ,AG.AMBITO
- --PACIENTE
- ,PA.APELLIDO_P || ' ' || PA.NOMBRES NOMBRE_PACIENTE
- ,PA.NUM_REGISTRO_MEDICO IDENTIFICADOR_PACIENTE
- ,PA.RUT CEDULA_PACIENTE
- ,PA.NUM_REGISTRO_MEDICO AS NUMERO_REGISTRO_PACIENTE
- ,(SELECT US2.NOMBRE || ' ' || US2.APELLIDO_P || ' ' || US2.APELLIDO_M FROM USUARIOS US2 WHERE AG.REFERING_DOCTOR_ID = TO_CHAR(US2.INDICE_USUARIO) ) AS NOMBRE_COMPLETO_MEDICO_S
- ,(CASE WHEN (PA.SEXO = '0' OR PA.SEXO = 'M' ) THEN 'Masculino' ELSE 'Femenino' END) AS SEXO_PACIENTE
- ,TO_CHAR(PATIENT_BIRTHDATETIME,'DD/MM/YYYY') AS FECHA_NACIMIENTO_C_PACIENTE
- ,TO_CHAR(PATIENT_BIRTHDATETIME,'DD') || ' DE ' || TO_CHAR(PATIENT_BIRTHDATETIME,'MONTH YYYY','NLS_DATE_LANGUAGE = spanish') AS FECHA_NACIMIENTO_PACIENTE
- ,TO_CHAR(FECHA_HORA_REPORTE,'DD/MM/YYYY') AS FECHA_HORA_REPORTE
- --ESTUDIOS
- ,ES.DESCRIPCION AS NOMBRE_PROCEDIMIENTO
- ,TO_CHAR(AG.FECHA_HORA,'DD') || ' DE ' || TO_CHAR(AG.FECHA_HORA,'MONTH YYYY','NLS_DATE_LANGUAGE = spanish') AS FECHA_ESTUDIO
- ,TO_CHAR(AG.FECHA_HORA,'DD/MM/YYYY') AS FECHA_ESTUDIO_CORTA
- ,TO_CHAR(AG.FECHA_HORA,'HH24:MI') AS HORA_ESTUDIO
- --MEDICO
- ,AG.ATENDING_DOCTOR AS MEDICO_EJECUTANTE
- ,AG.REFERING_DOCTOR AS MEDICO_INFORMANTE
- ,AG.CONSULTING_DOCTOR AS MEDICO_SOLICITANTE
- ,US.NOMBRE || ' ' || US.APELLIDO_P || ' ' || US.APELLIDO_M AS NOMBRE_COMPLETO_MEDICO
- ,(CASE WHEN (PE.SEXO = '0' OR PE.SEXO = 'M' ) THEN 'Dr.' ELSE 'Dra.' END) AS PREFIJO_MEDICO
- ,PE.RUT AS CEDULA_MEDICO
- ,(SELECT DESCRIPCION FROM ESPECIALIDAD ESP WHERE ESP.INDICE_ESPECIALIDAD = PE.INDICE_ESPECIALIDAD) AS ESPECIALIDAD_MEDICO
- ,FIR.IMAGEN_FIRMA AS FIRMA_INFORME
- --REPORTES
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'DD') || ' DE ' || TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'MONTH YYYY','NLS_DATE_LANGUAGE = spanish') AS FECHA_IMPRESION_INFORME
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'DD/MM/YYYY') AS FECHA_IMPRESION_INFORME_CORTA
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL), 'HH24:MI') AS HORA_IMPRESION_INFORME
- ,TO_CHAR(OB.ADQUISITION_DATE_TIME, 'DD/MM/YYYY') AS FECHA_CREACION_INFORME_CORTA
- ,TO_CHAR(OB.ADQUISITION_DATE_TIME, 'DD') || ' DE ' || TO_CHAR(OB.ADQUISITION_DATE_TIME, 'MONTH YYYY','NLS_DATE_LANGUAGE = spanish') AS FECHA_CREACION_INFORME
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'DD/MM/YYYY') AS FECHA_FIRMA_INFORME_CORTA
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'DD') || ' DE ' || TO_CHAR((SELECT CURRENT_DATE FROM DUAL),'MONTH YYYY','NLS_DATE_LANGUAGE = spanish') AS FECHA_FIRMA_INFORME
- ,TO_CHAR((SELECT CURRENT_DATE FROM DUAL), 'HH24:MI') AS HORA_FIRMA_INFORME
- FROM AGENDAMIENTO AG
- INNER JOIN PACIENTES PA ON AG.PATIENT_ID = PA.NUM_REGISTRO_MEDICO
- LEFT JOIN ESTUDIOS ES ON AG.ACCESSION_NUMBER = ES.ACCESSION_NUMBER
- LEFT JOIN USUARIOS US ON ((AG.CONSULTING_DOCTOR_ID IS NULL AND AG.ATENDING_DOCTOR_ID = TO_CHAR(US.INDICE_USUARIO)) OR (AG.CONSULTING_DOCTOR_ID = TO_CHAR(US.INDICE_USUARIO)))
- LEFT JOIN PERSONAL PE ON US.USER_NAME = PE.USER_NAME
- LEFT JOIN FIRMA FIR ON US.INDICE_USUARIO = FIR.INDICE_PERSONAL
- LEFT JOIN SERIES SE ON ES.INDICE_ESTUDIO = SE.INDICE_ESTUDIO
- LEFT JOIN OBJETOS OB ON SE.INDICE_SERIE = OB.INDICE_SERIE
- WHERE AG.INDICE_AGENDAMIENTO = $indiceAgendamiento
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement