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 Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW2

OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20