EOAW_PCDESCRVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.EOPCSOURCE_CD , A.EOPCAPP_OBJ , B.DISP_OBJ_NAME , OBJ.EOPCOBJECT_NAME , B.EOPCMAIN_FIELD_HSH , B.EOPCFORM_LG , B.EOPCFORM_MED , B.EOPCFORM_SM , B.EOPCFORM_XLG , A.EOPCDEFN_DESCR , B.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 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 | EOPCFORM_LG | Character(1) | VARCHAR2(1) NOT NULL | Large |
| 7 | EOPCFORM_MED | Character(1) | VARCHAR2(1) NOT NULL | Medium |
| 8 | EOPCFORM_SM | Character(1) | VARCHAR2(1) NOT NULL | Small |
| 9 | EOPCFORM_XLG | Character(1) | VARCHAR2(1) NOT NULL | X-Large |
| 10 | EOPCDEFN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | EOPC Definition Description |
| 11 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |