[Home] [Help]
View: IGSBV_APPL_PANEL_DETAILS
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT IPD.PANEL_DTLS_ID
, IPD.PERSON_ID
, IPD.ADMISSION_APPL_NUMBER
, IPD.NOMINATED_COURSE_CD
, IPD.SEQUENCE_NUMBER
, IPD.PANEL_CODE
, IPD.FINAL_DECISION_CODE
, '_LA:IPD.FINAL_DECISION_TYPE:IGS_LOOKUP_VALUES:INTERVIEW_PANEL_TYPE:MEANING'
, '_LA:IPD.CLOSED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, IPD.INTERVIEW_DATE
, IPD.INTERVIEW_TIME
, IPD.LOCATION_CD
, IPD.ROOM_ID
, IPD.FINAL_DECISION_DATE
, '_DF:IGS:IGS_AD_PANEL_DTLS_FLEX:IPD'
, IPD.CREATED_BY
, IPD.CREATION_DATE
, IPD.LAST_UPDATED_BY
, IPD.LAST_UPDATE_DATE
FROM IGS_AD_PANEL_DTLS IPD WITH READ ONLY
Columns
Name |
PANEL_DETAILS_ID |
PERSON_ID |
ADMISSION_APPL_NUMBER |
NOMINATED_PROGRAM_CODE |
SEQUENCE_NUMBER |
PANEL_CODE |
FINAL_DECISION_CODE |
"_LA:DECISION_TYPE_MEANING" |
"_LA:CLOSED_IND_FLAG" |
INTERVIEW_DATE |
INTERVIEW_TIME |
LOCATION_CODE |
ROOM_ID |
FINAL_DECISION_DATE |
"_DF" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |