QS_XFER_SESN_VW(SQL View) |
Index Back |
|---|---|
session vw for QS integrationRRE- view used to extract session information |
| SELECT DISTINCT STRM.STREAM_ROOT_ID , SGH.SESSN_ID , SGH.SESSN_CRE_DTTM , SGH.SESSN_STS_CD FROM PS_QS_SUBGROUP SG , PS_QS_STREAM8 STRM , PS_QS_SESSN_HDR8 SGH WHERE STRM.STREAM_ID = SG.STREAM_ID AND SGH.SESSN_ID = SG.SESSN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 2 | SESSN_ID | Character(30) | VARCHAR2(30) NOT NULL | Session ID |
| 3 | SESSN_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Date Submitted |
| 4 | SESSN_STS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Select Session for Edit
ALLO=Allocated ANLZ=Analyzed DISC=Discarded DISP=Dispatched SAVE=Saved SUBM=Submitted |