| # |
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_ID |
Number(8,0) |
INTEGER NOT NULL |
Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
|
| 3 |
CLIM_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 4 |
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
|
| 5 |
CLIM_UPPER_X |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 6 |
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
|
| 7 |
CLIM_MEAN_X |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 8 |
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
|
| 9 |
CLIM_LOWER_X |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 10 |
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
|
| 11 |
CLIM_UPPER_MRANGE |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 12 |
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
|
| 13 |
CLIM_MEAN_RANGE |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 14 |
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
|
| 15 |
CLIM_LOWER_MRANGE |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Object used for Contorl Limits storage,calculation, and/or display
|
| 16 |
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
|
| 17 |
CLIM_CRE_DTTM |
DateTime(26) |
TIMESTAMP |
Object used for Contorl Limits storage,calculation, and/or display
Default Value: %DATE
|
| 18 |
CLIM_CRE_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
object used for Contorl Limits storage,calculation, and/or display
|