WV_USR_MGMT_VW6

(SQL View)
Index Back

supplier user mgmt vw6

5/1/2004 cel

SELECT DISTINCT A.SETID , A.VENDOR_ID , A.OPRID , B.LASTSIGNONDTTM , A.CREATED_DTTM , (CASE WHEN B.PTACCTLOCKDATE IS NULL THEN B.ACCTLOCK WHEN B.PTACCTLOCKDATE <= %CurrentDateIn THEN 1 ELSE B.ACCTLOCK END ) ACCTLOCK , C.ROLENAME , G.PNLGRPNAME FROM PS_VENDOR_USER A , PSOPRDEFN B , PSROLEUSER C , PSROLECLASS D , PSAUTHITEM E , PSMENUITEM F , PSPNLGRPDEFN G WHERE A.OPRID = B.OPRID AND A.OPRID = C.ROLEUSER AND C.ROLENAME = D.ROLENAME AND D.CLASSID = E.CLASSID AND E.MENUNAME = F.MENUNAME AND E.BARITEMNAME = F.ITEMNAME AND F.PNLGRPNAME = G.PNLGRPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 LASTSIGNONDTTM DateTime(26) TIMESTAMP Last Signon Date
5 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
6 ACCTLOCK Number(1,0) SMALLINT NOT NULL To lock out PeopleSoft User Account
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
8 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name