[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Academic Intent View |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ACAD.ROWID ROW_ID
, ACAD.ACAD_INTENT_ID
, ACAD.PERSON_ID
, ACAD.CAL_TYPE
, ACAD.SEQUENCE_NUMBER
, ACAD.ACAD_INTENT_CODE
, CAL.DESCRIPTION CALENDAR_DESC
, LKUPS.MEANING ACAD_INTENT_DESC
, CAL.START_DT
, CAL.END_DT
, ACAD.ACTIVE_FLAG
, ACAD.CREATED_BY
, ACAD.CREATION_DATE
, ACAD.LAST_UPDATED_BY
, ACAD.LAST_UPDATE_DATE
, ACAD.LAST_UPDATE_LOGIN
FROM IGS_PE_ACAD_INTENTS ACAD
, IGS_CA_INST_ALL CAL
, IGS_LOOKUP_VALUES LKUPS
WHERE ACAD.CAL_TYPE = CAL.CAL_TYPE
AND ACAD.SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER
AND ACAD.ACAD_INTENT_CODE = LKUPS.LOOKUP_CODE
AND LKUPS.LOOKUP_TYPE = 'PE_ACAD_INTENTS'