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_AD_PERD_PS_OF_PAT1_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT APCOODV.ROW_ID ROW_ID
, APCOODV.ADM_CAL_TYPE ADM_CAL_TYPE
, APCOODV.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, APCOODV.ADMISSION_CAT ADMISSION_CAT
, APCOODV.DT_ALIAS DT_ALIAS
, APCOODV.DAI_SEQUENCE_NUMBER DAI_SEQUENCE_NUMBER
, APCOODV.SEQUENCE_NUMBER SEQUENCE_NUMBER
, APCOODV.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCOODV.COURSE_CD COURSE_CD
, APCOODV.VERSION_NUMBER VERSION_NUMBER
, APCOODV.ACAD_CAL_TYPE ACAD_CAL_TYPE
, APCOODV.LOCATION_CD LOCATION_CD
, APCOODV.ATTENDANCE_MODE ATTENDANCE_MODE
, APCOODV.ATTENDANCE_TYPE ATTENDANCE_TYPE
, APCOODV.ALIAS_VAL ALIAS_VAL
, APCOODV.ROLLOVER_INCLUSION_IND ROLLOVER_INCLUSION_IND
, DECODE( APCOODV.S_ADMISSION_PROCESS_TYPE
, NULL
, NULL
, (SELECT LKUP.MEANING
FROM IGS_LOOKUP_VALUES LKUP
WHERE LKUP.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND LKUP.LOOKUP_CODE = APCOODV.S_ADMISSION_PROCESS_TYPE )) MEANING
, APCOODV.CREATED_BY CREATED_BY
, APCOODV.CREATION_DATE CREATION_DATE
, APCOODV.LAST_UPDATED_BY LAST_UPDATED_BY
, APCOODV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCOODV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PERD_PS_OF_PAT_V APCOODV

Columns

Name
ROW_ID
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
ADMISSION_CAT
DT_ALIAS
DAI_SEQUENCE_NUMBER
SEQUENCE_NUMBER
S_ADMISSION_PROCESS_TYPE
COURSE_CD
VERSION_NUMBER
ACAD_CAL_TYPE
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
ALIAS_VAL
ROLLOVER_INCLUSION_IND
MEANING
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN