QS_APP_CONTEXTQS_FIELD_COMP_NAMEHIER=Stream Hierarchy
TRC=Traceability
QS_APP_HFLDS_VW(SQL View) |
Index Back |
|---|---|
QC application fieldsIs used on RowInit in QS_TRACE_SET8 Is used on RowInit in QS_RTFILTER_WRK Is used on RowInit in QS_STREAM_ROOT |
| SELECT A.QS_APP_CONTEXT , A.QS_FIELD_COMP_NAME , B.CAT_DESCR , A.QS_FIELD_USE_CODE , A.QS_SEQ , A.CAT_ID , A.QS_PROMPT_TBL , A.QS_SPEC_ENABLE FROM PS_QS_APP_FIELDS A , PS_QS_CATALOG B WHERE A.QS_FIELD_USE_CODE = 'HIER' AND A.CAT_ID = B.CAT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 2 | QS_FIELD_COMP_NAME |
Character(18) | VARCHAR2(18) NOT NULL | QC application structure field component |
| 3 | CAT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Catalog Field Description |
| 4 | QS_FIELD_USE_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Field type code (hierarchial, traceable)
HIER=Stream Hierarchy TRC=Traceability |
| 5 | QS_SEQ | Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 6 | CAT_ID | Number(3,0) | SMALLINT NOT NULL | ID of catalog field |
| 7 | QS_PROMPT_TBL | Character(24) | VARCHAR2(24) NOT NULL | Validation table/view name |
| 8 | QS_SPEC_ENABLE | Character(1) | VARCHAR2(1) NOT NULL | Switch to enable entry of specs & factors at trace field level (1) |