PSOPRDEFNVW

index back

SELECT OPRID , VERSION , OPRDEFNDESC , EMPLID , EMAILID , OPRCLASS , ROWSECCLASS , ENCRYPTED , SYMBOLICID , LANGUAGE_CD , MULTILANG , CURRENCY_CD , LASTPSWDCHANGE , ACCTLOCK , PRCSPRFLCLS , DEFAULTNAVHP , FAILEDLOGINS , EXPENT , OPRTYPE , USERIDALIAS , LASTSIGNONDTTM , LASTUPDDTTM , LASTUPDOPRID , PTALLOWSWITCHUSER FROM PSOPRDEFN

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLOperator Class

Prompt Table: PSCLASSDEFN

ROWSECCLASSCharacter(30)VARCHAR2(30) NOT NULLThe class used to determine row level security

Prompt Table: PSCLASSDEFN

ENCRYPTEDNumber(1,0)SMALLINT NOT NULLEncrypted Flag
SYMBOLICIDCharacter(8)VARCHAR2(8) NOT NULLThe foreign key linking the PSOPRDEFN table to PSACCESSPRFL

Prompt Table: PSACCESSPRFL

LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

Default: ENG

MULTILANGNumber(1,0)SMALLINT NOT NULLUsed to determine if user is Multi-Lingual
CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code

Prompt Table: CURRENCY_CD_TBL

LASTPSWDCHANGEDate(10)DATE NOT NULLThe date the user last changed their password

Default: %Date

ACCTLOCKNumber(1,0)SMALLINT NOT NULLTo lock out PeopleSoft User Account
PRCSPRFLCLSCharacter(30)VARCHAR2(30) NOT NULLA class that determines a user's process profile

Prompt Table: PSCLASSDEFN

DEFAULTNAVHPCharacter(30)VARCHAR2(30) NOT NULLDefault Navigator Home Page

Prompt Table: PSCLASSDEFN

FAILEDLOGINSNumber(3,0)SMALLINT NOT NULLFailed Login Attempts
EXPENTNumber(1,0)SMALLINT NOT NULLExpert Entry

Default: 0

OPRTYPENumber(1,0)SMALLINT NOT NULLOperator Type

Default: 0

USERIDALIASCharacter(70)VARCHAR2(70) NOT NULLUser ID Alias
LASTSIGNONDTTMDateTime(26)TIMESTAMPLast Signon Date
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
PTALLOWSWITCHUSERNumber(1,0)SMALLINT NOT NULLAllow Switch User

Default: 0

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19