RC_EMWKRCONS_VW

(SQL View)
 Index Back

Consumer Contacts

consumer profile for customer selections.

SELECT DISTINCT F.EMAIL_ADDR , A.PERSON_ID , D.BO_ID , A.NAME , A.LAST_NAME , A.FIRST_NAME , A.MIDDLE_NAME , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , D.BO_ID , D.ROLE_TYPE_ID , C.BO_NAME , 'Y' FROM PS_RB_PRSN_P_NM_VW A , PS_BO_NAME_PRIM_VW C , PS_BO_ROLE D , PS_BO_EMAIL_VW F WHERE A.BO_ID = D.BO_ID AND C.BO_ID = A.BO_ID AND D.BO_ID = F.BO_ID AND D.ROLE_START_DT <= %CurrentDateIn AND D.ROLE_END_DT > %CurrentDateIn AND D.ROLE_TYPE_ID IN (9, 4)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
9 WS_HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Telephone Number
10 WS_WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Telephone Number
11 WS_WORK_EXT Character(6) VARCHAR2(6) NOT NULL Phone Extension
12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
13 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SETID
14 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
15 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
16 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
17 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
18 CUST_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to represent the customer name
19 CONSUMER_FLAG Character(1) VARCHAR2(1) NOT NULL To indicate whether a person has a consumer role.