QS_SPECLIM_HIS

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SPEC_ID Number(7,0) INTEGER NOT NULL Specification
2 SPEC_USL Signed Number(14,5) DECIMAL(12,5) NOT NULL Upper
3 SPEC_USL_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
4 SPEC_LSL Signed Number(14,5) DECIMAL(12,5) NOT NULL Lower
5 SPEC_LSL_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
6 SPEC_FACTOR1 Signed Number(14,5) DECIMAL(12,5) NOT NULL Factor 1
7 SPEC_FACTOR1_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
8 SPEC_FACTOR2 Signed Number(14,5) DECIMAL(12,5) NOT NULL Factor 2
9 SPEC_FACTOR2_IND Character(1) VARCHAR2(1) NOT NULL
N=Null
U=User Specified
10 QS_ORIGIN_CD Character(4) VARCHAR2(4) NOT NULL Origination Code
11 QS_ORIGIN_ID Number(8,0) INTEGER NOT NULL Origination ID
12 QS_MOD_DATE DateTime(26) TIMESTAMP General modification date for record change tracking
13 QS_MOD_BY Character(30) VARCHAR2(30) NOT NULL Modified by "operator"