EOPCSOURCE_CDCOMPONENT_IDPNLNAMELANGUAGE_CDEOPCPNL_DESCLNG(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.EOPCSOURCE_CD , A.EOPCAPP_OBJ , B.DISP_OBJ_NAME , D.LANGUAGE_CD , OBJ.EOPCOBJECT_NAME , B.EOPCMAIN_FIELD_HSH , E.EOPCDEFN_DESCR , D.DESCR254 , D.EOPCMAIN_DESCR , D.EOPCMAIN_DESCR254 FROM PS_EOPC_DEFN_LNG E , PS_EOPCMAIN_LNG D , 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 D.EOPCMAIN_ID = B.EOPCMAIN_ID AND E.EOPCDEFN_ID = A.EOPCDEFN_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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
| 7 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | EOPCMAIN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Page Description |
| 10 | EOPCMAIN_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Page Description |