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 Name Field Type Column Type Description
DBID Character(32) VARCHAR2(32) NOT NULL DBID
DISCOBJECTID1 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 1
DISCOBJECTID2 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 2
DISCOBJECTID3 Character(50) VARCHAR2(50) NOT NULL Disconnected Object ID 3
ISCOMPLETED Number(1,0) SMALLINT NOT NULL IS Completed
CURAVAIL Number(4,0) SMALLINT NOT NULL Current Available
SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19