RC_COLL_REC_VW

(SQL View)
 Index Back

Collection Record view

This is a view of Call Center Collection Records.

SELECT A.SRCH_COLLECTN_NAME %Concat ' ' %Concat A.RECNAME , %TrimSubstr(C.DESCR,1,29) %Concat ' - ' %Concat %TrimSubstr(B.RECDESCR,1,28) FROM PS_RB_SRCHIDX_HDR A , PSRECDEFN B , PS_RB_SRCH_PARMS C WHERE A.RECNAME = B.RECNAME AND A.SRCH_COLLECTN_NAME = C.SRCH_COLLECTN_NAME AND EXISTS ( SELECT 'X' FROM PS_RB_SRCHIDX_LINE D WHERE D.SRCH_COLLECTN_NAME = A.SRCH_COLLECTN_NAME AND D.RECNAME = B.RECNAME AND (D.RB_INDEX_FLG = 'Y' OR D.RB_FIELD_FLG = 'Y') AND D.RB_APP_FIELD_FLG = 'Y' AND D.FIELDNUM > 0)

  • Related Language Record: RC_COLLREC_VWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description