AUC_OPRDEFN

(SQL Table)
Index Back

Operator Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
3 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
4 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
5 OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password
6 SYMBOLICID Character(8) VARCHAR2(8) NOT NULL The foreign key linking the PSOPRDEFN table to PSACCESSPRFL

Prompt Table: PSACCESSPRFL

7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: PSOPTIONS.LANGUAGE_CD

8 MULTILANG Number(1,0) SMALLINT NOT NULL Used to determine if user is Multi-Lingual
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 ACCTLOCK Number(1,0) SMALLINT NOT NULL To lock out PeopleSoft User Account
11 PRCSPRFLCLS Character(30) VARCHAR2(30) NOT NULL A class that determines a user's process profile
12 DEFAULTNAVHP Character(30) VARCHAR2(30) NOT NULL Default Navigator Home Page