WM_WR_CNTCT_VW

(SQL View)
 Index Back

WR Contact Info View


SELECT A.BUSINESS_UNIT , A.WR_ID , '1' , A.CONTACT_USERID , A.CONTACT_EMPLID , B.NAME_DISPLAY , A.CONTACT_MTHD , CASE WHEN A.CONTACT_MTHD = '3' THEN ' ' ELSE C.EMAILID END , CASE WHEN A.CONTACT_MTHD = '3' THEN ' ' ELSE C.PHONE END , A.CONTACT_DETAIL FROM PS_WM_WR_HDR A , PS_WM_OPER_NAME_VW B , PS_WM_WR_BY_VW C WHERE B.OPRID = A.CONTACT_USERID AND C.CONTACT_USERID = A.CONTACT_USERID UNION SELECT D.BUSINESS_UNIT , D.WR_ID , '2' , D.RQST_FOR_USERID , D.RQST_FOR_EMPLID , E.NAME_DISPLAY , D.RQST_FOR_MTHD , CASE WHEN D.RQST_FOR_MTHD = '3' THEN ' ' ELSE F.EMAILID END , CASE WHEN D.RQST_FOR_MTHD = '3' THEN ' ' ELSE F.PHONE END , D.RQST_FOR_DETAIL FROM PS_WM_WR_HDR D , PS_WM_OPER_NAME_VW E , PS_WM_WR_FOR_VW F WHERE E.OPRID = D.RQST_FOR_USERID AND F.RQST_FOR_USERID = D.RQST_FOR_USERID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
3 WR_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Contact Type
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display
7 CONTACT_MTHD Character(1) VARCHAR2(1) NOT NULL Contact method
1=E-mail
2=Phone
3=Do Not Contact
8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 CONTACT_DETAIL Character(70) VARCHAR2(70) NOT NULL Contact detail