PSUSEROPTNDEFN (SQL Table)	Index Back
User Personalization Admin Administrator table for setting personalization defaults and determining which options a user may personalize.

PSUSEROPTNDEFN

(SQL Table)

User Personalization Admin

Administrator table for setting personalization defaults and determining which options a user may personalize.

Related Language Record: PSUSEROPTNLANG

Parent record: PSOPTNCATLVL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPTN_CATEGORY_LVL Character(4) VARCHAR2(4) NOT NULL Option Category Level
CRM=Customer Relationship Mgmt
CSTM=Custom
EPM=Enterprise Performance Mgmt
FIN=Financials
HRMS=Human Capital Management
LS=Enterprise Learning Management
PPTL=PeopleTools
SCM=Supply Chain Management

2 USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option

3 OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group
Prompt Table: PSOPTNCATGRPTBL

4 OPTN_CATEGORY Character(12) VARCHAR2(12) NOT NULL Option Category
Prompt Table: PSOPTNCATTBL

5 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 USEROPTN_TYPE Character(1) VARCHAR2(1) NOT NULL User Option Type
1=Restricted
2=User List
3=Locale
F=Functional
S=System

8 LOCALE_BASED Character(1) VARCHAR2(1) NOT NULL Locale Based
Y/N Table Edit
Default Value: N

9 FORMAT_CNTL Character(2) VARCHAR2(2) NOT NULL Format control for personalization option values, e.g., Mixedcase, Upper, or Number Only..
0=Uppercase
6=Mixedcase
8=Numbers Only

10 FORMATLENGTH Number(4,0) SMALLINT NOT NULL Format Length in characters. Except that Images and Attachments in Kb.

11 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: %EDITTABLE

12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

13 USER_OPTION_VALUE Character(30) VARCHAR2(30) NOT NULL User personalization option override value.

14 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN

15 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

16 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.
Prompt Table: CONT_IMAGE_VW

17 IMAGE_FIELD Image Reference(30) VARCHAR2(30) Image Reference Field to display images used in Personalizations explanations.

18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPTN_CATEGORY_LVL	Character(4)	VARCHAR2(4) NOT NULL	Option Category Level CRM=Customer Relationship Mgmt CSTM=Custom EPM=Enterprise Performance Mgmt FIN=Financials HRMS=Human Capital Management LS=Enterprise Learning Management PPTL=PeopleTools SCM=Supply Chain Management
2	USEROPTN	Character(12)	VARCHAR2(12) NOT NULL	User Option
3	OPTN_CATEGORY_GRP	Character(12)	VARCHAR2(12) NOT NULL	Option Category Group Prompt Table: PSOPTNCATGRPTBL
4	OPTN_CATEGORY	Character(12)	VARCHAR2(12) NOT NULL	Option Category Prompt Table: PSOPTNCATTBL
5	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	USEROPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	User Option Type 1=Restricted 2=User List 3=Locale F=Functional S=System
8	LOCALE_BASED	Character(1)	VARCHAR2(1) NOT NULL	Locale Based Y/N Table Edit Default Value: N
9	FORMAT_CNTL	Character(2)	VARCHAR2(2) NOT NULL	Format control for personalization option values, e.g., Mixedcase, Upper, or Number Only.. 0=Uppercase 6=Mixedcase 8=Numbers Only
10	FORMATLENGTH	Number(4,0)	SMALLINT NOT NULL	Format Length in characters. Except that Images and Attachments in Kb.
11	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: %EDITTABLE
12	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
13	USER_OPTION_VALUE	Character(30)	VARCHAR2(30) NOT NULL	User personalization option override value.
14	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGSETDEFN
15	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
16	IMAGE_NAME	Character(30)	VARCHAR2(30) NOT NULL	The name of images used in Personalizations explanations. Prompt Table: CONT_IMAGE_VW
17	IMAGE_FIELD	Image Reference(30)	VARCHAR2(30)	Image Reference Field to display images used in Personalizations explanations.
18	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies 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.
19	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies 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.