SAE_LDAPWBORDVW

(SQL View)
Index Back

SAIP LDAP Web Order View

Web address order view

SELECT UA.EMPLID ,UA.E_ADDR_TYPE ,ORD.ADDR_USAGE_ORDER ,ORD.ADDR_USAGE ,UA.URL_ADDRESS FROM %Table(URL_ADDRESSES) UA , %Table(ADDR_ORDER_TBL) ORD WHERE ORD.E_ADDR_TYPE = UA.E_ADDR_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 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
3 ADDR_USAGE_ORDER Number(4,0) SMALLINT NOT NULL Address Usage Order
4 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage
5 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address