PTPG_QRYPRMPTVW

index back

SELECT DISTINCT A.FIELDNAME , A.EFFDT ,A.XLATLONGNAME , A.FIELDVALUE FROM XLATTABLE_VW A WHERE A.EFF_STATUS='A'

PeopleSoft Field NameField TypeColumn TypeDescription
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
EFFDTDate(10)DATEEffective Date

Default: %date

PTPG_QRYPROMPTVALCharacter(30)VARCHAR2(30) NOT NULLQuery Prompt Values
FIELDVALUECharacter(4)VARCHAR2(4) NOT NULLField Value
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19