OPR_SETID_VW

(SQL View)
Index Back

User Preferences

This is the User record for Common Applications' preferences.

SELECT SETID , OPRID , NAME1 , BUSINESS_UNIT , PERSON_ID FROM PS_OPR_DEF_TBL_RB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_OPRVW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW2

3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_FS_OPRVW

5 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID