EOAW_PCDESC_LNG(SQL View) |
Index Back |
|---|
| SELECT DISTINCT D.LANGUAGE_CD , B.DISP_OBJ_NAME , OBJ.EOPCOBJECT_NAME , B.EOPCMAIN_FIELD_HSH , B.EOPCFORM_LG , B.EOPCFORM_MED , B.EOPCFORM_SM , B.EOPCFORM_XLG , D.DESCR254 FROM PS_EOPC_OBJECT OBJ , PS_EOPCMAIN_LNG D , PS_EOPCMAIN_FIELDS C , PS_EOPCMAIN_DISP B WHERE B.EOPCMAIN_ID = C.EOPCMAIN_ID AND B.EOPCMAIN_ID = D.EOPCMAIN_ID AND OBJ.EOPCOBJECT_ID = B.EOPCOBJ_PF_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 2 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
| 5 | EOPCFORM_LG | Character(1) | VARCHAR2(1) NOT NULL | Large |
| 6 | EOPCFORM_MED | Character(1) | VARCHAR2(1) NOT NULL | Medium |
| 7 | EOPCFORM_SM | Character(1) | VARCHAR2(1) NOT NULL | Small |
| 8 | EOPCFORM_XLG | Character(1) | VARCHAR2(1) NOT NULL | X-Large |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |