DATA_SBR_VW3

index back

subrecs recdefn

This view will show the record definition for the current subrecord
SELECT A.RECNAME, 0, ' ', A.SQLTABLENAME, 'N' FROM PSRECDEFN A WHERE 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