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 NameField TypeColumn TypeDescription
PSARCH_RECCOUNTCharacter(18)VARCHAR2(18) NOT NULLPS Record Name
PSARCH_NUM_ROWSNumber(18,0)DECIMAL(18) NOT NULLNumber of Rows
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
SQLTABLENAMECharacter(18)VARCHAR2(18) NOT NULLSQL Table Name
PSARCH_IS_KEYCharacter(1)VARCHAR2(1) NOT NULLKey Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19