Suzanne Stoakley's Discussions

Contact Details for the Contract Contact
4 Replies

Started this discussion. Last reply by Debbie Bruce Oct 28.

View All

Suzanne Stoakley's Page

Latest Activity

Debbie Bruce replied to Suzanne Stoakley's discussion 'Contact Details for the Contract Contact'

Hi Suzanne I have just this morning created a very similar query, please see below the SQL for this. Please bear in mind I set this for only Payable contracts which you might want to edit. I have also not included email or telephone but you can jus…

October 28

Peter Row replied to Suzanne Stoakley's discussion 'Contact Details for the Contract Contact'

I have just verfied my claim my set the Organisation contact to a different contact than the contact for a Contract that belongs to the same Organisation. Join the 2 tables I mentioned gives me the correct contact details. Are you sure that the one…

October 28

Suzanne Stoakley replied to Suzanne Stoakley's discussion 'Contact Details for the Contract Contact'

Peter I have tried this, linking the ContractContactID to the OrganisationContactID, because there doesn't appear to be anywhere else to link it to that works. Unfortunately this brings up the name of the person who is the main contact for the orga…

October 28

Peter Row replied to Suzanne Stoakley's discussion 'Contact Details for the Contract Contact'

The table V_AHR_Contracts has a field ContractContactID which can be linked to V_AHR_Organisation_Contacts table to the get the contacts name and address amongst other things. See the Ad-Hoc Reporting Reference Guide on you Start menu in Windows in…

October 28

Suzanne Stoakley added a discussion

Contact Details for the Contract Contact

I am trying to produce a report which lists the address, telephone number and e-mail address of the contact person assigned to our service contracts. After numerous attempts, I can work out the names of the main contact details for the organisation…

October 28

Suzanne Stoakley replied to Dawn Field's discussion 'Missing PI Report'

We export the report into Excel, then filter out all those who have done the latest PI, leaving a list of all those who have not. The only problem is, is that it doesn't show who has never completed a PI, so I have written a report which lists them…

July 10

Suzanne Stoakley replied to Dawn Field's discussion 'HIA PI Workbooks'

We in East Sussex have the same problem. As we only have 4 HIAs we print off the workbook and input the data manually. If you find out how to sort this, can you please let us know. supportingpeople@eastsussex.gov.uk. Thanks

June 12

Suzanne Stoakley replied to Andy Ross's discussion 'SPOCC Reports'

Andy I have spoken to OCC about this because I've wanted to do the same thing. You either ask them if they can change it for you (there will probably be a cost involved) or re-write it yourself.

June 4