CenterPiece Discussions  > Getting Started  > Re: deleting donors  
Previous Thread :: Next Thread 
 Author Thread: deleting donors
rose is not online. Last active: 9/22/2006 10:52:25 AM rose
Joined: 15 Sep 2005
Total Posts: 8
 
deleting donors
Posted: 30 Nov 2005 03:18 PM
If I delete a donor, does the FileID # get re-used?
brianp is not online. Last active: 12/20/2024 2:47:16 PM brianp
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Aug 2002
Total Posts: 1248
 
Re: deleting donors
Posted: 01 Dec 2005 06:05 PM
Hi Rose,

No it does not. When you add a new donor, the system just automatically increments the file ID.

Chris is not online. Last active: 9/3/2009 1:40:27 PM Chris
Joined: 07 Feb 2006
Total Posts: 17
 
Re: deleting donors
Posted: 24 Feb 2006 10:34 AM
So what happens with the deleted donor number? Is that a file that we pay for?
brianp is not online. Last active: 12/20/2024 2:47:16 PM brianp
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Aug 2002
Total Posts: 1248
 
Re: deleting donors
Posted: 24 Feb 2006 10:47 AM
Hi Chris,

During billing we count the number of files you have in your database regardless of file ID. For example, if your center had the following files in your database (notice the gap between 1000 and 2001), your database size is 3 because you have 3 physical records...*not* 2002.

FileID, FirstName, LastName...
------------------------------------------------
1000, Susie, Smith
2001, Sally, Jones
2002, Cindy, James



scpcljculler is not online. Last active: 9/13/2022 12:56:01 PM scpcljculler
Top 100 Poster
Joined: 10 Aug 2017
Total Posts: 10
 
Re: deleting donors
Posted: 22 Feb 2018 01:11 PM
Does making a donor inactive give the same result as deleting a donor, for billing purposes?

Also, is billing for donor and client records combined? And what about making a client file inactive? How does that affect billing.

Thanks for your help in advance.
ashleighg is not online. Last active: 12/12/2024 7:15:04 PM ashleighg
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Mar 2009
Total Posts: 1082
 
Re: deleting donors
Posted: 22 Feb 2018 01:17 PM
Hello scpcljculler,

Billing is based on the total number of records (client, donor, and staff) regardless of status (inactive/active) as they are stored and backed up nightly. You can review your database usage by clicking on the "Administration" tab and clicking "Database Usage" tab to review your record counts individually per module or as a whole.

Have a GREAT day!

Blessings,
Ashleigh
scpcljculler is not online. Last active: 9/13/2022 12:56:01 PM scpcljculler
Top 100 Poster
Joined: 10 Aug 2017
Total Posts: 10
 
Re: deleting donors
Posted: 22 Feb 2018 01:33 PM
Thanks Ashleigh!

I get the following error when deleting long ago staff.

The DELETE statement conflicted with the REFERENCE constraint "FK_tblIntake_tblDirectoryStaffVol". The conflict occurred in database "CenterPiece70", table "dbo.tblIntake". The statement has been terminated.
ashleighg is not online. Last active: 12/12/2024 7:15:04 PM ashleighg
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Mar 2009
Total Posts: 1082
 
Re: deleting donors
Posted: 22 Feb 2018 01:35 PM
Hi scpcljculler,

You do not want to delete any staff files that have seen clients or are attached to activity forms as that will potentially remove history. Instead what you will do is mark them inactive. You are receiving that error because it is tied to an intake.

Blessings,
Ashleigh
scpcljculler is not online. Last active: 9/13/2022 12:56:01 PM scpcljculler
Top 100 Poster
Joined: 10 Aug 2017
Total Posts: 10
 
Re: deleting donors
Posted: 22 Feb 2018 01:37 PM
ok - makes sense

how about a former staff that won't delete because it states that the record has a followup associated with it. I can not locate such a followup item?
ashleighg is not online. Last active: 12/12/2024 7:15:04 PM ashleighg
www.ekyros.com
Top 25 Poster
Forum Moderator
Joined: 01 Mar 2009
Total Posts: 1082
 
Re: deleting donors
Posted: 22 Feb 2018 01:40 PM
Hi scpcljculler,
You will want to run the follow-up reports in Client, Donor, and Staff as it is tied to a follow-up in one of those modules. I generally run the report for 1/1/1900-current to catch any dates.

Again I discourage deleting any staff files that have had client contact to prevent loss of history on activity forms.

Blessings,
Ashleigh
Previous Thread :: Next Thread 
Goto to page:  Prev Next
 
Forums  > CenterPiece Discussions  > Getting Started  > Re: deleting donors