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