PSUSERPRSNLOPTN (SQL Table)	Index Back
User Personalizations

PSUSERPRSNLOPTN

(SQL Table)

User Personalizations

Parent record: PSOPRDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN

2 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

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

4 USER_OPTION_CNTL Character(1) VARCHAR2(1) NOT NULL Determines if an user personalization option is being enabled. It is set at the administer level and may be utilized at the user level if administrator allows it.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN
2	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
3	USEROPTN	Character(12)	VARCHAR2(12) NOT NULL	User Option
4	USER_OPTION_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Determines if an user personalization option is being enabled. It is set at the administer level and may be utilized at the user level if administrator allows it.
5	USER_OPTION_VALUE	Character(30)	VARCHAR2(30) NOT NULL	User personalization option override value.