QS_QSRVPNL_VW(SQL View) |
Index Back |
|---|---|
QServer query panel map view |
| SELECT A.PANELNAME, A.CAT_RECNAME, A.CAT_FIELDNAME, A.DESCR, A.QS_SEQ, A.QS_SCROLL_LEVEL, A.COLRT_ID, A.COLRT_VAR_ROLE, A.QS_CHECK_VALUE_SW, A.QS_ACTIVE, B.QS_DATASET_NAME, B.QS_SUBSET_NAME, B.QS_QSRV_MODEL, B.MFDS_DATA_TYPE_CD, B.MFDS_SGRP_SIZE, B.CHART_ID, B.PROC_ID, B.GREF_ID, A.MFDS_FORMULA FROM PS_QS_QSRVPNL_MAP A, PS_QS_QSRVPNL_DEF B WHERE B.PANELNAME = A.PANELNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PANELNAME | Character(18) | VARCHAR2(18) NOT NULL | Panelname |
| 2 | CAT_RECNAME | Character(18) | VARCHAR2(18) NOT NULL | Primary Record Name |
| 3 | CAT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Name of object field used in catalog |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | QS_SEQ | Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 6 | QS_SCROLL_LEVEL | Number(3,0) | SMALLINT NOT NULL | Scroll level indicator |
| 7 | COLRT_ID | Number(4,0) | SMALLINT NOT NULL | Column Type |
| 8 | COLRT_VAR_ROLE | Character(4) | VARCHAR2(4) NOT NULL |
QServer column roles
0=None 1=Measure 2=Sizen 3=Attribute 90=Subset by |
| 9 | QS_CHECK_VALUE_SW | Character(1) | VARCHAR2(1) NOT NULL | Field check/validation switch |
| 10 | QS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive X=Do not use in Search Y=Active |
| 11 | QS_DATASET_NAME | Character(48) | VARCHAR2(48) NOT NULL | Default QServer dataset name |
| 12 | QS_SUBSET_NAME | Character(24) | VARCHAR2(24) NOT NULL | Default QServer subset name |
| 13 | QS_QSRV_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
QServer panel mapping model
1=Single Level 2=Two Level |
| 14 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 15 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL | Subgroup Size |
| 16 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 17 | PROC_ID | Number(4,0) | SMALLINT NOT NULL | Control Procedure |
| 18 | GREF_ID | Number(4,0) | SMALLINT NOT NULL | Graph Preference ID |
| 19 | MFDS_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Formula |