PSCDBACTPARM

index back

Action Parameters

Dashboard Action Parameter Setup Table.

PeopleSoft Field Name Field Type Column Type Description
PT_CDB_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Dashboard Action ID field. It is a field of the RBD_ACTION record.
PT_CDB_PARM_NAME Character(30) VARCHAR2(30) NOT NULL Dashboard Action Parameter Name. It is part of RBD_ACT_PARM record.
PT_CDB_REQUIRE_FLG Character(1) VARCHAR2(1) NOT NULL Dashboard Action Parameter Required Flag.

Y/N Table Edit

PT_CDB_PARM_TYPE Character(2) VARCHAR2(2) NOT NULL Dashboard Action Parameter Data Type.
DD=Date
DT=DateTime
NR=Number
SR=String
TT=Time
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
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

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19