PSCDBINSTALL |
index back |
|---|---|
Dashboard Installation |
| 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
|
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |