QS_QSX_TFLDS_VW(SQL View) |
Index Back |
|---|---|
Extract trace flds view |
| SELECT tflds.business_unit , tflds.qs_app_context , tflds.qsx_name , tflds.qs_seq , tflds.qs_field_comp_name , tflds.qs_field_value , tflds.qs_field_operator , cat.cat_descr , cat.colrt_id , rt.colrt_var_type FROM ps_qs_qsx_tflds tflds , ps_qs_catalog cat , PS_QS_COLRT rt WHERE (cat.cat_fieldname = tflds.qs_field_comp_name) AND (rt.colrt_id = cat.colrt_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 |  QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 3 | QSX_NAME |
Character(24) | VARCHAR2(24) NOT NULL | Extraction Name |
| 4 | QS_SEQ |
Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 5 | QS_FIELD_COMP_NAME | Character(18) | VARCHAR2(18) NOT NULL | QC application structure field component |
| 6 | QS_FIELD_VALUE | Character(40) | VARCHAR2(40) NOT NULL | Generic field for trace value input |
| 7 | QS_FIELD_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Field selection operator
<>=<> === ALL=ALL BTWN=BETWEEN LIKE=LIKE |
| 8 | CAT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Catalog Field Description |
| 9 | COLRT_ID | Number(4,0) | SMALLINT NOT NULL | Column Type |
| 10 | COLRT_VAR_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Variable Type
0=Any 11=Character 12=Date 13=DateTime 14=Float 15=Integer 16=Time 20=Config 30=CSpec 31=HSpec 40=CLimit 41=HLimit 50=Subgroup 51=Sample 52=Size 60=Attribute 61=Defect 62=Ctl Test 63=Cause 64=Action 69=Tally |