[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RD.ROWID ROW_ID
, RD.RESIDENT_DETAILS_ID
, RD.PERSON_ID
, PE.PERSON_NUMBER
, RD.RESIDENCY_CLASS_CD RESIDENCY_CLASS
, CC1.MEANING RESIDENCY_CLASS_DESC
, RD.RESIDENCY_STATUS_CD RESIDENCY_STATUS
, CC2.MEANING RESIDENCY_STATUS_DESC
, RD.EVALUATION_DATE
, RD.EVALUATOR
, CI.START_DT
, CI.END_DT
, RD.COMMENTS
, RD.ATTRIBUTE_CATEGORY
, RD.ATTRIBUTE1
, RD.ATTRIBUTE2
, RD.ATTRIBUTE3
, RD.ATTRIBUTE4
, RD.ATTRIBUTE5
, RD.ATTRIBUTE6
, RD.ATTRIBUTE7
, RD.ATTRIBUTE8
, RD.ATTRIBUTE9
, RD.ATTRIBUTE10
, RD.ATTRIBUTE11
, RD.ATTRIBUTE12
, RD.ATTRIBUTE13
, RD.ATTRIBUTE14
, RD.ATTRIBUTE15
, RD.ATTRIBUTE16
, RD.ATTRIBUTE17
, RD.ATTRIBUTE18
, RD.ATTRIBUTE19
, RD.ATTRIBUTE20
, RD.CREATED_BY
, RD.CREATION_DATE
, RD.LAST_UPDATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATE_LOGIN
, RD.CAL_TYPE
, RD.SEQUENCE_NUMBER
, CI.DESCRIPTION CALENDAR_DESC
FROM IGS_PE_RES_DTLS RD
, IGS_LOOKUP_VALUES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_PE_PERSON_BASE_V PE
, IGS_CA_INST_ALL CI
WHERE RD.RESIDENCY_CLASS_CD = CC1.LOOKUP_CODE
AND CC1.LOOKUP_TYPE = 'PE_RES_CLASS'
AND RD.RESIDENCY_STATUS_CD = CC2.LOOKUP_CODE
AND CC2.LOOKUP_TYPE = 'PE_RES_STATUS'
AND RD.PERSON_ID = PE.PERSON_ID
AND RD.CAL_TYPE = CI.CAL_TYPE
AND RD.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER