276896 - Revision history

DuttonT: /* Client Requirement */

2011-07-08T10:04:49Z

Client Requirement

← Older revision		Revision as of 12:04, 8 July 2011
Line 23:		Line 23:

	'''DHL:'''		'''DHL:'''

	Clarification.		Clarification.

	Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..		Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..

	'''OBS:'''		'''OBS:'''

	Fine.		Fine.

	'''DHL:'''		'''DHL:'''

	Clarification.		Clarification.

	Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip		Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip

DuttonT: /* Client Requirement */

2011-07-08T10:04:19Z

Client Requirement

← Older revision		Revision as of 12:04, 8 July 2011
Line 30:		Line 30:
	Clarification.		Clarification.
	Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip		Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip

	# '''Locations '''		# '''Locations '''
	#* Add option to Inactivate		#* Add option to Inactivate

DuttonT: /* Client Requirement */

2011-07-08T10:03:49Z

Client Requirement

← Older revision		Revision as of 12:03, 8 July 2011
Line 23:		Line 23:

	'''DHL:'''		'''DHL:'''
	#Clarification.		Clarification.
	#Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..		Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..
	#'''OBS:'''		'''OBS:'''
	#Fine.		Fine.
	'''DHL:'''		'''DHL:'''
	#Clarification.		Clarification.
	#Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip		Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip
	# '''Locations '''		# '''Locations '''
	#* Add option to Inactivate		#* Add option to Inactivate

DuttonT: /* Client Requirement */

2011-07-08T10:03:08Z

Client Requirement

← Older revision		Revision as of 12:03, 8 July 2011
Line 21:		Line 21:
	#* Add restriction to any LOV on Drivers		#* Add restriction to any LOV on Drivers
	#* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.		#* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.
	#'''DHL:'''
			'''DHL:'''
	#Clarification.		#Clarification.
	#Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..		#Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..
	#'''OBS:'''		#'''OBS:'''
	#Fine.		#Fine.
	#'''DHL:'''		'''DHL:'''
	#Clarification.		#Clarification.
	#Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip		#Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip

DuttonT: /* Client Requirement */

2011-07-08T10:02:25Z

Client Requirement

← Older revision		Revision as of 12:02, 8 July 2011
Line 21:		Line 21:
	#* Add restriction to any LOV on Drivers		#* Add restriction to any LOV on Drivers
	#* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.		#* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.
			#'''DHL:'''
	'''DHL:'''		#Clarification.
			#Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..
	Clarification.		#'''OBS:'''
			#Fine.
	Agency Drivers: Pop list, Individual Agency set up as a driver name, enter the agency name forces an additional field in which the drivers name is entered as Free Text and stored only against that trip not against the Driver table..		#'''DHL:'''
			#Clarification.
			#Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip
	'''OBS:'''

	Fine.

	'''DHL:'''

	Clarification.

	Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip
	# '''Locations '''		# '''Locations '''

	#* Add option to Inactivate		#* Add option to Inactivate
	#* Restrict Add/Update to only privileged users controlled by parameter		#* Restrict Add/Update to only privileged users controlled by parameter

DuttonT: /* Client Requirement */

2011-07-08T10:01:03Z

Client Requirement

← Older revision		Revision as of 12:01, 8 July 2011
Line 38:		Line 38:

	Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip		Subcontractor Drivers: Set carrier up as Free Text, any entry made is not stored in Driver table only store against the individual trip


	# '''Locations '''		# '''Locations '''

	* Add option to Inactivate		#* Add option to Inactivate
	* Restrict Add/Update to only privileged users controlled by parameter		#* Restrict Add/Update to only privileged users controlled by parameter
	* Restrict non-privileged users to viewing only Active locations without update ability.		#* Restrict non-privileged users to viewing only Active locations without update ability.

	Execution Screen needs to be included in solution for lists of LOV etc		Execution Screen needs to be included in solution for lists of LOV etc

DuttonT: /* Solution */

2011-07-08T10:00:26Z

Solution

← Older revision		Revision as of 12:00, 8 July 2011
Line 51:		Line 51:

	# '''Hauliers / Carriers'''		# '''Hauliers / Carriers'''
	* A new column called ‘INACTIVE’ will be added to table ‘RES_CARRIER’. It will accept values of ‘Y’ or ‘N’, where ‘Y’ indicates that the carrier is inactive and ‘N’ indicates that the carrier is active. This new field will be added to the ‘Carrier’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Carrier’ screen. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.		#* A new column called ‘INACTIVE’ will be added to table ‘RES_CARRIER’. It will accept values of ‘Y’ or ‘N’, where ‘Y’ indicates that the carrier is inactive and ‘N’ indicates that the carrier is active. This new field will be added to the ‘Carrier’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Carrier’ screen. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.
	* An active/inactive/all radio button filter will be added to the top of this screen.		#* An active/inactive/all radio button filter will be added to the top of this screen.
	* The list of values for the carriers will only show the carriers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’, ‘Tracking’ and ‘Fixed Routes Maintenance’.		#* The list of values for the carriers will only show the carriers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’, ‘Tracking’ and ‘Fixed Routes Maintenance’.
	* The carriers that will employ external drivers will need to be setup as drivers because the drivers will be automatically populated with the carrier when the carrier is assigned to a trip, the carrier ID may be the forename and the carrier name may be the surname.		#* The carriers that will employ external drivers will need to be setup as drivers because the drivers will be automatically populated with the carrier when the carrier is assigned to a trip, the carrier ID may be the forename and the carrier name may be the surname.
	* A flag on the carrier table will indicate if the carrier employs external drivers.		#* A flag on the carrier table will indicate if the carrier employs external drivers.
	# '''Trailers'''		# '''Trailers'''
	* The column ‘INACTIVE’ already exists on the table ‘RES_TRAILER’ so will not be added. A field called ‘Inactive’ will be added to ‘Trailers’ page of the ‘Resource Maintenance’ screen. It will also be added to the ‘Insert Trailer’ and ‘Edit Trailer’ screens.		#* The column ‘INACTIVE’ already exists on the table ‘RES_TRAILER’ so will not be added. A field called ‘Inactive’ will be added to ‘Trailers’ page of the ‘Resource Maintenance’ screen. It will also be added to the ‘Insert Trailer’ and ‘Edit Trailer’ screens.
	* An active/inactive/all radio button filter will be added to the top of this screen.		#* An active/inactive/all radio button filter will be added to the top of this screen.
	* The list of values for trailers will only show the trailers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’.		#* The list of values for trailers will only show the trailers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’.
	# '''Tractors'''		# '''Tractors'''
	* The column ‘INACTIVE’ already exists on the table ‘RES_TRACTOR’ so will not be added. A field called ‘Inactive’ already exists in the ‘Tractors’ page of the ‘Resource Maintenance’ screen and the ‘Insert Tractor’ and ‘Edit Tractor’ screens. An active/inactive/all radio button filter will be added to the top of this screen.		#* The column ‘INACTIVE’ already exists on the table ‘RES_TRACTOR’ so will not be added. A field called ‘Inactive’ already exists in the ‘Tractors’ page of the ‘Resource Maintenance’ screen and the ‘Insert Tractor’ and ‘Edit Tractor’ screens. An active/inactive/all radio button filter will be added to the top of this screen.
	* Selection lists in ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’ will be restricted to select active tractors only.		#* Selection lists in ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’ will be restricted to select active tractors only.
	# '''Drivers'''		# '''Drivers'''
	* A new column called ‘INACTIVE’ will be added to table ‘RES_PERSON’. It will accept values of ‘Y’ or ‘N, where ‘Y’ indicates that the driver is inactive and ‘N’ indicates that the driver is active. This new field will be added to the ‘Drivers’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Driver’ and ‘Edit Driver’ screens. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.		#* A new column called ‘INACTIVE’ will be added to table ‘RES_PERSON’. It will accept values of ‘Y’ or ‘N, where ‘Y’ indicates that the driver is inactive and ‘N’ indicates that the driver is active. This new field will be added to the ‘Drivers’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Driver’ and ‘Edit Driver’ screens. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.
	* An active/inactive/all radio button filter will be added to the top of this screen.		#* An active/inactive/all radio button filter will be added to the top of this screen.
	* The list of values for the drivers will only show the drivers that are not inactive.		#* The list of values for the drivers will only show the drivers that are not inactive.
	* A tick box to identify Agencies set up as drivers will be added to the DRIVERS resource screen.		#* A tick box to identify Agencies set up as drivers will be added to the DRIVERS resource screen.
	* If the Driver selected from a pop list has the Agency driver flag set to ‘Y’ then the user will be prompted to enter the Agency Driver’s name in a free text pop up in the ‘Trip Planning’, ‘Trip Manipulation’, Execution’,‘Trip Summary’, ‘Trip Waterfall’ or ‘Trip Debrief’ screens.		#* If the Driver selected from a pop list has the Agency driver flag set to ‘Y’ then the user will be prompted to enter the Agency Driver’s name in a free text pop up in the ‘Trip Planning’, ‘Trip Manipulation’, Execution’,‘Trip Summary’, ‘Trip Waterfall’ or ‘Trip Debrief’ screens.
	* If a Carrier is set to Freetext then the Driver entered will not be saved to the Drivers table it will now populate the columns against the Trip record.		#* If a Carrier is set to Freetext then the Driver entered will not be saved to the Drivers table it will now populate the columns against the Trip record.
	* If the driver is deleted from a trip in the ‘Trip Waterfall’ screen then the external driver will be deleted from the trip.		#* If the driver is deleted from a trip in the ‘Trip Waterfall’ screen then the external driver will be deleted from the trip.
			#* '''''Programmers Note''': The external driver information will be stored in a new column called ‘EXTERNAL_DRIVER’ on table ‘SCH_TRIP’. ''
	* '''''Programmers Note''': The external driver information will be stored in a new column called ‘EXTERNAL_DRIVER’ on table ‘SCH_TRIP’. ''		#* '''''Any report which reports Driver Name will now only display the Agency Name or DHL Own Drivers. Subcontractors with FreeText Drivers will not be displayed. '''''

	* '''''Any report which reports Driver Name will now only display the Agency Name or DHL Own Drivers. Subcontractors with FreeText Drivers will not be displayed. '''''

	# '''Locations'''		# '''Locations'''
			#* The column ‘INACTIVE’ already exists on the table ‘GEO_LOCATION’ so will not be added. Radio buttons called ‘Active’, ‘Inactive’ and ‘All’ already exist in the ‘Locations’ screen.
	* The column ‘INACTIVE’ already exists on the table ‘GEO_LOCATION’ so will not be added. Radio buttons called ‘Active’, ‘Inactive’ and ‘All’ already exist in the ‘Locations’ screen.		#* A new system function called ‘GEO_EDIT_LOCATIONS’ for user groups will be created to control user ability to add or update details in the ‘Locations’ screen.
	* A new system function called ‘GEO_EDIT_LOCATIONS’ for user groups will be created to control user ability to add or update details in the ‘Locations’ screen.		#* Only users that have access to this system function will be able to edit details in the screen, otherwise users will only to be able to view active locations.
	* Only users that have access to this system function will be able to edit details in the screen, otherwise users will only to be able to view active locations.

	== Scope ==		== Scope ==

DuttonT: /* Solution */

2011-07-08T09:59:19Z

Solution

DuttonT: /* Client Requirement */

2011-07-08T09:58:27Z

Client Requirement

← Older revision		Revision as of 11:58, 8 July 2011
Line 15:		Line 15:
	#* Add restriction to any LOV on trailers table		#* Add restriction to any LOV on trailers table
	# '''Tractors '''		# '''Tractors '''
	* Add Active/Inactive filter to maintenance form		#* Add Active/Inactive filter to maintenance form
	# '''Drivers '''		# '''Drivers '''
	* Add option to Inactivate		#* Add option to Inactivate
	* Add Active/Inactive filter to maintenance form		#* Add Active/Inactive filter to maintenance form
	* Add restriction to any LOV on Drivers		#* Add restriction to any LOV on Drivers
	* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.		#* Add Agency flag on Drivers so that when used it will force additional Free Text to be entered and stored on new field against SCH_TRIP in order to cater for Agency drivers.

	'''DHL:'''		'''DHL:'''

DuttonT: /* Client Requirement */

2011-07-08T09:58:07Z

Client Requirement

← Older revision		Revision as of 11:58, 8 July 2011
Line 10:		Line 10:
	#* Add Active/Inactive filter to maintenance form		#* Add Active/Inactive filter to maintenance form
	#* Add restriction to any list of values (LOV) on Carriers table		#* Add restriction to any list of values (LOV) on Carriers table

	# '''Trailers '''		# '''Trailers '''
	#* Add option to Inactivate		#* Add option to Inactivate
	#* Add Active/Inactive filter to maintenance form		#* Add Active/Inactive filter to maintenance form
	#* Add restriction to any LOV on trailers table		#* Add restriction to any LOV on trailers table

	# '''Tractors '''		# '''Tractors '''
	* Add Active/Inactive filter to maintenance form		* Add Active/Inactive filter to maintenance form

	# '''Drivers '''		# '''Drivers '''

	* Add option to Inactivate		* Add option to Inactivate
	* Add Active/Inactive filter to maintenance form		* Add Active/Inactive filter to maintenance form

← Older revision		Revision as of 11:59, 8 July 2011
Line 51:		Line 51:

	# '''Hauliers / Carriers'''		# '''Hauliers / Carriers'''

	* A new column called ‘INACTIVE’ will be added to table ‘RES_CARRIER’. It will accept values of ‘Y’ or ‘N’, where ‘Y’ indicates that the carrier is inactive and ‘N’ indicates that the carrier is active. This new field will be added to the ‘Carrier’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Carrier’ screen. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.		* A new column called ‘INACTIVE’ will be added to table ‘RES_CARRIER’. It will accept values of ‘Y’ or ‘N’, where ‘Y’ indicates that the carrier is inactive and ‘N’ indicates that the carrier is active. This new field will be added to the ‘Carrier’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Carrier’ screen. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.
	* An active/inactive/all radio button filter will be added to the top of this screen.		* An active/inactive/all radio button filter will be added to the top of this screen.
Line 57:		Line 56:
	* The carriers that will employ external drivers will need to be setup as drivers because the drivers will be automatically populated with the carrier when the carrier is assigned to a trip, the carrier ID may be the forename and the carrier name may be the surname.		* The carriers that will employ external drivers will need to be setup as drivers because the drivers will be automatically populated with the carrier when the carrier is assigned to a trip, the carrier ID may be the forename and the carrier name may be the surname.
	* A flag on the carrier table will indicate if the carrier employs external drivers.		* A flag on the carrier table will indicate if the carrier employs external drivers.

	# '''Trailers'''		# '''Trailers'''

	* The column ‘INACTIVE’ already exists on the table ‘RES_TRAILER’ so will not be added. A field called ‘Inactive’ will be added to ‘Trailers’ page of the ‘Resource Maintenance’ screen. It will also be added to the ‘Insert Trailer’ and ‘Edit Trailer’ screens.		* The column ‘INACTIVE’ already exists on the table ‘RES_TRAILER’ so will not be added. A field called ‘Inactive’ will be added to ‘Trailers’ page of the ‘Resource Maintenance’ screen. It will also be added to the ‘Insert Trailer’ and ‘Edit Trailer’ screens.
	* An active/inactive/all radio button filter will be added to the top of this screen.		* An active/inactive/all radio button filter will be added to the top of this screen.
	* The list of values for trailers will only show the trailers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’.		* The list of values for trailers will only show the trailers that are active in: ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’.

	# '''Tractors'''		# '''Tractors'''

	* The column ‘INACTIVE’ already exists on the table ‘RES_TRACTOR’ so will not be added. A field called ‘Inactive’ already exists in the ‘Tractors’ page of the ‘Resource Maintenance’ screen and the ‘Insert Tractor’ and ‘Edit Tractor’ screens. An active/inactive/all radio button filter will be added to the top of this screen.		* The column ‘INACTIVE’ already exists on the table ‘RES_TRACTOR’ so will not be added. A field called ‘Inactive’ already exists in the ‘Tractors’ page of the ‘Resource Maintenance’ screen and the ‘Insert Tractor’ and ‘Edit Tractor’ screens. An active/inactive/all radio button filter will be added to the top of this screen.
	* Selection lists in ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’ will be restricted to select active tractors only.		* Selection lists in ‘Trip Planning’, ‘Trip Manipulation’, ‘Trip Summary’, ‘Trip Waterfall’, ‘Trip Debrief’ will be restricted to select active tractors only.

	# '''Drivers'''		# '''Drivers'''

	* A new column called ‘INACTIVE’ will be added to table ‘RES_PERSON’. It will accept values of ‘Y’ or ‘N, where ‘Y’ indicates that the driver is inactive and ‘N’ indicates that the driver is active. This new field will be added to the ‘Drivers’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Driver’ and ‘Edit Driver’ screens. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.		* A new column called ‘INACTIVE’ will be added to table ‘RES_PERSON’. It will accept values of ‘Y’ or ‘N, where ‘Y’ indicates that the driver is inactive and ‘N’ indicates that the driver is active. This new field will be added to the ‘Drivers’ page of the ‘Resource Maintenance’ screen as a tick box. It will also be added to the ‘Insert Driver’ and ‘Edit Driver’ screens. It will be ‘Y’ (i.e. inactive) if the box is checked or ‘N’ (i.e. active) if the box is unchecked.
	* An active/inactive/all radio button filter will be added to the top of this screen.		* An active/inactive/all radio button filter will be added to the top of this screen.