AGC_CAT_STEPBTN

(SQL Table)
Index Back

AGC Category Step Button

Activity Guide Composer Category Step Button Table - This table stores additiional buttons and/or override buttons for a step.

  • Related Language Record: AGC_CAT_STEPBTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 AGC_STEP_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Step Id
    4 AGC_BUTTON_METHOD Character(32) VARCHAR2(32) NOT NULL Activity Guide Composer Button Method
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

    8 AGC_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Active Flag
    N=No
    Y=Yes

    Default Value: N

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

    Default Value: N