PSCDBINSTALL

index back

Dashboard Installation

This is the record for the Dashboard installation table.

PeopleSoft Field Name Field Type Column Type Description
PT_CDB_ADM_ROLE Character(30) VARCHAR2(30) NOT NULL This is the Dashboard Administrator Role field.

Prompt Table: PSROLEDEFN

PT_CDB_IMP_ROLE Character(30) VARCHAR2(30) NOT NULL This is the field for the Dashboard Implementer role.

Prompt Table: PSROLEDEFN

PT_CDB_USR_ROLE Character(30) VARCHAR2(30) NOT NULL This is the field for the Dashboard User Role.

Prompt Table: PSROLEDEFN

PT_CDB_DEF_CUR_CD Character(3) VARCHAR2(3) NOT NULL Dashboard default currency code.

Prompt Table: CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD

PT_CDB_MAX_MSG_LN Number(8,0) INTEGER NOT NULL This is the Dashboard change notification maximum message size in bytes.
PT_CDB_PARM_CHK Character(1) VARCHAR2(1) NOT NULL This is the field for the Dashboard action framework to validate the parameter types.
N=No
Y=Yes

Y/N Table Edit

PT_CDB_XFERPIA_URI Character(254) VARCHAR2(254) NOT NULL This is the Dashboard field used to set the URI for the PIA installation that the remote Dashboard should link to.
PT_CDB_MSGPRC_TI Number(3,0) SMALLINT NOT NULL Maximum Inactivity Time for the Dashboard Messaging background process.
PT_CDB_CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Dashboard default Currency Rate Type
PT_CDB_SRC_SYS_ID Character(5) VARCHAR2(5) NOT NULL This is the field to hold the Source System ID for the dashboard messaging.
PT_CDB_DAEMON_FLG Character(1) VARCHAR2(1) NOT NULL Daemon Process flag that is used to control the messaging dameon process whether if it should process the message change queue.

Y/N Table Edit

Default: N

PT_CDB_LIMIT_Q_MSG Character(1) VARCHAR2(1) NOT NULL The flag is used to indicate whether if the change request can be recorded in the queue.

Y/N Table Edit

Default: Y

PT_CDB_PARALLEL Character(1) VARCHAR2(1) NOT NULL Dashboard Parallel Processing Enabled Flag.

Y/N Table Edit

Default: N

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