RA_WF_OFFER_VW (SQL View)	Index Back
CRM Workflow Action Request VW CRM Workflow Action Request View

RA_WF_OFFER_VW

(SQL View)

CRM Workflow Action Request VW

CRM Workflow Action Request View

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.INSTSTATUS , A.INSTAVAILABLEDTTM , A.INSTTIMEOUTDTTM , A.ORIGINATORID , B.SETID , B.RA_OFFER_ID , B.RB_WF_WL_PRIORITY , B.RA_OFFER_STATUS , B.RA_OFFER_NAME , B.RA_REASON_WORKFLOW , B.RA_PROMO_CD , B.RA_DISCOUNT_SRC , B.RA_DISCOUNT_TYPE , B.PRODUCT_ID , B.R_DATE_REPORTED , B.WORKLIST_DESCR , A.WL_PRIORITY , A.COMMENTSHORT , CASE WHEN A.INSTSTATUS = 2 THEN 'Y' ELSE 'N' END , B.WF_PURPOSE , A.SYNCID FROM PSWORKLIST A , PS_RA_OFFER_WL B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND A.INSTSTATUS <= 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

7 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
0=Selected
1=Open
2=Worked
3=Cancelled

8 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available

9 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out

10 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

11 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

12 RA_OFFER_ID Character(15) VARCHAR2(15) NOT NULL Marketing Offer ID

13 RB_WF_WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification Priority
1=High
2=Medium
3=Low

14 RA_OFFER_STATUS Character(4) VARCHAR2(4) NOT NULL Marketing Offer status
ARCH=Archived
CMPL=Completed
DECL=Declined
IREV=In Review
NEW=New
PLAN=Planning

15 RA_OFFER_NAME Character(50) VARCHAR2(50) NOT NULL Marketing Offer Name

16 RA_REASON_WORKFLOW Character(254) VARCHAR2(254) NOT NULL Reason for Workflow Routing

17 RA_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Promotion Code

18 RA_DISCOUNT_SRC Character(4) VARCHAR2(4) NOT NULL Discount Source
OTHR=Other
PSOM=PeopleSoft OM

19 RA_DISCOUNT_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing - Offer - Discount Type
GIVE=Giveaway
NONE=No Discount
STD=Standard Discount
TIER=Tiered Pricing

20 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

21 R_DATE_REPORTED Date(10) DATE Reported date

22 WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description

23 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-High
2=2-Medium
3=3-Low

24 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment

25 SHOW_COMPLETED Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the worklist should be filtered to show only completed worklist entries.
Y/N Table Edit
Default Value: N

26 WF_PURPOSE Character(4) VARCHAR2(4) NOT NULL Purpose of the Notification
0=FYI
APPR=Approval Required
ASSN=Assignment
ESCA=Escalation
FOLL=Follow-Up Requested
HOLD=Hold Notification
SLA=SLA Warning
SLAX=SLA Exception
STAT=Status Change
TASG=Task Assignment
UPD=Update Notification

27 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
3	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
4	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow
5	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name
6	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
7	INSTSTATUS	Number(5,0)	INTEGER NOT NULL	Determines worklist status, available, selected, worked, cancelled 0=Selected 1=Open 2=Worked 3=Cancelled
8	INSTAVAILABLEDTTM	DateTime(26)	TIMESTAMP	Datetime worklist instance was made available
9	INSTTIMEOUTDTTM	DateTime(26)	TIMESTAMP	Datetime that a worklist times out
10	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
12	RA_OFFER_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing Offer ID
13	RB_WF_WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Notification Priority 1=High 2=Medium 3=Low
14	RA_OFFER_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Marketing Offer status ARCH=Archived CMPL=Completed DECL=Declined IREV=In Review NEW=New PLAN=Planning
15	RA_OFFER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Marketing Offer Name
16	RA_REASON_WORKFLOW	Character(254)	VARCHAR2(254) NOT NULL	Reason for Workflow Routing
17	RA_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Promotion Code
18	RA_DISCOUNT_SRC	Character(4)	VARCHAR2(4) NOT NULL	Discount Source OTHR=Other PSOM=PeopleSoft OM
19	RA_DISCOUNT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Marketing - Offer - Discount Type GIVE=Giveaway NONE=No Discount STD=Standard Discount TIER=Tiered Pricing
20	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
21	R_DATE_REPORTED	Date(10)	DATE	Reported date
22	WORKLIST_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
23	WL_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-High 2=2-Medium 3=3-Low
24	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
25	SHOW_COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine whether the worklist should be filtered to show only completed worklist entries. Y/N Table Edit Default Value: N
26	WF_PURPOSE	Character(4)	VARCHAR2(4) NOT NULL	Purpose of the Notification 0=FYI APPR=Approval Required ASSN=Assignment ESCA=Escalation FOLL=Follow-Up Requested HOLD=Hold Notification SLA=SLA Warning SLAX=SLA Exception STAT=Status Change TASG=Task Assignment UPD=Update Notification
27	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.