QS_STATITEM_VW

(SQL View)
 Index Back

View of all Stat Items


SELECT STATS_ID , stats_version , STATS_MNC , STATS_LABEL , STATS_FORMAT , STATS_DTQUAL_CD , STATS_LOWER_LIM , STATS_LOWER_IND , STATS_UPPER_LIM , STATS_UPPER_IND , STATS_FORMULA , STATS_INTERNAL_SW FROM PS_QS_STATITEM , PS_QS_VERSION WHERE STATS_MNC NOT IN ('FACT1','FACT2','TRANS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATS_ID Number(3,0) SMALLINT NOT NULL Statistic ID
2 STATS_VERSION Number(6,0) INTEGER NOT NULL Statistics
3 STATS_MNC Character(12) VARCHAR2(12) NOT NULL Mnemonic
4 STATS_LABEL Character(16) VARCHAR2(16) NOT NULL Statistic
5 STATS_FORMAT Character(7) VARCHAR2(7) NOT NULL Statistical Format
6 STATS_DTQUAL_CD Character(4) VARCHAR2(4) NOT NULL Data Type Qualifier
ANY=Any
DEF=Defects
DEFS=Defectives
VAR=Variables

Default Value: ANY

7 STATS_LOWER_LIM Signed Number(14,5) DECIMAL(12,5) NOT NULL Lower Display Limit
8 STATS_LOWER_IND Character(1) VARCHAR2(1) NOT NULL Lwr Indicator
N=Null
U=User Specified

Default Value: N

9 STATS_UPPER_LIM Signed Number(14,5) DECIMAL(12,5) NOT NULL Upper Display Limit
10 STATS_UPPER_IND Character(1) VARCHAR2(1) NOT NULL Upr Indicator
N=Null
U=User Specified

Default Value: N

11 STATS_FORMULA Character(254) VARCHAR2(254) NOT NULL Stats Formula
12 STATS_INTERNAL_SW Character(1) VARCHAR2(1) NOT NULL Use Flag

Y/N Table Edit

Default Value: N