Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT API.ROWID ROW_ID
, API.PE_PERSON_ID
, API.API_PERSON_ID
, API.API_PERSON_ID_UF
, API.PERSON_ID_TYPE
, API.START_DT
, API.END_DT
, API.CREATED_BY
, API.CREATION_DATE
, API.LAST_UPDATED_BY
, API.LAST_UPDATE_DATE
, API.LAST_UPDATE_LOGIN
, PT.DESCRIPTION PERSON_ID_TYPE_DESC
, PT.FORMAT_MASK
, API.ATTRIBUTE_CATEGORY
, API.ATTRIBUTE1
, API.ATTRIBUTE2
, API.ATTRIBUTE3
, API.ATTRIBUTE4
, API.ATTRIBUTE5
, API.ATTRIBUTE6
, API.ATTRIBUTE7
, API.ATTRIBUTE8
, API.ATTRIBUTE9
, API.ATTRIBUTE10
, API.ATTRIBUTE11
, API.ATTRIBUTE12
, API.ATTRIBUTE13
, API.ATTRIBUTE14
, API.ATTRIBUTE15
, API.ATTRIBUTE16
, API.ATTRIBUTE17
, API.ATTRIBUTE18
, API.ATTRIBUTE19
, API.ATTRIBUTE20
, API.REGION_CD
, PT.REGION_IND FROM IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PT
WHERE PT.PERSON_ID_TYPE = API.PERSON_ID_TYPE