Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view IGS_CO_ITM_V, describes correspondence items that are sent to students. These may be system generated items or non system generated items that users have chosen to register against students. |
Implementation/DBA Data: | Not implemented in this database |
SELECT C.ROW_ID
, C.CORRESPONDENCE_TYPE
, C.REFERENCE_NUMBER
, C.CREATE_DT
, C.S_JOB_NAME
, C.REQUEST_JOB_ID
, C.OUTPUT_NUM
, C.REQUEST_JOB_RUN_ID
, C.CAL_TYPE
, C.CI_SEQUENCE_NUMBER
, C.COURSE_CD
, C.CV_VERSION_NUMBER
, C.UNIT_CD
, C.UV_VERSION_NUMBER
, C.COMMENTS
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATE_LOGIN
, C.REQUEST_ID
, C.PROGRAM_ID
, C.PROGRAM_APPLICATION_ID
, C.PROGRAM_UPDATE_DATE
, C.ORIGINATOR_PERSON_ID
, P.PERSON_NUMBER
, C.REQUEST_NUM
, C.JOB_REQUEST_ID
, C.ORG_ID
FROM IGS_CO_ITM C
, IGS_PE_PERSON P
WHERE C.ORIGINATOR_PERSON_ID = P.PERSON_ID (+)