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_PERSON_ID_TYP_V

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

View Text

SELECT PIT.ROWID ROW_ID
, PIT.PERSON_ID_TYPE PERSON_ID_TYPE
, PIT.DESCRIPTION DESCRIPTION
, PIT.S_PERSON_ID_TYPE S_PERSON_ID_TYPE
, PIT. PREFERRED_IND PREFERRED_IND
, PIT. UNIQUE_IND UNIQUE_IND
, PIT.INSTITUTION_CD INSTITUTION_CD
, OU.PARTY_NAME NAME
, OU.INSTITUTION_STATUS INSTITUTION_STATUS
, INS_STS.S_INSTITUTION_STATUS S_INSTITUTION_STATUS
, LKUPS.LOOKUP_TYPE LOOKUP_TYPE
, LKUPS.MEANING MEANING
, PIT.FORMAT_MASK FORMAT_MASK
, PIT.CREATED_BY CREATED_BY
, PIT.CREATION_DATE CREATION_DATE
, PIT.LAST_UPDATED_BY LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PIT.REGION_IND
, PIT.CLOSED_IND
FROM IGS_PE_PERSON_ID_TYP PIT
, IGS_OR_INST_ORG_BASE_V OU
, IGS_OR_INST_STAT INS_STS
, IGS_LOOKUP_VALUES LKUPS
WHERE PIT.INSTITUTION_CD =OU.PARTY_NUMBER(+)
AND INS_STS.S_INSTITUTION_STATUS (+) = 'ACTIVE'
AND INS_STS.INSTITUTION_STATUS (+) =OU.INSTITUTION_STATUS
AND LKUPS.LOOKUP_CODE = PIT.S_PERSON_ID_TYPE
AND LKUPS.LOOKUP_TYPE = 'PERSON_ID_TYPE'

Columns

Name
ROW_ID
PERSON_ID_TYPE
DESCRIPTION
S_PERSON_ID_TYPE
PREFERRED_IND
UNIQUE_IND
INSTITUTION_CD
NAME
INSTITUTION_STATUS
S_INSTITUTION_STATUS
LOOKUP_TYPE
MEANING
FORMAT_MASK
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REGION_IND
CLOSED_IND