RB_CASE_ACT_WRK (SQL View)	Index Back
Email Case GBL View Email Case view that gets information for Goverment, Financial services and Communications.

RB_CASE_ACT_WRK

(SQL View)

Email Case GBL View

Email Case view that gets information for Goverment, Financial services and Communications.

SELECT CASE_ID , BUSINESS_UNIT , RC_VERTICAL , SETID_CUSTOMER , BO_ID_CONTACT , ROLE_TYPE_ID_CNTCT , BO_ID_CUST , ROLE_TYPE_ID_CUST , BO_ID_SITE , BO_NAME_DISPLAY_2 , BO_NAME_DISPLAY , EMPLID , SECURE_CASE_FLG , RC_SUMMARY , CREATION_DATE FROM %Table(RB_EM_CASE_VW) WHERE RC_VERTICAL = 'SW' AND MARKET NOT IN ('GOV','FIN','COM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support

4 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID

5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

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

8 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

9 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

10 BO_NAME_DISPLAY_2 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

13 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

14 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

15 CREATION_DATE Date(10) DATE Creation date of the case.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
4	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
5	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
6	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
7	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
8	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
9	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
10	BO_NAME_DISPLAY_2	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
11	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	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
14	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
15	CREATION_DATE	Date(10)	DATE	Creation date of the case.