CONTACT_USER_VW (SQL View)	Index Back
Contact/User realationship vw This view is a join of PSOPRDEFN, PSOPRALIAS, PS_CONTACT. With this view you could pull in all the users that are associated to contacts.

CONTACT_USER_VW

(SQL View)

Contact/User realationship vw

This view is a join of PSOPRDEFN, PSOPRALIAS, PS_CONTACT. With this view you could pull in all the users that are associated to contacts.

SELECT oprdef.OPRID , oprals.SETID , oprals.CONTACT_ID , cnt.NAME1 FROM psoprdefn oprdef , PSOPRALIAS oprals , ps_contact cnt WHERE oprdef.oprid = oprals.oprid AND oprals.opraliastype = 'CNT' AND oprals.SETID = cnt.SETID AND oprals.CONTACT_ID = cnt.CONTACT_ID

Related Language Record: CONTACT_USER_LN

# 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: CONTACT_USER_VW

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: CONTACT_USER_VW

3 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: CONTACT_USER_VW

4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	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: CONTACT_USER_VW
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: CONTACT_USER_VW
3	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: CONTACT_USER_VW
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1