Co-Operative PeopleTools Table Reference

View: PS_OPRID_VW2	Return to Index
OPRID_VW2	Return to Index

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.

Platform View Text
Default SELECT oprid ,oprdefndesc FROM PSOPRDEFN A

Platform	View Text
Default	SELECT oprid ,oprdefndesc FROM PSOPRDEFN A

PeopleSoft Field Name Description
OPRID A user's ID
Prompt Table: OPRID_VW2
OPRDEFNDESC Description field for a user
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
OPRID	A user's ID Prompt Table: OPRID_VW2
OPRDEFNDESC	Description field for a user

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

OPRID_VW2

View: PS_OPRID_VW2