GDP_CTX_SEQ_VW

(SQL View)
 Index Back

GDP Context Data View

Guided Process Context Data View

SELECT LST.PTAI_LIST_ID , CTX.FIELDNAME , CTX.RECNAME , GCTX.GDP_KEY_LABEL , CTX.PTAI_KEY_VALUE , CTX.PTAI_CTX_KEY , CTX.PTAI_CTX_VISBL , GCTX.GDP_DSP_SEQ FROM PS_PTAI_LIST LST , PS_PTAI_CONTEXT CTX , PS_GDP_TMPL_TBL GTBL , PS_GDP_TMPL_CTX GCTX WHERE LST.PTAI_LIST_ID = CTX.PTAI_LIST_ID AND LST.PTAI_PARENT_TMPL = GTBL.GDP_LIST_ID AND GTBL.GDP_TEMPLATE_ID = GCTX.GDP_TEMPLATE_ID AND CTX.RECNAME = GCTX.RECNAME AND CTX.FIELDNAME = GCTX.FIELDNAME

  • Related Language Record: GDP_CTX_SEQ_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 PTAI_KEY_LABEL Character(100) VARCHAR2(100) NOT NULL Label
    5 PTAI_KEY_VALUE Character(254) VARCHAR2(254) NOT NULL Value
    6 PTAI_CTX_KEY Character(1) VARCHAR2(1) NOT NULL Key Field
    N=No
    Y=Yes

    Default Value: Y

    7 PTAI_CTX_VISBL Character(1) VARCHAR2(1) NOT NULL Context Visible

    Default Value: N

    8 GDP_DSP_SEQ Number(2,0) SMALLINT NOT NULL Guided Process Context Display Sequence