IT_EMPL_EMAIL (SQL View)	Index Back
Email information Employee email view with language code.

IT_EMPL_EMAIL

(SQL View)

Email information

Employee email view with language code.

SELECT DISTINCT A.emailid ,A.emplid , C.NAME , A.worklist_user_sw , A.email_user_sw , C.LANG_CD FROM PS_ROLEXLATOPR A , PSROLEUSER B , PS_PERSONAL_DATA C WHERE A.ROLEUSER = B.ROLEUSER AND A.EMPLID = C.EMPLID AND A.EMAIL_USER_SW = 'Y' AND A.EMAILID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
Prompt Table: %EDITTABLE

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

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated

5 EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated

6 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address Prompt Table: %EDITTABLE
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	WORKLIST_USER_SW	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if the user gets a worklist generated
5	EMAIL_USER_SW	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if the user gets workflow email generated
6	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German INE=International English ITA=Italian JPN=Japanese POR=Portuguese