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_PAT_V

Product:	IGS - Student System (Obsolete)
Description:	Describes a further breakdown of the program
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT APCOOD.ROWID ROW_ID
, APCOOD.ADM_CAL_TYPE
, APCOOD.ADM_CI_SEQUENCE_NUMBER
, APCOOD.ADMISSION_CAT
, APCOOD.DT_ALIAS
, APCOOD.DAI_SEQUENCE_NUMBER
, APCOOD.SEQUENCE_NUMBER
, APCOOD.S_ADMISSION_PROCESS_TYPE
, APCOOD.COURSE_CD
, APCOOD.VERSION_NUMBER
, APCOOD.ACAD_CAL_TYPE
, APCOOD.LOCATION_CD
, APCOOD.ATTENDANCE_MODE
, APCOOD.ATTENDANCE_TYPE
, DAIV.ALIAS_VAL
, APCOOD.ROLLOVER_INCLUSION_IND
, APCOOD.CREATED_BY
, APCOOD.CREATION_DATE
, APCOOD.LAST_UPDATED_BY
, APCOOD.LAST_UPDATE_DATE
, APCOOD.LAST_UPDATE_LOGIN
FROM IGS_AD_PECRS_OFOP_DT APCOOD
, IGS_CA_DA_INST_V DAIV
WHERE DAIV.DT_ALIAS = APCOOD.DT_ALIAS
AND DAIV.SEQUENCE_NUMBER = APCOOD.DAI_SEQUENCE_NUMBER
AND DAIV.CAL_TYPE = APCOOD.ADM_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = APCOOD.ADM_CI_SEQUENCE_NUMBER

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
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN