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