GEN_COL_KEY |
Generic Column Key |
RMXTE_OTPT__GEN_COLKEY |
|
INT4 |
|
10 |
0 |
|
TRIALID |
Trial Number |
RMXTE_OTPT_TRIALID |
|
CHAR |
|
13 |
0 |
|
TRIALNAME |
Trial Name |
RMXTE_TRIALNAME |
|
CHAR |
|
60 |
0 |
|
QMNUM |
Notification No |
QMNUM |
|
CHAR |
|
12 |
0 |
|
STABICON |
Storage Condition |
QSTABICON |
|
CHAR |
|
8 |
0 |
|
STABICONTXT |
Description of Storage Condition |
QSTABICONTXT |
|
CHAR |
|
120 |
0 |
|
EINGDT |
Date of Receipt of Initial Sample for Stability Study |
QST_EINGDT |
|
DATS |
|
8 |
0 |
|
EINLDT |
Storage Date of Sample for Storage Condition |
QST_EINLDT |
|
DATS |
|
8 |
0 |
|
AUSLDT |
Date of Removal from Storage of Sample for Storage Condition |
QST_AUSLDT |
|
DATS |
|
8 |
0 |
|
INSPLOT |
Inspection Lot Number |
QIBPLOSNR |
|
NUMC |
|
12 |
0 |
|
HERKUNFT |
Inspection Lot Origin |
QHERK |
|
CHAR |
|
2 |
0 |
|
INSPOPER |
Inspection Lot Operation Number |
QIBPVORNR |
|
CHAR |
|
4 |
0 |
|
TXT_OPER |
Operation Short Text |
RMXTE_OTPT_QKURZTEXT |
|
CHAR |
|
40 |
0 |
|
INSPCHAR |
Insp. Lot Charac. No. |
QIBPMERKNR |
|
NUMC |
|
4 |
0 |
|
CHAR_DESCR |
Inspection Characteristic Description |
RMXTE_OTPT_QMKKURZTXT |
|
CHAR |
|
40 |
0 |
|
INSPSAMPLE |
Insp. Lot Sample |
QIBPPROBE |
|
NUMC |
|
6 |
0 |
|
LAST_SMPL |
Last Original Value, Sample or Inspection Point |
QEIFKZENDE |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
CLOSED |
Close Characteristic or Sample |
QEIFABSCHL |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
EVALUATED |
Copy Valuation from External System |
QEIFBEWE |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
SMPL_ATTR |
Attribute of the Results Record (Valid, Invalid,...) |
QATTRIBUT |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Result is valid (default) |
< |
The true value is less or equal to; valid result |
> |
The true value is greater or equal to; valid result |
? |
The result was estimated; valid result |
* |
Result considerede an outlier; valid result |
/ |
Invalid result |
( |
Customer attribute '('; valid result |
) |
Customer attribute '('; invalid result |
[ |
Customer attribute '['; valid result |
] |
Customer attribute '['; invalid result |
{ |
Customer attribute '{'; valid result |
} |
Customer attribute '}'; invalid result |
~ |
Result not proven; valid result |
# |
Result not determinable; valid result |
U |
Customer attribute 'U'; valid result |
V |
Customer attribute 'V'; valid result |
W |
Customer attribute 'W'; valid result |
X |
Customer attribute 'X'; invalid result |
Y |
Customer attribute 'Y'; invalid result |
Z |
Customer attribute 'Z'; invalid result |
A |
Formula: Calculation input characteristic is inappropriate |
B |
Formula: Calculation input characteristic does not exist |
C |
Formula: Syntax error |
D |
Formula: Calculation input charac. has an incorrect format |
E |
Formula: Error during values' trans. for calc. input charac. |
F |
Formula: Arithmetic error during formula calculation |
G |
Formula: Not all single results were calculated |
H |
Formula: Error when calculating single units |
& |
Error occurred during results transfer |
\ |
Result is not current; invalid result |
|
SMPL_INVAL |
Invalid Result |
QRES_INVAL |
|
CHAR |
|
1 |
0 |
|
EVALUATION |
Inspection Result Valuation |
QMBEWERTG |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
No valuation |
A |
Accepted |
R |
Rejected |
F |
Failed |
|
ERR_CLASS |
Defect Class |
QFEHLKLAS |
|
CHAR |
|
2 |
0 |
|
VALID_VALS |
No. of Valid Values for Char. Results Upload to QM Subsys. |
QEIFAWERTG |
|
CHAR |
|
7 |
0 |
|
NONCONF |
No. of Nonconforming Units for Char. Confirmation via QM-IDI |
QEIFAFEEH |
|
CHAR |
|
7 |
0 |
|
DEFECTS |
Number of Defects for Confirmation of Charac. via QM-IDI |
QEIFAFEHL |
|
CHAR |
|
7 |
0 |
|
VALS_ABOVE |
Number of Values Below the Tolerance Limit (Characteristic) |
QEIFAWRTU |
|
CHAR |
|
7 |
0 |
|
VALS_BELOW |
Number of Values Above the Tolerance Limit (Characteristic) |
QEIFAWRTO |
|
CHAR |
|
7 |
0 |
|
MEAN_VALUE |
Mean Value |
QMEAN_VAL |
|
CHAR |
|
22 |
0 |
|
VARIANCE |
Variance |
QVARIANCE |
|
CHAR |
|
22 |
0 |
|
MAXIMUM |
Maximum |
QMAX_VAL |
|
CHAR |
|
22 |
0 |
|
MINIMUM |
Minimum |
QMIN_VAL |
|
CHAR |
|
22 |
0 |
|
START_DATE |
Inspection Start Date (QM Subsystem Interface) |
QEIFPRDATV |
|
DATS |
|
8 |
0 |
|
START_TIME |
Inspection Start Time (QM Subsystem Interface) |
QEIFPRZTV |
|
TIMS |
|
6 |
0 |
|
END_DATE |
Inspection End Date (QM Subsystem Interface) |
QEIFPRDATB |
|
DATS |
|
8 |
0 |
|
END_TIME |
Inspection End Time (QM Subsystem Interface) |
QEIFPRZTB |
|
TIMS |
|
6 |
0 |
|
INSPECTOR |
Name of the Inspector |
QINSPECTOR |
|
CHAR |
|
20 |
0 |
|
RES_ORG |
Data Origin |
QRES_ORG |
|
CHAR |
|
2 |
0 |
|
REMARK |
Inspection Description for Single Value |
QRES_REMAR |
|
CHAR |
|
40 |
0 |
|
CODE1 |
Code |
QCODE |
|
CHAR |
|
4 |
0 |
|
CODE_GRP1 |
Code Group |
QCODE_GROU |
|
CHAR |
|
8 |
0 |
|
CODE2 |
Code |
QCODE |
|
CHAR |
|
4 |
0 |
|
CODE_GRP2 |
Code Group |
QCODE_GROU |
|
CHAR |
|
8 |
0 |
|
CODE3 |
Code |
QCODE |
|
CHAR |
|
4 |
0 |
|
CODE_GRP3 |
Code Group |
QCODE_GROU |
|
CHAR |
|
8 |
0 |
|
CODE4 |
Code |
QCODE |
|
CHAR |
|
4 |
0 |
|
CODE_GRP4 |
Code Group |
QCODE_GROU |
|
CHAR |
|
8 |
0 |
|
CODE5 |
Code |
QCODE |
|
CHAR |
|
4 |
0 |
|
CODE_GRP5 |
Code Group |
QCODE_GROU |
|
CHAR |
|
8 |
0 |
|
ORIGINAL_INPUT |
Original Value Before Input Processing |
QORIGINAL_INPUT |
|
CHAR |
|
25 |
0 |
|
INPPROC_READY |
Input Processing Successfully Completed |
QINPPROC_READY |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
DIFF_DEC_PLACES |
Different Number of Decimal Places |
QDIFF_DEC_PLACES |
|
INT2 |
|
5 |
0 |
|
METHOD |
Inspection Method |
QPMETHODE |
|
CHAR |
|
8 |
0 |
|
METHOD_TXT |
Short Text for Inspection Method |
RMXTE_OTPT_QEIFPMTTXT |
|
CHAR |
|
40 |
0 |
|
MEAS_UNIT |
Unit of Measurement (Internal Code) |
QMEAS_UNIT |
|
CHAR |
|
6 |
0 |
|
MEAS_UNITT |
Short Text for Unit of Measure |
QMEASUNITT |
|
CHAR |
|
20 |
0 |
|
MSEHT |
Unit of Measurement Text (Maximum 10 Characters) |
MSEHT |
|
CHAR |
|
10 |
0 |
|
TARGET_VAL |
Target Value |
QTARGET_VA |
|
CHAR |
|
22 |
0 |
|
UP_TOL_LMT |
Upper Tolerance Limit |
QUPTOL_LMT |
|
CHAR |
|
22 |
0 |
|
LW_TOL_LMT |
Lower Tolerance Limit |
QLWTOL_LMT |
|
CHAR |
|
22 |
0 |
|
CODE_TXT1 |
Short Text for Code (Up to 40 Characters in Length) |
QTXT_CODE |
|
CHAR |
|
40 |
0 |
|
CODE_TXT2 |
Short Text for Code (Up to 40 Characters in Length) |
QTXT_CODE |
|
CHAR |
|
40 |
0 |
|
CODE_TXT3 |
Short Text for Code (Up to 40 Characters in Length) |
QTXT_CODE |
|
CHAR |
|
40 |
0 |
|
CODE_TXT4 |
Short Text for Code (Up to 40 Characters in Length) |
QTXT_CODE |
|
CHAR |
|
40 |
0 |
|
CODE_TXT5 |
Short Text for Code (Up to 40 Characters in Length) |
QTXT_CODE |
|
CHAR |
|
40 |
0 |
|
PHYNR |
Physical Sample Number |
QPHYSPRNR |
|
CHAR |
|
12 |
0 |
|
PRARTKTXT |
Short Text |
QKURZTEXT |
|
CHAR |
|
40 |
0 |
|
KTEXTLOS |
Inspection Lot in Trial Management |
RMXTE_KTEXTLOS |
|
CHAR |
|
40 |
0 |
|