Field Force
Field force table populated from Align. Mappings are delivered disabled by default. If field force object is brought into Nitro from Align, this mapping table can be enabled in the Align connector.
| Global ODS Field | Field Type |
Source Data Connector: Align Table: field_force_ods__aln |
|---|---|---|
| composite_key__v | varchar(18) |
|source_connector_name__v|vault_field_force_id__v|start_date__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console |
| native_id__v | varchar(125) | vault_field_force_id__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console |
| source_table_name__v | varchar(100) | field_force_ods__aln |
| field_force_type__v | varchar(1280) | type__aln |
| field_force_name__v | varchar(384) | field_force_name__v |
| field_force_description__v | varchar(3000) | description__aln |
| field_force_start_date__v | date | start_date__aln |
| field_force_end_date__v | date | end_date__aln |
| staus__v | varchar(1280) | status__v |
| field_force_external_id__v | varchar(360) | external_id__aln |
| start_date__v | timestamp | start_date__v |
| end_date__v | timestamp | end_date__v |
| last_modified_date__v | timestamp | modified_date__v |
