STATS_IDDefault Value: QS_AUTO_NUMBERS.STATS_ID
ANY=Any
DEF=Defects
DEFS=Defectives
VAR=Variables
Default Value: ANY
N=Null
U=User Specified
Default Value: N
N=Null
U=User Specified
Default Value: N
Y/N Table Edit
Default Value: N
QS_STATITEM(SQL Table) |
Index Back |
|---|---|
Statistical Items Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATS_ID |
Number(3,0) | SMALLINT NOT NULL |
Statistic ID
Default Value: QS_AUTO_NUMBERS.STATS_ID |
| 2 | STATS_MNC | Character(12) | VARCHAR2(12) NOT NULL | Mnemonic |
| 3 | STATS_LABEL | Character(16) | VARCHAR2(16) NOT NULL | Statistic |
| 4 | STATS_FORMAT | Character(7) | VARCHAR2(7) NOT NULL | Statistical Format |
| 5 | STATS_DTQUAL_CD | Character(4) | VARCHAR2(4) NOT NULL |
Data Type Qualifier
ANY=Any DEF=Defects DEFS=Defectives VAR=Variables Default Value: ANY |
| 6 | STATS_LOWER_LIM | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Lower Display Limit |
| 7 | STATS_LOWER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Lwr Indicator
N=Null U=User Specified Default Value: N |
| 8 | STATS_UPPER_LIM | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Upper Display Limit |
| 9 | STATS_UPPER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Upr Indicator
N=Null U=User Specified Default Value: N |
| 10 | STATS_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Stats Formula |
| 11 | STATS_INTERNAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Use Flag
Y/N Table Edit Default Value: N |
| 12 | STATS_LIST_SW | Character(1) | VARCHAR2(1) NOT NULL | Select Statistic in List |