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