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 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