EOPC_OBJ_PF_VW

(SQL View)
Index Back

Page Composer System Objects

Page Composer System Objects

SELECT EOPCOBJECT_ID , EOPCBUFFER_LEVEL , EOPCOBJECT_TYPE , EOPCOBJECT_NAME , DESCR254 , DESCRSHORT , OWNERID FROM PS_EOPC_OBJECT WHERE EOPCOBJECT_TYPE IN ('PF','C','AT','AC', 'FS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCOBJECT_ID Character(10) VARCHAR2(10) NOT NULL EOPC Object ID
2 EOPCBUFFER_LEVEL Number(2,0) SMALLINT NOT NULL Buffer Level
3 EOPCOBJECT_TYPE Character(2) VARCHAR2(2) NOT NULL Page Composer reserved object types
AA=Application Area
AC=Application Class
AT=Attachment
C=Comment
E1=Email Rich Text HTML
E2=Email HTML Page
HT=HTML Area
PB=Push Button
PC=Tap Chevron
PF=Page Field
PL=Hyperlink
R=Report
RS=Reserved Area
4 EOPCOBJECT_NAME Character(30) VARCHAR2(30) NOT NULL EOPC Object Name
5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 OWNERID Character(8) VARCHAR2(8) NOT NULL SQL Owner ID