PSCDBAPPCODE

(SQL Table)
 Index Back

Installed Application Code

Installed Dashboard Application Codes

  • Related Language Record: PSCDBAPPCDLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PT_CDB_APP_CODE Character(4) VARCHAR2(4) NOT NULL Code of the application message to the dashboard. This may be used by the messaging framework as a mechanism to distribute messages to a JMS server.
    2 PT_CDB_DATA_DESCR Character(30) VARCHAR2(30) NOT NULL This is the databoard data object name, which is equivalent to a record name in a PS application.
    3 PT_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    4 PT_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    5 PT_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Last Modified
    6 PT_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Modified by
    7 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

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N