Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view incorporates the assessment of those students who are not enrolled in any course offerings. |
Implementation/DBA Data: | Not implemented in this database |
SELECT NESO.ROWID
, PEV.PARTY_NUMBER
, NESO.PERSON_ID
, NESO.UNIT_CD
, NESO.VERSION_NUMBER
, NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(NESO.CAL_TYPE
, NESO.CI_SEQUENCE_NUMBER)
, 1
, 10)
, NESO.COURSE_CD
, NESO.LOCATION_CD
, NESO.UNIT_MODE
, NESO.UNIT_CLASS
, NESO.S_GRADE_CREATION_METHOD_TYPE
, NESO.GRADING_SCHEMA_CD
, NESO.GS_VERSION_NUMBER
, NESO.GRADE
, NESO.MARK
, NESO.RESOLVED_IND
, NESO.COMMENTS
, NESO.CREATED_BY
, NESO.CREATION_DATE
, NESO.LAST_UPDATED_BY
, NESO.LAST_UPDATE_DATE
, NESO.LAST_UPDATE_LOGIN
, CI.DESCRIPTION
FROM HZ_PARTIES PEV
, IGS_AS_NON_ENR_STDOT NESO
, IGS_CA_INST_ALL CI
WHERE PEV.PARTY_ID = NESO.PERSON_ID
AND NESO.CAL_TYPE =CI.CAL_TYPE
AND NESO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER