WC_ROLE_RUN

(SQL Table)
Index Back

Dyn Role run control

This 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