PSAAUTHROLES_VW |
index back |
|---|---|
PSAAUTHROLES_VW |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |