PNLNAMELBLTEXTEODP_FLDLBL1_VW(SQL View) |
Index Back |
|---|---|
Record Prompt ViewRecord Prompt View |
| SELECT a.pnlname ,a.lbltext ,a.recname ,a.fieldname FROM pspnlfield a , PSRECFIELDDB c WHERE a.fieldtype IN (4,5,6,7,9,11,12,13,14,15,16,17,21,26,29,31) AND %Sql(eodp_bitand_all_platforms, a.fielduse, 2) <> 2 AND c.recname=a.recname AND c.fieldname=a.fieldname AND c.edittable>' ' AND EXISTS ( SELECT 'x' FROM ps_eodp_comp_ref b WHERE b.pnlgrpname='BLANK_DP' AND (b.pnlname<> 'SEARCH_PAGE_DP' AND b.pnlname <> 'PROMPT_PAGE_DP') AND b.pnlname=a.pnlname) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 2 | LBLTEXT |
Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |