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_S_PER_LTR_V

Product:	IGS - Student System (Obsolete)
Description:	IGS_CO_S_PER_LTR_V describes the system letter to be produced for the person.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CSPL.ROW_ID ROW_ID
, CSPL.PERSON_ID PERSON_ID
, PV.PERSON_NUMBER PERSON_NUMBER
, PV.FULL_NAME NAME
, PV.SEX_MEANING SEX
, PV.BIRTH_DT BIRTH_DT
, CSPL.CORRESPONDENCE_TYPE CORRESPONDENCE_TYPE
, CT.DESCRIPTION DESCRIPTION
, CSPL.LETTER_REFERENCE_NUMBER LETTER_REFERENCE_NUMBER
, CSPL.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CSPL.CREATED_BY CREATED_BY
, CSPL.CREATION_DATE CREATION_DATE
, CSPL.LAST_UPDATED_BY LAST_UPDATED_BY
, CSPL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSPL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSPL.REQUEST_ID REQUEST_ID
, CSPL.PROGRAM_ID PROGRAM_ID
, CSPL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CSPL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CSPL.ORG_ID ORG_ID
FROM IGS_CO_S_PER_LTR CSPL
, IGS_PE_PERSON_V PV
, IGS_CO_TYPE CT
WHERE CSPL.PERSON_ID = PV.PERSON_ID
AND CSPL.CORRESPONDENCE_TYPE = CT.CORRESPONDENCE_TYPE

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
NAME
SEX
BIRTH_DT
CORRESPONDENCE_TYPE
DESCRIPTION
LETTER_REFERENCE_NUMBER
SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE
ORG_ID