The following table below describes the mappings from the COMPASS data files into the MET/TEAM database. The MET/TEAM table column represents the MET/TEAM database and field. The Origin/Value column represents the COMPASS data file element or a fixed value that is written to the MET/team database field. The Remarks column identifies any special rules associated with the particular data element.
|
MET/TEAM Table |
Origin / Value |
Remarks |
|
CallSheetResults |
||
|
CallSheetResults.lRun
|
-1 |
|
|
CallSheetResults.cDescription
|
TestHeader.Label |
|
|
CallSheetResults.cWorkstationName
|
GeneralHeader.StationID |
|
|
CallSheetResults.cDataOrigin
|
Import |
|
|
CallSheetResults.cStatus
|
<calculated> |
pass/fail |
|
CallSheetResults.cCallSheetResultType
|
As Found |
|
|
CallSheetResults.nRunAtFacilityUID
|
Null |
|
|
CallSheetResults.nProcedureUID
|
COMPASS Import |
|
|
CallSheetResults.nTechnicianUID |
GeneralHeader.UserID |
|
|
CallSheetResults.nCallSheetResultOrdinal |
<calculated> |
row count |
|
CallSheetResultEx |
||
|
CallSheetResultEx.cField001
|
DUT.Identification |
|
|
CallSheetResultEx.cField002
|
DUTRaw1.Identification |
|
|
CallSheetResultEx.cField003
|
DUTRaw2.Identification |
|
|
CallSheetResultEx.cField004
|
DUTRaw3.Identification |
|
|
CallSheetResultEx.cField005
|
Ref.Identification |
|
|
CallSheetResultEx.cField006
|
RefRaw1.Identification |
|
|
CallSheetResultEx.cField007
|
RefRaw2.Identification |
|
|
CallSheetResultEx.cField008
|
RefRaw3.Identification |
|
|
CallSheetResultEx.cField009
|
AmbPres.Identification |
|
|
CallSheetResultEx.cField010
|
AmbTemp.Identification |
|
|
CallSheetResultEx.cField011
|
AmbRH.Identification |
|
|
CallSheetResultEx.cField012
|
GeneralHeader.UserID |
technician |
|
CallSheetResultEx.cField013 |
ID000501 |
test label |
|
CallSheetResultEx.cField014 |
ID001003 |
customer id |
|
CallSheetResultEx.cField015 |
DUT.CalibrationCoefficient1 |
|
|
CallSheetResultEx.cField016 |
DUT.CalibrationCoefficient2 |
|
|
CallSheetResultEx.cField017 |
DUT.CalibrationCoefficient3 |
|
|
CallSheetResultEx.cField018 |
DUT.CalibrationCoefficient4 |
|
|
CallSheetResultEx.cField019 |
DUT.CalibrationCoefficient5 |
|
|
CallSheetResultEx.cField020 |
DUT.CalibrationCoefficient6 |
|
|
CallSheetResultEx.mField003
|
100001=Point|100002=Date|100003=... |
headers |
|
CallSheetStandardLink |
||
|
CallSheetStandardLink.nAssetUID |
DUTRaw1.Identification |
|
|
CallSheetStandardLink.nAssetUID |
DUTRaw2.Identification |
|
|
CallSheetStandardLink.nAssetUID |
DUTRaw3.Identification |
|
|
CallSheetStandardLink.nAssetUID |
Ref.Identification |
|
|
CallSheetStandardLink.nAssetUID |
RefRaw1.Identification |
|
|
CallSheetStandardLink.nAssetUID |
RefRaw2.Identification |
|
|
CallSheetStandardLink.nAssetUID |
RefRaw3.Identification |
|
|
CallSheetStandardLink.nAssetUID |
AmbPres.Identification |
|
|
CallSheetStandardLink.nAssetUID |
AmbTemp.Identification |
|
|
CallSheetStandardLink.nAssetUID |
AmbRH.Identification |
|
|
Points |
||
|
Points.nPointOrdinal |
<calculated> |
row count |
|
Points.cPointDescription |
ID100010 |
cardinal point |
|
Points.tPointDateTime |
ID100002 + ' ' +
ID100003 |
point date/time |
|
Points.nCardinalPoint |
ID100010 |
cardinal point |
|
Points.nReference |
ID200002 |
reference |
|
Points.nUUT |
ID300002 |
dut |
|
Points.cPointPassFailStatus |
<calculated> |
from ID100005 |
|
Points.nUUTRange |
ID300004-ID300003 |
max-min |
|
Points.cPointLabel |
Numeric |
|
|
PointAmbients |
||
|
PointAmbients.nAmbientPressure |
ID100011 |
ambient pressure |
|
PointAmbients.nAmbientTemperature |
ID100012 |
ambient temperature |
|
PointAmbients.nAmbientHumidity |
ID100013 |
ambient humidity |
|
PointExStrings |
||
|
PointExStrings.cField009 |
ID100001 |
test point |
|
PointExStrings.cField021 |
ID100006 |
SetPointTemperature |
|
PointExStrings.cField022 |
ID100007 |
Final Temp Out |
|
PointExStrings.cField023 |
ID100008 |
SetPointLinePressure |
|
PointExStrings.cField024 |
ID100009 |
Final Line Pressure |
|
PointExNumerics |
||
|
PointExNumerics.nField006 |
ID300002-ID200002 |
deviation (dut-ref) |
|
PointExNumerics.nField010 |
ID200002 |
reference |
|
PointExNumerics.nField027 |
ID300007 |
DUT Raw Output 1 |
|
PointExNumerics.nField029 |
ID300002 |
dut |
|
PointTolerances |
||
|
PointTolerances.cToleranceReference |
ID200015 |
ref tol |
|
PointTolerances.nError |
ID301002 |
error |
|
PointTolerances.nReadingErrorPercent |
ID301003 |
rel err |
|
PointTolerances.nTolerance |
ID301004 |
tolerance |
|
PointTolerances.nToleranceNegative |
ID300002-ID301004 |
dut-tol |
|
PointTolerances.nTolerancePositive |
ID300002+ID301004 |
dut+tol |
|
PointStatistics |
||
|
PointStatistics.nNumberOfSamplesUUT |
ID300005 |
number of
measurements |
|
PointStatistics.nUUTStandardDeviation |
ID300006 |
standard deviation |
|
PointStatistics.lNoisy |
<calculated> |
from ID100005 |
|
PointStatistics.lReliable |
<calculated> |
from ID100005 |
|
PointExLogicals |
||
|
PointExLogicals.lField001 |
0 |
corr flag |
|
PointExLogicals.lField002 |
-1 |
measurement flag |
|
PointUncertainties |
||
|
PointUncertainties.nLowerLimit |
ID200002-ID301004 |
ref-tol |
|
PointUncertainties.nUpperLimit |
ID200002+ID301004 |
ref+tol |
Related Topics