PSAAUTHUSERS_VW

index back

PSAAUTHUSERS_VW

List of Active Authorized User
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 = 'U' AND B.ACTIVE_FLAG ='A'

PeopleSoft Field NameField TypeColumn TypeDescription
USERID_ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table

Prompt Table: %EDITTABLE

DIGITAL_IDCharacter(30)VARCHAR2(30) NOT NULLDIGITAL_ID
SIGNER_IDCharacter(50)VARCHAR2(50) NOT NULLSIGNER_ID
ATTACHSYSFILENAMECharacter(128)VARCHAR2(128) NOT NULLUnique Sys Filename
ATTACHUSERFILECharacter(64)VARCHAR2(64) NOT NULLAttached File
KEYSTORE_PSWDCharacter(254)VARCHAR2(254) NOT NULLKEYSTORE_PSWD
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19