PV_REQ_OPER

(SQL View)
Index Back

Req Operator View

Req Operator View

SELECT DISTINCT A.OPRID , B.ROLEUSER FROM PS_ROLEXLATOPR A , PSROLEUSER B WHERE A.ROLEUSER = B.ROLEUSER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Default Value: OPR_DEF_TBL_PM.REQUESTOR_ID

Prompt Table: %EDITTABLE16