Linking data between tables in MET/TEAM is often
done via the UID of the other record. To establish a link between tables
during the import, for example to specify the manufacturer for an Asset to be
imported, the Assets.nManufacturerUID column should be added to the definition.
The data for Assets.nManufacturerUID should be the actual facility name of the
manufacturer, not the reference number normally stored in nManufacturerUID.
In order to establish the link, the referenced item
has to be located or created. In order to do so, all fields that uniquely
identify the referenced item have to be specified within that one column of
data in the import data file. In case two fields are needed to uniquely
identify the referenced record, the data elements are separated by a
double-colon (::). This method is currently employed when referencing Units and
Service Types. If the data column does not contain a double-colon, the second
part of the data is defaulted. The unit prefix defaults to no prefix, the service mode (ServiceTypes.cServiceType) defaults to
Calibration.
|
Addresses.nFacilityUID |
Facilities.cFacilityName |
|
AssetServices.nServiceTypeUID |
ServiceTypes.cServiceName::ServiceTypes.cServiceType |
|
Assets.nAssignedFacUID |
Facilities.cFacilityName |
|
Assets.nAuthorizedFacUID |
Facilities.cFacilityName |
|
Assets.nCategoryUID |
Category.cDescription |
|
Assets.nDepartmentUID |
Facilities.cFacilityName |
|
Assets.nFacilityUID |
Facilities.cFacilityName |
|
Assets.nInventoryByUID |
Users.cUsername |
|
Assets.nMaintenanceFacUID |
Facilities.cFacilityName |
|
Assets.nManufacturerUID |
Facilities.cFacilityName |
|
Assets.nParentUID |
Assets.cBarcode |
|
Assets.nSubCategoryUID |
SubCategory.cDescription |
|
CallSheetStandardLink.nAssetUID |
Assets.cBarcode |
|
CallSheetPartsLink.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
CallSheetResults.nProcedureUID |
Procedures.cProcedureName |
|
CallSheetResults.nRunAtFacilityUID |
Facilities.cFacilityName |
|
CallSheetResults.nTechnicianUID |
Users.cUsername |
|
CallSheets.nAssignedTechUID |
Users.cUsername |
|
CallSheets.nCategoryUID |
Category.cDescription |
|
CallSheets.nDepartmentUID |
Facilities.cFacilityName |
|
CallSheets.nInvoiceUID |
Invoices.cInvoiceNo |
|
CallSheets.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
CallSheets.nProcedureUID |
Procedures.cProcedureName |
|
CallSheets.nQCApprovedByUID |
Users.cUsername |
|
CallSheets.nReturnedByUID |
Users.cUsername |
|
CallSheets.nSubCategoryUID |
SubCategory.cDescription |
|
CallSheets.nSubContractorUID |
Facilities.cFacilityName |
|
CallSheets.nTechnicianUID |
Users.cUsername |
|
CallSheets.nWorkingFacilityUID |
Facilities.cFacilityName |
|
Contacts.nManagerUID |
Contacts.cEmail2 |
|
Contacts.nUserUID |
Users.cUsername |
|
Facilities.nCategoryUID |
Category.cDescription |
|
Facilities.nParentFacilityUID |
Facilities.cFacilityName |
|
Facilities.nSubCategoryUID |
SubCategory.cDescription |
|
JobNumbers.nFundingAuthorityUID |
Facilities.cFacilityName |
|
Labor.nCategoryUID |
Category.cDescription |
|
Labor.nJobNumberUID |
JobNumbers.cJobOrderNumber |
|
Labor.nSubCategoryUID |
SubCategory.cDescription |
|
Labor.nUserUID |
Users.cUsername |
|
Parts.nCategoryUID |
Category.cDescription |
|
Parts.nInventoryByUID |
Users.cUsername |
|
Parts.nManufacturerUID |
Facilities.cFacilityName |
|
PointAmbients.nAmbientHumidityUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointAmbients.nAmbientPressureUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointAmbients.nAmbientTemperatureUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField001UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField002UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField003UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField004UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField005UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField006UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField007UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField008UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField009UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField010UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField011UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField012UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField013UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField014UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField015UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField016UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField017UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField018UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField019UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField020UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField021UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField022UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField023UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField024UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField025UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField026UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField027UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField028UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField029UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField030UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField031UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField032UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField033UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField034UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField035UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField036UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField037UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField038UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField039UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField040UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField041UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField042UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField043UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField044UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField045UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField046UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField047UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField048UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField049UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField050UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField051UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField052UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField053UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField054UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField055UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField056UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField057UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField058UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField059UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointExNumerics.nField060UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointReadings.nAssetUID |
Assets.cBarcode |
|
PointReadings.nReadingUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nCardinalPointUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nCorrectionUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nSystemAccuracyUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nUUTRangeUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Points.nUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMaximumReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMaximumUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMinimumReferenceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nMinimumUUTUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReference2StandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceRaw2StandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceRawStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nReferenceStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nSampleRateUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nUUTRawStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointStatistics.nUUTStandardDeviationUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nErrorUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nReferenceToleranceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceErrorUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceNegativeUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nTolerancePositiveUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointTolerances.nToleranceUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nGuardBandLowerUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nGuardBandUpperUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nLowerLimitUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nModifier1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nModifier2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nS1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nS2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyDominantUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyExpandedUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter10UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter1UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter2UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter3UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter4UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter5UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter6UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter7UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter8UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyParameter9UnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyStandardUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUncertaintyUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
PointUncertainties.nUpperLimitUnitUID |
Units.cBaseUnit::Units.cPrefix |
|
Procedures.nApprovedByUID |
Users.cUsername |
|
Procedures.nAttTemplateUID |
Files.cFileName |
|
Procedures.nCategoryUID |
Category.cDescription |
|
Procedures.nProcedureFileUID |
Files.cFileName |
|
ToolAssignments.nContactUID |
Contacts.cEmail2 |
|
TypeProcedureDefaults.nAttTemplateUID |
Files.cFileName |
|
Types.nCategoryUID |
Category.cDescription |
|
Types.nManufacturerUID |
Facilities.cFacilityName |
|
Types.nSubCategoryUID |
SubCategory.cDescription |
|
Users.nManagerUID |
Users.cUsername |
<any>.nAddFacilityUID
<any>.nAddUserUID
<any>.nUpdateFacilityUID
<any>.nUpdateUserUID
<any>.nImportUID
AssetEx.nAssetUID
AssetLog.nAssetUID
Assets.nTypeUID
AssetServices.nAssetUID
CallSheetEx.nCallSheetUID
CallSheetPartsLink.nCallSheetUID
CallSheetPartsLink.nPartUID
CallSheetResults.lRun
CallSheetResults.nCallSheetUID
CallSheets.nAssetUID
CallSheets.nCalendarUID
CallSheets.nCallSheetAttributeUID
CallSheets.nGroupUID
CallSheets.nRevision
CallSheets.nTypeUID
CallSheetStandardLink.nCallSheetUID
FacilityContactLink.nContactUID
FacilityContactLink.nFacilityContactLinkUID
FacilityContactLink.nFacilityUID
FacilityEx.nFacilityUID
FacilityUserLink.nFacilityUID
FacilityUserLink.nUserUID
Files.nManualTemplateUID
JobNumbers.nProjectUID
Labor.nCallSheetUID
PointAmbient.nPointUID
PointExLogicals.nPointUID
PointExNumerics.nPointUID
PointExStrings.nPointUID
PointReadings.nPointUID
Points.nCallSheetResultUID
Points.nTemplateItemUID
PointStatistics.nPointUID
PointTolerances.nPointUID
PointUncertainties.nPointUID
ServiceTypes.nServiceTypeUID
ToolAssignmentEx.nToolAssignmentUID
ToolAssignments.nAssetUID
TypeProcedureDefaults.nProcedureUID
TypeProcedureDefaults.nTypeUID
Types.nImageUID
Related Topics