BUSINESS_UNITSTREAM_IDSESSN_IDQS_SGRP_VW(SQL View) |
Index Back |
|---|---|
Subgroup table - summary viewFetch subgroup rows where status = 'ANLZ' (analyzed). |
| SELECT A.BUSINESS_UNIT , A.STREAM_ID , A.SESSN_ID , A.SESSN_SGRP_SEQ , A.SESSN_SUBMIT_DTTM , A.SESSN_STRM_STS , A.QS_SUBGROUP_STATUS FROM PS_QS_SUBGROUP A WHERE (A.SESSN_STRM_STS = 'ANLZ' AND A.QS_SUBGROUP_STATUS >=0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | STREAM_ID |
Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 3 | SESSN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Session ID |
| 4 | SESSN_SGRP_SEQ | Number(6,0) | INTEGER NOT NULL | Subgroup ID |
| 5 | SESSN_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Date Submitted |
| 6 | SESSN_STRM_STS | Character(4) | VARCHAR2(4) NOT NULL | Session Stream Status |
| 7 | QS_SUBGROUP_STATUS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Status |