SAD_SL_ADDRS_VW

(SQL View)
 Index Back

Studielink Address Change View

This view is used for selecting the latest changed address based on the type of address that is sent to Studielink using Message 06.

SELECT A.EMPLID , A.SAD_SL_ADDR_XLAT , A.XLATLONGNAME , A.ADDRESS_TYPE , D.SSR_COUNTRY_NLD , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.CITY , A.NUM1 , A.NUM2 , A.POSTAL , C.NAME_INITIALS , C.LAST_NAME FROM PS_SAD_SL_OT_AD_VW A , PS_HCR_PERSON_NM_I C , PS_SSR_COUNTRY_NLD D WHERE A.EMPLID=C.EMPLID AND A.XLATLONGNAME='Mailing' AND D.SSR_COUNTRY_NLD =( SELECT E.SSR_COUNTRY_NLD FROM PS_SSR_COUNTRY_NLD E WHERE E.COUNTRY=A.COUNTRY AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SSR_COUNTRY_NLD F WHERE F.COUNTRY=A.COUNTRY))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: STDNT_AID_SRCH

2 SAD_SL_ADDR_XLAT Character(4) VARCHAR2(4) NOT NULL Used to allow prompting for valid Studielink address type values.
BILL=Billing
LIVE=Living
MAIL=Mailing
PERM=Permanent
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
4 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: ADDRESS_TYP_TBL

5 SSR_COUNTRY_NLD Character(4) VARCHAR2(4) NOT NULL GBA Country Code
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
11 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name