PNLFIELD_LVW

index back

Panel Field Translation View


SELECT C.PNLNAME , C.PNLFLDID , C.LANGUAGE_CD , A.FIELDNUM , C.LBLTEXT FROM PS_PNLFIELD_VW A , PSPNLFIELDLANG C WHERE A.PNLNAME = C.PNLNAME AND A.PNLFLDID = C.PNLFLDID

PeopleSoft Field NameField TypeColumn TypeDescription
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).

Prompt Table: PSPNLDEFN_VW

PNLFLDIDNumber(4,0)SMALLINT NOT NULLPage Field ID
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

Prompt Table: PSPNLDEFN

FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
LBLTEXTCharacter(60)VARCHAR2(60) NOT NULLLabel Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19