L=Long Name
M=Message Catalog
S=Short Name
T=Text
EOPCMAIN_IDEOPC_MNCOLVW(SQL View) |
Index Back |
|---|---|
EOPCR_MNDISP_VWEOPCR_MNDISP_VW |
| SELECT B.EOPCDEFN_ID , B.EOPCMAIN_FIELD_HSH , C.RECNAME , C.FIELDNAME , C.EOPCLABEL_TYPE_ALL , C.LABEL_ID , C.EOPCLBL_MSGSET , C.EOPCLBL_MSGNBR , A.EOPCMAIN_ID , A.EOPCBIND_IDX , A.EOPC_ISROWHEADER , A.EOPCALT_LABEL , A.HTMLDISPLAY FROM PS_EOPC_FORMAT A LEFT OUTER JOIN PS_EOPC_FIELD C ON ( A.EOPCMAIN_ID = C.EOPCMAIN_ID AND A.EOPCFORMAT_ID = C.EOPCFORMAT_ID AND C.EOPC_ISLABEL = 'Y') , PS_EOPCMAIN_DISP B WHERE A.EOPCMAIN_ID = B.EOPCMAIN_ID AND (A.HTMLDISPLAY IS NOT NULL OR A.EOPCALT_LABEL <> '') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
| 3 | EOPCLABEL_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | EOPC Label Record Name |
| 4 | EOPCLABEL_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | EOPC Label Field Name |
| 5 | EOPCLABEL_TYPE_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Label Type
L=Long Name M=Message Catalog S=Short Name T=Text |
| 6 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 7 | EOPCLBL_MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 8 | EOPCLBL_MSGNBR | Number(5,0) | INTEGER NOT NULL | Message Number |
| 9 | EOPCMAIN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 10 | EOPCBIND_IDX | Number(4,0) | SMALLINT NOT NULL | EOPC Bind Index |
| 11 | EOPC_ISROWHEADER | Character(1) | VARCHAR2(1) NOT NULL | Row Header Indicator |
| 12 | EOPCALT_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Alternate Label |
| 13 | HTMLDISPLAY | Long Character | CLOB | HTML Display |