RC_AGT_PREF_VW

(SQL View)
 Index Back

Saved Config Searches

User's saved configurable searches

SELECT A.OPRID ,PRF.OPRID2 ,PRF.SEQ_NUM ,A.PNLGRPNAME ,A.MARKET ,A.PNLNAME ,A.RECNAME ,A.RC_FILTER_NAME ,A.RC_FILTER_DESCR ,PRF.ACTIVE_STATUS ,A.AVAILABLE ,A.ORDERBY1 ,A.LASTUPDDTTM ,A.ADMIN FROM PS_RC_AGT_PREF A LEFT OUTER JOIN PS_RC_AGT_TRG_PRF PRF ON (A.OPRID = PRF.OPRID AND A.RC_FILTER_NAME = PRF.RC_FILTER_NAME) WHERE A.ADMIN %Concat A.AVAILABLE <> 'YN'

# 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 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
5 MARKET Character(3) VARCHAR2(3) NOT NULL Market
6 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
8 RC_FILTER_NAME Character(20) VARCHAR2(20) NOT NULL Search Defintion name
9 RC_FILTER_DESCR Character(35) VARCHAR2(35) NOT NULL Search definition description
10 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Allows for Active and Inactive status.
A=Active
I=Inactive
11 AVAILABLE Character(1) VARCHAR2(1) NOT NULL Available for Agent
N=Not Available
Y=Available

Default Value: N

12 ORDERBY1 Number(3,0) SMALLINT NOT NULL Order
13 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.
14 ADMIN Character(1) VARCHAR2(1) NOT NULL Admin role
N=Agent
Y=Admin

Default Value: N