APP_DES_OBJCSTV

index back

Application Designer Objects


SELECT PSOWNER , APP_DES_CATEGORY , OBJNAME , SECURE , SEARCHRECNAME FROM %Table(APP_DES_OBJ_CST) UNION SELECT PSOWNER , APP_DES_CATEGORY , OBJNAME , 'N' , ' ' FROM %Table(APP_DES_OBJECTS) WHERE OBJECTTYPE <> 9999 AND OBJNAME NOT IN ( SELECT OBJNAME FROM %Table(APP_DES_OBJ_CST))

PeopleSoft Field Name Field Type Column Type Description
PSOWNER Character(8) VARCHAR2(8) NOT NULL Owner
APP_DES_CATEGORY Character(1) VARCHAR2(1) NOT NULL category
1=Objects
2=Tools
3=Misc.
OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
SECURE Character(1) VARCHAR2(1) NOT NULL Secure

Y/N Table Edit

Default: N

SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name

Prompt Table: PSPTRECDEFNDVW

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19