FS 291985 EPOD Job Groups: Difference between revisions
From Calidus HUB
(Slight format change) |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 4: | Line 4: | ||
{{#vardefine:System|''CALIDUS'' EPOD}} | {{#vardefine:System|''CALIDUS'' EPOD}} | ||
{{#vardefine:Doc_Title|Job Groups}} | {{#vardefine:Doc_Title|Job Groups}} | ||
{{#vardefine:Version|0 | {{#vardefine:Version|1.0}} | ||
{{#vardefine:Date| | {{#vardefine:Date|14th September 2011}} | ||
{{#vardefine:Reference|291985}} | {{#vardefine:Reference|291985}} | ||
</div> | </div> | ||
| Line 37: | Line 37: | ||
The Work Report will use the Job Group Format, Logo and Description in preference to the Site values, if there is a Job Group. | The Work Report will use the Job Group Format, Logo and Description in preference to the Site values, if there is a Job Group. | ||
An additional table User Access Groups will be added which will allow users to be limited to specific job groups. Note that these changes will affect the administrative interface only, at this point. | |||
== Scope == | == Scope == | ||
| Line 79: | Line 80: | ||
==New Procedures== | ==New Procedures== | ||
New procedures must be added to the database as per the DAL interface, to Create, Find, Edit and Delete Job Groups | New procedures must be added to the database as per the DAL interface, to Create, Find, Edit and Delete Job Groups | ||
==New Table EPL_USER_ACCESS_GROUPS== | |||
A new table must be added to validate user access against job groups. | |||
The table will be created as follows: | |||
<table border="1"> | |||
<tr bgcolor="lightgrey"> | |||
<td>Element</td><td>Type</td><td>Description</td> | |||
</tr> | |||
<tr> | |||
<td>(PK) EPL_SITE_ID</td><td>NCHAR (10)</td><td>Site or Warehouse code.</td> | |||
</tr> | |||
<tr> | |||
<td>(PK) EPL_JOB_GROUP</td><td>NCHAR (5)</td><td>Job Group.</td> | |||
</tr> | |||
<tr> | |||
<td>(PK) EPL_USER_ID</td><td>NCHAR(10)</td><td>User to be granted access to this group</td> | |||
</tr> | |||
</table> | |||
Note: There will be a 1:* relationship between users and access groups to allow for a user to have more than one access group. | |||
==New Procedures== | |||
New procedures must be added to the database as per the DAL interface, to Create, Find, Edit and Delete User Access Groups | |||
=Server Changes= | =Server Changes= | ||
== | ==JOB GROUP (DAL)== | ||
A new DAL object must be added for the Job Groups table, as per the standard processing. This must allow: | A new DAL object must be added for the Job Groups table, as per the standard processing. This must allow: | ||
*Finding Job Groups for a specific Site | *Finding Job Groups for a specific Site | ||
| Line 94: | Line 118: | ||
{{Note}} It must also be possible to edit the Details and Configuration elements of the Job Group table separately, as these will be modified through different screens. | {{Note}} It must also be possible to edit the Details and Configuration elements of the Job Group table separately, as these will be modified through different screens. | ||
==USER ACCESS GROUPS (DAL)== | |||
A new DAL object must be added for the User Access Group table, as per the standard processing. This must allow: | |||
*Finding User Access Group for a specific Site and User | |||
*Editing a User Access Group | |||
*Creating a new User Access Group | |||
*Deleting an existing User Access Group | |||
==Other Changes== | |||
The existing DAL’s will need to be modified to allow for a set of user access groups to be passed through and will return this set of data, this will need to be changed for both the Stored Procedures and the DAL’s for the following objects: | |||
*Jobs | |||
*Services | |||
*Service_Job | |||
=Client-Server Communications= | =Client-Server Communications= | ||
| Line 106: | Line 143: | ||
=Admin Changes= | =Admin Changes= | ||
==Services Maintenance== | ==Services Maintenance== | ||
When creating a new Service, the user may enter a Job Group. This should be through a DDL of the available Job Groups for that user's | When creating a new Service, the user may enter a Job Group. This should be through a DDL of the available Job Groups for that user's profile within User Access Groups. | ||
When finding Services, the Job Group filter should be a DDL of the available Job Groups for that user access profile, with an optional blank entry. Note that search should produce results for all jobs groups that the user has access to. | |||
When finding Services, the Job Group filter should be a DDL of the available Job Groups for that user | When editing an existing Service, the Job Group should be a DDL of the available Job Groups for that user profile. | ||
The Job Group DDL should show the Description of the Job Group, sequenced by Job Group. | |||
When editing an existing Service, the Job Group should be a DDL of the available Job Groups for that user | When data is displayed in the Services grid, the Job Group for the specified Job must be translated into the Description of the Job Group from the new table. If there is no job group, this should be displayed as blank space. | ||
The Job Group DDL should show the Description of the Job Group, sequenced by Job Group | |||
When data is displayed in the Services grid, the Job Group for the specified Job must be translated into the Description of the Job Group from the new table. If there is no job group, this should be displayed as blank space. | |||
==Service Details== | ==Service Details== | ||
==Jobs Maintenance== | ==Jobs Maintenance== | ||
When creating a new Job, the user may enter a Job Group. This should be through a DDL of the available Job Groups for that user | When creating a new Job, the user may enter a Job Group. This should be through a DDL of the available Job Groups for that user access profile. | ||
When finding Jobs, the Job Group filter should be a DDL of the available Job Groups for that user access profile, with an optional blank entry. Note that search should produce results for all jobs groups that the user has access to. | |||
When finding Jobs, the Job Group filter should be a DDL of the available Job Groups for that user | When editing an existing Job, the Job Group should be a DDL of the available Job Groups for that user access profile. | ||
The Job Group DDL should show the Description of the Job Group, sequenced by Job Group. | |||
When editing an existing Job, the Job Group should be a DDL of the available Job Groups for that user | When data is displayed in the Jobs grid, the Job Group for the specified Job must be translated into the Description of the Job Group from the new table. If there is no job group, this should be displayed as blank space. | ||
The Job Group DDL should show the Description of the Job Group, sequenced by Job Group, | |||
==Load Maintenance== | |||
No Changes, for the time being. This is so that all Job Groups can be planned onto any load. | |||
==Isotrak Service Upload== | ==Isotrak Service Upload== | ||
| Line 236: | Line 268: | ||
==POD Production== | ==POD Production== | ||
This page must be modified to take the Format, Logo and Description from the Job Group record (if there is one), or then from the Site record. | This page must be modified to take the Format, Logo and Description from the Job Group record (if there is one), or then from the Site record. | ||
==USER ACCESS MAINTENANCE== | |||
This page will only be available to admin users. | |||
===Admin Functions:=== | |||
Users will be able to search for users or job groups and will be displayed all data for that user or job group. The two fields are User and Job Group. | |||
Users can add or delete job groups. | |||
When adding data, admin users will have a dropdown list of all users, and a dropdown list of their current Job Groups. By default admin users will have access to all job groups. | |||
When deleting data users will be prompted for confirmation. If there is only one user assigned to a job group and there are still jobs associated to that group this will not allow deletion. | |||
=PDA= | =PDA= | ||
| Line 273: | Line 314: | ||
|Rev2=Steve McCartney | |Rev2=Steve McCartney | ||
|Rev2Title=OBS Manager | |Rev2Title=OBS Manager | ||
|Rev3=Matt Turner | |||
|Rev3Title=OBS Sales | |||
}}</div> | }}</div> | ||
[[Category:SM Fleet FS]] | [[Category:SM Fleet FS]] | ||
Latest revision as of 17:51, 26 September 2011
SM Fleet
Job Groups
CALIDUS EPOD
14th September 2011 - 1.0
Reference: FS 291985
Note: The deletion of a Job Group can only occur if there are no jobs assigned to this group.
