RC_ADMN_PREF_VW

(SQL View)
 Index Back

Saved Config Searches

User's saved configurable searches

SELECT A.OPRID ,A.PNLGRPNAME ,A.MARKET ,A.PNLNAME ,A.RECNAME ,A.RC_FILTER_NAME ,A.RC_FILTER_DESCR ,A.AVAILABLE ,A.ORDERBY1 ,A.LASTUPDDTTM ,A.ADMIN FROM PS_RC_AGT_PREF A

# 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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
4 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 RC_FILTER_NAME Character(20) VARCHAR2(20) NOT NULL Search Defintion name
7 RC_FILTER_DESCR Character(35) VARCHAR2(35) NOT NULL Search definition description
8 AVAILABLE Character(1) VARCHAR2(1) NOT NULL Available for Agent
N=Not Available
Y=Available

Default Value: N

9 ORDERBY1 Number(3,0) SMALLINT NOT NULL Order
10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11 ADMIN Character(1) VARCHAR2(1) NOT NULL Admin role
N=Agent
Y=Admin

Default Value: N