QS_CL_PRCTST_VW(SQL View) |
Index Back |
|---|---|
Select proc and test configselect all control tests associated w/ a control proc |
| SELECT P.PROC_ID , P.PROC_DESCR , P.PROC_WINDOW_PTS , P.PROC_PRELIM_PTS , P.PROC_MON_PTS , P.PROC_ONGOING_PTS , P.PROC_RECALC_PTS , P.PROC_GRAPH_PTS , E.EVAL_SEQ , E.TEST_ID , T.TEST_DESCR , T.TEST_PROTOTYPE_CD , T.TEST_APPLY_TO_CD , T.TEST_TESTED_PTS , T.TEST_TRIGGER_PTS FROM PS_QS_CL_PROC P , PS_QS_CL_EVLIST E , PS_QS_CL_TEST T WHERE (E.PROC_ID = P.PROC_ID) AND (T.TEST_ID = E.TEST_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 2 | PROC_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Procedure Description |
| 3 | PROC_WINDOW_PTS | Number(3,0) | SMALLINT NOT NULL | Limits Calculate Window |
| 4 | PROC_PRELIM_PTS | Number(2,0) | SMALLINT NOT NULL | Preliminary |
| 5 | PROC_MON_PTS | Number(2,0) | SMALLINT NOT NULL | Monitoring |
| 6 | PROC_ONGOING_PTS | Number(2,0) | SMALLINT NOT NULL | OnGoing |
| 7 | PROC_RECALC_PTS | Number(3,0) | SMALLINT NOT NULL | Recalculate |
| 8 | PROC_GRAPH_PTS | Number(2,0) | SMALLINT NOT NULL | Graph Window |
| 9 | EVAL_SEQ | Number(3,0) | SMALLINT NOT NULL | Seq |
| 10 | TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |
| 11 | TEST_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Test Description |
| 12 | TEST_PROTOTYPE_CD | Character(3) | VARCHAR2(3) NOT NULL | Test Prototype |
| 13 | TEST_APPLY_TO_CD | Character(1) | VARCHAR2(1) NOT NULL |
Apply To
1=Chart 1 2=Chart 2 |
| 14 | TEST_TESTED_PTS | Number(4,0) | SMALLINT NOT NULL | Tested Points |
| 15 | TEST_TRIGGER_PTS | Number(4,0) | SMALLINT NOT NULL | Trigger Points |