RC_SOLN_LIBSECR (SQL View)	Index Back
Solution Library Security This view returns type 'UR' (user role) solution library security definitions.

RC_SOLN_LIBSECR

(SQL View)

Solution Library Security

This view returns type 'UR' (user role) solution library security definitions.

SELECT SETID , LIBRARY_ID , LIB_SECURITY_TYPE , SEQNO , ROLENAME , REGION_ID , LOCATION , %subrec(RB_AUDIT_SBR, PS_RC_SOLN_LIBSEC) FROM PS_RC_SOLN_LIBSEC WHERE LIB_SECURITY_TYPE = 'UR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID

3 LIB_SECURITY_TYPE Character(2) VARCHAR2(2) NOT NULL Solution library security type

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 1

5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN_SRCH

6 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RF_REGIONGEO_VW

7 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
Prompt Table: LOCATION_WRK_VW
Set Control Field: SETID_LOCATION

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

9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID
3	LIB_SECURITY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Solution library security type
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
5	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN_SRCH
6	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RF_REGIONGEO_VW
7	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code. Prompt Table: LOCATION_WRK_VW Set Control Field: SETID_LOCATION
8	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
9	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
10	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
11	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
12	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.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time