[Home] [Help]
View: IGSFV_PASSPORTS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This entity contains information about a person's passport details. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT HZP.PARTY_NUMBER
, PEP.PASSPORT_NUMBER
, PEP. PASSPORT_CNTRY_CODE
, '_LA:PEP.PASSPORT_CNTRY_CODE:HR_LOOKUPS:PER_US_COUNTRY_CODE:MEANING'
, PEP.PASSPORT_EXPIRY_DATE
, PEP.PERSON_ID
, PEP.PASSPORT_ID
, PEP.CREATION_DATE
, PEP.CREATED_BY
, PEP.LAST_UPDATED_BY
, PEP.LAST_UPDATE_DATE
FROM IGS_PE_PASSPORT PEP
, HZ_PARTIES HZP
WHERE PEP.PERSON_ID=HZP.PARTY_ID WITH READ ONLY
Columns
| Name |
| PERSON_NUMBER |
| PASSPORT_NUMBER |
| PASSPORT_COUNTRY_CODE |
| "_LA:PASSPORT_COUNTRY" |
| PASSPORT_EXPIRY_DATE |
| PERSON_ID |
| PASSPORT_ID |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |