PTGL_GET_FLD_VW

index back

SELECT DISTINCT A.RECNAME , C.FIELDNAME ,C.FIELDNUM , D.FIELDTYPE , D.LENGTH FROM PSRECDEFN A , PSRECFIELD C , PSDBFIELD D WHERE A.RECTYPE = 0 AND A.RECNAME=C.RECNAME AND C.FIELDNAME = D.FIELDNAME AND D.FIELDTYPE IN (0,1) AND C.FIELDNAME NOT IN ( SELECT FIELDNAME FROM PSKEYDEFN D WHERE D.RECNAME = C.RECNAME AND D.INDEXID = '_')

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).
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
LENGTH Number(5,0) INTEGER NOT NULL Length
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19