TEST_DESCR1=Chart 1
2=Chart 2
QS_CL_TESTS_VW(SQL View) |
Index Back |
|---|---|
List target tests for copy |
| SELECT TEST_DESCR, TEST_ID, TEST_PROTOTYPE_CD, TEST_APPLY_TO_CD, TEST_TESTED_PTS, TEST_TRIGGER_PTS, QS_MOD_DATE, QS_MOD_BY FROM PS_QS_CL_TEST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEST_DESCR |
Character(36) | VARCHAR2(36) NOT NULL | Test Description |
| 2 | TEST_ID | Number(4,0) | SMALLINT NOT NULL | Control Test ID |
| 3 | TEST_PROTOTYPE_CD | Character(3) | VARCHAR2(3) NOT NULL | Test Prototype |
| 4 | TEST_APPLY_TO_CD | Character(1) | VARCHAR2(1) NOT NULL |
Apply To
1=Chart 1 2=Chart 2 |
| 5 | TEST_TESTED_PTS | Number(4,0) | SMALLINT NOT NULL | Tested Points |
| 6 | TEST_TRIGGER_PTS | Number(4,0) | SMALLINT NOT NULL | Trigger Points |
| 7 | QS_MOD_DATE | DateTime(26) | TIMESTAMP | General modification date for record change tracking |
| 8 | QS_MOD_BY | Character(30) | VARCHAR2(30) NOT NULL | Modified by "operator" |