Pre-Inspection Checklist

The pre-inspection checklist functionality is to provide clients with a means to streamline their equipment pre-checklist procedures electronically prior to the commencement of work.

These pre-inspection checklist may be for plant items prior to start up or fixed assets like wharfs to check tides, water conditions and weather etc.

This functionality will remove the necessity of the operator completing unnecessary paper work and an office person then inputting the same information into Smart Asset.  

Technical Setup

A technical setup is required to be configured behind the scenes via a script /SQL Studio.

A special Ticket Template is to be created

After creating a job, check its content against TicketTemplate table for a match against ShopId, ActivityCause, ActivityType,JobNoPrefix and AssetType and if values match, create a new job step for the StandardActivityNo contained in the Template column of the table.

This is to accommodate a special pre-Job inspection job for TasPorts when conducting work on a Wharf (eg. check tide times, water condition etc…)

Allow for retrieval of AssetStandard to be for a different AssetCode to the one passed from sa_CreateNewJob while building the job for that one, where the Asset on the nominated StandardActivity is used to retrieve the AssetStandard.

BUT: after creating the job, reset the StandardActivityNo to the default one to avoid issues down the track due to missing AssetStandard for Asset/StdActNo combo

NOTE: There is currently no user control to enable entry of TicketTemplate data so these need to be added via a script/SQLStudio

Testing for the above, showed an issue with the ValidateJob method as called via JobSteps tab (& Excel) in that a job could be closed with empty mandatory checklist items so included this check in validation process.

Job Step validation error message included a superfluous ‘&’.

Testing for the above showed an issue with uploading JobHistory for an existing job clears the job no and inserts a new job in history while leaving old job in job table.

Addressed by treating this as a job completion.

ALSO: cancel auto-date formatting when displaying date fields on insert into a spreadsheet (by preceding with a ‘).