QS_QSRVPNL_DEF(SQL Table) |
Index Back |
|---|---|
QServer query panel/grid map |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PANELNAME |
Character(18) | VARCHAR2(18) NOT NULL | Panelname |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | CAT_RECNAME | Character(18) | VARCHAR2(18) NOT NULL | Primary Record Name |
| 4 | QS_DATASET_NAME | Character(48) | VARCHAR2(48) NOT NULL | Default QServer dataset name |
| 5 | QS_SUBSET_NAME | Character(24) | VARCHAR2(24) NOT NULL | Default QServer subset name |
| 6 | QS_QSRV_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
QServer panel mapping model
1=Single Level 2=Two Level Default Value: 1 |
| 7 | MFDS_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type
DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables Default Value: VAR |
| 8 | MFDS_SGRP_SIZE | Number(13,5) | DECIMAL(12,5) NOT NULL |
Subgroup Size
Default Value: 1 |
| 9 | CHART_ID | Number(4,0) | SMALLINT NOT NULL |
Quality control chart ID
Default Value: 1 Prompt Table: QS_CL_CHART |
| 10 | PROC_ID | Number(4,0) | SMALLINT NOT NULL |
Control Procedure
Default Value: 1 Prompt Table: QS_CL_PROC |
| 11 | GREF_ID | Number(4,0) | SMALLINT NOT NULL |
Graph Preference ID
Default Value: 0 Prompt Table: QS_GRSET_VW |