PSRECTBLSPC_VW - Records not in PSRECTBLSPC - PeopleTools Table Reference

PSRECTBLSPC_VW	index back
Records not in PSRECTBLSPC

This is a view of records not assigned to a DDLSPACENAME.

SELECT A.RECNAME , A.RECDESCR FROM PSRECDEFN A WHERE NOT EXISTS ( SELECT 'X' FROM PSRECTBLSPC B WHERE A.RECNAME = B.RECNAME)

PeopleSoft Field Name Field Type Column Type Description

RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description