DISP_OBJ_NAMEEOPCOBJECT_IDEOPCPANEL_OB2VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT D.DISP_OBJ_NAME , O.EOPCOBJECT_ID , O.EOPCOBJECT_NAME FROM PS_EOPC_OBJECT O , PS_EOPCMAIN_DISP D WHERE O.EOPCOBJECT_ID = D.EOPCOBJ_PF_ID AND D.DISP_OBJ_TYPE = 'P' AND O.EOPCOBJECT_TYPE IN ('PF','AA','AC','C','PB') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_OBJ_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Page |
| 2 | EOPCOBJECT_ID |
Character(10) | VARCHAR2(10) NOT NULL | EOPC Object ID |
| 3 | EOPCOBJECT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Page Field |