dspCompose

Org Unit Objects Generated by dspCompose™

When a user generates a template that has Org Units assigned, dspCompose™ creates the standard set of objects in the cMass_Data database, but also adds these Org Unit related objects to the ttTemplateObjects table in the cMass database.

Org Unit Table

dspCompose™ creates an org unit table with the naming convention: tt + ttTemplate.ScriptID + 'OrgUnit' , for example: ttChangeMaterial1OrgUnit  (where "ttChangeMaterial1" is the TemplateScriptID).

This table contains the following columns:

  • RequestOrgUnitID  (unique identifier; Primary Key)
  • RequestID
  • boaUserID
  • Each Org Unit on the Template (field names are the TemplateColumn values for the Org Units)

Org Unit View

dspCompose™ creates an org unit view for each org unit on the template with the naming convention: web + ttTemplate.ScriptID + 'Request' + ttTemplateOrgUnit.OrgUnit + 'InsSel'.

For example, for

webChangeMaterial1RequestPlantInsSel

  • ChangeMaterial1 is the ScriptID

  • Plant is the ttTemplateOrgUnit.OrgUnit.

For

webChangeMaterial1RequestSalesOrgInsSel

  • ChangeMaterial1 is the ScriptID

  • SalesOrg is the ttTemplateOrgUnit.OrgUnit.

Each Org Unit view contains the following columns:

  • RequestID
  • TemplateID
  • boaUserID
  • Org Unit (field name is the value of TemplateColumn for the Org Unit)

A Combined Org Unit View

dspCompose™ creates a combined org unit view for the template with the naming convention: web + ttTemplate.ScriptID + 'RequestOrgUnitInsSel’, for example: webChangeMaterial1RequestOrgUnitInsSel  (where "ttChangeMaterial1" is the ScriptID).

The Org Unit view contains the following columns:

  • RequestID
  • boaUserID
  • Each Org Unit on the Template (field names are the TemplateColumn values for the Org Unit)

Security View

dspCompose™ creates a security view for the template with the naming convention: web + ttTemplate.ScriptID + ‘SecuritySel’, for example: webChangeMaterial1SecuritySel  (where "ttChangeMaterial1" is the ScriptID).

The security view contains the following columns:

  • boaUserID
  • RequestID
  • ID - the ID for the record in the tt… Data table for the Templatecss par