BUSINESS_UNITSESSN_IDSTREAM_IDSAMPLETEST_SEQQS_ALL_STST_VW(SQL View) |
Index Back |
|---|---|
V8 View of all Session Tests |
| SELECT A.BUSINESS_UNIT , A.SESSN_ID , A.STREAM_ID , A.SAMPLE , A.TEST_SEQ , A.TEST_ID , B.TEST_DESCR FROM PS_QS_SESSN_TEST8 A , PS_QS_CL_TEST B WHERE B.TEST_ID = A.TEST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SESSN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Session ID |
| 3 | STREAM_ID |
Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 4 | SAMPLE |
Number(4,0) | SMALLINT NOT NULL | Sample |
| 5 | TEST_SEQ |
Number(3,0) | SMALLINT NOT NULL | Test Sequence |
| 6 | TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |
| 7 | TEST_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Test Description |