Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Shows the program approval status and details for a particular person |
Implementation/DBA Data: | Not implemented in this database |
SELECT AP.ROWID ROW_ID
, AP.APPL_PGMAPPRV_ID APPL_PGMAPPRV_ID
, AP.PERSON_ID PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, AP.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AP.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AP.PGM_APPROVER_ID PGM_APPROVER_ID
, P.FULL_NAME FULL_NAME
, AP.ASSIGN_TYPE ASSIGN_TYPE
, AP.ASSIGN_DATE ASSIGN_DATE
, AP.PROGRAM_APPROVAL_DATE PROGRAM_APPROVAL_DATE
, AP.PROGRAM_APPROVAL_STATUS PROGRAM_APPROVAL_STATUS
, L.MEANING MEANING
, AP.APPROVAL_NOTES APPROVAL_NOTES
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AP.REQUEST_ID REQUEST_ID
, AP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AP.PROGRAM_ID PROGRAM_ID
, AP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE FROM IGS_AD_APPL_PGMAPPRV AP
, IGS_LOOKUP_VALUES L
, IGS_PE_PERSON_BASE_V P
WHERE AP.PROGRAM_APPROVAL_STATUS = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'PROGRAM_APPROVAL_STATUS' AND AP.PGM_APPROVER_ID = P.PERSON_ID