[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IA.ROWID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, P.PREFERRED_NAME DSP_PREFERRED_NAME
, IA.ASS_ID ASS_ID
, IA.PERSON_ID PERSON_ID
, IA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, IA.ASS_ASSESSOR_TYPE ASS_ASSESSOR_TYPE
, IA.PRIMARY_ASSESSOR_IND PRIMARY_ASSESSOR_IND
, IA.ITEM_LIMIT ITEM_LIMIT
, IA.LOCATION_CD LOCATION_CD
, IA.UNIT_MODE UNIT_MODE
, IA.UNIT_CLASS UNIT_CLASS
, IA.COMMENTS COMMENTS
, UCL.DESCRIPTION DSP_DESCRIPTION
, UCL.UNIT_MODE DSP_UNIT_MODE
, UCL.CLOSED_IND DSP_CLOSED_IND
, UM.DESCRIPTION DSP_DESCRIPTION2
, UM.CLOSED_IND DSP_CLOSED_IND2
, ASST.DESCRIPTION DSP_DESCRIPTION3
, ASST.DFLT_IND DSP_DFLT_IND
, ASST.CLOSED_IND DSP_CLOSED_IND3
, LOC.DESCRIPTION DSP_DESCRIPTION4
, LOC.CLOSED_IND DSP_CLOSED_IND4
, LOC.LOCATION_TYPE DSP_LOCATION_TYPE
, LOCT.S_LOCATION_TYPE DSP_S_LOCATION_TYPE
, IA.CREATED_BY CREATED_BY
, IA.CREATION_DATE CREATION_DATE
, IA.LAST_UPDATED_BY LAST_UPDATED_BY
, IA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_ITEM_ASSESSOR IA
, IGS_PE_PERSON_V P
, IGS_AS_UNIT_CLASS UCL
, IGS_AS_UNIT_MODE UM
, IGS_AS_ASSESSOR_TYPE ASST
, IGS_AD_LOCATION LOC
, IGS_AD_LOCATION_TYPE LOCT
WHERE IA.PERSON_ID = P.PERSON_ID
AND IA.UNIT_CLASS = UCL.UNIT_CLASS (+)
AND IA.UNIT_MODE = UM.UNIT_MODE (+)
AND IA.ASS_ASSESSOR_TYPE = ASST.ASS_ASSESSOR_TYPE
AND IA.LOCATION_CD = LOC.LOCATION_CD (+)
AND UPPER(LOC.LOCATION_TYPE) = UPPER(LOCT.LOCATION_TYPE(+))