RSEC_DQ_VPRF_VW (SQL View)	Index Back
Deep query for view list This is deep query for view list associated to security profile.

RSEC_DQ_VPRF_VW

(SQL View)

Deep query for view list

This is deep query for view list associated to security profile.

SELECT A.SYNCID , A.RSEC_PROFILE_ID , B.RSEC_VIEW_ID , C.DESCR , C.RSEC_OBJECT_ID , C.RSEC_DOMAIN_SIZE , C.RSEC_DOMAIN_TYPE FROM PS_RSEC_PROFILEDFN A , PS_RSEC_PROFILEVDM B , PS_RSEC_VIEW_DEFN C WHERE A.RSEC_PROFILE_ID = B.RSEC_PROFILE_ID AND B.RSEC_VIEW_ID = C.RSEC_VIEW_ID AND A.SYNCID > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RSEC_PROFILE_ID Character(30) VARCHAR2(30) NOT NULL A unique identifier of security profile for application security.

3 RSEC_VIEW_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier of a view list used in application security.

4 RSEC_VW_OBJ_DESCR Character(30) VARCHAR2(30) NOT NULL Used for showing the membership object definition in the wizard drop-down.

5 RSEC_OBJECT_ID2 Character(30) VARCHAR2(30) NOT NULL Security object ID used in configurable search where we need to prompt for both membership and view security objects.

6 RSEC_DOMAIN_SIZE2 Character(4) VARCHAR2(4) NOT NULL This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'.
0001=All
0002=Multiple Members
0003=Single Member

7 RSEC_DOMAIN_TYPE2 Character(4) VARCHAR2(4) NOT NULL This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'.
0001=Dynamic
0002=Static

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.
3	RSEC_VIEW_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier of a view list used in application security.
4	RSEC_VW_OBJ_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used for showing the membership object definition in the wizard drop-down.
5	RSEC_OBJECT_ID2	Character(30)	VARCHAR2(30) NOT NULL	Security object ID used in configurable search where we need to prompt for both membership and view security objects.
6	RSEC_DOMAIN_SIZE2	Character(4)	VARCHAR2(4) NOT NULL	This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'. 0001=All 0002=Multiple Members 0003=Single Member
7	RSEC_DOMAIN_TYPE2	Character(4)	VARCHAR2(4) NOT NULL	This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'. 0001=Dynamic 0002=Static