EOPCSOURCE_CDCOMPONENT_IDPNLNAMEEOPCPNL_DESCRVW(SQL View) |
Index Back |
|---|---|
EOPCPNL_DESCRVWEOPCPNL_DESCRVE |
| SELECT DISTINCT A.EOPCSOURCE_CD , A.EOPCAPP_OBJ , B.DISP_OBJ_NAME , OBJ.EOPCOBJECT_NAME , B.EOPCMAIN_FIELD_HSH , A.EOPCDEFN_DESCR , B.DESCR254 , B.EOPCMAIN_DESCR , B.EOPCMAIN_DESCR254 FROM PS_EOPC_OBJECT OBJ , PS_EOPCMAIN_FIELDS C , PS_EOPCMAIN_DISP B , PS_EOPC_DEFN A WHERE B.EOPCDEFN_ID = A.EOPCDEFN_ID AND C.EOPCMAIN_ID = B.EOPCMAIN_ID AND C.EOPCPRIMARY = 'Y' AND OBJ.EOPCOBJECT_ID = B.EOPCOBJ_PF_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCSOURCE_CD |
Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
| 2 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 3 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
| 6 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | EOPCMAIN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Page Description |
| 9 | EOPCMAIN_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Page Description |