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 NameField TypeColumn TypeDescription
PSOWNERCharacter(8)VARCHAR2(8) NOT NULLOwner
APP_DES_CATEGORYCharacter(1)VARCHAR2(1) NOT NULLcategory
1=Objects
2=Tools
3=Misc.
OBJNAMECharacter(30)VARCHAR2(30) NOT NULLObject Name
SECURECharacter(1)VARCHAR2(1) NOT NULLSecure

Y/N Table Edit

Default: N

SEARCHRECNAMECharacter(15)VARCHAR2(15) NOT NULLSearch Record Name

Prompt Table: PSPTRECDEFNDVW

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