DIGITAL_IDSEQ_NBRR=Role
U=User ID
Default Value: U
Prompt Table: %EDITTABLE
PSCERTAUTH(SQL Table) |
Index Back |
|---|---|
PSCERTAUTHThis table is used to determined who can access on the external file. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DIGITAL_ID |
Character(30) | VARCHAR2(30) NOT NULL | DIGITAL_ID |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | AUTH_BY | Character(1) | VARCHAR2(1) NOT NULL |
U = User ID Field is enabled, R = Rolename Field is enabled.
R=Role U=User ID Default Value: U |
| 4 | USERID_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table: %EDITTABLE |