OPRID_VW2

(SQL View)
Index Back

View of Opr IDs in PSOPRDEFN

This is a new version of PSOPRDEFN_VW. The OPRDEFNDESCR coloumn has been added as an alternate key field. This SQL view will be used as the prompt table behind PRG_USR_PROFILE.OPRID.

SELECT oprid ,oprdefndesc FROM PSOPRDEFN A

# 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_VW2

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user