[Home] [Help]
View: IGS_SV_CRT_STDT_FADDR_V
Product: | IGS - Student System (Obsolete) |
Description: | View for fetching foreign address for the new Non-Immigrant students |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FADD.BATCH_ID
, FADD.PERSON_ID
, FADD.ADDRESS_LINE1 FN_ADDRESS_LINE1
, FADD.ADDRESS_LINE2 FN_ADDRESS_LINE2
, FADD.CITY FN_CITY
, FADD.PROVINCE FN_PROVINCE
, FADD.COUNTRY_CODE FN_COUNTRY_CODE
, FADD.POSTAL_CODE FN_POSTAL_CODE
FROM IGS_SV_ADDRESSES FADD
WHERE FADD.ACTIVITY_SITE_CD IS NULL
AND FADD.ADDRESS_TYPE = 'F'
Columns
Name |
BATCH_ID |
PERSON_ID |
FN_ADDRESS_LINE1 |
FN_ADDRESS_LINE2 |
FN_CITY |
FN_PROVINCE |
FN_COUNTRY_CODE |
FN_POSTAL_CODE |