QS_CLIM_DHIS_VW(SQL View) |
Index Back |
|---|---|
Control Limit History |
| SELECT A.BUSINESS_UNIT , A.STREAM_ROOT_ID , A.STREAM_ID , A.CLIM_ID , B.CLIM_STS_CD , B.CLIM_UPPER_X , B.CLIM_UX_IND , B.CLIM_MEAN_X , B.CLIM_MX_IND , B.CLIM_LOWER_X , B.CLIM_LX_IND , B.CLIM_UPPER_MRANGE , B.CLIM_UMRANGE_IND , B.CLIM_MEAN_RANGE , B.CLIM_MRANGE_IND , B.CLIM_LOWER_MRANGE , B.CLIM_LMRANGE_IND , B.CLIM_CRE_DTTM , B.CLIM_CRE_BY FROM PS_QS_STREAM8_VW A , PS_QS_CNTL_LIM_HIS B WHERE B.CLIM_ID=A.CLIM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | STREAM_ROOT_ID | Number(8,0) | INTEGER NOT NULL | Stream Root ID - hierarchal structure |
| 3 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 4 | CLIM_ID | Character(30) | VARCHAR2(30) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 5 | CLIM_STS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Status of Control Limit Calculations
ASGN=Assigned MON=Monitor NONE=None ONG=OnGoing PRE=Preliminary RCLC=ReCalc RSET=Reset Default Value: NONE |
| 6 | CLIM_UPPER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 7 | CLIM_UX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined Default Value: N |
| 8 | CLIM_MEAN_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 9 | CLIM_MX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display--indicates if value is a zero or null
N=Null S=System Assigned U=User Defined Default Value: N |
| 10 | CLIM_LOWER_X | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 11 | CLIM_LX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates whether value is zero or null
N=Null S=System Assigned U=User Defined Default Value: N |
| 12 | CLIM_UPPER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 13 | CLIM_UMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined Default Value: N |
| 14 | CLIM_MEAN_RANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 15 | CLIM_MRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display. Indicates if the value is a zero or a null
N=Null S=System Assigned U=User Defined Default Value: N |
| 16 | CLIM_LOWER_MRANGE | Signed Number(15,6) | DECIMAL(13,6) NOT NULL | Object used for Contorl Limits storage,calculation, and/or display |
| 17 | CLIM_LMRANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
N=Null S=System Assigned U=User Defined Default Value: N |
| 18 | CLIM_CRE_DTTM | DateTime(26) | TIMESTAMP |
Object used for Contorl Limits storage,calculation, and/or display
Default Value: %DATE |
| 19 | CLIM_CRE_BY | Character(30) | VARCHAR2(30) NOT NULL | object used for Contorl Limits storage,calculation, and/or display |