PANELNAMECAT_RECNAMECAT_FIELDNAMEDefault Value: 1
Default Value: 1
0=None
1=Measure
2=Sizen
3=Attribute
90=Subset by
Y/N Table Edit
Default Value: N
N=Inactive
X=Do not use in Search
Y=Active
Y/N Table Edit
Default Value: Y
QS_QSRVPNL_MAP(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 | 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
Default Value: 1 |
| 7 | COLRT_ID | Number(4,0) | SMALLINT NOT NULL |
Column Type
Default Value: 1 |
| 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
Y/N Table Edit Default Value: N |
| 10 | QS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
N=Inactive X=Do not use in Search Y=Active Y/N Table Edit Default Value: Y |
| 11 | MFDS_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Formula |