IT_EXCPT_EMAIL

(SQL View)
 Index Back

Email Information

Email information for all potential email candidates from the Manage Exceptions component

SELECT HDR.SERIAL_ID , C.MACHINENAME , HDR.CSTDN_EMAIL , HDR.CSTDN_EMPLID , HDR.CSTDN_LG_CD , HDR.CSTDN_MGR_EMAIL , HDR.CSTDN_MGR_EMPLID , HDR.CSTDN_MGR_LG_CD , HDR.PUSER_LG_CD , HDR.PUSER_EMPLID , HDR.PUSER_NAME , HDR.PUSER_EMAIL , HDR.PUSER_MGR_EMPLID , HDR.PUSER_MGR_LG_CD , HDR.PUSER_MGR_EMAIL FROM PS_IT_RECON_HDR HDR , PS_IT_HRDWR_CACHE C WHERE HDR.SERIAL_ID = C.SERIAL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
2 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
3 CSTDN_EMAIL Character(70) VARCHAR2(70) NOT NULL Custodian's Email Address
4 CSTDN_EMPLID Character(11) VARCHAR2(11) NOT NULL Custodian Empl Id
5 CSTDN_LG_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
6 CSTDN_MGR_EMAIL Character(70) VARCHAR2(70) NOT NULL Custodian Manager's Email
7 CSTDN_MGR_EMPLID Character(11) VARCHAR2(11) NOT NULL Custodian Manager's Employee I
8 CSTDN_MGR_LG_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
9 PUSER_LG_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
10 PUSER_EMPLID Character(11) VARCHAR2(11) NOT NULL Primary User Empl Id
11 PUSER_NAME Character(50) VARCHAR2(50) NOT NULL Primary User's Name
12 PUSER_EMAIL Character(70) VARCHAR2(70) NOT NULL Priary User's Email Address
13 PUSER_MGR_EMPLID Character(11) VARCHAR2(11) NOT NULL Primary User Manager's EMPLID
14 PUSER_MGR_LG_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
15 PUSER_MGR_EMAIL Character(70) VARCHAR2(70) NOT NULL Primary User Manager's Email