AGC_CAT_STEP

(SQL Table)
 Index Back

AGC Category Step Table

Activity Guide Composer Category Step Table - This table stores the technical attributes of a steps for an activity guide category. Steps are selected and configured when definining an activity guide template.

  • Related Language Record: AGC_CAT_STEPLNG

    • # 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 DESCRLONG Long Character CLOB NOT NULL Long Description
    6 AGC_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Service Type
    A=Application Class
    C=PS Component
    M=Manual
    N=Non PeopleSoft URL
    Q=PS Query
    S=PS Script
    7 AGC_SERVICE_ID Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Related Content Service Id

    Prompt Table: AGC_SVSTYPE_DVW

    8 AGC_ISFLUID Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Is Fluid indicator

    Y/N Table Edit

    9 AGC_REQUIRED Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Required Indicator
    N=No
    Y=Yes

    Default Value: N

    10 AGC_STEP_PACKAGE Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Step Application Package

    Prompt Table: PSPACKAGROOT_VW

    11 AGC_STEP_PATH Character(127) VARCHAR2(127) NOT NULL Activity Guide Composer Step Application Path

    Prompt Table: AGC_STEPPATH_VW

    12 AGC_STEP_CLASS Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Step Class

    Prompt Table: AGC_STEPCLS_VW

    13 AGC_STEP_PREMETHOD Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Pre Process Method
    14 AGC_STEP_PSTMETHOD Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Post Process Method
    15 AGC_AWE_PROCESS_ID Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer AWE Process Id
    16 AGC_AWE_PACKAGE Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer AWE Application Package

    Prompt Table: PSPACKAGROOT_VW

    17 AGC_AWE_PATH Character(127) VARCHAR2(127) NOT NULL Activity Guide Composer AWE Path

    Prompt Table: AGC_AWEPATH_VW

    18 AGC_AWE_CLASS Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer AWE Class

    Prompt Table: AGC_AWECLS_VW

    19 AGC_AWE_APPROVAL Character(32) VARCHAR2(32) NOT NULL Activity Guide Composer AWE On Approval Method
    20 AGC_AWE_DENIAL Character(32) VARCHAR2(32) NOT NULL Activity Guide Composer AWE Denial
    21 AGC_PG_TEXT_ENABLE Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Page Text Enabled
    N=No
    Y=Yes

    Default Value: N

    22 AGC_DATA_FLD1 Character(100) VARCHAR2(100) NOT NULL Activity Guide Composer Data Field 1
    23 AGC_DATA_FLD2 Character(100) VARCHAR2(100) NOT NULL Activity Guide Composer Data Field 2
    24 AGC_DATA_FLD3 Character(100) VARCHAR2(100) NOT NULL Activity Guide Composer Data Field 3
    25 AGC_DATA_FLD4 Character(100) VARCHAR2(100) NOT NULL Activity Guide Data Field 4
    26 AGC_DATA_FLD5 Character(100) VARCHAR2(100) NOT NULL Activity Guide Composer Data Field 5
    27 AGC_DATA_FLD6 Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Data Field 6 (Yes/No)
    28 AGC_DATA_FLD7 Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Data Field 7 (Yes/No)
    29 AGC_DATA_FLD8 Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Data Field 8 (Yes/No)
    30 AGC_DATA_FLD9 Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Data Field 9 (Yes/No)
    31 AGC_DATA_FLD10 Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Data Field 10 (Yes/No)
    32 AGC_SMRY_ENBLE_BTN Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Enable Summary Button
    N=No
    Y=Yes

    Default Value: N

    33 AGC_SMRY_BTN_LBL Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Summary Button Label
    34 AGC_VIDEO_URL Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Video URL

    Prompt Table: PSURLDEFN

    35 AGC_VIDEO_TRNSCRPT Long Character CLOB Activity Guide Composer Video Transcript
    36 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N