RB_WL_R_CSHD_VW (SQL View)	Index Back
Workflow VW for case reassign Workflow view for help desk for HR case reassignment.

RB_WL_R_CSHD_VW

(SQL View)

Workflow VW for case reassign

Workflow view for help desk for HR case reassignment.

SELECT A.OPRID , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , B.BUSINESS_UNIT , B.CASE_ID , C.PROVIDER_GRP_ID , C.ASSIGNED_TO , C.BO_ID_CUST , C.SECURE_CASE_FLG , C.ROW_ADDED_DTTM FROM PSWORKLIST A , PS_RC_CASE_WL_HD B , PS_RC_CASE C 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 B.CASE_ID = C.CASE_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

9 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

10 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

11 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

12 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes

13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
9	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
10	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
11	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
12	SECURE_CASE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case. N=No Y=Yes
13	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.