SETIDEMAIL_ADDR_CUSTRC_EMAIL_VW4(SQL View) |
Index Back |
|---|---|
Email Address ViewThis is a Call Center View used for Email Address. |
| SELECT DISTINCT G.SETID , C.EMAIL_ADDR , %Substring(F.BO_NAME_DISPLAY,1,50) , F.BO_NAME_AC , D.DESCR FROM PS_BO_SRCH_EML C , PS_CM_PURP_TYPE D , PS_BO_NAME F , PS_BC G WHERE C.ROLE_TYPE_ID IN (2,9) AND C.BO_CM_USE_TYPE = 'R' AND C.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND C.BO_ID = F.BO_ID AND F.PRIMARY_IND = 'Y' AND C.BO_ID = G.BO_ID AND G.CUST_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | EMAIL_ADDR_CUST |
Character(70) | VARCHAR2(70) NOT NULL | email address for the customer - used in case |
| 3 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 4 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | RC_PURP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Short Description |