OI_USER_VW

(SQL View)
 Index Back

Created By User

Primary record for Created By User

SELECT OD.OPRID , OD.OPRDEFNDESC , OD.EMPLID , PD.NAME , PD.NAME_TITLE , PD.FIRST_NAME , PD.MIDDLE_NAME , PD.LAST_NAME , OD.EMAILID , OD.LANGUAGE_CD , OD.MULTILANG , OD.CURRENCY_CD , OD.OPRTYPE , OD.USERIDALIAS , OD.LASTSIGNONDTTM FROM PSOPRDEFN OD LEFT OUTER JOIN PS_PERSONAL_DATA PD ON OD.EMPLID=PD.EMPLID UNION SELECT ' ' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , 0 , '-' , 0 , '-' , %DateTimeIn('9999-12-31-12.00.00.000000') FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
11 MULTILANG Number(1,0) SMALLINT NOT NULL Used to determine if user is Multi-Lingual
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 OPRTYPE Number(1,0) SMALLINT NOT NULL Operator Type
14 USERIDALIAS Character(70) VARCHAR2(70) NOT NULL User ID Alias
15 LASTSIGNONDTTM DateTime(26) TIMESTAMP Last Signon Date