EOPCMAIN_FLD_VW(SQL View) |
Index Back |
|---|
| SELECT A.EOPCSOURCE_CD , A.EOPCDEFN_ID , B.EOPCMAIN_ID , B.DISP_OBJ_TYPE , B.DISP_OBJ_NAME , C.EOPCMAIN_FIELDS_ID , B.EOPCFORM_LG , B.EOPCFORM_MED , B.EOPCFORM_SM , B.EOPCFORM_XLG , C.FIELDNAME , C.EOPCKEYVALUE , C.EOPCMAIN_FIELD_HSH , C.EOPCPRIMARY , C.EOPCXREF_RECNAME FROM 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCSOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL | EOPC Source Code |
| 2 | EOPCDEFN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 3 | EOPCMAIN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 4 | DISP_OBJ_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
EOPC Display Object Type - main display
E=Email HT=Stand-Alone HTML P=Page |
| 5 | DISP_OBJ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Display Object Name |
| 6 | EOPCMAIN_FIELDS_ID | Character(20) | VARCHAR2(20) NOT NULL | Composition Field ID |
| 7 | EOPCFORM_LG | Character(1) | VARCHAR2(1) NOT NULL | Large |
| 8 | EOPCFORM_MED | Character(1) | VARCHAR2(1) NOT NULL | Medium |
| 9 | EOPCFORM_SM | Character(1) | VARCHAR2(1) NOT NULL | Small |
| 10 | EOPCFORM_XLG | Character(1) | VARCHAR2(1) NOT NULL | X-Large |
| 11 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 12 | EOPCKEYVALUE | Character(100) | VARCHAR2(100) NOT NULL | EOPC Key Value |
| 13 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
| 14 | EOPCPRIMARY | Character(1) | VARCHAR2(1) NOT NULL | Primary |
| 15 | EOPCXREF_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Cross-Reference Recname |