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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
KEYPOSNNumber(3,0)SMALLINT NOT NULLKey Position
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19