PSAAUTHROLES_VW

index back

PSAAUTHROLES_VW

List of Active Authorized Role
SELECT A.USERID_ROLENAME , A.DIGITAL_ID , B.SIGNER_ID , B.ATTACHSYSFILENAME ,B.ATTACHUSERFILE , B.KEYSTORE_PSWD FROM PSCERTAUTH A , PSCERTEXTFILE B WHERE A.DIGITAL_ID = B.DIGITAL_ID AND A.AUTH_BY = 'R' AND B.ACTIVE_FLAG ='A'

PeopleSoft Field Name Field Type Column Type Description
USERID_ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table

Prompt Table: %EDITTABLE

DIGITAL_ID Character(30) VARCHAR2(30) NOT NULL DIGITAL_ID
SIGNER_ID Character(50) VARCHAR2(50) NOT NULL SIGNER_ID
ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
KEYSTORE_PSWD Character(254) VARCHAR2(254) NOT NULL KEYSTORE_PSWD
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19