QS_APP_FLDS_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_use_code , a.qs_field_comp_name , a.qs_seq , a.cat_id , a.qs_prompt_tbl , a.qs_spec_enable , b.cat_descr , b.cat_mnc , b.qs_setctrl_fld , b.qs_select_dtyp , b.qs_fld_label_cd , b.cat_label_id FROM ps_qs_app_fields a , PS_QS_CATALOG b WHERE b.cat_id = a.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_USE_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Field type code (hierarchial, traceable)
HIER=Stream Hierarchy TRC=Traceability |
| 3 | QS_FIELD_COMP_NAME | Character(18) | VARCHAR2(18) NOT NULL | QC application structure field component |
| 4 | QS_SEQ | Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 5 | CAT_ID | Number(3,0) | SMALLINT NOT NULL | ID of catalog field |
| 6 | QS_PROMPT_TBL | Character(24) | VARCHAR2(24) NOT NULL | Validation table/view name |
| 7 | QS_SPEC_ENABLE | Character(1) | VARCHAR2(1) NOT NULL | Switch to enable entry of specs & factors at trace field level (1) |
| 8 | CAT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Catalog Field Description |
| 9 | CAT_MNC | Character(7) | VARCHAR2(7) NOT NULL | Abreviation used in place of object field name for cases when characters are limited when refering to field. An example would be views created for each catalog field. We use this field when creating views for this field against the QS_STREAM_ROOT table. Such views are the format: QS_QCP_XXXX_VW XXXX being a reference to the catalog field name. |
| 10 | QS_SETCTRL_FLD | Character(13) | VARCHAR2(13) NOT NULL |
Set Control Field
BU=Business Unit NONE=None SETD=SetID |
| 11 | QS_SELECT_DTYP | Character(4) | VARCHAR2(4) NOT NULL |
Specify datatype for SQL/Select verifictaion
CHAR=Character NUM=Numeric |
| 12 | QS_FLD_LABEL_CD | Character(4) | VARCHAR2(4) NOT NULL |
Select field label type for display - short or long
LONG=Long SHRT=Short |
| 13 | CAT_LABEL_ID | Character(24) | VARCHAR2(24) NOT NULL | used for retrieving app-field labels |