QS_CL_TEST(SQL Table) |
Index Back |
---|---|
Control Test DefinitionRE 12/04/98 Change pcode on SPr of PROC_ID to use INCR_NUMBER instead of: SQLExec("Update ps_qs_version set test_version = test_version + 1"); MT 12/10/98 Replaces QS_CNTL_TEST record for rel 8 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TEST_ID | Number(4,0) | SMALLINT NOT NULL |
Control Test ID
Default Value: 1 |
2 | TEST_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Test Description |
3 | TEST_PROTOTYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Test Prototype
Prompt Table: QS_TESTPROT_TBL |
4 | TEST_APPLY_TO_CD | Character(1) | VARCHAR2(1) NOT NULL |
Apply To
1=Chart 1 2=Chart 2 Default Value: 1 |
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" |