PSUSEROBJTYPE

(SQL Table)
Index Back

Format for persistible object

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
6 OBJNAME Character(30) VARCHAR2(30) NOT NULL Setting Name
7 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

Default Value: U

8 PTCUSTOMFORMAT Long Character CLOB Personalization Custom Format