SAE_WEBADDR_VW

(SQL View)

SELECT URL.EMPLID , USAGETBL.ADDR_USAGE , URL.E_ADDR_TYPE , URL.URL_ADDRESS , 'A' SAE_MODE FROM %Table(URL_ADDRESSES) URL , %Table(ADDR_USAGE_TBL) USAGETBL , %Table(ADDR_ORDER_TBL) ORD WHERE URL.E_ADDR_TYPE = ORD.E_ADDR_TYPE AND USAGETBL.ADDR_USAGE = ORD.ADDR_USAGE AND ORD.ADDR_USAGE_TYPE = 'EM' AND ORD.ADDR_USAGE_ORDER = ( SELECT MIN(ORD1.ADDR_USAGE_ORDER) FROM %Table(URL_ADDRESSES) URL1 , %Table(ADDR_ORDER_TBL) ORD1 WHERE USAGETBL.ADDR_USAGE = ORD1.ADDR_USAGE AND URL1.E_ADDR_TYPE = ORD1.E_ADDR_TYPE AND ORD1.ADDR_USAGE_TYPE = 'EM' AND URL1.EMPLID = URL.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

3 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other

4 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address

5 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage
3	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR. BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other
4	URL_ADDRESS	Character(254)	VARCHAR2(254) NOT NULL	URL Address
5	SAE_MODE	Character(1)	VARCHAR2(1) NOT NULL	Operation Mode A=Add C=Change D=Delete