PSCDBACTION

(SQL Table)
 Index Back

Action Definition

Dashboard Action Definitions. It is used to define an action.

  • Related Language Record: PSCDBACTLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PT_CDB_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Dashboard Action ID field. It is a field of the RBD_ACTION record.
    2 PT_CDB_ACTION_NAME Character(50) VARCHAR2(50) NOT NULL Dashboard Action Name. It is part of RBD_ACTION record.
    3 PT_CDB_ACT_DESCR Character(254) VARCHAR2(254) NOT NULL Dashboard Action Description. Dashboard Action Parameter Name. It is part of RBD_ACTION record.
    4 PT_CDB_APP_CLASS Character(187) VARCHAR2(187) NOT NULL Application Class Path for Dashboard Action Setup
    5 PT_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    6 PT_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    7 PT_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Last Modified
    8 PT_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Modified by
    9 PT_CDB_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    10 PT_CDB_SYSD_APP01 Character(1) VARCHAR2(1) NOT NULL Core
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    11 PT_CDB_SYSD_APP02 Character(1) VARCHAR2(1) NOT NULL Used in Application02
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    12 PT_CDB_SYSD_APP03 Character(1) VARCHAR2(1) NOT NULL Used in Application03
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    13 PT_CDB_SYSD_APP04 Character(1) VARCHAR2(1) NOT NULL Used in Application04
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    14 PT_CDB_SYSD_APP05 Character(1) VARCHAR2(1) NOT NULL Used in Application05
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    15 PT_CDB_SYSD_APP06 Character(1) VARCHAR2(1) NOT NULL Used in Application06
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    16 PT_CDB_SYSD_APP07 Character(1) VARCHAR2(1) NOT NULL Used in Application07
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    17 PT_CDB_SYSD_APP08 Character(1) VARCHAR2(1) NOT NULL Used in Application08
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    18 PT_CDB_SYSD_APP09 Character(1) VARCHAR2(1) NOT NULL Used in Application09
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N

    19 PT_CDB_SYSD_APP10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Default Value: N