AGC_TILE_TBL

(SQL Table)
 Index Back

AGC Tile Table

Activity Guide Composer Tile Table - This table stores attributes for the activity guide composer tiles. The activity guide tile will start an activity guide or take the user to a landing page displaying controls that enable the user to access and manage their activity guide.

  • Related Language Record: AGC_TILE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_TILE_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Tile Id
    2 AGC_TILE_TITLE Character(30) VARCHAR2(30) NOT NULL Activity Guide Tile Title
    3 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL

    4 AGC_IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Image Name
    5 AGC_START_AG Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Tile - Start Activity Guide indicator
    N=No
    Y=Yes

    Default Value: N

    6 AGC_VIEW_AG Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Tile - View Activity Guides indicator
    N=No
    Y=Yes

    Default Value: Y

    7 AGC_DELETE_AG Character(1) VARCHAR2(1) NOT NULL Activity Guide Composer Tile - Delete Activity Guide Indicator
    N=No
    Y=Yes

    Default Value: N

    8 AGC_MAX_AG Number(3,0) SMALLINT NOT NULL Activity Guide Composer Tile - Max Activity Guides In Progress
    9 AGC_START_PACKAGE Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Start Application Package

    Prompt Table: PSPACKAGROOT_VW

    10 AGC_START_PATH Character(127) VARCHAR2(127) NOT NULL Activity Guide Composer Tile - Application Package Start Path

    Prompt Table: AGC_STRTPATH_VW

    11 AGC_START_CLASS Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer Tile - Application Package Start Class

    Prompt Table: AGC_STRTCLS_VW

    12 AGC_START_METHOD Character(32) VARCHAR2(32) NOT NULL Activity Guide Composer Tile - Application Package Start Method
    13 AGC_TMA_ID Character(20) VARCHAR2(20) NOT NULL Activity Guide Composer Template Assignement Id

    Prompt Table: AGC_TMA_VW

    14 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    15 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N