GDP_TMPL_TBL

(SQL Table)
 Index Back

GDP Template Table

Guided Process Template Table

  • Related Language Record: GDP_TMPL_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 GDP_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Title
    3 DESCRLONG Long Character CLOB Long Description
    4 GDP_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Guided Process Active Flag
    N=Inactive
    Y=Active
    5 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    6 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    7 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW

    8 GDP_INST_METHOD Character(30) VARCHAR2(30) NOT NULL Guided Process Create Instance Method
    9 GDP_PREPROC_METH Character(30) VARCHAR2(30) NOT NULL Guided Process Pre Process Method
    10 GDP_DISP_QUESTS Character(1) VARCHAR2(1) NOT NULL Guided Process Display Questions Indicator

    Y/N Table Edit

    Default Value: N

    11 GDP_PB_VISIBLE Character(1) VARCHAR2(1) NOT NULL Guided Process Task Progress Bar Visible indicator
    N=No
    Y=Yes

    Default Value: N

    12 GDP_LIST_ID Character(31) VARCHAR2(31) NOT NULL Guided Process List ID (PTAI List ID assigned to Guided Process Template)

    Default Value: NEW

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

    Default Value: N

    14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier