SAE_GROUP_NOSAE_GRP_AUTH_TYPER=Role
U=Userid
SAE_GRP_AUTHUSERIDPrompt Table: SAE_GRP_USER_VW
SAE_GRP_AUTHROLEPrompt Table: SAE_GRP_ROLE_VW
E=Execute
R=Read
W=Write
Default Value: R
SAE_GRP_AUTHS(SQL Table) |
Index Back |
|---|---|
SAE_GRP_AUTHSSAIP Group Authorizations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_GROUP_NO |
Number(6,0) | INTEGER NOT NULL | Group Number identifier |
| 2 | SAE_GRP_AUTH_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
SAIP Group Authorization Type
R=Role U=Userid |
| 3 | SAE_GRP_AUTHUSERID |
Character(30) | VARCHAR2(30) NOT NULL |
SAIP Group Authorization UserID
Prompt Table: SAE_GRP_USER_VW |
| 4 | SAE_GRP_AUTHROLE |
Character(30) | VARCHAR2(30) NOT NULL |
SAIP Group Authorization Role
Prompt Table: SAE_GRP_ROLE_VW |
| 5 | SAE_GRP_AUTH_PERM | Character(1) | VARCHAR2(1) NOT NULL |
Authorized Permission
E=Execute R=Read W=Write Default Value: R |