[Home] [Help]
View: IGS_PE_PERSON_ALIAS_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PA.ROWID ROW_ID
, PA.PERSON_ID
, PA.SEQUENCE_NUMBER
, PA.ALIAS_TYPE
, PA.START_DT
, PA.END_DT
, PA.SURNAME
, PA.GIVEN_NAMES
, PA.TITLE
, PA.ALIAS_COMMENT
, PA.CREATED_BY
, PA.CREATION_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATE_LOGIN
, LKUP.MEANING ALIAS_TYPE_MEANING FROM IGS_PE_PERSON_ALIAS PA
, IGS_LOOKUP_VALUES LKUP
WHERE PA.ALIAS_TYPE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'PE_ALIAS_TYPE'
Columns
Name |
ROW_ID |
PERSON_ID |
SEQUENCE_NUMBER |
ALIAS_TYPE |
START_DT |
END_DT |
SURNAME |
GIVEN_NAMES |
TITLE |
ALIAS_COMMENT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ALIAS_TYPE_MEANING |