QS_SPEC_HIS_VW(SQL View) |
Index Back |
|---|---|
Specs in Measment Plan Review |
| SELECT SPEC_ID, SPEC_USL, SPEC_USL_IND, SPEC_LSL, SPEC_LSL_IND, SPEC_FACTOR1, SPEC_FACTOR1_IND, SPEC_FACTOR2, SPEC_FACTOR2_IND, QS_ORIGIN_CD, QS_ORIGIN_ID, QS_MOD_DATE, QS_MOD_BY FROM PS_QS_SPECLIM_HIS |
| # | 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" |