AGC_TMPL_STEPS

(SQL Table)
 Index Back

AGC Template Steps Table

Activity Guide Composer Template Step Table - This table contains the steps for the activity guide composer template. This table stores attributes that the functional user can specify.

  • Related Language Record: AGC_TMPL_STEPSL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 AGC_ACTION_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer Action Item Id
    4 AGC_STEP_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Step Id
    5 AGC_STEP_SEQ Number(4,0) SMALLINT NOT NULL Activity Guide Step Sequence Number
    6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    7 AGC_STEP_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Guide Composer Step Type
    0001=Step
    0002=Group Step
    0003=Sub Step

    Default Value: 0001

    8 AGC_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer Parent Action
    9 AGC_REQUIRED Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Required Indicator
    N=No
    Y=Yes

    Default Value: N

    10 AGC_DISABLE_AWE Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Disable AWE Integration
    N=No
    Y=Yes

    Default Value: N

    11 AGC_START_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Start Date Option
    0=None
    1=Current Date
    2=Date Field

    Default Value: 0

    12 AGC_START_CTXD_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Componser Start Contextual Data Id
    13 AGC_START_CTXDF_ID Character(3) VARCHAR2(3) NOT NULL Activity Guide Composer Start Contextual Field Id
    14 AGC_DUE_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Due Date Option
    0=None
    1=Start Date
    2=Date Field

    Default Value: 0

    15 AGC_DUE_CTXD_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Due Date Contextual Data Id
    16 AGC_DUE_CTXDF_ID Character(3) VARCHAR2(3) NOT NULL Activity Guide Composer Due Date Contextual Field Id
    17 AGC_DUE_ADD_DAYS Number(3,0) SMALLINT NOT NULL Activity Guide Composer Add Days To Due Date
    18 AGC_INACTIVATEAFTD Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Inactivate After Due Date
    N=No
    Y=Yes

    Default Value: N

    19 AGC_LOCKAFTCOMPLET Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Lock Step After Complete
    N=No
    Y=Yes

    Default Value: N

    20 AGC_QUESTION Character(150) VARCHAR2(150) NOT NULL Activity Guide Composer Question
    21 AGC_PAGE_TEXT Long Character CLOB Activity Guide Composer Page Text
    22 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N