QS_CHARTS_VW(SQL View) |
Index Back |
|---|---|
view of ctl charts |
| SELECT A.CHART_ID , A.CHART_DATA_TYPE_CD , A.CHART_DESCR FROM PS_QS_CL_CHART A , PS_QS_MFDS_MST B WHERE A.CHART_DATA_TYPE_CD = B.MFDS_DATA_TYPE_CD OR A.CHART_DATA_TYPE_CD = 'ANY' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHART_ID | Number(4,0) | SMALLINT NOT NULL | Quality control chart ID |
| 2 | CHART_DATA_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Object used for Charts- indicates data type to be displayed on chart.
ANY=Any DEF=Defects DEFS=Defectives DFTV=Defectives VAR=Variables |
| 3 | CHART_DESCR | Character(36) | VARCHAR2(36) NOT NULL | Control Chart Name |