RE_OPRID_UPD (SQL View)	Index Back
Lease Administration Roles This view fetchs the Lease Administration Roles

RE_OPRID_UPD

(SQL View)

Lease Administration Roles

This view fetchs the Lease Administration Roles

SELECT B.PARTY_KEY , A.OPRID , A.OPRDEFNDESC FROM PSOPRDEFN A , PS_RE_INT_PARTY B WHERE A.OPRID NOT IN ( SELECT C.OPRID FROM PS_RE_INT_PARTY C WHERE C.OPRID <> B.OPRID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
Default Value: 0

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PARTY_KEY	Number(10,0)	DECIMAL(10) NOT NULL	Party Key Default Value: 0
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user