View: IGS_AS_SUAAI_HIST_V

Product:	IGS - Student System
Description:	This view displays the context information for the student assessment items outcomes history.
Implementation/DBA Data:	APPS.IGS_AS_SUAAI_HIST_V

View Text

SELECT SUAAI.ROWID
, SUAAI.PERSON_ID
, PEV.PERSON_NUMBER
, P.PARTY_NAME
, PEV.FULL_NAME
, L1.MEANING
, PEV.BIRTH_DATE
, API.API_PERSON_ID
, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(SUAAI.PERSON_ID)
, DECODE(PEV.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y')
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUAAI.ASS_ID
, SUAAI.CREATION_DT
, SUAAI.ATTEMPT_NUMBER
, ASI.ASSESSMENT_TYPE
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_UAI_REF(SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.UOO_ID)
, 1
, 10)
, SUAAI.CREATED_BY
, SUAAI.CREATION_DATE
, SUAAI.LAST_UPDATED_BY
, SUAAI.LAST_UPDATE_DATE
, SUAAI.LAST_UPDATE_LOGIN
, SUAAI.UOO_ID
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_ASSESSMNT_ITM ASI
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PE_PERSON_BASE_V PEV
, IGS_PE_HZ_PARTIES PD
, FND_LOOKUP_VALUES L1
, HZ_PARTIES P
, IGS_PE_PERSON_ID_TYP PIT
, IGS_PE_ALT_PERS_ID API
WHERE SUAAI.ASS_ID = ASI.ASS_ID
AND SUAAI.PERSON_ID = PEV.PERSON_ID
AND SUAAI.UOO_ID = UOO.UOO_ID
AND SUAAI.PERSON_ID = P.PARTY_ID
AND SUAAI.PERSON_ID = API.PE_PERSON_ID(+)
AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE(+)
AND PIT.PREFERRED_IND(+) = 'Y'
AND SYSDATE BETWEEN API.START_DT(+)
AND NVL(API.END_DT(+)
, SYSDATE)
AND SUAAI.PERSON_ID = PD.PARTY_ID (+)
AND PEV.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0

Columns