PSCDBINSTALL(SQL Table) |
Index Back |
|---|---|
Dashboard InstallationThis is the record for the Dashboard installation table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PT_CDB_ADM_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
This is the Dashboard Administrator Role field.
Prompt Table: PSROLEDEFN |
| 2 | PT_CDB_IMP_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
This is the field for the Dashboard Implementer role.
Prompt Table: PSROLEDEFN |
| 3 | PT_CDB_USR_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
This is the field for the Dashboard User Role.
Prompt Table: PSROLEDEFN |
| 4 | PT_CDB_DEF_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL |
Dashboard default currency code.
Prompt Table:
CURRENCY_CD_TBL
|
| 5 | PT_CDB_MAX_MSG_LN | Number(8,0) | INTEGER NOT NULL | This is the Dashboard change notification maximum message size in bytes. |
| 6 | 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 |
| 7 | 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. |
| 8 | PT_CDB_MSGPRC_TI | Number(3,0) | SMALLINT NOT NULL | Maximum Inactivity Time for the Dashboard Messaging background process. |
| 9 | PT_CDB_CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Dashboard default Currency Rate Type |
| 10 | 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. |
| 11 | 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 Value: N |
| 12 | 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 Value: Y |
| 13 | PT_CDB_PARALLEL | Character(1) | VARCHAR2(1) NOT NULL |
Dashboard Parallel Processing Enabled Flag.
Y/N Table Edit Default Value: N |
| 14 | 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 |
| 15 | PT_CDB_SYSD_APP01 | Character(1) | VARCHAR2(1) NOT NULL |
Core
N=No S=Sample Data Y=Yes Default Value: N |
| 16 | PT_CDB_SYSD_APP02 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application02
N=No S=Sample Data Y=Yes Default Value: N |
| 17 | PT_CDB_SYSD_APP03 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application03
N=No S=Sample Data Y=Yes Default Value: N |
| 18 | PT_CDB_SYSD_APP04 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application04
N=No S=Sample Data Y=Yes Default Value: N |
| 19 | PT_CDB_SYSD_APP05 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application05
N=No S=Sample Data Y=Yes Default Value: N |
| 20 | PT_CDB_SYSD_APP06 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application06
N=No S=Sample Data Y=Yes Default Value: N |
| 21 | PT_CDB_SYSD_APP07 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application07
N=No S=Sample Data Y=Yes Default Value: N |
| 22 | PT_CDB_SYSD_APP08 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application08
N=No S=Sample Data Y=Yes Default Value: N |
| 23 | PT_CDB_SYSD_APP09 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application09
N=No S=Sample Data Y=Yes Default Value: N |
| 24 | PT_CDB_SYSD_APP10 | Character(1) | VARCHAR2(1) NOT NULL |
Used in Application 10
N=No S=Sample Data Y=Yes Default Value: N |
| 25 | PT_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 26 | PT_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 27 | PT_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Last Modified |
| 28 | PT_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Modified by |