DATA_SBR_VW1

index back

subrecs with column

This view will show the 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