RSEC_DQ_MPRF_VW (SQL View)	Index Back
Deep query for membership list This is deep query that relates memberships related to security profile.

RSEC_DQ_MPRF_VW

(SQL View)

Deep query for membership list

This is deep query that relates memberships related to security profile.

SELECT A.SYNCID , A.RSEC_PROFILE_ID , B.RSEC_MEMBER_ID , C.DESCR , C.RSEC_OBJECT_ID , C.RSEC_DOMAIN_SIZE , C.RSEC_DOMAIN_TYPE FROM PS_RSEC_PROFILEDFN A , PS_RSEC_PROFILEMDM B , PS_RSEC_MEMBERDEFN C WHERE A.RSEC_PROFILE_ID = B.RSEC_PROFILE_ID AND B.RSEC_MEMBER_ID = C.RSEC_MEMBER_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_MEMBER_ID Character(30) VARCHAR2(30) NOT NULL Security Membership ID for application security membership definition.

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

5 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.

6 RSEC_DOMAIN_SIZE 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_TYPE 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_MEMBER_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Membership ID for application security membership definition.
4	RSEC_MEM_OBJ_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used for showing the membership object definition in the wizard drop-down.
5	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects.
6	RSEC_DOMAIN_SIZE	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_TYPE	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