SCC_RTRIG_R2_PT

(SQL View)
 Index Back

Prompt Comopnent Record View

This view is created to be used as a prompt to search for records used in a component used in the setup of triggers in the rules engine.

SELECT DISTINCT A.PNLGRPNAME , D.RECNAME , D.RECTYPE , D.RECDESCR FROM PSPNLGRPDEFN A , PSPNLGROUP B , PSPNLFIELD C , PSRECDEFN D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND B.PNLNAME = C.PNLNAME AND C.RECNAME > ' ' AND C.RECNAME = D.RECNAME

  • Related Language Record: SCC_RTRIG_R2_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
    0=SQL Table
    1=SQL View
    2=Derived Work/Record
    3=Subrecord
    5=Dynamic View
    6=Query View
    7=Temporary Table
    4 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description