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 Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
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