QS_CL_TEST

(SQL Table)
Index Back

Control Test Definition

RE 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"