PSCDBACTSEC

index back

Action Definition Security

The Dashboard Action Definition Security page is used to secure actions by User ID.

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.
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PTCDBRLDFN_VW

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