WV_USR_MGMT_VW5

(SQL View)
Index Back

supplier user mgmt vw 5

5/1/2004 cel

SELECT 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 FROM PS_VENDOR_USER A , PSOPRDEFN B WHERE A.OPRID = B.OPRID

# 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