RB_DIRECTORY_VW

(SQL View)
 Index Back

Directory View

CRM Common Object: Directory View ..........

SELECT 'PER' ,A.PERSON_ID ,(RTRIM(UPPER(B.FIRST_NAME)) %Concat ' ' %Concat RTRIM(UPPER(B.LAST_NAME))) , B.FIRST_NAME , B.LAST_NAME , CASE WHEN E.EMAIL_ADDR IS NULL THEN ' ' ELSE E.EMAIL_ADDR END , CASE WHEN P.OPRID IS NULL THEN ' ' ELSE P.OPRID END , CASE WHEN P.OPRID IS NULL THEN ' ' ELSE 'Y' END , CASE WHEN E.EMAIL_ADDR IS NULL THEN ' ' ELSE 'Y' END , A.CONTACT_FLAG , A.PREF_WF_ROUTE_MTHD ,%CurrentDateTimeIn FROM PS_RD_PERSON A , PSOPRALIAS P , PS_RD_PERSON AA , PS_BO_PRIM_EMAL_VW E , PS_RD_PERSON_NAME B WHERE A.PERSON_ID=B.PERSON_ID AND AA.PERSON_ID=B.PERSON_ID AND B.PRIMARY_IND='Y' AND (A.PERSON_ID = P.OPRALIASVALUE(+) AND P.OPRALIASTYPE(+) = 'PER' ) AND AA.BO_ID = E.BO_ID(+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECIPIENT_TYPE Character(4) VARCHAR2(4) NOT NULL Recipient Type
PER=Person
PROV=Provider Group
2 IDTYPEATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP ID Type Attribute
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
6 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
7 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
8 WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated
9 EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated
10 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact
11 PREF_WF_ROUTE_MTHD Character(1) VARCHAR2(1) NOT NULL Preferred workflow notification method. E.g., Email, Worklist, or Both.
B=Both
E=Email
W=Worklist
12 RB_CREATE_DTTM DateTime(26) TIMESTAMP Created date time