WS_LOGIN_VW (SQL View)	Index Back
eStore - Login View This view is a join of PSOPRDEFN, PSOPRALIAS, PS_CONTACT, PS_CONTACT_CUST. With this view eStore will be able to determine with the user is a valid peoplesoft user and also is a contact that has customers associated.

WS_LOGIN_VW

(SQL View)

eStore - Login View

This view is a join of PSOPRDEFN, PSOPRALIAS, PS_CONTACT, PS_CONTACT_CUST. With this view eStore will be able to determine with the user is a valid peoplesoft user and also is a contact that has customers associated.

SELECT oprals.PERSON_ID , oprdef.OPRID , oprdef.OPERPSWD , oprdef.EMAILID , oprdef.LANGUAGE_CD FROM PSOPRDEFN oprdef , psopralias oprals WHERE oprdef.oprid = oprals.oprid AND oprals.opraliastype = 'PER' AND ACCTLOCK = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

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

3 OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password

4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	OPERPSWD	Character(32)	VARCHAR2(32) NOT NULL	An user's password
4	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code