PSCDBINSTALL

index back

Dashboard Installation

This is the record for the Dashboard installation table.

PeopleSoft Field NameField TypeColumn TypeDescription
PT_CDB_ADM_ROLECharacter(30)VARCHAR2(30) NOT NULLThis is the Dashboard Administrator Role field.

Prompt Table: PSROLEDEFN

PT_CDB_IMP_ROLECharacter(30)VARCHAR2(30) NOT NULLThis is the field for the Dashboard Implementer role.

Prompt Table: PSROLEDEFN

PT_CDB_USR_ROLECharacter(30)VARCHAR2(30) NOT NULLThis is the field for the Dashboard User Role.

Prompt Table: PSROLEDEFN

PT_CDB_DEF_CUR_CDCharacter(3)VARCHAR2(3) NOT NULLDashboard default currency code.

Prompt Table: CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD

PT_CDB_MAX_MSG_LNNumber(8,0)INTEGER NOT NULLThis is the Dashboard change notification maximum message size in bytes.
PT_CDB_PARM_CHKCharacter(1)VARCHAR2(1) NOT NULLThis is the field for the Dashboard action framework to validate the parameter types.
N=No
Y=Yes

Y/N Table Edit

PT_CDB_XFERPIA_URICharacter(254)VARCHAR2(254) NOT NULLThis is the Dashboard field used to set the URI for the PIA installation that the remote Dashboard should link to.
PT_CDB_MSGPRC_TINumber(3,0)SMALLINT NOT NULLMaximum Inactivity Time for the Dashboard Messaging background process.
PT_CDB_CUR_RT_TYPECharacter(5)VARCHAR2(5) NOT NULLDashboard default Currency Rate Type
PT_CDB_SRC_SYS_IDCharacter(5)VARCHAR2(5) NOT NULLThis is the field to hold the Source System ID for the dashboard messaging.
PT_CDB_DAEMON_FLGCharacter(1)VARCHAR2(1) NOT NULLDaemon 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_MSGCharacter(1)VARCHAR2(1) NOT NULLThe flag is used to indicate whether if the change request can be recorded in the queue.

Y/N Table Edit

Default: Y

PT_CDB_PARALLELCharacter(1)VARCHAR2(1) NOT NULLDashboard Parallel Processing Enabled Flag.

Y/N Table Edit

Default: N

PT_CDB_MAINT_OWNERCharacter(1)VARCHAR2(1) NOT NULLCall center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer

Default: 2

PT_CDB_SYSD_APP01Character(1)VARCHAR2(1) NOT NULLCore
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP02Character(1)VARCHAR2(1) NOT NULLUsed in Application02
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP03Character(1)VARCHAR2(1) NOT NULLUsed in Application03
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP04Character(1)VARCHAR2(1) NOT NULLUsed in Application04
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP05Character(1)VARCHAR2(1) NOT NULLUsed in Application05
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP06Character(1)VARCHAR2(1) NOT NULLUsed in Application06
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP07Character(1)VARCHAR2(1) NOT NULLUsed in Application07
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP08Character(1)VARCHAR2(1) NOT NULLUsed in Application08
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP09Character(1)VARCHAR2(1) NOT NULLUsed in Application09
N=No
S=Sample Data
Y=Yes

Default: N

PT_CDB_SYSD_APP10Character(1)VARCHAR2(1) NOT NULLUsed in Application 10
N=No
S=Sample Data
Y=Yes

Default: N

PT_ROW_ADDED_DTTMDateTime(26)TIMESTAMPDatetime Added
PT_ROW_ADDED_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAdded By
PT_ROW_MAINT_DTTMDateTime(26)TIMESTAMPLast Modified
PT_ROW_MAINT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLLast Modified by
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19