DATA_SBR_VW2

index back

subrecs with column

This view will show the subrecords that contain subrecords that contain the user specified column
SELECT A.RECNAME, 0, B.FIELDNAME, A.SQLTABLENAME, 'N' FROM PSRECDEFN A, PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE = 3

PeopleSoft Field Name Field Type Column Type Description
PSARCH_RECCOUNT Character(18) VARCHAR2(18) NOT NULL PS Record Name
PSARCH_NUM_ROWS Number(18,0) DECIMAL(18) NOT NULL Number of Rows
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
PSARCH_IS_KEY Character(1) VARCHAR2(1) NOT NULL Key Field
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19