Product: | IGS - Student System (Obsolete) |
---|---|
Description: | iew of IGS_AD_PANEL_MEMBRS table. Show the Panel Members of the Panel. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PNLMBR.ROWID ROW_ID
, PNLMBR.PANEL_CODE PANEL_CODE
, PNLMBR.MEMBER_PERSON_ID MEMBER_PERSON_ID
, PEBASE.PERSON_NUMBER PERSON_NUMBER
, PEBASE.FULL_NAME FULL_NAME
, PNLMBR.PANEL_SEQ_NUM PANEL_SEQ_NUM
, PNLMBR.ROLE_TYPE_CODE ROLE_TYPE_CODE
, LKUPS.MEANING ROLE_TYPE_DESC
, PNLMBR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PNLMBR.ATTRIBUTE1 ATTRIBUTE1
, PNLMBR.ATTRIBUTE2 ATTRIBUTE2
, PNLMBR.ATTRIBUTE3 ATTRIBUTE3
, PNLMBR.ATTRIBUTE4 ATTRIBUTE4
, PNLMBR.ATTRIBUTE5 ATTRIBUTE5
, PNLMBR.ATTRIBUTE6 ATTRIBUTE6
, PNLMBR.ATTRIBUTE7 ATTRIBUTE7
, PNLMBR.ATTRIBUTE8 ATTRIBUTE8
, PNLMBR.ATTRIBUTE9 ATTRIBUTE9
, PNLMBR.ATTRIBUTE10 ATTRIBUTE10
, PNLMBR.ATTRIBUTE11 ATTRIBUTE11
, PNLMBR.ATTRIBUTE12 ATTRIBUTE12
, PNLMBR.ATTRIBUTE13 ATTRIBUTE13
, PNLMBR.ATTRIBUTE14 ATTRIBUTE14
, PNLMBR.ATTRIBUTE15 ATTRIBUTE15
, PNLMBR.ATTRIBUTE16 ATTRIBUTE16
, PNLMBR.ATTRIBUTE17 ATTRIBUTE17
, PNLMBR.ATTRIBUTE18 ATTRIBUTE18
, PNLMBR.ATTRIBUTE19 ATTRIBUTE19
, PNLMBR.ATTRIBUTE20 ATTRIBUTE20
, PNLMBR.CREATED_BY CREATED_BY
, PNLMBR.CREATION_DATE CREATION_DATE
, PNLMBR.LAST_UPDATED_BY LAST_UPDATED_BY
, PNLMBR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNLMBR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PANEL_MEMBRS PNLMBR
, IGS_PE_PERSON_BASE_V PEBASE
, IGS_LOOKUP_VALUES LKUPS
, IGS_AD_INTVW_PNLS PNLTYPE
WHERE PNLMBR.MEMBER_PERSON_ID = PEBASE.PERSON_ID
AND PNLMBR.ROLE_TYPE_CODE = LKUPS.LOOKUP_CODE
AND PNLMBR.PANEL_CODE = PNLTYPE.PANEL_CODE
AND ((PNLTYPE.PANEL_TYPE_CODE = 'INTERVIEW'
AND LKUPS.LOOKUP_TYPE = 'INTERVIEW_ROLE_TYPE') OR (PNLTYPE.PANEL_TYPE_CODE = 'SCREENING'
AND LKUPS.LOOKUP_TYPE = 'SCREEN_ROLE_TYPE'))