EOPC_SECTION_VW(SQL View) |
Index Back |
|---|---|
Page Composer System ObjectsPage Composer System Objects |
| SELECT P.PNLNAME , P.DESCR , EOPF.DESCRSHORT , EOPCOBJECT_ID , EOPCOBJECT_TYPE , EOPCOBJECT_NAME , DESCR254 , OWNERID , PF.PNLFLDID , PF.FIELDNUM FROM PS_EOPC_OBJ_PF_VW EOPF , PSPNLFIELD PF , PSPNLDEFN P WHERE EOPF.EOPCOBJECT_NAME = PF.FIELDNAME AND PF.PNLNAME = P.PNLNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | EOPCOBJECT_ID | Character(10) | VARCHAR2(10) NOT NULL | EOPC Object ID |
| 5 | 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 |
| 6 | EOPCOBJECT_NAME | Character(30) | VARCHAR2(30) NOT NULL | EOPC Object Name |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | OWNERID | Character(8) | VARCHAR2(8) NOT NULL | SQL Owner ID |
| 9 | PNLFLDID | Number(4,0) | SMALLINT NOT NULL | Page Field ID |
| 10 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |