UTAS (User Territory Account Share) Exclusion Table

The crm_utas_exclusion__v table allows admins to name specific territories to be skipped in the star load job, which allows the job to run faster. UTAS is used by the CRM Star Load job to assign territories to activities based on the User, Account, and Date the activity took place. Any territory marked active in the table is skipped in UTAS, and activities are not assigned to that territory:

  • Connector - nitro_reference_data__v
  • Table - crm_utas_exclusion__v
  • Delimeter - ‘,’
  • skipHeader - true
  • primaryKey - composite_key__v
  • textQualifier - ‘“‘
  • ods loadPattern - pt_ftp_ods_upsertload__v

Field

Type

Definition

organization_id__v

varchar(18)

 

crm_territory_id__v

varchar(18)

 

reason_for_exclusion__v

varchar(255)

 

enabled__v

boolean

 

composite_key__v

(varchar39)

|organization_id__v|crm_territory_id__v|