PSAAUTHROLES_VW(SQL View) |
Index Back |
|---|---|
PSAAUTHROLES_VWList 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table: %EDITTABLE |
| 2 | DIGITAL_ID | Character(30) | VARCHAR2(30) NOT NULL | DIGITAL_ID |
| 3 | SIGNER_ID | Character(50) | VARCHAR2(50) NOT NULL | SIGNER_ID |
| 4 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 5 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 6 | KEYSTORE_PSWD | Character(254) | VARCHAR2(254) NOT NULL | KEYSTORE_PSWD |