PSPTLOGINAUDIT

index back

PeopleSoft Field Name Field Type Column Type Description
PT_AUTH_TYPE Character(2) VARCHAR2(2) NOT NULL PeopleTools Authentication Type
00=Token Authentication
01=Database Authentication
02=Signon Pcode Authentication
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PTSIGNONID Character(70) VARCHAR2(70) NOT NULL PeopleTools Signon ID. The ID used in the login page, not necessarily OPRID.
PT_SIGNON_STATUS Character(1) VARCHAR2(1) NOT NULL PeopleTools Signon Status
0=Success
1=Failure
FAILEDLOGINS Number(3,0) SMALLINT NOT NULL Failed Login Attempts
LASTSIGNONDTTM DateTime(26) TIMESTAMP Last Signon Date
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19