View: IGS_AS_EXM_SUPRVISOR_V

View Text

SELECT ES.ROWID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, ES.PERSON_ID PERSON_ID
, P.PREFERRED_NAME PREFERRED_NAME
, PDV.SEX SEX
, PDV.MEANING_SEX MEANING_SEX
, PDV.BIRTH_DT BIRTH_DT
, P.ENCUMBERED_IND ENCUMBERED_IND
, PDV.DECEASED_IND DECEASED_IND
, EST.DESCRIPTION ES_DESCRIPTION
, EST.IN_CHARGE_IND IN_CHARGE_IND
, EST.CLOSED_IND CLOSED_IND
, ES.EXAM_SUPERVISOR_TYPE EXAM_SUPERVISOR_TYPE
, ES.PREVIOUS_SESSIONS PREVIOUS_SESSIONS
, ES.RESPONSIBLE_ORG_UNIT_CD RESPONSIBLE_ORG_UNIT_CD
, OU.DESCRIPTION OU_DESCRIPTION
, OU.ORG_STATUS ORG_STATUS
, ORG_STATUS.S_ORG_STATUS S_ORG_STATUS
, ES.RESPONSIBLE_OU_START_DT RESPONSIBLE_OU_START_DT
, ES.COMMENTS COMMENTS
, ES.CREATED_BY CREATED_BY
, ES.CREATION_DATE CREATION_DATE
, ES.LAST_UPDATED_BY LAST_UPDATED_BY
, ES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_EXM_SUPRVISOR ES
, IGS_PE_PERSON_V P
, IGS_PE_PERSON_LKUPV_V PDV
, IGS_AS_EXM_SPRVSRTYP EST
, IGS_OR_UNIT OU
, IGS_OR_STATUS ORG_STATUS
WHERE ES.PERSON_ID = P.PERSON_ID
AND PDV.PERSON_ID = ES.PERSON_ID
AND EST.EXAM_SUPERVISOR_TYPE = ES.EXAM_SUPERVISOR_TYPE
AND OU.ORG_UNIT_CD(+) = ES.RESPONSIBLE_ORG_UNIT_CD
AND OU.START_DT(+) = ES.RESPONSIBLE_OU_START_DT
AND ORG_STATUS.ORG_STATUS(+) = OU.ORG_STATUS

Columns