PSPTLOGINAUDIT

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PT_AUTH_TYPECharacter(2)VARCHAR2(2) NOT NULLPeopleTools Authentication Type
00=Token Authentication
01=Database Authentication
02=Signon Pcode Authentication
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PTSIGNONIDCharacter(70)VARCHAR2(70) NOT NULLPeopleTools Signon ID. The ID used in the login page, not necessarily OPRID.
PT_SIGNON_STATUSCharacter(1)VARCHAR2(1) NOT NULLPeopleTools Signon Status
0=Success
1=Failure
FAILEDLOGINSNumber(3,0)SMALLINT NOT NULLFailed Login Attempts
LASTSIGNONDTTMDateTime(26)TIMESTAMPLast Signon Date
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19