PSPTDEFSECCNTRV

index back

Inclusion rl counts by grp/typ


SELECT OBJGROUPID , OBJNAME , COUNT(*) FROM %Table(PSPTDEFSEC_GRP) WHERE DYNAMIC_FLAG= 'Y' GROUP BY OBJGROUPID , OBJNAME

PeopleSoft Field NameField TypeColumn TypeDescription
OBJGROUPIDCharacter(18)VARCHAR2(18) NOT NULLDefinition Group
OBJNAMECharacter(30)VARCHAR2(30) NOT NULLObject Name
NUMROWSNumber(15,0)DECIMAL(15) NOT NULLNumber of Rows fetched.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19