RB_OBEM_VW (SQL View)	Index Back
Search Record for RB_EM_OB.GBL Search record for Outbound Email Component RB_EM_OB.GBL

RB_OBEM_VW

(SQL View)

Search Record for RB_EM_OB.GBL

Search record for Outbound Email Component RB_EM_OB.GBL

SELECT A.CMF_INSTANCE_ID , A.CMF_ID , A.BO_ID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , A.ROLE_TYPE_ID , A.EMAIL_ADDR , %Upper(A.EMAIL_ADDR) , B.CMF_REQST_STATUS , B.EMAIL_ADDR_SENDER , B.SUBMIT_DATE , A.SUBJECT , B.SUBMIT_OPRID , E.OPRDEFNDESC , A.CMF_RECP_STATUS , B.SYNCID FROM PS_RBC_RECIPIENT A , PS_RBC_REQUEST B , PS_BO_NAME_PRIM_VW D , PSOPRDEFN E WHERE A.CMF_ID = B.CMF_ID AND B.CMF_SOURCE = 'ERMS' AND B.SUBMIT_OPRID = E.OPRID (+) AND A.BO_ID = D.BO_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CMF_INSTANCE_ID Character(36) VARCHAR2(36) NOT NULL Outbound Email ID

2 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID

3 BO_ID_RECIPIENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

7 ERMS_SEND_TO Character(254) VARCHAR2(254) NOT NULL CRM common field: Send to field for email

8 ERMS_SEND_UPPER Character(254) VARCHAR2(254) NOT NULL Common field: Send to field for email in uppercase

9 CMF_REQST_STATUS Character(4) VARCHAR2(4) NOT NULL Correspondence Request Status
APPR=Send For Approval
CNCL=Cancelled
COMP=Completed
IP=In Progress
PREV=Preview and Personalize
PVRD=Preview Ready
SBMT=Submitted

10 EMAIL_ADDR_SENDER Long Character CLOB This is the senders email address field.

11 SUBMIT_DATE Date(10) DATE Correspondence Submit Date

12 EMAIL_SUBJECT254 Character(254) VARCHAR2(254) NOT NULL Email Subject

13 SUBMIT_OPRID Character(30) VARCHAR2(30) NOT NULL Submitted By OPRID.........................................
Prompt Table: RB_SBMTOPRID_VW

14 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

15 CMF_RECP_STATUS Character(4) VARCHAR2(4) NOT NULL Correspondence Request Status
DLVR=Delivered
INVD=Invalid
NDLV=Not Delivered

16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CMF_INSTANCE_ID	Character(36)	VARCHAR2(36) NOT NULL	Outbound Email ID
2	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence ID
3	BO_ID_RECIPIENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
7	ERMS_SEND_TO	Character(254)	VARCHAR2(254) NOT NULL	CRM common field: Send to field for email
8	ERMS_SEND_UPPER	Character(254)	VARCHAR2(254) NOT NULL	Common field: Send to field for email in uppercase
9	CMF_REQST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Request Status APPR=Send For Approval CNCL=Cancelled COMP=Completed IP=In Progress PREV=Preview and Personalize PVRD=Preview Ready SBMT=Submitted
10	EMAIL_ADDR_SENDER	Long Character	CLOB	This is the senders email address field.
11	SUBMIT_DATE	Date(10)	DATE	Correspondence Submit Date
12	EMAIL_SUBJECT254	Character(254)	VARCHAR2(254) NOT NULL	Email Subject
13	SUBMIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Submitted By OPRID......................................... Prompt Table: RB_SBMTOPRID_VW
14	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
15	CMF_RECP_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Request Status DLVR=Delivered INVD=Invalid NDLV=Not Delivered
16	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.