EOCF_PNLNAME_FLTPNLFIELDNAMEEOCF_FLTRELFVW(SQL View) |
Index Back |
|---|---|
EOCF_FLTRELFVWEOCF_FLTRELFVW |
| SELECT PNLNAME , PNLFIELDNAME , RECNAME , FIELDNAME , LBLTEXT FROM PSPNLFIELD WHERE GRDCOLUMNCOUNT = 0 AND NOT FIELDTYPE IN (9,12,16,21,23,24) AND PNLFIELDNAME <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_PNLNAME_FLT |
Character(30) | VARCHAR2(30) NOT NULL | Page Name |
| 2 | PNLFIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Panel Field Name |
| 3 | EOCF_REL_DISP_REC | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 4 | EOCF_REL_DISP_FLD | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 5 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |