PSMSFSEQ_VW

index back

SELECT DBID , DISCOBJECTID1 ,DISCOBJECTID2 , DISCOBJECTID3 ,ISCOMPLETED , COUNT(*) , MAX(SEQUENCENO) FROM %Table(PSMSFSEQ) GROUP BY DBID , DISCOBJECTID1 ,DISCOBJECTID2 , DISCOBJECTID3 ,ISCOMPLETED

PeopleSoft Field NameField TypeColumn TypeDescription
DBIDCharacter(32)VARCHAR2(32) NOT NULLDBID
DISCOBJECTID1Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 1
DISCOBJECTID2Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 2
DISCOBJECTID3Character(50)VARCHAR2(50) NOT NULLDisconnected Object ID 3
ISCOMPLETEDNumber(1,0)SMALLINT NOT NULLIS Completed
CURAVAILNumber(4,0)SMALLINT NOT NULLCurrent Available
SEQUENCENONumber(10,0)DECIMAL(10) NOT NULLSequence Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19