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_CO_INTERACTION_HISTORY_V

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

View Text

SELECT CINH.ROWID
, CINH.REQUEST_ID
, CINH.STUDENT_ID
, CINH.DOCUMENT_ID
, AMV.NAME
, CINH.DOCUMENT_TYPE
, CINH.SYS_LTR_CODE
, CINH.ADM_APPLICATION_NUMBER
, CINH.NOMINATED_COURSE_CD
, CINH.SEQUENCE_NUMBER
, FRH.OUTCOME_CODE
, CINH.CAL_TYPE
, CINH.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CINH.CREATED_BY
, CINH.CREATION_DATE
, CINH.LAST_UPDATED_BY
, CINH.LAST_UPDATE_DATE
, CINH.LAST_UPDATE_LOGIN
, CINH.REQUESTED_DATE
, CINH.DELIVERY_TYPE
, FRH.PROCESSED_DT_TM
, DECODE(FRH.PARENT_REQ_ID
, NULL
, 'N'
, 'Y')
, CINH.VERSION_ID VERSON_ID
FROM IGS_CO_INTERAC_HIST CINH
, IGS_CA_INST CI
, IBC_CITEMS_V AMV
, JTF_FM_REQUEST_HISTORY FRH
WHERE CINH.CAL_TYPE = CI.CAL_TYPE(+)
AND CINH.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND CINH.DOCUMENT_ID=AMV.CITEM_ID
AND NVL(CINH.VERSION_ID
, 1)=AMV.VERSION
AND CINH.REQUEST_ID = FRH.HIST_REQ_ID(+)
AND AMV.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
REQUEST_ID
STUDENT_ID
DOCUMENT_ID
DOCUMENT_NAME
DOCUMENT_TYPE
SYS_LTR_CODE
ADM_APPLICATION_NUMBER
NOMINATED_COURSE_CD
SEQUENCE_NUMBER
COMP_STATUS
CAL_TYPE
CI_SEQUENCE_NUMBER
START_DT
END_DT
ALTERNATE_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUESTED_DATE
DELIVERY_TYPE
SENT_DATE
RESEND_FLAG
VERSION_ID