Mass Maintenance
When a user generates a template that has Org Units assigned, Mass Maintenance 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
Mass Maintenance 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
Mass Maintenance 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
Mass Maintenance 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
Mass Maintenance 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
