QS_QSX_HFLDS_VW(SQL View) |
Index Back |
|---|---|
Extract hierarchy flds view |
| SELECT HFLDS.BUSINESS_UNIT , HFLDS.QS_APP_CONTEXT , HFLDS.QSX_NAME , HFLDS.QS_SEQ , HFLDS.QS_FIELD_COMP_NAME , HFLDS.QS_FIELD_VALUE , HFLDS.QS_FIELD_OPERATOR , CAT.CAT_DESCR , CAT.COLRT_ID , RT.COLRT_VAR_TYPE FROM PS_QS_QSX_HFLDS HFLDS , PS_QS_CATALOG CAT , PS_QS_COLRT RT WHERE (CAT.CAT_FIELDNAME = HFLDS.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 |