Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about a person's visa details. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZP.PARTY_NUMBER
, PEV.VISA_TYPE
, PEV.VISA_ISSUE_DATE
, PEV.VISA_NUMBER
, PEV.VISA_CATEGORY
, '_LA:PEV.VISA_TYPE:HR_LOOKUPS:PER_US_VISA_TYPES:MEANING'
, '_LA:PEV.VISA_ISSUING_POST:IGS_LOOKUP_VALUES:PE_US_VISA_ISSUE_LOC:MEANING'
, '_LA:PEV.VISA_ISSUING_COUNTRY:HR_LOOKUPS:PER_US_COUNTRY_CODE:MEANING'
, PEV.VISA_EXPIRY_DATE
, PEV.AGENT_ORG_UNIT_CD
, PEV.AGENT_CONTACT_NAME
, PEV.PERSON_ID
, PEV.VISA_ID
, PEV.PASSPORT_ID
, PEV.AGENT_PERSON_ID
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE
FROM IGS_PE_VISA PEV
, HZ_PARTIES HZP
WHERE PEV.PERSON_ID=HZP.PARTY_ID WITH READ ONLY