How is the TRS implemented?

Follow

New project setup:

  1. Add project information into table [dbo].[ Airport] (even if the project is not an airport project)
  2. Add information into table [dbo].[ProjectAirport] if there are many sub-projects in the parent project (e.g. Avinor is a parent project that tracking 17 airports)

Update data:

Steps below could be done orderly by using any automation tool or by manual:

  1. Insert interview tracking data to table [dbo].[RespData]
  2. Execute stored-procedure [dbo].[sp_InsertInterview] with appropriate parameters.
  3. Execute stored-procedure [dbo].[sp_MultiInsertInterview] with appropriate parameters.
Have more questions? Submit a request

Comments

Powered by Zendesk