PNLNAMEFIELDNUMRC_PAGEFLD_VW(SQL View) |
Index Back |
|---|---|
Page - Edittable Fields ViewThis View displays all the fields that are Edittiable ( Other than Display Only and Hidden Fields ) . Used in Old Page Configurator Design, but not used any more |
| SELECT PNLNAME , FIELDNUM , LBLTEXT , RECNAME , FIELDNAME FROM PSPNLFIELD WHERE FIELDUSE/2 = FIELDUSE/(4)*2 AND RECNAME <> ' ' AND FIELDNAME <> ' ' AND FIELDTYPE NOT IN (0, 2, 8) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 3 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |