PTSF_INSROLE_VW

(SQL View)
 Index Back

Insight Roles View


SELECT A.PTSF_DBOARD_NAME , A.ROLENAME , A.PTSF_DB_PREVILEGE FROM PS_PTSF_KIB_ROLE A UNION SELECT B.PTSF_DBOARD_NAME , 'Search Administrator' , 'E' FROM PS_PTSF_DBOARD_DTL B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSF_DBOARD_NAME Character(100) VARCHAR2(100) NOT NULL Dashboard Name
2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
3 PTSF_DB_PREVILEGE Character(1) VARCHAR2(1) NOT NULL Privilege
E=Edit
V=View