[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view would be used in form |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IASS.ROWID
, IASS.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.FULL_NAME
, PDV.SEX_MEANING
, PDV.BIRTH_DT
, PDV.API_PERSON_ID
, IASS.COURSE_CD
, IASS.UNIT_SET_CD
, IASS.US_VERSION_NUMBER
, IASS.SEQUENCE_NUMBER
, IASS.SELECTION_DT
, IASS.STUDENT_CONFIRMED_IND
, IASS.END_DT
, IASS.PARENT_UNIT_SET_CD
, IASS.PARENT_SEQUENCE_NUMBER
, IASS.PRIMARY_SET_IND
, IASS.VOLUNTARY_END_IND
, IASS.AUTHORISED_PERSON_ID
, PDV1.PERSON_NUMBER
, IASS.AUTHORISED_ON
, IASS.OVERRIDE_TITLE
, IASS.RQRMNTS_COMPLETE_IND
, IASS.RQRMNTS_COMPLETE_DT
, IASS.S_COMPLETED_SOURCE_TYPE
, CI.DESCRIPTION CATALOG
, IASS.CATALOG_CAL_TYPE
, IASS.CATALOG_SEQ_NUM
, IASS.ATTRIBUTE_CATEGORY
, IASS.ATTRIBUTE1
, IASS.ATTRIBUTE2
, IASS.ATTRIBUTE3
, IASS.ATTRIBUTE4
, IASS.ATTRIBUTE5
, IASS.ATTRIBUTE6
, IASS.ATTRIBUTE7
, IASS.ATTRIBUTE8
, IASS.ATTRIBUTE9
, IASS.ATTRIBUTE10
, IASS.ATTRIBUTE11
, IASS.ATTRIBUTE12
, IASS.ATTRIBUTE13
, IASS.ATTRIBUTE14
, IASS.ATTRIBUTE15
, IASS.ATTRIBUTE16
, IASS.ATTRIBUTE17
, IASS.ATTRIBUTE18
, IASS.ATTRIBUTE19
, IASS.ATTRIBUTE20
, IASS.CREATED_BY
, IASS.CREATION_DATE
, IASS.LAST_UPDATED_BY
, IASS.LAST_UPDATE_DATE
, IASS.LAST_UPDATE_LOGIN
, IASS.REQUEST_ID
, IASS.PROGRAM_APPLICATION_ID
, IASS.PROGRAM_ID
, IASS.PROGRAM_UPDATE_DATE
FROM IGS_AS_SU_SETATMPT IASS
, IGS_PE_PERSON_V PDV
, IGS_PE_PERSON_V PDV1
, IGS_CA_INST CI
WHERE PDV.PERSON_ID = IASS.PERSON_ID
AND PDV1.PERSON_ID(+) = IASS.AUTHORISED_PERSON_ID
AND CI.CAL_TYPE(+) = IASS.CATALOG_CAL_TYPE
AND CI.SEQUENCE_NUMBER(+) = IASS.CATALOG_SEQ_NUM