[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View to select the Personal Statements for the Applications from the Self Service staging table |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID
, A.SS_PERSTAT_ID
, A.PERSON_ID
, A.SS_ADM_APPL_ID
, A.PERSL_STAT_TYPE
, C.PERSL_STAT_TYPE_DESC
, C.CLOSED_IND
, A.DATE_RECEIVED
, A.CREATED_BY
, A.CREATION_DATE
, A.ATTACH_EXISTS
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, B.GROUP_NUMBER
, B.MANDATORY
, B.ADMISSION_APPLICATION_TYPE
, D.GROUP_MIN
, D.SELF_MESSAGE
, D.GROUP_NAME
, D.GROUP_REQUIRED_FLAG
FROM IGS_SS_APPL_PERSTAT A
, IGS_AD_APTYP_PESTAT B
, IGS_AD_PER_STM_TYP C
, IGS_AD_PESTAT_GROUP D
WHERE A.PERSL_STAT_TYPE = B.PERSL_STAT_TYPE
AND B.PERSL_STAT_TYPE = C.PERSL_STAT_TYPE
AND D.GROUP_NUMBER(+) = B.GROUP_NUMBER
AND D.ADMISSION_APPLICATION_TYPE(+) = B.ADMISSION_APPLICATION_TYPE
AND A.ADMISSION_APPLICATION_TYPE = B.ADMISSION_APPLICATION_TYPE WITH CHECK OPTION