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_PE_SRC_TYPES

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

View Text

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.SOURCE_TYPE_ID SOURCE_TYPE_ID
, TAB.SOURCE_TYPE SOURCE_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.SYSTEM_SOURCE_TYPE SYSTEM_SOURCE_TYPE
, TAB.CLOSED_IND CLOSED_IND
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ADMISSION_CAT ADMISSION_CAT
, TAB.PERSON_TYPE_CODE
, TAB.ENQUIRY_SOURCE_TYPE
, TAB.FUNNEL_STATUS
, NULL INQ_ENTRY_STAT_ID
, TAB.FEE_TYPE_ID
, TAB.FEE_CAL_TYPE
, TAB.FEE_CI_SEQUENCE_NUMBER
, TAB.INQUIRY_TYPE_ID
FROM IGS_PE_SRC_TYPES_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
ORG_ID
SOURCE_TYPE_ID
SOURCE_TYPE
DESCRIPTION
SYSTEM_SOURCE_TYPE
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ADMISSION_CAT
PERSON_TYPE_CODE
ENQUIRY_SOURCE_TYPE
FUNNEL_STATUS
INQ_ENTRY_STAT_ID
FEE_TYPE_ID
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
INQUIRY_TYPE_ID