XREF_PCMNAME_VW

index back

Records used in peoplecode


SELECT DISTINCT RECNAME, REFNAME, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3 FROM PSPCMNAME WHERE OBJECTID1=1 AND OBJECTID2=2 AND OBJECTID3=12

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
REFNAME Character(30) VARCHAR2(30) NOT NULL PeopleCode Reference Name
REF_RECNAME Character(15) VARCHAR2(15) NOT NULL PeopleCode Recname
REF_FIELDNAME Character(18) VARCHAR2(18) NOT NULL PeopleCode Fieldname
PCODE_PGM_TYPE Character(30) VARCHAR2(30) NOT NULL PeopleCode Type
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19