RSF_FCAST_LL_VW(SQL View) |
Index Back |
|---|---|
Field Label View - LanguageForecast Field Label - Related Language View |
| SELECT DISTINCT A.LANGUAGE_CD , B.FIELDNAME , A.PNLNAME , A.LBLTEXT FROM PSPNLFIELDLANG A , PSPNLFIELD B WHERE A.PNLNAME = B.PNLNAME AND A.PNLFLDID = B.PNLFLDID AND B.PNLNAME IN ('RSF_FCAST_REVIEW','RSF_FCAST_FILTER') AND B.FIELDNAME <> ' ' AND B.LBLTEXT <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
| 3 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 4 | FIELDLABEL | Character(60) | VARCHAR2(60) NOT NULL | Field Label |