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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
2 | FIELDNAME | 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 |