[Home] [Help]
View: IGS_PE_PID_TYPE_V
Product: | IGS - Student System (Obsolete) |
Description: | IGS_PE_PID_TYPE_V describes the person identifier types in the system |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PIT.ROWID ROW_ID
, PIT.PERSON_ID_TYPE
, API.API_PERSON_ID
, API.PE_PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
, PIT.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_ID_TYP PIT
, IGS_PE_ALT_PERS_ID API
WHERE API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE
AND PIT.PREFERRED_IND = 'Y'
Columns
Name |
ROW_ID |
PERSON_ID_TYPE |
API_PERSON_ID |
PE_PERSON_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |