eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_DA_RQST_V

Product:	IGS - Student System (Obsolete)
Description:	View over Degree Audit Request
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DR.ROWID
, DR.BATCH_ID
, DR.REQUEST_TYPE_ID
, DR.REQUEST_MODE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SELECTION_MODE'
AND LOOKUP_CODE = DR.REQUEST_MODE) REQUEST_MODE_MEANING
, DR.PROGRAM_COMPARISON_TYPE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_PROG_COMP'
AND LOOKUP_CODE = DR.PROGRAM_COMPARISON_TYPE) PROGRAM_COMP_TYPE_MEANING
, DR.REQUEST_STATUS
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_RQST_STATUS'
AND LOOKUP_CODE = DR.REQUEST_STATUS) REQUEST_STATUS_MEANING
, DR.PERSON_ID_GROUP_ID
, PGRP.GROUP_CD
, PGRP.DESCRIPTION GROUP_CD_DESC
, DR.PERSON_ID
, PBV.PARTY_NUMBER
, PBV.PARTY_NAME
, DR.REQUESTOR_ID
, PBV1.PARTY_NUMBER
, PBV1.PARTY_NAME
, DR.STUDENT_RELEASE_IND
, DR.SPECIAL_PROGRAM
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM) SPECIAL_PROGRAM_MEANING
, DR.SPECIAL_PROGRAM_CATALOG
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGM_CATS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM_CATALOG) SPECIAL_PROG_CATALOG_MEANING
, REQT.REQUEST_NAME
, DR.ATTRIBUTE_CATEGORY
, DR.ATTRIBUTE1
, DR.ATTRIBUTE2
, DR.ATTRIBUTE3
, DR.ATTRIBUTE4
, DR.ATTRIBUTE5
, DR.ATTRIBUTE6
, DR.ATTRIBUTE7
, DR.ATTRIBUTE8
, DR.ATTRIBUTE9
, DR.ATTRIBUTE10
, DR.ATTRIBUTE11
, DR.ATTRIBUTE12
, DR.ATTRIBUTE13
, DR.ATTRIBUTE14
, DR.ATTRIBUTE15
, DR.ATTRIBUTE16
, DR.ATTRIBUTE17
, DR.ATTRIBUTE18
, DR.ATTRIBUTE19
, DR.ATTRIBUTE20
, DR.CREATION_DATE
, DR.CREATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE
FROM IGS_DA_RQST DR
, HZ_PARTIES PBV
, HZ_PARTIES PBV1
, IGS_DA_CNFG_REQ_TYP REQT
, IGS_PE_PERSID_GROUP_ALL PGRP
WHERE DR.PERSON_ID = PBV.PARTY_ID(+)
AND DR.REQUESTOR_ID = PBV1.PARTY_ID
AND DR.REQUEST_TYPE_ID = REQT.REQUEST_TYPE_ID
AND PGRP.GROUP_ID(+) = DR.PERSON_ID_GROUP_ID UNION ALL SELECT DR.ROWID
, DR.BATCH_ID
, DR.REQUEST_TYPE_ID
, DR.REQUEST_MODE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SELECTION_MODE'
AND LOOKUP_CODE = DR.REQUEST_MODE) REQUEST_MODE_MEANING
, DR.PROGRAM_COMPARISON_TYPE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_PROG_COMP'
AND LOOKUP_CODE = DR.PROGRAM_COMPARISON_TYPE) PROGRAM_COMP_TYPE_MEANING
, DR.REQUEST_STATUS
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_RQST_STATUS'
AND LOOKUP_CODE = DR.REQUEST_STATUS) REQUEST_STATUS_MEANING
, DR.PERSON_ID_GROUP_ID
, NULL
, NULL
, DR.PERSON_ID
, PBV.PARTY_NUMBER
, PBV.PARTY_NAME
, DR.REQUESTOR_ID
, PBV1.PARTY_NUMBER
, PBV1.PARTY_NAME
, DR.STUDENT_RELEASE_IND
, DR.SPECIAL_PROGRAM
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM) SPECIAL_PROGRAM_MEANING
, DR.SPECIAL_PROGRAM_CATALOG
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGM_CATS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM_CATALOG) SPECIAL_PROG_CATALOG_MEANING
, REQT.REQUEST_NAME
, DR.ATTRIBUTE_CATEGORY
, DR.ATTRIBUTE1
, DR.ATTRIBUTE2
, DR.ATTRIBUTE3
, DR.ATTRIBUTE4
, DR.ATTRIBUTE5
, DR.ATTRIBUTE6
, DR.ATTRIBUTE7
, DR.ATTRIBUTE8
, DR.ATTRIBUTE9
, DR.ATTRIBUTE10
, DR.ATTRIBUTE11
, DR.ATTRIBUTE12
, DR.ATTRIBUTE13
, DR.ATTRIBUTE14
, DR.ATTRIBUTE15
, DR.ATTRIBUTE16
, DR.ATTRIBUTE17
, DR.ATTRIBUTE18
, DR.ATTRIBUTE19
, DR.ATTRIBUTE20
, DR.CREATION_DATE
, DR.CREATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE
FROM IGS_DA_RQST DR
, IGS_DA_REQ_STDNTS STDNTS
, HZ_PARTIES PBV
, HZ_PARTIES PBV1
, IGS_DA_CNFG_REQ_TYP REQT
WHERE DR.BATCH_ID = STDNTS.BATCH_ID
AND DR.REQUESTOR_ID = PBV1.PARTY_ID
AND DR.REQUEST_TYPE_ID = REQT.REQUEST_TYPE_ID
AND DR.PERSON_ID IS NULL
AND DR.PERSON_ID_GROUP_ID IS NULL

Columns

Name
ROW_ID
BATCH_ID
REQUEST_TYPE_ID
REQUEST_MODE
REQUEST_MODE_MEANING
PROGRAM_COMPARISON_TYPE
PROGRAM_COMP_TYPE_MEANING
REQUEST_STATUS
REQUEST_STATUS_MEANING
PERSON_ID_GROUP_ID
GROUP_CD
GROUP_CD_DESC
PERSON_ID
PERSON_NUMBER
FULL_NAME
REQUESTOR_ID
REQUESTOR_PERSON_NUMBER
REQUESTOR_FULL_NAME
STUDENT_RELEASE_IND
SPECIAL_PROGRAM
SPECIAL_PROGRAM_MEANING
SPECIAL_PROGRAM_CATALOG
SPECIAL_PROG_CATALOG_MEANING
REQUEST_NAME
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE