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 Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
EFFDT Date(10) DATE Effective Date

Default: %date

PTPG_QRYPROMPTVAL Character(30) VARCHAR2(30) NOT NULL Query Prompt Values
FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19