WC_ROLE_RUN(SQL Table) |
Index Back |
---|---|
Dyn Role run controlThis is the run control for assigning the roles to the users. It processes all the rolenames defined for the run control. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
3 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: WC_ROLE_HDR |
4 | WC_UNASSIGN_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
Unassign Role
1=Unassign only 2=Unassign and reassign Default Value: 2 |