GDP_TMPL_CTX

(SQL Table)
 Index Back

GDP Template Context Table

Guided Process Template Context Table

  • Related Language Record: GDP_CTX_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GDP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Guided Process Template ID
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: GDP_RECDFN_VW

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDALL

    4 GDP_KEY_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Context Key Label
    5 GDP_KEY_VALUE Character(254) VARCHAR2(254) NOT NULL Guided Process Context Key Value
    6 GDP_CTX_KEY Character(1) VARCHAR2(1) NOT NULL Guided Process Context Key
    N=No
    Y=Yes

    Default Value: Y

    7 GDP_CTX_VISBL Character(1) VARCHAR2(1) NOT NULL Guided Process Context Visible Indicator

    Default Value: N

    8 GDP_DSP_SEQ Number(2,0) SMALLINT NOT NULL Guided Process Context Display Sequence
    9 PROMPT_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Edit Type
    1=No Table Edit
    2=Prompt Table
    3=Translate Table
    4=Yes/No

    Default Value: 1

    10 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: PSRECDEFNPVW

    11 GDP_REL_DSP_FLD Character(18) VARCHAR2(18) NOT NULL Guided Process Related Display Field for Context Key Value

    Prompt Table: GDP_PRMPTFLD_VW

    12 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N