PSCDBOBJCLASS

index back

Object to App Class map

This table maps a transaction options to an app class in order to message the transactions contents to an external system.

PeopleSoft Field Name Field Type Column Type Description
PT_CDB_OBJTYPE_ID Character(31) VARCHAR2(31) NOT NULL This object type is the ID for the data that is sent through the messaging framework. This usually, but not necessarily, is equivalent to a database record.
PT_CDB_OBJ_SEQ_NBR Number(4,0) SMALLINT NOT NULL Object sequence number for dashboard objects.
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.

Prompt Table: PSCDBAPPCODE

PT_CDB_APP_CLASS Character(187) VARCHAR2(187) NOT NULL Application Class Path for Dashboard Action Setup
PT_CDB_INCLUDE Character(1) VARCHAR2(1) NOT NULL Y/N flag to indicate whether or not this row should be included in the build.

Y/N Table Edit

Default: Y

PT_CDB_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer

Default: 2

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

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

Default: N

PT_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
PT_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
PT_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Last Modified
PT_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Modified by
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19