PSDSUSERATTR_VW (SQL View)	Index Back
Directory Services User Attr User Attribute view

PSDSUSERATTR_VW

(SQL View)

Directory Services User Attr

User Attribute view

SELECT DISTINCT BCITEMNAME FROM PSBCITEM WHERE BCNAME = 'USER_PROFILE' AND FIELDNAME IN ('CURRENCY_CD', 'DEFAULTNAVHP', 'EMAILID', 'EMPLID', 'MULTILANG', 'OPRCLASS', 'OPRDEFNDESC', 'PRCSPRFLCLS', 'ROWSECCLASS', 'SYMBOLICID', 'USERIDALIAS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USRPROFILEPROPERTY Character(30) VARCHAR2(30) NOT NULL User Profile Property