[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Session Details Information |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PEPREF.ROW_ID
, PEPREF.PERSON_ID
, PEPREF.ADM_ACAD_CAL_TYPE
, CTA.DESCRIPTION
, PEPREF.ADM_ACAD_CI_SEQUENCE_NUMBER
, CIA.ALTERNATE_CODE
, CIA.START_DT
, CIA.END_DT
, PEPREF.ADM_ADMISSION_CAT
, APCV.AC_DESCRIPTION
, PEPREF.ADM_S_ADMISSION_PROCESS_TYPE
, APCV.SAPT_DESCRIPTION
, PEPREF.ADM_ADM_CAL_TYPE
, CTB.DESCRIPTION
, PEPREF.ADM_ADM_CI_SEQUENCE_NUMBER
, CIB.ALTERNATE_CODE
, CIB.START_DT
, CIB.END_DT
, PEPREF.ENR_ACAD_CAL_TYPE
, PEPREF.ENR_ACAD_SEQUENCE_NUMBER
, PEPREF.ENR_ENROLMENT_CAT
, PEPREF.ENR_ENR_METHOD_TYPE
, PEPREF.ENQ_ACAD_CAL_TYPE
, PEPREF.ENQ_ACAD_CI_SEQUENCE_NUMBER
, PEPREF.ENQ_ADM_CAL_TYPE
, PEPREF.ENQ_ADM_CI_SEQUENCE_NUMBER
, PEPREF.SERVER_PRINTER_DFLT
, PEPREF.ALLOW_STND_REQ_IND
, PEPREF.CREATED_BY
, PEPREF.CREATION_DATE
, PEPREF.LAST_UPDATED_BY
, PEPREF.LAST_UPDATE_DATE
, PEPREF.LAST_UPDATE_LOGIN
FROM IGS_PE_PERS_PREFS PEPREF
, IGS_CA_INST CIA
, IGS_CA_TYPE CTA
, IGS_CA_INST CIB
, IGS_CA_TYPE CTB
, IGS_AD_PRCS_CAT_ADMPRCS_V APCV
WHERE PEPREF.ADM_ACAD_CAL_TYPE = CIA.CAL_TYPE (+)
AND PEPREF.ADM_ACAD_CI_SEQUENCE_NUMBER = CIA.SEQUENCE_NUMBER (+)
AND PEPREF.ADM_ACAD_CAL_TYPE = CTA.CAL_TYPE (+)
AND PEPREF.ADM_ADMISSION_CAT = APCV.ADMISSION_CAT (+)
AND PEPREF.ADM_S_ADMISSION_PROCESS_TYPE = APCV.S_ADMISSION_PROCESS_TYPE (+)
AND PEPREF.ADM_ADM_CAL_TYPE = CIB.CAL_TYPE (+)
AND PEPREF.ADM_ADM_CAL_TYPE = CTB.CAL_TYPE (+)
AND PEPREF.ADM_ADM_CI_SEQUENCE_NUMBER = CIB.SEQUENCE_NUMBER (+)