SAD_SL_EM_TP_VW (SQL View)	Index Back
Studielink Email Address Type This view links the Studielink email address type to address usage.

SAD_SL_EM_TP_VW

(SQL View)

Studielink Email Address Type

This view links the Studielink email address type to address usage.

SELECT B.E_ADDR_TYPE , A.ADDR_USAGE FROM PS_SAD_SL_EM_USAGE A , PS_ADDR_ORDER_TBL B WHERE A.ADDR_USAGE = B.ADDR_USAGE AND B.ADDR_USAGE_ORDER = ( SELECT MIN(J.ADDR_USAGE_ORDER) FROM PS_ADDR_ORDER_TBL J WHERE B.ADDR_USAGE = J.ADDR_USAGE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage