DBIDDISCOBJECTID1DISCOBJECTID2DISCOBJECTID3PSMSFSEQ_VW(SQL View) |
Index Back |
|---|
| SELECT DBID , DISCOBJECTID1 ,DISCOBJECTID2 , DISCOBJECTID3 ,ISCOMPLETED , COUNT(*) , MAX(SEQUENCENO) FROM %Table(PSMSFSEQ) GROUP BY DBID , DISCOBJECTID1 ,DISCOBJECTID2 , DISCOBJECTID3 ,ISCOMPLETED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DBID |
Character(32) | VARCHAR2(32) NOT NULL | DBID |
| 2 | DISCOBJECTID1 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 1 |
| 3 | DISCOBJECTID2 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 2 |
| 4 | DISCOBJECTID3 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 3 |
| 5 | ISCOMPLETED | Number(1,0) | SMALLINT NOT NULL | IS Completed |
| 6 | CURAVAIL | Number(4,0) | SMALLINT NOT NULL | Current Available |
| 7 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |