EMAIL_ADDR_VW

(SQL View)
Index Back

Email Addresses

View on Email Addresses Record and is used in Search Match.

SELECT EMPLID ,E_ADDR_TYPE ,%Upper(EMAIL_ADDR) ,PREF_EMAIL_FLAG FROM PS_EMAIL_ADDRESSES

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

Default Value: NEW

Prompt Table: PERSON_NAME

2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
4 PREF_EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred
N=No
Y=Yes

Y/N Table Edit

Default Value: N