WF_KEYDEFN_VW

index back

Worfflow PSKEYDEFN View


select a.recname, a.keyposn, a.fieldname, b.fieldtype from pskeydefn a, psdbfield b where a.fieldname = b.fieldname and a.indexid = '_'

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
KEYPOSNNumber(3,0)SMALLINT NOT NULLKey Position
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
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