GET_KEYS_VW

index back

SELECT A.RECNAME , A.FIELDNAME , A.KEYPOSN , B.FIELDTYPE FROM PSKEYDEFN A , PSDBFIELD B WHERE INDEXID = '_' AND A.FIELDNAME = B.FIELDNAME

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19