Stores mappings between fields in input files and columns in target databases for import jobs.
Touchstone 2022 Database Reference
tImportMappingSet Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 28 |
| Data Space Used | 3,456.00 KB |
| Index Space Used | 40.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ImportMappingSetSID | Unique system-generated sequential identifier for the mapping set record using during import. | int | 4 | |||
| ContractTypeCode | Code that represent the contract type. For a complete list of codes, see tContractType Table. | varchar | 10 | ||||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| Name | Name of the mapping set. | varchar | 255 |  | |||
| Value | XML string that defines mapping set. Used internally by Touchstone. | xml | 0 | | |||
| IsDefault | Indicates whether the mapping set is the default.
| bit | 1 | | ((0)) | ||
| EnteredDate | Date and time when the import mapping set was created. | date | 8 | (getutcdate()) | |||
| EditedDate | Date and time when the import mapping set was last modified. | date | 8 | (getutcdate()) | |||
| DomainUserName | User name of the user that created the mapping set. | varchar | 511 | | |||
| IsLocked | Indicates whether the mapping set is locked by the user specified in the DomainUserName column.
| bit | 1 | ((0)) | |||
| Signature | System-generated sequential code for the import record. | nvarchar | 16 | | |||
| SignatureHash | System-generated code that represents the signature. For example: 0x37E1ABBA78E9A22E6DE6CBC47F573729. | varbinary | 8000 | | (hashbytes('MD5',[Signature])) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tImportDefault | Table | Provides the default settings for import jobs. | 1 |