[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PD.ROWID ROW_ID
, PD.IGS_PE_PERS_DISABLTY_ID
, PD.PERSON_ID
, PD.DISABILITY_TYPE
, CC1.MEANING SPECIAL_NEED_ALLOW
, PD. SPECIAL_ALLOW_CD
, CC2.MEANING ADDITIONAL_SUP_LEVEL
, PD. SUPPORT_LEVEL_CD
, PD.ELIG_EARLY_REG_IND
, PD.START_DATE
, PD.END_DATE
, PD.INFO_SOURCE
, HP.FULL_NAME INTERVIEWER_FN
, PD.INTERVIEWER_ID
, HP.PERSON_NUMBER
, PD.INTERVIEWER_DATE
, PD.ATTRIBUTE_CATEGORY
, PD.ATTRIBUTE1
, PD.ATTRIBUTE2
, PD.ATTRIBUTE3
, PD.ATTRIBUTE4
, PD.ATTRIBUTE5
, PD.ATTRIBUTE6
, PD.ATTRIBUTE7
, PD.ATTRIBUTE8
, PD.ATTRIBUTE9
, PD.ATTRIBUTE10
, PD.ATTRIBUTE11
, PD.ATTRIBUTE12
, PD.ATTRIBUTE13
, PD.ATTRIBUTE14
, PD.ATTRIBUTE15
, PD.ATTRIBUTE16
, PD.ATTRIBUTE17
, PD.ATTRIBUTE18
, PD.ATTRIBUTE19
, PD.ATTRIBUTE20
, PD.CREATED_BY
, PD.CREATION_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN
, DT.DESCRIPTION FROM IGS_PE_PERS_DISABLTY PD
, IGS_LOOKUP_VALUES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_PE_PERSON_BASE_V HP
, IGS_AD_DISBL_TYPE DT
WHERE CC1.LOOKUP_CODE(+) = PD.SPECIAL_ALLOW_CD
AND CC1.LOOKUP_TYPE(+) = 'PE_SN_ALLOW'
AND CC2.LOOKUP_CODE(+) = PD.SUPPORT_LEVEL_CD
AND CC2.LOOKUP_TYPE(+) = 'PE_SN_ADD_SUP_LVL'
AND HP.PERSON_ID(+) = PD.INTERVIEWER_ID
AND DT.DISABILITY_TYPE = PD.DISABILITY_TYPE