QS_TRACE_VW

(SQL View)
 Index Back

TraceSet Parent view

This view is used as a search record and a prompt table. Be careful when making changes. 10/12/00 changed rel lang vw to qs_trace_lvw 12/00 -- rre -- added DESCR and prompt tables so that this view may also be used as a search record for Trace Set Component. Needed to use this view because its key fields are not required, allowing user to leave fields blank or use wildcards when searching for existing trace sets. Also added OPR_DEF_TBL_FS.SETID as default value in setid field and set up search init pcode to pick up default SETID.

SELECT setid , qs_app_context , qs_traceset_id , qs_traceset_name , descr FROM PS_QS_TRACE_SET8

  • Related Language Record: QS_TRACE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 QS_APP_CONTEXT Character(18) VARCHAR2(18) NOT NULL QC application context identifier

    Prompt Table: QS_APP_DEF

    3 QS_TRACESET_ID Number(5,0) INTEGER NOT NULL Trace Set ID
    4 QS_TRACESET_NAME Character(24) VARCHAR2(24) NOT NULL Trace Set Name
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description