Touchstone 4.0 Database Documentation
tImportMappingSet Table
Description
Used during import, this table provides mapping between the fields in the source input file to the columns in the target database table.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows24
Data Space Used3,048.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ImportMappingSetSID

Unique system-generated sequential identifier for the mapping set record using during import.

Integer4   
 ContractTypeCode

Code that represent the contract type.

For a complete list of codes, see tContractType Table.

VarChar10   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 NameName of the mapping set.VarChar255  
 Value

XML string that defines mapping set. Used internally by Touchstone.

Xml16  
 IsDefault

Indicates whether the mapping set is the default.

  • 1 = Yes (default)
  • 0 = No (not default)
Boolean1
((0))
 
 EnteredDate

Date and time when the import mapping set was created.

VarWChar10 
(getutcdate())
 
 EditedDate

Date and time when the import mapping set was last modified.

VarWChar10 
(getutcdate())
 
Check Constraints
NameDescriptionExpression
CKC_ISDEFAULT_TIMPORTM 
([IsDefault] IS NULL OR [IsDefault]>=(0) AND [IsDefault]<=(1))
Objects that depend on tImportMappingSet
 Database ObjectObject TypeDescriptionDep Level
tImportDefault tabletImportDefaultTableProvides the default setting information to be used for import.1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.