RB_TSK_USRF_VW1 (SQL View)	Index Back
Task ListUser Folders view This view retrieves folder names used to categorize CRM Task List.

RB_TSK_USRF_VW1

(SQL View)

Task ListUser Folders view

This view retrieves folder names used to categorize CRM Task List.

SELECT OPRID , UID20F_FOLDER , FOLDER_LABEL FROM PS_RB_TSK_USR_FLDR

Related Language Record: RB_WL_FLDR_LNG

# 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 UID20F_FOLDER Character(20) VARCHAR2(20) NOT NULL This field is used to store a unique identifier for a folder that is created to categorize CRM worklist notifications.

3 FOLDER_LABEL Character(30) VARCHAR2(30) NOT NULL This field is used to store the name of a folder that is created to categorize CRM worklist notifications.

#	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	UID20F_FOLDER	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store a unique identifier for a folder that is created to categorize CRM worklist notifications.
3	FOLDER_LABEL	Character(30)	VARCHAR2(30) NOT NULL	This field is used to store the name of a folder that is created to categorize CRM worklist notifications.