AGC_CAT_CTX

(SQL Table)
 Index Back

AGC Category Context Table

Activity Guide Composer Category Context Table - This table stores the context definition for the activity guide composer category. The context definition consists of a set of fields that provide context to the activity guide composer template. The context key fields defined in this definition are assigned values when an activity guide instance is created and are used to uniquely identify activity guide instances.

  • Related Language Record: AGC_CAT_CTX_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: AGC_CTXREC_VW

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

    Prompt Table: AGC_CTXFLD_VW

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 AGC_CTX_DSPL_ORDER Number(3,0) SMALLINT NOT NULL AGC Context Display Order
    7 AGC_CTX_KEY Character(1) VARCHAR2(1) NOT NULL AGC Context Key

    Y/N Table Edit

    8 AGC_CTX_VALUE Character(254) VARCHAR2(254) NOT NULL AGC Context Value
    9 AGC_CTX_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL AGC Prompt Edit Type
    1=No Table Edit
    2=Prompt Table
    3=Translate Table
    4=Yes/No

    Default Value: 1

    10 AGC_CTX_PROMPT Character(15) VARCHAR2(15) NOT NULL AGC Context Prompt Table

    Prompt Table: AGC_CTXREC_VW

    11 AGC_CTX_PROMPTDESC Character(18) VARCHAR2(18) NOT NULL Activity Guide Composer Context Prompt Description Field

    Prompt Table: AGC_CTXREL_VW

    12 AGC_CTXDTA_ID Character(15) VARCHAR2(15) NOT NULL AGC Contextual Data Id

    Prompt Table: AGC_CTXDTA_TBL

    13 AGC_CTXDTA_FLD_ID Character(3) VARCHAR2(3) NOT NULL AGC Contextual Data Field Id

    Prompt Table: AGC_CTXDTA_FLDS

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

    Default Value: N